exception org.apache.jasper.JasperException: Exception in JSP: /m/user_land/chklogin.jsp:8380: String password=new String(request.getParameter("password"));
81: int role=0;
82: ResultSet rs=jdbcbean.executeQuery("select * from user where userid='"+username+"' and password='"+password+"'");
83: if(rs.next())
84: {String check="T";
85: session.setAttribute("login",check);
86: role=rs.getInt("role");
Stacktrace:
org.apache.jasper.servlet.JspServletWrapper.handleJspException(JspServletWrapper.java:504)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:393)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:314)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:264)
javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
81: int role=0;
82: ResultSet rs=jdbcbean.executeQuery("select * from user where userid='"+username+"' and password='"+password+"'");
83: if(rs.next())
84: {String check="T";
85: session.setAttribute("login",check);
86: role=rs.getInt("role");
Stacktrace:
org.apache.jasper.servlet.JspServletWrapper.handleJspException(JspServletWrapper.java:504)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:393)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:314)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:264)
javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
解决方案 »
- 一个购物网站,当点击结算按钮的0.01毫秒之前,正好管理就员把商品价格改了。要怎样才能在结算的时候使用的是修改后的价格?
- 十万火急,在myeclipse下发布项目出现端口被占,不知道如何更改
- 分享 Jquery+JAVA实现开心网上传头像剪裁功能
- FCKeditor将图片放到数据库问题
- jijiji
- 在jsp中显示execel的内容?解决马上结贴!
- 为什么页面显示不出来?
- jsp+sql server 2000的问题
- 对于WAP来说,在set cookie的时候,不能够setPath("/")吗?
- 十万火急!百分求助!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!
- http://gcc001.mycool.net我的网站,友情链接有几个我的作品,我还没毕业,在公司做了3个月,工资800,经理说加工资没说加多少?没提转正的
- 一个简单的问题
还是页面代码写的有问题!
package manage;
import java.sql.*;public class JdbcBean {
Connection con=null;
ResultSet rs=null;
int value=0;//实例化,装载JDBC驱动
public JdbcBean() {
try {
Class.forName("org.gjt.mm.mysql.Driver");
}
catch (ClassNotFoundException e) {}
} //查询后返回的数据集
public ResultSet executeQuery(String sql){
try{
con=DriverManager.getConnection("jdbc:mysql://localhost/secman","root","root");
Statement stmt = con.createStatement ();
rs=stmt.executeQuery(sql);
}
catch(SQLException e)
{}
return rs;
} //更新数据库
public int executeUpdate(String sql){
try{
con=DriverManager.getConnection("jdbc:mysql://localhost/secman","root","root");
Statement stmt = con.createStatement ();
System.out.println(11);
value=stmt.executeUpdate(sql);
System.out.println(22);
}
catch(SQLException e)
{e.printStackTrace();}
return value;
} //关闭数据库
public void closeDB(){
try{
rs.close();
con.close();
}catch(SQLException e)
{}
}}
<%
String username=new String(request.getParameter("username"));
String password=new String(request.getParameter("password"));
int role=0;
ResultSet rs=jdbcbean.executeQuery("select * from user where userid='"+username+"' and password='"+password+"'");
if(rs.next())
{String check="T";
session.setAttribute("login",check);
role=rs.getInt("role");
if(role==1)
response.sendRedirect("admin.jsp");
else
response.sendRedirect("user.jsp");
}
else {
%>
<h3> </h3>
<h3> <font size="+1"><strong> </strong> <font size="3">用户名或密码错误,请重新登录!</font></font></h3>
<%
} rs.close();
jdbcbean.closeDB();
%>