preparestatement

来源：互联网发布：马踏棋盘栈贪婪算法编辑：程序博客网时间：2024/04/30 16:57

“`
/**
* 将用户信息插入数据库
* @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;

}“`

0 0