Java to MySQL database operation under eclipse

1. Download the MySQL driver.

link:http://dev.mysql.com/downloads/connector/j/

2. Load JDBC

In eclipse, select the appropriate project, Properties->java Build path->add external Jars->ok.

3.JDBC General steps to operate a database

Registered driver (only once) Class.forName ("Com.mysql.jdbc.Driver"); Establish connection (Connection) Connection conn = drivermanager.getconnection (URL, user, password); URL format: JDBC: Sub-Protocol: Sub-name//hostname: Port/database name? Property name = attribute value &. User,password can tell the database with the property name = attribute value; Example:

String url= "Jdbc:mysql://localhost:3306/test";

Connection Conn;

conn = drivermanager.getconnection (URL, "root", "root"), create Execute SQL statement (Statement) EXECUTE statement Statement is a SQL executor, Can be used to execute a static SQL statement. Statement st = Conn.createstatement (); st.executequery (SQL); Example

Statement stmt = Conn.createstatement (); Create a statement object
String sql= "SELECT * from writers";
ResultSet rs = stmt.executequery (SQL);

Execute stored procedure callablestatement (extended from preperedstatement) cs = Connection.preparecall ("{Call Psname (?,?,?)}"); Cs.registeroutparameter (index, Types.integer); Cs.setxxx (i, XXXX); cs.executeupdate (); int id=cs.getint (index); The processing execution result (ResultSet) ResultSet represents a query result set. ResultSet rs = statement.executequery (SQL); while (Rs.next ()) {rs.getstring ("Col_name"), Rs.getint ("Col_name"),//...} Release resources in order to release resources is ResultSet, statement,connection;connection after use is completed, must be closed, ResultSet, Statement does not matter, as long as Connection off, They are also automatically closed (but resources are not immediately released). Connection's use principle is to create as late as possible, releasing as early as possible.

Java to MySQL database operation under eclipse