Connect to the MySQL database using JDBC

It is convenient to connect to the MySql server using Jdbc.

First, import jdbc to the project or put jdbc into ClassPath. Here, I use Eclipse to directly import the jdbc jar file.

Then, the DriverManager is developed, And the froName of the Class is directly completed using the simplest method. The Code is as follows:

Class. forName ("com. mysql. jdbc. Driver"). newInstance ();

Then, instantiate a Connection. Pay attention to the user name and password. There are several methods to choose from. Here I use the getConnection (String url, String user, String password) method of the DirverManager class. Specific Use: DriverManager

For example: Connection conn = DriverManager. getConnection ("jdbc: mysql: // localhost/mydatabase", "root", "1234 ");

Next, create a Statement for executing the SQL Statement. This is easy to do with one line of code:

Statement stat = conn. createStatement ();

Finally, you can use the stat instance to execute SQL statements. For details, refer to Statement.

Sample Code:

The created mydatabase contains a mytable table that contains an integer id and a text content.

Use the following code to view the content of the first 20 rows in mytable.

1. PackageCom. tobacco. mysqltest;
3. ImportJava. SQL. Connection;
4. ImportJava. SQL. DriverManager;
5. ImportJava. SQL. ResultSet;
6. ImportJava. SQL. SQLException;
7. ImportJava. SQL. Statement;
9. Public ClassMain {
10. Private StaticConnection conn;
11. Private StaticStatement stat;
12. Private StaticResultSet rs;
15. Public Static VoidMain (String [] args ){
16. Try{
17. Class. forName ("Com. mysql. jdbc. Driver"). NewInstance ();
18. System. out. println ("Load jdbc successfully");
19. }Catch(InstantiationException e ){
20. // TODO Auto-generated catch block
21. E. printStackTrace ();
22. }Catch(IllegalAccessException e ){
23. // TODO Auto-generated catch block
24. E. printStackTrace ();
25. }Catch(ClassNotFoundException e ){
26. // TODO Auto-generated catch block
27. E. printStackTrace ();
28. }
30. Try{
31. Conn = DriverManager. getConnection ("Jdbc: mysql: // localhost/mydatabase","Root","1234");
32. Stat = conn. createStatement ();
33. IntN =20;
34. IntI =1;
35. While(I <n ){
36. Rs = stat.exe cuteQuery ("SELECT * FROM mytable WHERE id ="+ I );
37. If(Rs! =Null){
38. Rs. first ();
39. String content = rs. getString (rs. findColumn ("Content"));
40. System. out. println (content );
41. }
42. I ++;
43. }
45. }Catch(SQLException e ){
46. // TODO Auto-generated catch block
47. E. printStackTrace ();
48. }
51. }
53. }