代码如下:<%@ page import="java.sql.*"
contentType="text/html;charset=gb2312"%><html>
<head><title>用户登录信息检测</title></head>
<body>
<%
String username=new String(request.getParameter("username").getBytes("ISO8859_1"),"GBK");
String password=new String(request.getParameter("password").getBytes("ISO8859_1"),"GBK");
int isvalid,isadmin,uid;
String uname,sql;
String users="sa";
String pwd="sa";
Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");
String url="jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=bbs"; //bbs 为你的数据库的
Connection conn=DriverManager.getConnection(url,users,pwd);
Statement stmt=conn.createStatement();
sql="SELECT * FROM Users WHERE UserName='"+username+"'AND PassWord='"+password+"'";
ResultSet rs=stmt.executeQuery(sql);
if(rs.next())
{
uname=rs.getString("UserName");
uid= rs.getInt("ID");
isadmin=rs.getInt("IsAdmin");
isvalid=rs.getInt("IsValid");
//uid=Integer.parseInt(rs.getString("ID").toString());
//isadmin=rs.getInt("IsAdmin");
//isvalid=rs.getInt("IsValid");
// isadmin=Integer.parseInt(rs.getString("IsAdmin").toString());
// isvalid=Integer.parseInt(rs.getString("IsValid").toString());
if(isadmin==1&&isvalid==1)
{
session.setAttribute("current_id",uid);
session.setAttribute("current_name",uname);
response.sendRedirect("/bbs/manage.jsp");
}
if(isadmin==0&&isvalid==1)
{
session.setAttribute("current_id",uid);
session.setAttribute("current_name",uname);
response.sendRedirect("/bbs/listarticle.jsp");
}
if(isadmin==0&&isvalid==0)
{
out.print("<font color='red'>");
out.print("您注册后还未通过审核不能进入技术论坛管理系统");
out.print("<br>经过5秒网页会自动转到登录页面");
out.print("</font>");
response.setHeader("Refresh","5;URL=login.html");
}
}
else
{
out.print("<font color='red'>");
out.print("用户名或密码错误");
out.print("<br>经过5秒网页会自动转到登录页面");
out.print("</font>");
response.setHeader("Refresh","5;URL=login.html");
}
%>
</body>
</html>
异常:The server encountered an internal error () that prevented it from fulfilling this request.exception org.apache.jasper.JasperException: java.lang.Integer
org.apache.jasper.servlet.JspServletWrapper.handleJspException(JspServletWrapper.java:460)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:373)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:329)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:265)
javax.servlet.http.HttpServlet.service(HttpServlet.java:729)
root cause java.lang.ClassCastException: java.lang.Integer
org.apache.jsp.listarticle_jsp._jspService(listarticle_jsp.java:51)
org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:98)
javax.servlet.http.HttpServlet.service(HttpServlet.java:729)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:331)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:329)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:265)
javax.servlet.http.HttpServlet.service(HttpServlet.java:729)
note The full stack trace of the root cause is available in the Apache Tomcat/5.5.28 logs.小弟做毕业设计遇到这个问题,希望各位大侠帮我解决一下
contentType="text/html;charset=gb2312"%><html>
<head><title>用户登录信息检测</title></head>
<body>
<%
String username=new String(request.getParameter("username").getBytes("ISO8859_1"),"GBK");
String password=new String(request.getParameter("password").getBytes("ISO8859_1"),"GBK");
int isvalid,isadmin,uid;
String uname,sql;
String users="sa";
String pwd="sa";
Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");
String url="jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=bbs"; //bbs 为你的数据库的
Connection conn=DriverManager.getConnection(url,users,pwd);
Statement stmt=conn.createStatement();
sql="SELECT * FROM Users WHERE UserName='"+username+"'AND PassWord='"+password+"'";
ResultSet rs=stmt.executeQuery(sql);
if(rs.next())
{
uname=rs.getString("UserName");
uid= rs.getInt("ID");
isadmin=rs.getInt("IsAdmin");
isvalid=rs.getInt("IsValid");
//uid=Integer.parseInt(rs.getString("ID").toString());
//isadmin=rs.getInt("IsAdmin");
//isvalid=rs.getInt("IsValid");
// isadmin=Integer.parseInt(rs.getString("IsAdmin").toString());
// isvalid=Integer.parseInt(rs.getString("IsValid").toString());
if(isadmin==1&&isvalid==1)
{
session.setAttribute("current_id",uid);
session.setAttribute("current_name",uname);
response.sendRedirect("/bbs/manage.jsp");
}
if(isadmin==0&&isvalid==1)
{
session.setAttribute("current_id",uid);
session.setAttribute("current_name",uname);
response.sendRedirect("/bbs/listarticle.jsp");
}
if(isadmin==0&&isvalid==0)
{
out.print("<font color='red'>");
out.print("您注册后还未通过审核不能进入技术论坛管理系统");
out.print("<br>经过5秒网页会自动转到登录页面");
out.print("</font>");
response.setHeader("Refresh","5;URL=login.html");
}
}
else
{
out.print("<font color='red'>");
out.print("用户名或密码错误");
out.print("<br>经过5秒网页会自动转到登录页面");
out.print("</font>");
response.setHeader("Refresh","5;URL=login.html");
}
%>
</body>
</html>
异常:The server encountered an internal error () that prevented it from fulfilling this request.exception org.apache.jasper.JasperException: java.lang.Integer
org.apache.jasper.servlet.JspServletWrapper.handleJspException(JspServletWrapper.java:460)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:373)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:329)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:265)
javax.servlet.http.HttpServlet.service(HttpServlet.java:729)
root cause java.lang.ClassCastException: java.lang.Integer
org.apache.jsp.listarticle_jsp._jspService(listarticle_jsp.java:51)
org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:98)
javax.servlet.http.HttpServlet.service(HttpServlet.java:729)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:331)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:329)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:265)
javax.servlet.http.HttpServlet.service(HttpServlet.java:729)
note The full stack trace of the root cause is available in the Apache Tomcat/5.5.28 logs.小弟做毕业设计遇到这个问题,希望各位大侠帮我解决一下
解决方案 »
- js 创建动态文本框,onclick如何获取值?
- 取Oracle字段注释编码转换的问题
- 请教,我在myeclipse里面导入了一个项目,原来的就起不来了
- 新建了个struts1.3的web项目,在项目中的一个JSP中插入struts-logic标签<logic:iterate id="" name="" >
- jsp在dreamwear中通过语法,在eclipse中错了,是不是因为<form></form>不能放<td>
- java连sql server2000的问题
- JSP连接MSSQL2000数据库碰到的问题,
- spring关于ContextLoaderListener的问题
- StringUtils是哪个包下的类?
- spring自动注入问题,求大神帮忙!
- 急、急、急、、、
- 请教 菜单问题?他这个是怎么做的?有源码不?[
{
uname=rs.getString("UserName");
uid= rs.getInt("ID");
isadmin=rs.getInt("IsAdmin");
isvalid=rs.getInt("IsValid");
这些地方有问题
//ResultSet rs=stmt.executeQuery(sql);这个取得的结果rs为一个结果集,当然在你这里只是用户验证 取得的只是单一的一个值 但是要取到值还是得rs.get(i)
uname = rs.get(0).getString("UserName");返回第一个查询结果的usernae值