while(rslogin.next())创建错误 [英] while(rslogin.next()) creates error
问题描述
[HTML] id = request.getParameter(" txtId");
51:pwd = request.getParameter(" txtPwd");
52: rslogin = getAllData(" select * from login where username =''" + id +"''and password =''" + pwd +"''");
53:while(rslogin.next())
54:{
55:flag = 1;
56:session.setAttribute(" ;用户ID",ID); [/ HTML]
上面给出的是我的编码。在我的登录表中我有用户名和密码。
但是当我使用Tomcat跟踪应用程序时出现以下错误。
org.apache.jasper.JasperException:在第53行处理JSP页面/myLogTest.jsp时发生异常
Stacktrace:
org.apache.jasper.servlet.JspServletWrapper.handle JspException(JspServletWrapper.java:515)
org.apache.jasper.servlet.JspServletWrapper.servic e(JspServletWrapper。 java:426)
org.apache.jasper.servlet.JspServlet.serviceJspFil e(JspServlet.java:320)
org.apache.jasper.servlet.JspServlet.service (JspSe rvlet.java:266)
javax.servlet.http.HttpServlet.service(HttpServlet .java:803)
根本原因
java.lang.NullPointerException
org.apache.jsp.myLogTest_jsp._jspService(myLogTest _jsp.java:170)
org.apache。 jasper.runtime.HttpJspBase.service(HTTP JspBase.java:70)
javax.servlet.http.HttpServlet.service(HttpServlet .java:803)
org.apache.jasper.servlet.JspServletWrapper.servic e (JspServletWrapper.java:384)
org.apache.jasper.servlet.JspServlet.serviceJspFil e(JspServlet.java:320)
org.apache.jasper.servlet。 JspServlet.service(JspSe rvlet.java:266)
javax.servlet.http.HttpServlet.service(HttpServlet .java:803)
我能做什么?请帮助我......:)
[HTML]id=request.getParameter("txtId");
51: pwd=request.getParameter("txtPwd");
52: rslogin=getAllData("select * from login where username=''"+id+"'' and password=''"+pwd+"''");
53: while(rslogin.next())
54: {
55: flag=1;
56: session.setAttribute("UserId",id); [/HTML]
The above given is my coding.In my login table i have username and password.
But when iam excecuing the application with Tomcat following error is occuring.
org.apache.jasper.JasperException: An exception occurred processing JSP page /myLogTest.jsp at line 53
Stacktrace:
org.apache.jasper.servlet.JspServletWrapper.handle JspException(JspServletWrapper.java:515)
org.apache.jasper.servlet.JspServletWrapper.servic e(JspServletWrapper.java:426)
org.apache.jasper.servlet.JspServlet.serviceJspFil e(JspServlet.java:320)
org.apache.jasper.servlet.JspServlet.service(JspSe rvlet.java:266)
javax.servlet.http.HttpServlet.service(HttpServlet .java:803)
root cause
java.lang.NullPointerException
org.apache.jsp.myLogTest_jsp._jspService(myLogTest _jsp.java:170)
org.apache.jasper.runtime.HttpJspBase.service(Http JspBase.java:70)
javax.servlet.http.HttpServlet.service(HttpServlet .java:803)
org.apache.jasper.servlet.JspServletWrapper.servic e(JspServletWrapper.java:384)
org.apache.jasper.servlet.JspServlet.serviceJspFil e(JspServlet.java:320)
org.apache.jasper.servlet.JspServlet.service(JspSe rvlet.java:266)
javax.servlet.http.HttpServlet.service(HttpServlet .java:803)
What i can Do ? Pleas Help me ...... :)
推荐答案
[HTML] id = request.getParameter(" ; txtId");
51:pwd = request.getParameter(" txtPwd");
52:rslogin = getAllData(" select * from login where username = ''" + id +"''和password =''" + pwd +"''");
53:while(rslogin.next())
54:{
55:flag = 1;
56:session.setAttribute(" UserId",id); [/ HTML]
上面给出的是我的编码。在我的登录表中我有用户名和密码。
但是当我使用Tomcat跟踪应用程序时出现以下错误。
org.apache.jasper.JasperException:在第53行处理JSP页面/myLogTest.jsp时发生异常
Stacktrace:
org.apache.jasper.servlet.JspServletWrapper.handle JspException(JspServletWrapper.java:515)
org.apache.jasper.servlet.JspServletWrapper.servic e(JspServletWrapper。 java:426)
org.apache.jasper.servlet.JspServlet.serviceJspFil e(JspServlet.java:320)
org.apache.jasper.servlet.JspServlet.service (JspSe rvlet.java:266)
javax.servlet.http.HttpServlet.service(HttpServlet .java:803)
根本原因
java.lang.NullPointerException
org.apache.jsp.myLogTest_jsp._jspService(myLogTest _jsp.java:170)
org.apache。 jasper.runtime.Htt pJspBase.service(Http JspBase.java:70)
javax.servlet.http.HttpServlet.service(HttpServlet .java:803)
org.apache.jasper.servlet .JspServletWrapper.servic e(JspServletWrapper.java:384)
org.apache.jasper.servlet.JspServlet.serviceJspFil e(JspServlet.java:320)
org.apache .jasper.servlet.JspServlet.service(JspSe rvlet.java:266)
javax.servlet.http.HttpServlet.service(HttpServlet .java:803)
我是什么可以做 ?请帮助我...... :)
[HTML]id=request.getParameter("txtId");
51: pwd=request.getParameter("txtPwd");
52: rslogin=getAllData("select * from login where username=''"+id+"'' and password=''"+pwd+"''");
53: while(rslogin.next())
54: {
55: flag=1;
56: session.setAttribute("UserId",id); [/HTML]
The above given is my coding.In my login table i have username and password.
But when iam excecuing the application with Tomcat following error is occuring.
org.apache.jasper.JasperException: An exception occurred processing JSP page /myLogTest.jsp at line 53
Stacktrace:
org.apache.jasper.servlet.JspServletWrapper.handle JspException(JspServletWrapper.java:515)
org.apache.jasper.servlet.JspServletWrapper.servic e(JspServletWrapper.java:426)
org.apache.jasper.servlet.JspServlet.serviceJspFil e(JspServlet.java:320)
org.apache.jasper.servlet.JspServlet.service(JspSe rvlet.java:266)
javax.servlet.http.HttpServlet.service(HttpServlet .java:803)
root cause
java.lang.NullPointerException
org.apache.jsp.myLogTest_jsp._jspService(myLogTest _jsp.java:170)
org.apache.jasper.runtime.HttpJspBase.service(Http JspBase.java:70)
javax.servlet.http.HttpServlet.service(HttpServlet .java:803)
org.apache.jasper.servlet.JspServletWrapper.servic e(JspServletWrapper.java:384)
org.apache.jasper.servlet.JspServlet.serviceJspFil e(JspServlet.java:320)
org.apache.jasper.servlet.JspServlet.service(JspSe rvlet.java:266)
javax.servlet.http.HttpServlet.service(HttpServlet .java:803)
What i can Do ? Pleas Help me ...... :)
在任何情况下你的getAllData方法都可以返回null吗?
Are there any situations where your getAllData method can return null?
在任何情况下你的getAllData方法都可以返回null吗?
Are there any situations where your getAllData method can return null?
这是我使用的代码。我将rslogin声明为null。
[HTML]<%
String id ="",pwd ="",area ="" ;;
int flag = 0;
connectionMe ();
java.sql.ResultSet rslogin = null;
if(request.getParameter(" loginhidden")!= null)
{
if(request.getParameter(" loginhidden")。equals(" log in"))
{
id = request.getParameter(" txtId");
pwd = request.getParameter(" txtPwd");
rslogin = getAllData(" select * from login where username =''" + id +"''和password =''" + pwd +"''");
while(rslogin.next())
{
flag = 1;
// session.setAttribute(" UserId",id);
out.print(" Login Successfully ....");
// session.setAttribute(" message","");
//重定向网址
response.sendRedirect(" process.jsp");
}
if (flag == 0)
{
session.setAttribute(" message",无效的用户名或密码);
}
}
}
%> [/ HTML]
This is the code i used.Here i declared rslogin as null.
[HTML]<%
String id="",pwd="",area="";
int flag=0;
connectionMe();
java.sql.ResultSet rslogin=null;
if(request.getParameter("loginhidden")!=null)
{
if(request.getParameter("loginhidden").equals("log in"))
{
id=request.getParameter("txtId");
pwd=request.getParameter("txtPwd");
rslogin=getAllData("select * from login where username=''"+id+"'' and password=''"+pwd+"''");
while(rslogin.next())
{
flag=1;
// session.setAttribute("UserId",id);
out.print("Login Successfully....");
// session.setAttribute("message","");
// redirect url
response.sendRedirect("process.jsp");
}
if(flag==0)
{
session.setAttribute("message","Invalid UserName or Password");
}
}
}
%>[/HTML]
这是我使用的代码。我将rslogin声明为null。
[HTML]<%
String id ="",pwd ="",area ="" ;;
int flag = 0;
connectionMe();
java.sql.ResultSet rslogin = null;
if(request.getParameter(" loginhidden")!= null)
{
if(request.getParameter(" loginhidden")。equals(" log in"))
{
id = request.getParameter(" txtId");
pwd = request.getParameter(" txtPwd");
rslogin = getAllData(" select * from login where username =''" + id +"''and password =''" + pwd +"''");
while(rslogin.next())
{
flag = 1;
// session.setAttribute(" UserId",id );
out.print(" Login Successfully ....");
// session.setAttribute(" message","");
//重定向网址
response.sendRedirect(" process.jsp");
}
if (flag == 0)
{
session.setAttribute(" message",无效的用户名或密码);
}
}
}
%> [/ HTML]
This is the code i used.Here i declared rslogin as null.
[HTML]<%
String id="",pwd="",area="";
int flag=0;
connectionMe();
java.sql.ResultSet rslogin=null;
if(request.getParameter("loginhidden")!=null)
{
if(request.getParameter("loginhidden").equals("log in"))
{
id=request.getParameter("txtId");
pwd=request.getParameter("txtPwd");
rslogin=getAllData("select * from login where username=''"+id+"'' and password=''"+pwd+"''");
while(rslogin.next())
{
flag=1;
// session.setAttribute("UserId",id);
out.print("Login Successfully....");
// session.setAttribute("message","");
// redirect url
response.sendRedirect("process.jsp");
}
if(flag==0)
{
session.setAttribute("message","Invalid UserName or Password");
}
}
}
%>[/HTML]
重要的是这一行
The important line is this one
这篇关于while(rslogin.next())创建错误的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!