AOP实现数据库日志打印

来源：互联网发布：免费电话会议软件编辑：程序博客网时间：2024/05/16 14:29

最近在学习动态代理，总结之余写了个用AOP实现数据库日志打印的方法，有些地方还不完善，思路仅供参考
定义接口：

package Test_Proxy;import java.sql.Connection;import java.sql.Statement;public interface ExcuteSQL {    public void executeInsert(String sql);    public void executeUpdate(String sql);    public void executeDelete(String sql);    public void executeQuery(String sql);    public void executeClose(Connection conn,Statement state);    //public void getConnect(String url, String username,String  password);}

实现接口类：

package Test_Proxy;import java.sql.Connection;import java.sql.SQLException;import java.sql.Statement;public class ExecuteSqlImpl implements ExcuteSQL {    private Connection conn;    private Statement state;    public ExecuteSqlImpl(Connection conn, Statement state) {        super();        this.conn = conn;        this.state = state;    }    public Connection getConn() {        return conn;    }    public void setConn(Connection conn) {        this.conn = conn;    }    public Statement getState() {        return state;    }    public void setState(Statement state) {        this.state = state;    }    public void closeDB(Connection conn, Statement state) {        try {            if (!state.isClosed()&&state!=null) {                state.close();            }            if (!conn.isClosed()&&conn!=null) {                conn.close();            }            System.out.println("成功关闭数据库连接");        } catch (SQLException e) {            // TODO Auto-generated catch block            System.out.println("关闭数据库有异常");            e.printStackTrace();        }    }    @Override    public void executeInsert(String sql) {        // TODO Auto-generated method stub        try {            state.executeUpdate(sql);        } catch (SQLException e) {            // TODO Auto-generated catch block            e.printStackTrace();        }finally{            this.closeDB(conn, state);        }    }    @Override    public void executeUpdate(String sql) {        // TODO Auto-generated method stub    }    @Override    public void executeDelete(String sql) {        // TODO Auto-generated method stub    }    @Override    public void executeQuery(String sql) {        // TODO Auto-generated method stub    }    @Override    public void executeClose(Connection conn, Statement state) {        // TODO Auto-generated method stub    }}

编写代理类

package Test_Proxy;import java.lang.reflect.InvocationHandler;import java.lang.reflect.Method;import java.lang.reflect.Proxy;public class ExecuteInvocation implements InvocationHandler {    private Object   impl;    public ExecuteInvocation(Object impl) {        super();        this.impl = impl;    }    public Object getImpl() {        return impl;    }    public void setImpl(Object impl) {        this.impl = impl;    }    public static Object getInstance(Object obj){        Class cl=obj.getClass();        return Proxy.newProxyInstance(cl.getClassLoader(), cl.getInterfaces(), new ExecuteInvocation(obj));    }    @Override    public Object invoke(Object proxy, Method method, Object[] args)            throws Throwable {        // TODO Auto-generated method stub        System.out.println("执行sql开始!");        System.out.println("执行语句:"+args[0]);        method.invoke(impl, args[0]);        System.out.println("执行sql结束!");        return null;    }}

测试代码：

package Test_Proxy;import java.sql.Connection;import java.sql.DriverManager;import java.sql.SQLException;import java.sql.Statement;public class TestProxyMain {    public static void main(String[] args) {        String url = "jdbc:oracle:thin:@127.0.0.1:1521:orcl";        String username = "scott";        String password = "system";        Connection conn=null;        Statement state=null;        try {            Class.forName("oracle.jdbc.driver.OracleDriver");        } catch (ClassNotFoundException e) {            // TODO Auto-generated catch block            e.printStackTrace();        }        try {            conn = DriverManager.getConnection(url, username, password);            state = conn.createStatement();        } catch (SQLException e) {            // TODO Auto-generated catch block            e.printStackTrace();        }        String sql = "insert into table_a(name,home) values('zhaowei','tongzhou')";        ExecuteSqlImpl executeImpl=new ExecuteSqlImpl(conn, state);        ExcuteSQL execute= (ExcuteSQL) ExecuteInvocation.getInstance(executeImpl);        execute.executeInsert(sql);    }}

数据库连接需要优化和关闭还需要优化。
有问题和建议跪求指点！

0 0