求救,jdbc驱动 呵呵,并非驱动的问题。是你的结果集不支持前后滚动;创建statement的代码应为:stmt = conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE); 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 package tics;import java.util.*;import java.sql.*;import java.io.*;import javax.naming.*;import javax.sql.*;import org.apache.log4j.Logger;/** * 连接数据库,取得VATCODE,更改SB_FB提交标识,执行SQL语句(查询或更改) */public class DbConnection { Connection conn = null; Statement stmt = null; ResultSet rset = null; static Logger logger = Logger.getLogger("tics.db"); public DbConnection() { } /************************************************ * 打开数据库连接 * 通过命名为etaxDS的DataSource连接数据库 ************************************************/ public boolean openConnection() { try { Context ctx = new InitialContext(); javax.sql.DataSource ds = (javax.sql.DataSource)ctx.lookup("ticsDS"); this.conn = ds.getConnection(); logger.debug("openConnection ok") ; //this.conn = DriverManager.getConnection ("jdbc:WebLogic:pool:etax Connection Pool ",null); } catch (Exception e) { logger.error("打开数据库连接错误!" + e.getMessage()); return false; } return true; } /************************************************* * executeQuery and executeUpdate * query and update DB *************************************************/ public ResultSet executeQuery(String query) throws SQLException { //ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_UPDATABLE stmt = conn.createStatement(); rset = stmt.executeQuery(query); logger.debug("executeQuery(" + query + ")"); return rset; } public ResultSet executeScrollQuery(String query) throws SQLException { //ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_UPDATABLE stmt = conn.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE, ResultSet.CONCUR_UPDATABLE); rset = stmt.executeQuery(query); logger.debug("executeScrollQuery(" + query + ")"); return rset; } public void executeUpdate(String query) throws SQLException { stmt = conn.createStatement(); stmt.executeUpdate(query); logger.debug("executeUpdate(" + query + ")"); if (stmt != null) stmt.close(); } public void rsclose() throws SQLException { //if(rset != null) rset.close(); //rset = null; if (stmt != null) stmt.close(); stmt = null; logger.debug("rsclose ok"); } public void close() throws SQLException { //if(rset != null) rset.close(); if (stmt != null) stmt.close(); if (conn != null) conn.close(); logger.debug("close ok"); } protected void finalize() throws Throwable { close(); } public static void main(String [] args) { //Design for test purpose. //DbConnection dc = new DbConnection(); //System.out.println(dc.openConnection()); }}如果是这个类,用execeuteScrool public ResultSet executeScrollQuery(String query) throws SQLException { //ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_UPDATABLE stmt = conn.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE, ResultSet.CONCUR_UPDATABLE); rset = stmt.executeQuery(query); logger.debug("executeScrollQuery(" + query + ")"); return rset; } public void executeUpdate(String query) throws SQLException { stmt = conn.createStatement(); stmt.executeUpdate(query); logger.debug("executeUpdate(" + query + ")"); if (stmt != null) stmt.close(); } 跪求smarty4j java实例 <jsp:useBean 引入时出现500错误码 Eclipse怎么集成Maven要现在最新的集成方法 求助poi加密Workbook的方法! 大话帮我看看,我这条分页SQL有什么问题啊?在线等! struts1 第一次访问页面使select有option选项 jsp页面怎样分类显示 struts2和spring2.5怎样实现用户的退出功能? tomact的启动问题 十分有用的代码:检测服务器环境的JSP Info 使用Hibernate时遇见的一个问题. 小弟现在分都送完了,还想请高手帮个忙。。。。在线等待一个javamail的问题。。。
import java.sql.*;
import java.io.*;
import javax.naming.*;
import javax.sql.*;
import org.apache.log4j.Logger;/**
* 连接数据库,取得VATCODE,更改SB_FB提交标识,执行SQL语句(查询或更改)
*/
public class DbConnection {
Connection conn = null;
Statement stmt = null;
ResultSet rset = null;
static Logger logger = Logger.getLogger("tics.db"); public DbConnection() { }
/************************************************
* 打开数据库连接
* 通过命名为etaxDS的DataSource连接数据库
************************************************/
public boolean openConnection() {
try {
Context ctx = new InitialContext();
javax.sql.DataSource ds = (javax.sql.DataSource)ctx.lookup("ticsDS");
this.conn = ds.getConnection();
logger.debug("openConnection ok") ;
//this.conn = DriverManager.getConnection ("jdbc:WebLogic:pool:etax Connection Pool ",null);
} catch (Exception e) {
logger.error("打开数据库连接错误!" + e.getMessage());
return false;
}
return true;
} /*************************************************
* executeQuery and executeUpdate
* query and update DB
*************************************************/
public ResultSet executeQuery(String query) throws SQLException
{
//ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_UPDATABLE
stmt = conn.createStatement();
rset = stmt.executeQuery(query);
logger.debug("executeQuery(" + query + ")");
return rset;
} public ResultSet executeScrollQuery(String query) throws SQLException
{
//ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_UPDATABLE
stmt = conn.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,
ResultSet.CONCUR_UPDATABLE);
rset = stmt.executeQuery(query);
logger.debug("executeScrollQuery(" + query + ")");
return rset;
} public void executeUpdate(String query) throws SQLException {
stmt = conn.createStatement();
stmt.executeUpdate(query);
logger.debug("executeUpdate(" + query + ")");
if (stmt != null)
stmt.close();
} public void rsclose() throws SQLException {
//if(rset != null) rset.close();
//rset = null;
if (stmt != null)
stmt.close();
stmt = null;
logger.debug("rsclose ok");
} public void close() throws SQLException {
//if(rset != null) rset.close();
if (stmt != null)
stmt.close();
if (conn != null)
conn.close();
logger.debug("close ok");
} protected void finalize() throws Throwable {
close();
} public static void main(String [] args) {
//Design for test purpose.
//DbConnection dc = new DbConnection();
//System.out.println(dc.openConnection());
}
}如果是这个类,用execeuteScrool
{
//ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_UPDATABLE
stmt = conn.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,
ResultSet.CONCUR_UPDATABLE);
rset = stmt.executeQuery(query);
logger.debug("executeScrollQuery(" + query + ")");
return rset;
} public void executeUpdate(String query) throws SQLException {
stmt = conn.createStatement();
stmt.executeUpdate(query);
logger.debug("executeUpdate(" + query + ")");
if (stmt != null)
stmt.close();
}