QueryRunner

package webbook.util;

import java.sql.SQLException;
import java.util.List;

import javax.naming.Context;
import javax.naming.InitialContext;
import javax.naming.NamingException;
import javax.sql.DataSource;
import org.apache.commons.dbutils.QueryRunner;
import org.apache.commons.dbutils.ResultSetHandler;

public class OracleUtil {
 private String dataSourceName;
 private DataSource ds;

 public OracleUtil(String dataSourceName) {
  
  this.dataSourceName = dataSourceName; 
  init();
 }

 public OracleUtil() {  
 }

 public void setDataSourceName(String dataSourceName) {
  this.dataSourceName = dataSourceName;
 }

 public void init() {
  Context initContext;
  try {
   initContext = new InitialContext();
   ds = (DataSource) initContext.lookup(dataSourceName);
  } catch (NamingException e) {
   e.printStackTrace();
  }
 }

 public int update(String sql, String[] param) {
  int result = 0;
  QueryRunner qr = new QueryRunner(ds);
  try {
   result = qr.update(sql, param);
  } catch (SQLException e) {
   e.printStackTrace();
  }
  return result;
 }

 public Object query(String sql, String[] param, ResultSetHandler rsh) {
  QueryRunner qr = new QueryRunner(ds);
  Object result = null;
  try {
   result = qr.query(sql, param, rsh);
   //System.out.print(sql);
  } catch (SQLException e) {
   
   e.printStackTrace();
  }
  return result;
 }
 public Object queryU(String sql, ResultSetHandler rsh) {
  QueryRunner qr = new QueryRunner(ds);
  Object result = null;
  try {
   result = qr.query(sql, rsh);
   //System.out.print(result.toString());
  } catch (SQLException e) {
   
   e.printStackTrace();
   //System.out.print(e);
  }
  return result;
 }
 
 
}