<%@ page contentType="text/html;charset=gb2312"%>
<%@ page import="java.sql.*"%>
<jsp:useBean id="conn" scope="page" class="clj.DataBaseCon"/>
<%
String a =(String)request.getParameter("username");
String b =(String)request.getParameter("pass");
ResultSet rs=conn.mySelect("select * from account where username='"+a+"'and pass='"+b+"'");
if (!rs.next()){
out.print("<script>alert('用户名或密码错误!');history.back(-1);</script>");
}
else{
String sql="update account set sumlogin=sumlogin+1 where username='"+a+"'";
int rs1=conn.myUpdate(sql);
session.setAttribute("username",a);
out.print("<script>alert('欢迎光临!'); window.location='index1.jsp';</script>");
}
%>
判断记录集为空不能这样写吗,if (!rs.next())我看到有这样写的啊
org.apache.jasper.JasperException org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:372) org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:292) org.apache.jasper.servlet.JspServlet.service(JspServlet.java:236) javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
root cause
java.lang.NullPointerException org.apache.jsp.logincg_jsp._jspService(logincg_jsp.java:60) org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:94) javax.servlet.http.HttpServlet.service(HttpServlet.java:802) org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:324) org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:292) org.apache.jasper.servlet.JspServlet.service(JspServlet.java:236) javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
----------------解决方案--------------------------------------------------------
不好意思,新来滴,不知道怎么发起自己的主题,麻烦知道的各位兄弟姐妹告诉下,不胜感激
----------------解决方案--------------------------------------------------------
if (!rs.next())这样写没错
java.lang.NullPointerException 应该是你的数据库没链好!~再检查一下
----------------解决方案--------------------------------------------------------
我也遇到了这个问题哦。
我仔细检查过代码,我写的bean也用main函数测试过,结果都正确,但是,运行jsp页面的结果却总是不正确。
我肯定是jsp代码的问题;我的代码如下:
<%@ page contentType="text/html;charset=GBK"%>
<!-- login.jsp -->
<%@ page import="java.sql.*,vcsql.*" %>
<jsp:useBean id="login" scope="session" class="vcsql.bean.Login"/>
<%
String num = request.getParameter("userID");
String pass = request.getParameter("userpasswd");
num = new String(num.getBytes("GBK"));
pass = new String(pass.getBytes("GBK"));
session.setAttribute("stunum",num);
session.setAttribute("stupass",pass);
boolean flag = login.checkLogin(num.trim(),pass.trim());
if(flag)
{
response.sendRedirect("wel.jsp");
}
else
{
response.sendRedirect("fail.jsp");
}
%>
其中vcsql.bean.Login中的chechlogin()是检查用户是否存在的函数,我检查过,它没有问题。
----------------解决方案--------------------------------------------------------