JDBC Pure Drive mode connection MySQL

1 Create a new Java Project named Mysqldemo

2 Download the latest driver package from http://dev.mysql.com/downloads/connector/j/.

Here are the. tar.gz and. zip Two-format packages, because they can be decompressed under Windows, either way.

3 after extracting the downloaded drive package, copy the Mysql-connector-java-5.1.38-bin.jar to the project

4 Creating a Java class named Mysqldemo in the project

5 Writing code in Mysqldemo.java

[Java]View PlainCopy 

2. Package com.abc;
10. Importjava.sql.DriverManager;
14. Importjava.sql.ResultSet;
18. Importjava.sql.SQLException;
22. Importjava.sql.Connection;
26. Importjava.sql.Statement;
34. Publicclass Mysqldemo {
38. Publicstaticvoid Main (string[] args) throws Exception {
42. Connection conn = null;
46. String SQL;
50. //MySQL JDBC URL writing method: jdbc:mysql://Host Name: Connection port/database name? parameter = value
54. //Avoid Chinese garbled to specify Useunicode and characterencoding
58. String url = "Jdbc:mysql://localhost:3306/test?"
62. + "User=root&password=123456&useunicode=true&characterencoding=utf8";
66. try {
70. //The reason to use the following statement is to use the MySQL driver, so we have to drive it up,
74. //Can be loaded through the class.forname, can also be driven by initialization, the following three forms can be
78. Class.forName ("Com.mysql.jdbc.Driver"); Dynamic load MySQL driver
82. //or:
86. //Com.mysql.jdbc.Driver Driver = new Com.mysql.jdbc.Driver ();
90. //or:
94. //New Com.mysql.jdbc.Driver ();
98. System.out.println ("load MySQL driver successfully");
102. //A connection represents a database connection
106. conn = drivermanager.getconnection (URL);
110. //Statement with many methods, such as executeupdate can be inserted, update and delete, etc.
114. Statement stmt = Conn.createstatement ();
118. sql = "createtable student (no char (), name varchar (), primary key (No))";
122. Intresult = stmt.executeupdate (sql); the///Executeupdate statement returns an affected number of rows if the return-1 does not succeed
126. if (Result! =-1) {
130. System.out.println ("Create data Table Success");
134. sql = "INSERT into student (No,name) VALUES (' 2016001 ', ' Liu Big ')";
138. result = Stmt.executeupdate (SQL);
142. sql = "INSERT into student (No,name) VALUES (' 2016002 ', ' Chen er ')";
146. result = Stmt.executeupdate (SQL);
150. sql = "SELECT * from student";
154. ResultSet rs = stmt.executequery (SQL); //ExecuteQuery Returns a collection of results, otherwise returns a null value
158. System.out.println ("School number \ t name");
162. While (Rs.next ()) {
166. System.out.println (rs.getstring (1) + "\ T" + rs.getstring (2)); If the type int is returned can be used Getint ()
170. }
174. }
178. } catch (SQLException e) {
182. System.out.println ("MySQL operation Error");
186. E.printstacktrace ();
190. } catch (Exception e) {
194. E.printstacktrace ();
198. } finally {
202. Conn.close ();
206. }
210. }
214. }

Operation Result:

JDBC Pure Drive mode connection MySQL