关键是我也不知道是哪里的代码有问题啊,时好时坏的!
数据库连接用的是连接池,也是来源也网络:DBConnectionManager.java
数据库操作类:
package dbConnect;import java.io.PrintStream;
import java.sql.*;public class DBQuery
{ Connection conn;
ResultSet rs;
Statement stmt;
CallableStatement cs;
private DBConnectionManager connMgr; public DBQuery()
{
conn = null;
rs = null;
stmt = null;
try
{
connMgr=DBConnectionManager.getInstance();
}
catch(Exception classnotfoundexception)
{
System.err.println("data begin err: " + classnotfoundexception.getMessage());
}
} public ResultSet executeQuery(String s)
{
rs = null;
try
{
conn=connMgr.getConnection("sqlserver");
stmt = conn.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_UPDATABLE);
rs = stmt.executeQuery(s);
}
catch(SQLException sqlexception)
{
System.err.println("data query connect err:" + sqlexception.getMessage());
System.out.println(s);
}
finally{
connMgr.freeConnection("sqlserver",conn);
return rs;
}
}
public CallableStatement executeProc(String s){
rs = null;
try
{
conn=connMgr.getConnection("sqlserver");
cs = conn.prepareCall(s);
return cs;
}
catch(SQLException sqlexception)
{
System.err.println("data query connect err:" + sqlexception.getMessage());
System.out.println(s);
}
finally{
connMgr.freeConnection("sqlserver",conn);
return cs;
}
}
public int executeUpdate(String s)
{
int intResult = -1;
try
{
conn = connMgr.getConnection("sqlserver");
stmt = conn.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_UPDATABLE);
intResult = stmt.executeUpdate(s);
}
catch(SQLException sqlexception)
{
System.err.println("data update connect err:" + sqlexception.getMessage());
System.out.println(s);
intResult = -1;
}
finally{
connMgr.freeConnection("sqlserver",conn);
return intResult;
}
} public void cls()
{
try{
if(stmt!=null) stmt.close();
}catch(SQLException ex){
System.err.println(ex.getMessage());
}
}
}
数据库连接用的是连接池,也是来源也网络:DBConnectionManager.java
数据库操作类:
package dbConnect;import java.io.PrintStream;
import java.sql.*;public class DBQuery
{ Connection conn;
ResultSet rs;
Statement stmt;
CallableStatement cs;
private DBConnectionManager connMgr; public DBQuery()
{
conn = null;
rs = null;
stmt = null;
try
{
connMgr=DBConnectionManager.getInstance();
}
catch(Exception classnotfoundexception)
{
System.err.println("data begin err: " + classnotfoundexception.getMessage());
}
} public ResultSet executeQuery(String s)
{
rs = null;
try
{
conn=connMgr.getConnection("sqlserver");
stmt = conn.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_UPDATABLE);
rs = stmt.executeQuery(s);
}
catch(SQLException sqlexception)
{
System.err.println("data query connect err:" + sqlexception.getMessage());
System.out.println(s);
}
finally{
connMgr.freeConnection("sqlserver",conn);
return rs;
}
}
public CallableStatement executeProc(String s){
rs = null;
try
{
conn=connMgr.getConnection("sqlserver");
cs = conn.prepareCall(s);
return cs;
}
catch(SQLException sqlexception)
{
System.err.println("data query connect err:" + sqlexception.getMessage());
System.out.println(s);
}
finally{
connMgr.freeConnection("sqlserver",conn);
return cs;
}
}
public int executeUpdate(String s)
{
int intResult = -1;
try
{
conn = connMgr.getConnection("sqlserver");
stmt = conn.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_UPDATABLE);
intResult = stmt.executeUpdate(s);
}
catch(SQLException sqlexception)
{
System.err.println("data update connect err:" + sqlexception.getMessage());
System.out.println(s);
intResult = -1;
}
finally{
connMgr.freeConnection("sqlserver",conn);
return intResult;
}
} public void cls()
{
try{
if(stmt!=null) stmt.close();
}catch(SQLException ex){
System.err.println(ex.getMessage());
}
}
}
解决方案 »
- 关于jboss+webservice部署的奇怪的问题
- iterator迭代radio问题,如何从后台得到从前台传过去的值?帮帮我~~
- 请教ORACLE数据库中的一个SQL
- 请教个问题
- 如何将保存进数据库的图片读出来?
- jsp页面间参数传递,请高手帮忙
- 标志库问题,急求助!
- 在JBUILDER7中如何使用版本控制来小组开发?(50分)
- <input type="file" name="" /> action中获取不到图片信息
- SSH框架配置了log4j.properties后出现了很多信息,我不太会看,请问这些信息对是些警告还是报了错
- 救火
- 在先等待!!如何将html文件与jsp文件连接执行?源代码以及出现的错误提示如下:(顺便说一句:多谢刚才个位高手帮忙!贴子怎么结不了?
如果我把ResultSet.CONCUR_UPDATABLE改为ResultSet.CONCUR_READ_ONLY服务器就会稳定很多,不过也会出现其他错误!烦死我了!
这个问题不解决我的程序算是白做了!
苦命的人啊!
wuwuwuwuwu~~~~~~~~~~~~~~~
例如 select a,b,c from table
你读取的时候也要按照a,b,c的顺序来读。
不然就会出你上面的错。