求助帖 报错信息 HTTP Status 500 - The server encountered an internal error that prevented it from fulfilling this request.
想要实现通过JSP+Servlet+DAO(+JDBC)+JavaBean实现登陆验证。学生登陆验证的时候可以正常运行,但管理员登陆验证的时候就报错了,下面是报错信息。
下面是MinHandle.java源代码
public void doGet(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {
String adminname = "";
String adminpass = "";
HttpSession session = request.getSession();//需要import javax.servlet.http.HttpSession类
adminname = request.getParameter("adminName");
adminpass = request.getParameter("adminPass");
MinDao mindao=new MinDao();
Min min=mindao.validateLogin(adminname,adminpass);
if(min.getAdminname()!=null){
session.setAttribute("min", min);
response.sendRedirect(request.getContextPath()+"/admin/state.jsp");
}else{
response.sendRedirect(request.getContextPath()+"/manage_login.jsp");
}
下面是Min.java的代码
package entity;
public class Min {
private int adminid;
private String adminname;
private String adminpass;
private String admingruop;
public int getAdminid() {
return adminid;
}
public void setAdminid(int adminid) {
this.adminid = adminid;
}
public String getAdminname() {
return adminname;
}
public void setAdminname(String adminname) {
this.adminname = adminname;
}
public String getAdminpass() {
return adminpass;
}
public void setAdminpass(String adminpass) {
this.adminpass = adminpass;
}
public String getAdmingruop() {
return admingruop;
}
public void setAdmingruop(String admingruop) {
this.admingruop = admingruop;
}
}
MinDao.java的代码
package dao;
import com.mysql.jdbc.*;
import java.sql.*;
import db.DBUtil;
import entity.Min;
public class MinDao {
public Min validateLogin(String adminname,String adminpass){
Min stu=new Min();
java.sql.Connection conn=null;
java.sql.PreparedStatement pre=null;
java.sql.ResultSet rs=null;
try{
conn=DBUtil.getConnection();
String sql="select * from adminuser where username=? and password=?";
pre=conn.prepareStatement(sql);
pre.setString(1, adminname);
pre.setString(2, adminpass);
rs=pre.executeQuery();
if(rs.next()){
stu.setAdminid(rs.getInt("adminid"));
stu.setAdminname(rs.getString("adminname"));
stu.setAdminpass(rs.getString("adminpass"));
}
}catch(Exception e){
e.printStackTrace();
}finally{
if(rs!=null)
try {
rs.close();
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
if(pre!=null)
try {
rs.close();
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
if(conn!=null)
try {
conn.close();
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
return stu;
}
}