oracleutil.java

一个简单的BBS系统 适用于初学者用JSP和连接池 开发系统

package webbook.util;

import java.sql.SQLException;
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;		
	}

	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);
		} catch (SQLException e) {
			e.printStackTrace();
		}
		return result;
	}
}