How to connect Mysql Database in java using maven dependecy
-:How to connect mysql database using maven dependency:-
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;
import java.sql.Statement;
public class Demo {
public static void main(String args[]) {
String url = "jdbc:mysql://localhost:3306/test";
String user = "root";
String password = "root@123";
try {
Class.forName("com.mysql.jdbc.Driver");
Connection connection = DriverManager.getConnection(url, user, password);
System.out.println("Connection is Successful to the database" + url);
String query = "Insert into student(id,name) values(101,'ram')";
Statement statement = connection.createStatement();
statement.execute(query);
} catch (ClassNotFoundException e) {
e.printStackTrace();
} catch (SQLException throwables) {
throwables.printStackTrace();
}
}
}
Video:-
Leave a Comment