jdbc连接mysql数据库执行insert语句后获取自增长的主键值

来源：互联网发布：matlab for 矩阵函数编辑：程序博客网时间：2024/05/05 05:08

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();}}}}

1 0