servlet-求大神指導怎麼把這兩個值取出來，語句怎麼寫

求大神指導怎麼把這兩個值取出來，語句怎麼寫

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怎麼寫能獲取數據庫裡取過來的值

最佳回答：

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