Package Cn.baokx;import Java.sql.connection;import Java.sql.preparedstatement;import java.sql.resultset;import Java.sql.sqlexception;import Java.sql.statement;import Cn.baokx.db.databaseconnection0;public class Test1 {public static void Main (string[] args) {Connection conn = new DatabaseConnection0 (). getconnection (); PreparedStatement PST = NULL; ResultSet rs = null; String sql = "INSERT into DZ (date,time,s,w,deep,level,location)" + "VALUES (' 2014-01-01 ', ' 05:03:44 ', 25.6,122.4,260,6.2 , ' Russia '); try {PST = conn.preparestatement (sql, Statement.return_generated_keys);p st.executeupdate (); rs = Pst.getgeneratedkeys (); if (Rs.next ()) {System.out.println (Rs.getobject (1));}} catch (SQLException e) {e.printstacktrace ();} finally{try {rs.close ();p st.close (); Conn.close ();} catch (SQLException E {//TODO auto-generated catch Blocke.printstacktrace ();}}}}
JDBC connects MySQL database after executing INSERT statement to get self-growing primary key value