public long submit() {
Connection con = Cconnection.getconnection();
PreparedStatement ps = null;
ResultSet rs = null;
long id = 0;
try {
String sql = "instal into abc(a,b,c) value(?,?,?)";
ps = con.prepareStatement(sql, Statement.RETURN_GENERATED_KEYS);
ps.setString(1, "内容");
ps.setString(2, "内容");
ps.setString(3, "内容");
ps.executeUpdate();
rs = ps.getGeneratedKeys();// 得到插入的记录的id
while (rs.next()) {
id = rs.getLong(1);
}
} catch (Exception e) {
// TODO Auto-generated catch block
e.printStackTrace();
} finally {
try {
rs.close();
ps.close();
con.close();
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
return id;
}
JSP向数据库中插入记录并返回记录id
最新推荐文章于 2021-02-03 16:35:32 发布