package JDBC;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
public class TestJDBC {
public static void main(String[] args) {
try {
Class.forName("com.mysql.jdbc.Driver");
} catch (ClassNotFoundException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
//建表hero时候就设置id的属性 auto_increment primary key
//这个位置 id设置为null或0就可自动增长了
String sql = "insert into hero values(0,?,?)";
try (
Connection c = DriverManager.getConnection(
"jdbc:mysql://127.0.0.1:3306/Hero?characterEncoding=UTF-8",
"root",
"123"); //设置Statement.RETURN_GENERATED_KEYS参数
PreparedStatement ps = c.prepareStatement(sql, Statement.RETURN_GENERATED_KEYS);
)
{
//设置属性
ps.setString(1, "李白");
ps.setInt(2, 25);
//执行sql
ps.execute();
//getGeneratedKeys()获得结果集
ResultSet rs = ps.getGeneratedKeys();
while(rs.next()) {
//获取id的值
int id = rs.getInt(1);
System.out.println(id);
}
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
}
jdbc中如何获取自增长的id呢
最新推荐文章于 2023-05-18 11:37:14 发布