JDBC自增长主键回显

自增长主键回显

一般数据库中表的主键是自增长的，有时候在插入记录时，需要获取该条记录的主键id

代码

/**
 * 获取自增长的主键值测试
 */
public class GetPrimaryKey {


	@Test
	public void getPrimaryKey() throws Exception {
		Class.forName("com.mysql.cj.jdbc.Driver");
		Connection connection = DriverManager.getConnection("jdbc:mysql://127.0.0.1:3306/test", "root", "123456");

		String sql = "insert into test.t_user (account, password,nickname) values (?, ?, ?)";
		// Statement.RETURN_GENERATED_KEYS 表示在插入数据后，返回自增的主键值
		PreparedStatement prepareStatement = connection.prepareStatement(sql, Statement.RETURN_GENERATED_KEYS);
		prepareStatement.setObject(1, "test1");
		prepareStatement.setObject(2, "123456");
		prepareStatement.setObject(3, "name");

		int i = prepareStatement.executeUpdate();
		if (i > 0){
			System.out.println("数据插入成功！");
			// 获取主键值
			ResultSet generatedKeys = prepareStatement.getGeneratedKeys();
			generatedKeys.next();
			System.out.println(generatedKeys.getInt(1));
		}else {
			System.out.println("数据插入失败！");
		}

		prepareStatement.close();
		connection.close();

	}
}

结果

数据插入成功！
5

Process finished with exit code 0