以前做的jsp连sql2000,由于没有找到这种服务器,所以只好改成access,可是在这出问题了Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
Connection conn=DriverManager.getConnection("jdbc:odbc:student");
Statement stmt=conn.createStatement(); String name=request.getParameter("name");
String password=request.getParameter("password");
out.println(name);
out.println(password);String query="select * from userreg where name =' " +name+ " 'and password = ' "+ password+ " ' ";ResultSet rs=stmt.executeQuery(query);
数据库绝对没问题,查别的都可以,就在这不成了,select * from userreg where name =' " +name+ " 'and password = ' "+ password+ " ' "怀疑是这个问题,网页执行也没报错,但什么都没反映
Connection conn=DriverManager.getConnection("jdbc:odbc:student");
Statement stmt=conn.createStatement(); String name=request.getParameter("name");
String password=request.getParameter("password");
out.println(name);
out.println(password);String query="select * from userreg where name =' " +name+ " 'and password = ' "+ password+ " ' ";ResultSet rs=stmt.executeQuery(query);
数据库绝对没问题,查别的都可以,就在这不成了,select * from userreg where name =' " +name+ " 'and password = ' "+ password+ " ' "怀疑是这个问题,网页执行也没报错,但什么都没反映
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货