<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求指导啊。。