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); }} 文件保存路径问题 如何获取Tomcat的安装路径? 求助:SSH连接SQL Server2005问题 求教Struts的权限登录问题(strust+hibernate) hibernate criteria example 设置主键为参数的问题 大家都是怎么学习J2EE的?有什么经验教训? tomcat 问题 (愿 地方不行,换个地方就行????????) 急!TOMCAT架好了,修改默认页面 我写了一个站点计数器,可是不知为什么TOMCAT总报错? 问题出在哪里呢?撒分!! 哪位高人有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);
}
}