向数据库插入数据时如何获取主键

向数据库中插入数据的同时获取主键，比较推荐的方式：

 

String sqlStr = "insert into user(name,birthday,money) values('name1','1987-02-03',1234)";
		Connection conn = null;
		PreparedStatement st = null;
		ResultSet rs = null;
		int key = 0;
		try {
			// 建立连接
			conn = JdbcUtils.getInstance().getConnection();
			// 创建语句
			st = conn.prepareStatement(sqlStr, Statement.RETURN_GENERATED_KEYS);
			// 执行语句
			st.executeUpdate();
	
			rs = st.getGeneratedKeys();
			if (rs.next()) {
				key = rs.getInt(1);
			}
			return key;
		} finally {
			JdbcUtils.getInstance().free(null, st, conn);
		}