Basic steps for Java JDBC to connect to MySQL

Basic steps for Java and MySQL links:

First Step: Register driver

Method One:

[Java]View PlainCopy

1. Drivermanager.registerdriver (new Com.mysql.jdbc.Driver ());

Method Two: Set properties

[Java]View PlainCopy

1. System.setproperty ("Jdbc.drivers", "Com.mysql.jdbc.Driver");

Method Three:

[Java]View PlainCopy

1. Class.forName ("Com.mysql.jdbc.Driver");

Step two: Establish a connection

[Java]View PlainCopy

1. Connection conn = (Connection) drivermanager.getconnection ("Jdbc:mysql://localhost:3306/test", "root", "  Root ");

Step three: Create a statement

[Java]View PlainCopy

1. Statement st = (Statement) conn.createstatement ();

Fourth step: Execute the statement

Fifth step: Process the results

Sixth step: Freeing up resources

Test code:

[Java]View PlainCopy

2. Import Java.sql.DriverManager;
4. Import Java.sql.ResultSet;
6. Import java.sql.SQLException;
10. Import com.mysql.jdbc.Connection;
12. Import com.mysql.jdbc.Statement;
16. Public class Demo {
18. public static void Main (string[] args) {
20. Demo d = new demo ();
22. try {
24. D.test ();
26. } catch (SQLException e) {
28. //TODO auto-generated catch block
30. E.printstacktrace ();
32. }
34. }
38. static void Test () throws SQLException {
40. //First step: Register driver
42. Drivermanager.registerdriver (new Com.mysql.jdbc.Driver ());
44. ///Step two: Establish a connection
46. Connection conn = (Connection) drivermanager.getconnection ("Jdbc:mysql://localhost:3306/test", "root", "  Root ");
48. //Step three: Create a statement
50. Statement st = (Statement) conn.createstatement ();
52. //Fourth step: Execute the statement and remove the result
54. ResultSet rs = st.executequery ("select * from MyTable");
58. //Fifth step: Process results
60. While (Rs.next ()) {
62. System.out.println (Rs.getobject (1) + "\ T" + Rs.getobject (2) + "\ T"
64. + Rs.getobject (3));
66. }
70. //Sixth step: Release Resources
72. Rs.close ();
74. St.close ();
76. Conn.close ();
78. }
80. }

Basic steps for Java JDBC to connect to MySQL