我自己的数据对象处理类 DBUtil

package com.jh.core.db.jdbc;

import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;

import org.apache.log4j.Logger;

class DBUtil {
 private static final Logger logger = (Logger) Logger.getLogger(DBUtil.class);

 public static Object preparedExecute(String dbName,PreparedDBCallBack pcallBack,String sql) {
  Connection conn = null;
  PreparedStatement ps = null;
  try {
   conn = DBConnection.getDBConnection(dbName);
   ps=conn.prepareStatement(sql);
      return pcallBack.execute(ps);
  } catch (Exception e) {
   logger.error("数据变更错误 ", e);
  } finally {
   try {
    DBConnection.closeDBPrepared(ps);
   } finally {
    DBConnection.closeDBConnection(conn);
   }
  }
  return null;
 }
 static public int getIntValue(ResultSet rs) throws SQLException{
  if(rs.next()){
   return rs.getInt(1);
  }
  return 0;
 }
 static public String getStrValue(ResultSet rs) throws SQLException{
  if(rs.next()){
   return rs.getString(1);
  }
  return null;
 }
 static public long getLongValue(ResultSet rs) throws SQLException{
  if(rs.next()){
   return rs.getLong(1);
  }
  return 0;
 }
 static public Object getObjValue(ResultSet rs) throws SQLException{
  if(rs.next()){
   return rs.getObject(1);
  }
  return null;
 }
// public static Object execute(String dbName,DBCallBack callBack,Object  obj) {
//  Connection conn = null;
//  try {
//   conn = DBConnection.getDBConnection(dbName);
//      return callBack.execute( conn);
//  }catch (Exception e) {
//   logger.error("数据变更错误 ", e);
//  }finally {
//    DBConnection.closeDBConnection(conn);
//  }
//  return null;
// }
 public static Object execute(String dbName,DBCallBack callBack) {
  Connection conn = null;
  try {
   conn = DBConnection.getDBConnection( dbName);
      return callBack.execute( conn);
  }catch (Exception e) {
   logger.error("数据变更错误 ", e);
  }finally {
    DBConnection.closeDBConnection(conn);
  }
  return null;
 }
}