java连接数据库多次循环取数据,为什么会突然出错(SQL2000) hehe`~这个问题我曾经碰到郭~~,你可能是一个Connection 对应了多个ResultSet引起的,当时我这里是General error~~~ 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 至于这个问题我在做项目时老碰到,如下面摘自我项目中的代码,注释部分均有执行时的例外,就是有异常在执行时产生,所以工建议的方法是用一个函数来做,可以反复调用,这样问题就好办了else if(object instanceof Login){ loginObject=(Login)object; try { Class.forName("sun.jdbc.odbc.JdbcOdbcDriver"); Connection con=DriverManager.getConnection("jdbc:odbc:KofSystem","sa",null); PreparedStatement stat=con.prepareStatement("select * from ZjyUser where vUserName=?"); stat.setString(1,loginObject.userName); ResultSet result=stat.executeQuery(); //System.out.println("len="+loginObject.userPassword.length()+">>"+loginObject.userPassword+"<<"); if(result.next()) { /* stat=con.prepareStatement("select * from ZjyUser where vUserName=? and vUserPassword=?"); stat.setString(1,loginObject.userName); stat.setString(2,loginObject.userPassword); result=stat.executeQuery(); if(result.next()) { System.out.println("register user login..."); PrintStream toClient=new PrintStream(inFromClient.getOutputStream()); toClient.println("登陆成功"); toClient.close(); }*/ if(result.getString(4).trim().equals(loginObject.userPassword.trim())) { System.out.println("register user login..."); PrintStream toClient=new PrintStream(inFromClient.getOutputStream()); toClient.println("登陆成功"); toClient.close(); } else { System.out.println("user password error..."); PrintStream toClient=new PrintStream(inFromClient.getOutputStream()); toClient.println("密码错误"); toClient.close(); } } else { System.out.println("the user is not exist..."); PrintStream toClient=new PrintStream(inFromClient.getOutputStream()); toClient.println("用户名错误"); toClient.close(); } } catch(Exception error) { System.out.println("could not execute the query"+error); }} 为什么Action从页面获取值只能获取到第一个表单值 如何更改tomcat的host hibernate 小问题 求助,急 帮我指条行军路线 java.lang.OutOfMemoryError 初学java ,《Java 编程思想--Thinking in JAVA》和《Java编程思想(第2版)》,大家推荐一下 新手报道! 顺便请教一个问题. S2SH框架 Struts2无法映射到action java中使用getResourceAsStream()能不能识别绝对路径 哪位高人有XML SPY的序列号,100分答谢! Hikaru(光)大侠请进,小弟拜谢!
else if(object instanceof Login)
{
loginObject=(Login)object;
try
{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
Connection con=DriverManager.getConnection("jdbc:odbc:KofSystem","sa",null);
PreparedStatement stat=con.prepareStatement("select * from ZjyUser where vUserName=?");
stat.setString(1,loginObject.userName);
ResultSet result=stat.executeQuery();
//System.out.println("len="+loginObject.userPassword.length()+">>"+loginObject.userPassword+"<<");
if(result.next())
{
/*
stat=con.prepareStatement("select * from ZjyUser where vUserName=? and vUserPassword=?");
stat.setString(1,loginObject.userName);
stat.setString(2,loginObject.userPassword);
result=stat.executeQuery();
if(result.next())
{
System.out.println("register user login...");
PrintStream toClient=new PrintStream(inFromClient.getOutputStream());
toClient.println("登陆成功");
toClient.close();
}*/
if(result.getString(4).trim().equals(loginObject.userPassword.trim()))
{
System.out.println("register user login...");
PrintStream toClient=new PrintStream(inFromClient.getOutputStream());
toClient.println("登陆成功");
toClient.close();
}
else
{
System.out.println("user password error...");
PrintStream toClient=new PrintStream(inFromClient.getOutputStream());
toClient.println("密码错误");
toClient.close();
}
}
else
{
System.out.println("the user is not exist...");
PrintStream toClient=new PrintStream(inFromClient.getOutputStream());
toClient.println("用户名错误");
toClient.close();
}
}
catch(Exception error)
{
System.out.println("could not execute the query"+error);
}
}