JDBC获取自动增长的主键值

gistfile1.java

public static void main(String[] args) throws Exception {
  	
	Class.forName("com.mysql.jdbc.Driver");
	Connection conn = DriverManager.getConnection("jdbc:mysql:///kaishengit_db", "root", "root");
	
	String sql = "insert into t_test(username,address) values('vv','china')";
	Statement stat = conn.createStatement();
	
	stat.execute(sql, Statement.RETURN_GENERATED_KEYS);
	
	ResultSet rs = stat.getGeneratedKeys();
	if(rs.next()) {
		System.out.println(rs.getObject(1));
	}
	
	
	stat.close();
	conn.close();
	
}

gistfile2.java

public static void main(String[] args) throws Exception {
  	
	Class.forName("com.mysql.jdbc.Driver");
	Connection conn = DriverManager.getConnection("jdbc:mysql:///kaishengit_db", "root", "root");
	
	String sql = "insert into t_test(username,address) values(?,?)";
	PreparedStatement stat = conn.prepareStatement(sql, Statement.RETURN_GENERATED_KEYS);
	
	stat.setString(1, "vivi");
	stat.setString(2, "Jp");
	
	stat.executeUpdate();
	
	ResultSet rs = stat.getGeneratedKeys();
	if(rs.next()) {
		System.out.println(rs.getObject(1));
	}
	
	
	stat.close();
	conn.close();
	
}