求助：JSP连接数据库 HTTP Status 500

下面是我的JSP代码，希望高手们帮我看看哪儿出错了，遇到了

type Exception report

message

description The server encountered an internal error () that prevented it from fulfilling this request.

String path = request.getContextPath();
String basePath = request.getScheme()+"://"+request.getServerName()+":"+request.getServerPort()+path+"/";
%>

 

   
   
    用户登录界面
   
 
 
    
 
 
 <!--
 
 --&gt

 
 
 
 

 

 
   

账号：
     
   

   

密码：
     
       
     
   

   

     
     
       
     
   

 
          String driver = "com.mysql.jdbc.Driver";
     String url = "jdbc:mysql://localhost/one-card?user=root&password=19881123";
  try {
    Class.forName(driver);
    Connection conn = DriverManager.getConnection(url);
    Statement stm = conn.createStatement();
    ResultSet rs = stm.executeQuery("select authority from account where userid = ' " + request.getParameter(account) + " 'and password =" + request.getParameter(psw)+" ' ");
    if(rs == null)
    response.sendRedirect("Loginerror.jsp");
    else
        if(rs.getString(authority).trim()=="Administrator")
     response.sendRedirect("Administrator.jsp");
     if(rs.getString(authority).trim()=="Member")
     response.sendRedirect("Member.jsp");
     
   } catch (ClassNotFoundException e) {
    e.printStackTrace();
    JOptionPane.showMessageDialog(null, "数据库操作失败！");
   } catch (SQLException e) {
    e.printStackTrace();
    JOptionPane.showMessageDialog(null, "数据库操作失败！");
   }
  
  %>
 

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/22960376/viewspace-630569/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/22960376/viewspace-630569/