菜鸟问题：关于session的存取值问题

显示全部楼层 · 发表于 2020-12-13 13:52:01

那是我的数据表，我念掏出grade列里的值放正在session中，以供我做映雩分级
可是我掏出的皆是username中的值
我该怎样做才气与到grade中的值？

另有假如我正在session中放进多个值（好像时放进id，username，grade），该怎样别离掏出？

代码以下：

userService

import java.sql.ResultSet;
import java.util.ArrayList;
import com.qym.Utils.SqlHelper;
import com.qym.DAO.userDAO;
public class userService {
public boolean checkUser(userDAO user){
String sql="select * from user where username=? and passwd=?";
String paras[]={user.getName()+"",user.getPassword()};
ArrayList al=new SqlHelper().executeQuery(sql, paras);
if(al.size()==0){
return false;
}else {
// for(int i=0;i<al.size();i++){
//
// }
Object []objects=(Object[]) al.get(0);
//user.setName((String)objects[1]);
user.setGrade(Integer.parseInt(objects[4].toString()));
return true;
}
}
public boolean checkAddUser(userDAO user){
String sql="insert into user(username,passwd) values(?,?)";
String a=user.getName();
String b=user.getPassword();
String[] parameters={a,b};
SqlHelper.executeUpdate(sql, parameters);
return true;
}
}

[color=rgb(51, 102, 153) !important]赶钙代码

GoMyJspUI

import java.io.IOException;
import java.io.PrintWriter;
import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import com.qym.DAO.userDAO;
import com.qym.Service.userService;
public class GoMyJspUI extends HttpServlet {
public void doGet(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {
request.setCharacterEncoding("utf-8");
response.setContentType("text/html;charset=utf-8");
PrintWriter out = response.getWriter();
String name=request.getParameter("name");
String p=request.getParameter("password");
userDAO loginuser=new userDAO(name,p);
userService userService=new userService();
if(userService.checkUser(loginuser)){
String s="mySession";
request.getSession().setAttribute("MS", s);
System.out.print(request.getSession().getAttribute("MS"));
request.getSession().setAttribute("loginuser", loginuser);
System.out.println("属性值曾经保留正在session");
Integer a =Integer.parseInt( request.getSession().getAttribute("loginuser").toString());
//String a =( request.getSession().getAttribute("loginuser").toString());
System.out.println(a);
request.getRequestDispatcher("/WEB-INF/MyJsp.jsp").forward(request, response);
}
else {
request.getRequestDispatcher("/WEB-INF/ShiBai.jsp").forward(request, response);
}
}
public void doPost(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {
this.doGet(request, response);
}
}