The following steps will give brief way to establish a connection with MySQL from Java
Load the JDBC driver
Class.forName("com.mysql.jdbc.Driver");
Get Connection with Mysql with DriverManager class
Connection connection = DriverManager.getConnection(url, username, password);
url should be something like jdbc:mysql://localhost:port/db_name
We can handle the exceptions using try-catch and remember to close the connection in finally section. That's it we got connected to Mysql
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
Most of the new users of JDBC may face problems with the connection because of the missing of mysql connector (jar file). The file must be included in the libraries of the project.
Other mysql problems may occur if the connection object is not closed properly. The object has to be closed explicitly for each connection preferably by placing it in 'finally' block.
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
Discuss how and what kind of problem in JDBC connectivity to MYSQL
The following steps will give brief way to establish a connection with MySQL from Java
Class.forName("com.mysql.jdbc.Driver");
Get Connection with Mysql with DriverManager class
Connection connection = DriverManager.getConnection(url, username, password);
url should be something like jdbc:mysql://localhost:port/db_name
We can handle the exceptions using try-catch and remember to close the connection in finally section. That's it we got connected to Mysql
Most of the new users of JDBC may face problems with the connection because of the missing of mysql connector (jar file). The file must be included in the libraries of the project.
Other mysql problems may occur if the connection object is not closed properly. The object has to be closed explicitly for each connection preferably by placing it in 'finally' block.
Note here port number is 3306
To solve the mysqlconnector.jar problem place it in apacetomact/lib folder
I hadn't used JDBC earlier.Can someone suggest me a good reference.