javascript - 如何使用多个 session.setAttribute 从 sql 数据库中获取行值？

Question

我正在尝试获取 jsp 页面 textox 上的行值。我使用了 value="${sessionScope.zfid}"然后获取了值但是当我使用value="${sessionScope.firstname}"时没有获取任何值。我获取了一个值（zfid），但无法为其他文本框做。请参阅下面的代码并建议我哪里出错了。

这是 index.jsp

<tr>
<td>Z id</td>
<td>
<input type="text" required="" name="zid"  value="${sessionScope.zfid}" readonly/> 
</td>
</tr>
<tr>
<td>First Name</td>
<td>
<input type="text" required="" name="firstname" value="${sessionScope.firstname}"/>
</td>
</tr>

这是 loginscript.jsp

<%
String zfid = request.getParameter("zid"); 
String firstname = request.getParameter("firstname");
String pwd = request.getParameter("pass");
Class.forName("com.mysql.jdbc.Driver");
Connection con = DriverManager.getConnection("jdbc:mysql://localhost:3306/dmsqms", "root", "");
Statement st = con.createStatement();
ResultSet rs;
rs = st.executeQuery("select * from dmsmembers where zid='" + zfid + "' and pass='" + pwd + "'");
if (rs.next()) {
   session.setAttribute("zfid", zfid);
   session.setAttribute("firstname", firstname);
   //out.println("welcome " + userid);
   //out.println("<a href='logout.jsp'>Log out</a>");
   response.sendRedirect("home.jsp");
} 
else {
   out.println("<script type=\"text/javascript\">");
   out.println("alert('Invalid username or password');");
   out.println("location='loginJSP.jsp';");
   out.println("</script>");
}
%>

这是 uploadservlet.java 类

public class UploadServletClass extends HttpServlet{
    PrintWriter out = null;
    Connection con = null;
    PreparedStatement ps = null;
    HttpSession session = null;
    
    protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException,IOException{
        response.setContentType("text/plain;charset=UTF-8");
        try{
            out = response.getWriter();
            session = request.getSession(false);
            String folderName = "allfiles";
            
            ...
            
            
           if(counter > 0){
                    String msg = "Successfully uploaded " + counter + " file(s).";
                    request.setAttribute("msg", msg);
                    System.out.println(msg);
                    session.setAttribute("filename", fileName);
                }
       }
       
}       

标签： javascriptsql