求大神指导怎么把这两个值取出来，语句怎么写

Question

try{
conn=DB.getConn();
String sql = "select userid from users where username = '"+username+"';select jztypeid from jztype where jztypename='"+jztype+"'";
pstmt = DB.getPStmt(conn, sql);
int userid =

        pstmt.executeUpdate();
    }catch(SQLException e){
        e.printStackTrace();

    }



    就是userid和typeid怎么写能获取数据库里取过来的值

Answer 1

ResultSet rs=pstmt.executeQuery(sql);
Users users = new Users();
while(rs.next()){
user.getUserid(rs.getInt("userid"));
users.getTypeid(rs.getInt("typeid"));
}
userid,typeid与表里字段相同