问题描述
<%@pageimport="java.sql.*"contentType="text/html;charset=GBK"%><html><head><metahttp-equiv="Content-Type"content="text/html;charset=GBK"></head><body><%Stringuid=request.getParameter("uid");Stringupassword=request.getParameter("upassword");Stringuname="xxx";try{//建立连接Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");Connectioncon=DriverManager.getConnection("jdbc:odbc:renshiguanli","","");Statementstmt=con.createStatement();//发送SQL语句,进行查询ResultSetrs=stmt.executeQuery("select*from[User]");//输出查询结果while(rs.next()){Stringx=rs.getString("Uid");uname=rs.getString("Uname");Stringy=rs.getString("Upassword");if(!(uid.equals(x)&&upassword.equals(y))){continue;}else{session.setAttribute("uid1",String.valueOf(uid));session.setAttribute("uname1",String.valueOf(uname));%><jsp:forwardpage="indexAdmit.jsp"/><%}}//关闭连接rs.close();stmt.close();con.close();%><jsp:forwardpage="reland.html"/><%}catch(Exceptione){out.println("出错了1!<p>"+e);}%></body></html>//我自己测试了一下将Stringuid=request.getParameter("uid");Stringupassword=request.getParameter("upassword");改成Stringuid="aaa";Stringupassword="aaa";//User表中是有Uid值为aaa(char类型),Upassword值为aaa(char类型)的,但是结果还是一样~我的逻辑没有问题,我以前用access数据库就不要紧,现在用sql就有问题了。