用户注册是向表中插入用户的基本信息并返回该记录的id值
例子
public long regist(Cuser cuser) {
Connection con=Cconnection.getconnection();//Cconnection是的到数据库连接的类
PreparedStatement ps=null;
ResultSet rs=null;
long id = 0;//存放数据库返回的用户注册过后的id
try {
ps=con.prepareStatement(Csqlutil.REGIST,Statement.RETURN_GENERATED_KEYS);//将Csqlutil.REGIST改为sql语句
ps.setString(1, cuser.getUsername());
ps.setString(2, cuser.getName());
ps.setString(3, cuser.getPwd());
ps.setInt(4, cuser.getAge());
ps.setString(5, cuser.getSex());
ps.setString(6, cuser.getPhone());
ps.executeUpdate();
rs=ps.getGeneratedKeys();//这一句代码就是得到插入的记录的id
while(rs.next()){
id=rs.getLong(1);
}
} catch (Exception e) {
// TODO Auto-generated catch block
e.printStackTrace();
}finally{
try {
rs.close();
ps.close();
con.close();
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
return id;
}