获得数据库自动生成的主键

获得数据库自动生成的主键

示例：

packagecom.hbsi.test;

importjava.sql.Connection;

importjava.sql.PreparedStatement;

importjava.sql.ResultSet;

importjava.sql.SQLException;

importjava.sql.Statement;

importcom.hbsi.utils.DBManager;

public class Demo4{

/**

*@param args

*/

public static void main(String[] args) {

// TODO Auto-generated method stub

Connection con=null;

PreparedStatement st=null;

ResultSet rs=null;

try {

con=DBManager.getConnection();

String sql="insert intousers (name,password) values (?,?)";

st=con.prepareStatement(sql);

st.setString(1,"Jerry");

st.setString(2,"QAZ");

st.executeUpdate();

rs=st.getGeneratedKeys();//结果集单行单列

if(rs.next()){

System.out.println(rs.getInt(1));

}

} catch (SQLException e) {

// TODO Auto-generated catchblock

e.printStackTrace();

} finally{

DBManager.release(con, st, rs);

}

}

}