<body>
<%
String name=user.getName().trim();
String password=user.getPassword().trim();
int i=0;
i=selectsql.check(name,password);
if(i==1){
session.setAttribute("ok","ok");
response.sendRedirect("../index.jsp");
}
if(i==0){
%>
<script>
window.alert("登录失败");
</script>
<%
response.sendRedirect("adminlogin.jsp");
}
%>
</body>
1.
public ResultSet executeQuery(String sql){
if(cn==null){
getConnection();
}
try {
return cn.createStatement().executeQuery(sql);
} catch (SQLException e) {
e.printStackTrace();
return null;
}finally{
}
}
2.
public static int check(String name,String password){
int i=0;
ResultSet rs=null;
connsqlserver connsqlserver=new connsqlserver();
String names="";
String passwords="";
String sql="select name,password from tb_usertable where name="+"'"+name+"'"+" and password="+"'"+password+"'";
rs=connsqlserver.executeQuery(sql);
System.out.println(sql);
if(rs!=null)
try {
while(rs.next()){
names=rs.getString(name);
passwords=rs.getString(password);
if(names!=null){
i=1;
}
}
} catch (SQLException e) {
e.printStackTrace();
}
System.out.println(i);
connsqlserver.close();
return i;
}
错误提示:
select name,password from tb_usertable where name='456' and password='2'
java.sql.SQLException: Column '456' not found.
at com.mysql.jdbc.ResultSet.findColumn(ResultSet.java:950)
at com.mysql.jdbc.ResultSet.getString(ResultSet.java:5015)
at org.apache.tomcat.dbcp.dbcp.DelegatingResultSet.getString(DelegatingResultSet.java:225)
at com.wsy.selectsql.check(selectsql.java:61)
at org.apache.jsp.houtai.houtaitest_jsp._jspService(houtaitest_jsp.java:89)
at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:393)
at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:320)
at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:266)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at com.wsy.Filter.ModifyCode.doFilter(ModifyCode.java:23)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:175)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:128)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:263)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:844)
at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:584)
at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:447)
at java.lang.Thread.run(Unknown Source)
0求指导啊。。
<%
String name=user.getName().trim();
String password=user.getPassword().trim();
int i=0;
i=selectsql.check(name,password);
if(i==1){
session.setAttribute("ok","ok");
response.sendRedirect("../index.jsp");
}
if(i==0){
%>
<script>
window.alert("登录失败");
</script>
<%
response.sendRedirect("adminlogin.jsp");
}
%>
</body>
1.
public ResultSet executeQuery(String sql){
if(cn==null){
getConnection();
}
try {
return cn.createStatement().executeQuery(sql);
} catch (SQLException e) {
e.printStackTrace();
return null;
}finally{
}
}
2.
public static int check(String name,String password){
int i=0;
ResultSet rs=null;
connsqlserver connsqlserver=new connsqlserver();
String names="";
String passwords="";
String sql="select name,password from tb_usertable where name="+"'"+name+"'"+" and password="+"'"+password+"'";
rs=connsqlserver.executeQuery(sql);
System.out.println(sql);
if(rs!=null)
try {
while(rs.next()){
names=rs.getString(name);
passwords=rs.getString(password);
if(names!=null){
i=1;
}
}
} catch (SQLException e) {
e.printStackTrace();
}
System.out.println(i);
connsqlserver.close();
return i;
}
错误提示:
select name,password from tb_usertable where name='456' and password='2'
java.sql.SQLException: Column '456' not found.
at com.mysql.jdbc.ResultSet.findColumn(ResultSet.java:950)
at com.mysql.jdbc.ResultSet.getString(ResultSet.java:5015)
at org.apache.tomcat.dbcp.dbcp.DelegatingResultSet.getString(DelegatingResultSet.java:225)
at com.wsy.selectsql.check(selectsql.java:61)
at org.apache.jsp.houtai.houtaitest_jsp._jspService(houtaitest_jsp.java:89)
at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:393)
at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:320)
at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:266)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at com.wsy.Filter.ModifyCode.doFilter(ModifyCode.java:23)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:175)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:128)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:263)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:844)
at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:584)
at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:447)
at java.lang.Thread.run(Unknown Source)
0求指导啊。。
names=rs.getString(1);
passwords=rs.getString(2);