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 block
e.printStackTrace();
}
}
}
}
jdbc连接mysql数据库执行insert语句后获取自增长的主键值
最新推荐文章于 2023-03-04 13:55:50 发布