jdbc串連mysql資料庫執行insert語句後擷取自增長的主索引值

標籤：jdbc mysql 自增長主鍵

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,'俄羅斯')";try {pst = conn.prepareStatement(sql, Statement.RETURN_GENERATED_KEYS);pst.executeUpdate();rs = pst.getGeneratedKeys();if(rs.next()){System.out.println(rs.getObject(1));}} catch (SQLException e) {e.printStackTrace();} finally{try {rs.close();pst.close();conn.close();} catch (SQLException e) {// TODO Auto-generated catch blocke.printStackTrace();}}}}

jdbc串連mysql資料庫執行insert語句後擷取自增長的主索引值