Java connects MySQL database with JDBC

First to download connector/j address: http://www.mysql.com/downloads/connector/j/

This is the official MySQL connection method:

After extracting the jar library file, you need to import the library file in the project

I'm using eclipse:

Java is a bit cumbersome to connect to MySQL, so write a class first to open or close the database:

Dbhelper.java

Java code

2. Package Com.hu.demo;
6. Import java.sql.Connection;
8. Import Java.sql.DriverManager;
10. Import java.sql.PreparedStatement;
12. Import java.sql.SQLException;
16. Public class DBHelper {
18. public static final String url = "jdbc:mysql://127.0.0.1/student";
20. public static final String name = "Com.mysql.jdbc.Driver";
22. public static final String user = "root";
24. public static final String password = "root";
28. Public Connection conn = null;
30. Public PreparedStatement PST = null;
34. Public dbhelper (String sql) {
36. try {
38. Class.forName (name); //Specify connection type
40. conn = drivermanager.getconnection (URL, user, password); //Get Connected
42. PST = conn.preparestatement (SQL); //Prepare to execute statement
44. } catch (Exception e) {
46. E.printstacktrace ();
48. }
50. }
54. public Void Close () {
56. try {
58. This.conn.close ();
60. This.pst.close ();
62. } catch (SQLException e) {
64. E.printstacktrace ();
66. }
68. }
70. }

Write a demo.java to perform the related query operation

Demo.java

Java code

2. Package Com.hu.demo;
6. Import Java.sql.ResultSet;
8. Import java.sql.SQLException;
12. Public class Demo {
16. static String sql = null;
18. static DBHelper db1 = null;
20. static RESULTSET ret = null;
24. public static void Main (string[] args) {
26. sql = "select *from stuinfo"; SQL statements
28. DB1 = new DBHelper (SQL); Create a DBHelper object
32. try {
34. ret = Db1.pst.executeQuery (); //EXECUTE statement to get result set
36. While (Ret.next ()) {
38. String uid = ret.getstring (1);
40. String ufname = ret.getstring (2);
42. String ulname = ret.getstring (3);
44. String udate = ret.getstring (4);
46. SYSTEM.OUT.PRINTLN (uid + "\ T" + ufname + "\ T" + ulname + "\ T" + udate);
48. }//Display data
50. Ret.close ();
52. Db1.close (); //Close connection
54. } catch (SQLException e) {
56. E.printstacktrace ();
58. }
60. }
64. }

Java connects MySQL database with JDBC