mysql aop_MySql读写分离的配置（AOP）

MyBaties.xml配置

#db driver master option-------

master.jdbc.driver=com.mysql.jdbc.Driver

#db url

master.jdbc.url=jdbc:mysql://127.0.0.1:3307/p2p?useUnicode=true&characterEncoding=utf-8

#db username

master.jdbc.username=root

#db password

master.jdbc.password=

#db maxActive

master.jdbc.maxActive=2

#db minIdle

master.jdbc.minIdle=5

#db maxIdle

master.jdbc.maxIdle=5

#db driver  slave option-------

slave.jdbc.driver=com.mysql.jdbc.Driver

#db url

slave.jdbc.url=jdbc:mysql://127.0.0.1:3308/p2p?useUnicode=true&characterEncoding=utf-8

#db username

slave.jdbc.username=root

#db password

slave.jdbc.password=

#db maxActive

slave.jdbc.maxActive=2

#db minIdle

slave.jdbc.minIdle=5

#db maxIdle

advice-ref="dataSourceAdvice"/>

JDBC配置

#db driver master option-------

master.jdbc.driver=com.mysql.jdbc.Driver

#db url

master.jdbc.url=jdbc:mysql://127.0.0.1:3307/p2p?useUnicode=true&characterEncoding=utf-8

#db username

master.jdbc.username=root

#db password

master.jdbc.password=

#db maxActive

master.jdbc.maxActive=2

#db minIdle

master.jdbc.minIdle=5

#db maxIdle

master.jdbc.maxIdle=5

#db driver slave option-------

slave.jdbc.driver=com.mysql.jdbc.Driver

#db url

slave.jdbc.url=jdbc:mysql://127.0.0.1:3308/p2p?useUnicode=true&characterEncoding=utf-8

#db username

slave.jdbc.username=root

#db password

slave.jdbc.password=

#db maxActive

slave.jdbc.maxActive=2

#db minIdle

slave.jdbc.minIdle=5

#db maxIdle

Mybaties中切面类的具体写法

package com.jk.provide.aop;

import java.lang.reflect.Method;

import org.springframework.aop.AfterReturningAdvice;

import org.springframework.aop.MethodBeforeAdvice;

import org.springframework.aop.ThrowsAdvice;

/**

* @author 作者 lxx:

* @version 创建时间：2017年11月19日 下午12:17:19

* 类说明

*/

public class DataSourceAdvice implements MethodBeforeAdvice,AfterReturningAdvice,ThrowsAdvice {

@Override

public void before(Method method, Object[] args, Object target) throws Throwable {

System.out.println("切入点："+target.getClass().getName()+"类中 "+method.getName()+"方法");

//指定xx开头名，走主库

if(method.getName().startsWith("add")||method.getName().startsWith("save")){

System.out.println("切换到主数据源");

DataSourceSwitcher.setMater();

}else {

//指定xx开头名，走从库

if(method.getName().startsWith("get")||method.getName().startsWith("query")){

System.out.println("切换到：slave");

DataSourceSwitcher.setSlave();

}

}

}

@Override

public void afterReturning(Object arg0, Method arg1, Object[] arg2, Object arg3) throws Throwable {

}

public void afterThrowing(Method method, Object[] args, Object target,Exception ex) throws Throwable{

DataSourceSwitcher.setSlave();

System.out.println("出现异常切换到slave");

}

}