一劳永逸的数据库编码解决方案(1)

_Connection.java 



/*
  * Created on 2003-10-23 by Liudong
  */package lius.pool;import java.sql.*;import java.lang.reflect.*;
/ *
  *
  * 数据库连接的代理类
  * @author Liudong
  */
 class _Connection implements InvocationHandler{
	private Connection conn = null;
	private boolean coding = false;
	//指定是否进行字符串转码操作
	_Connection(Connection conn, boolean coding){
	this.conn = conn;
	this.coding = coding;
	initConnectionParam(this.conn);
}
/**
 	 * Returns the conn.
 	 * @return Connection
 	 */
 	public Connection getConnection() {
		Class[] interfaces =conn.getClass().getInterfaces();
		if(interfaces==null||interfaces.length==0){
	interfaces = new Class[1];
	interfaces[0] = Connection.class;
		}
	Connection conn2 = (Connection)Proxy.newProxyInstance(
	conn.getClass().getClassLoader(), interfaces,this);
	return conn2;
}
	/**
 	 * @see java.lang.reflect.InvocationHandler#invoke
 	 */
	public Object invoke(Object proxy, Method m, Object[] args) throws Throwable {	
		String method = m.getName();
		//调用相应的操作
		Object obj = null;
		try{
			obj = m.invoke(conn, args);
			//接管用于获取语句句柄实例的方法
   		      if((CS.equals(method)||PS.equals(method))&&coding) 
				return new _Statement((Statement)obj,true).getStatement();
				} catch(InvocationTargetException e) {
			throw e.getTargetException();
		}
		return obj;
	}		private final static String PS = "prepareStatement";
	private final static String CS = "createStatement";}


_Statement.java 


/*
  * Created on 2003-10-23 by Liudong
  */
 package lius.pool;
 import java.sql.*;
 import java.lang.reflect.*;
/**
  * 数据库语句对象实例的代理类
  * @author Liudong
  */
class _Statement implements InvocationHandler{
		private Statement statement ; //保存所接管对象的实例
		private boolean decode = false; //指定是否进行字符串转码
		public _Statement(Statement stmt,boolean decode) {
		this.statement = stmt;
		this.decode = decode;
	}
	/**
 	 * 获取一个接管后的对象实例
 	 * @return
 	 */