求救！JSP数据库问题！
我用的数据库是MYSQL，新建了一个数据库叫JOB 其中有一个表叫User，里面有用户名User_ID，密码PassWD，昵称NickName三个属性。做了一个登录框，让用户输入帐号和密码，如果输入的帐号和密码存在，就打印出用户名（因为只是想测试一下数据库的使用）。可是运行出错了错误信息如下：
An error occurred at line: 9 in the jsp file: /Login.jsp
Generated servlet error:
connection cannot be resolved
An error occurred at line: 9 in the jsp file: /Login.jsp
Generated servlet error:
sqlstring cannot be resolved
An error occurred at line: 9 in the jsp file: /Login.jsp
Generated servlet error:
User_ID cannot be resolved
An error occurred at line: 9 in the jsp file: /Login.jsp
Generated servlet error:
PassWD cannot be resolved
An error occurred at line: 9 in the jsp file: /Login.jsp
Generated servlet error:
sqlstring cannot be resolved
An error occurred at line: 9 in the jsp file: /Login.jsp
Generated servlet error:
connection cannot be resolved
我的源代码如下：
<%@ page contentType= "text/html; charset=gb2312 " %>
<%@ page language= "java " %>
<%@ page import= "com.mysql.jdbc.Driver " %>
<%@ page import= "java.sql.* " %>
<%
String susername = request.getParameter( "User ");
String spassword = request.getParameter( "Password ");
//驱动程序名
String driverName= "com.mysql.jdbc.Driver ";
//数据库用户名
String userName= "root ";
//密码
String userPasswd= "1 ";
//数据库名
String dbName= "job ";
//表名
String tableName= "User ";
//联结字符串
String url= "jdbc:mysql://localhost:3306/job ";
Class.forName( "com.mysql.jdbc.Driver ").newInstance();
Connection con=DriverManager.getConnection(url,userName,userPasswd);
Statement statement = connection.createStatement();
sqlstring = "select User_ID,PassWD,NickName from User where susername = ' "+User_ID+ " ' and
spassword= ' "+PassWD+ " ' ";
ResultSet rs = statement.executeQuery(sqlstring);
// 输出用户名
out.print( " <br> <br> <center> <font size=5 color=blue> "+rs.getString( "User_ID ")
+ " </font> <br> <hr width=800 color=gray> </center> ");
out.print( " <br> ");
out.print( "数据库操作成功，恭喜你 ");
rs.close();
statement.close();
connection.close();
%>
请问是哪里错了啊？谢谢
[解决办法]
我们是同命啊 ，老兄！我也是这样的问题，可没人理我们，还是得自己解决啊
------解决方案--------------------
你可能先删掉一部份代码，然后再试，逐步排查
[解决办法]
ResultSet rs = statement.executeQuery(sqlstring); 之后少了 rs.next() 你加上在试试是否出错。
[解决办法]
1.Statement statement = connection.createStatement();
你没有定义connection,你定义的是con;
2.sqlstring = "select User_ID,PassWD,NickName from User where susername= ' "+User_ID+ " ' and spassword= ' "+PassWD+ " ' ";
(1)应该是String sqlstring=......;
(2)User_ID未定义
(3)PassWD未定义
给分吧
[解决办法]
同意enl_green(玉指冰弦)。baidu一下，csdn如何给分。。。
[解决办法]
呵呵~~~~`
baidu下，csdn如何给分~~~~
厉害啊~~~~
[解决办法]
谁有java连接SQL Server 2005的字符串
[解决办法]
我晕 大哥 你写代码还没入门撒
[解决办法]
路过~~
[解决办法]
sqlstring = "select User_ID,PassWD,NickName from User where susername = ' "+User_ID+ " ' and spassword= ' "+PassWD+ " ' ";
User_ID和PassWD是从哪里来的,根据你的上下文
是不是要把下面两个变量传到Sql里面去，
String susername = request.getParameter( "User ");
String spassword = request.getParameter( "Password ");
然后ＳＱＬ写成
sqlstring = "select User_ID,PassWD,NickName from User where User_ID = ' "+susername+ " ' and PassWD= ' "+spssword+ " ' ";
还有好像应该增加判断
String User_ID = " ";
if(rs.next()){
User_ID = rs.getStringA( "User_ID ");
}
