“`
/**
* 将用户信息插入数据库
* @param uv
* @return
*/
public int insertUser(UserVo uv){
int userId = 0;
initDb(); **初始化连接数据库的方法
PreparedStatement pst=null;
ResultSet rs=null;
try {
String sql="INSERT INTO usertable (user_name,user_password,user_sex,province_id,city_id,user_describe) VALUES (?,?,?,?,?,?)";
pst=con.prepareStatement(sql);
pst.setString(1, uv.getUserName());
pst.setString(2, uv.getUserPassword());
pst.setString(3, uv.getUserSex());
pst.setInt(4, uv.getProvinceId());
pst.setInt(5, uv.getCityId());
pst.setString(6, uv.getUserDescribe());
pst.executeUpdate();
rs = pst.getGeneratedKeys();//获取自增长的列的新值
while(rs.next()){
userId=rs.getInt(1);
列表内容
} } catch (SQLException e) { try { con.rollback(); } catch (SQLException e1) { // TODO Auto-generated catch block e1.printStackTrace(); } // TODO Auto-generated catch block e.printStackTrace(); } finally{ try { pst.close(); con.close(); } catch (SQLException e) { // TODO Auto-generated catch block e.printStackTrace(); } } return userId;
}“`