获取数据自动插入列

最新推荐文章于 2024-03-27 16:55:52 发布

boxyuan

最新推荐文章于 2024-03-27 16:55:52 发布

阅读量323

点赞数

分类专栏： Java 文章标签： java jdbc 序列

本文链接：https://blog.csdn.net/boxyuan/article/details/78168208

版权

Java 专栏收录该内容

45 篇文章 1 订阅

订阅专栏

//获取数据自动插入列
public class getAutoIncrement {
	private Connection conn;
	private PreparedStatement ps;
	private ResultSet rs;

	public static void main(String[] args) throws SQLException {
		getAutoIncrement gai = new getAutoIncrement();
		gai.getIncre();
	}

	private void getIncre() throws SQLException {
		// TODO Auto-generated method stub
		DbUtil db = new DbUtil();
		conn = db.getConnection();
		String sql = "INSERT INTO users(uname,upwd) VALUES(?,?) ";
		ps = (PreparedStatement) conn.prepareStatement(sql,
				PreparedStatement.RETURN_GENERATED_KEYS);
		ps.setString(1, "aa");
		ps.setString(2, "111");
		ps.executeUpdate();
		ResultSet rs = ps.getGeneratedKeys();
		while (rs.next()) {
			System.out.println(rs.getInt(1));
		}
		rs.close();
		ps.close();
		conn.close();

	}
}