今天又同学说到一个应用多数据源切换问题,我大概一想,不就是个工厂方法模式去处理,随手谢了个demo。
1、首先是接口
public interface IDBUtil {
Connection getConnection();
void closeConn(Connection c);
}
2、几个实现:
public class DBSource2 implements IDBUtil {
private static DataSource dataSource;
public DBSource2(){
//初始化数据源
if(dataSource == null){
//加载
}
}
/* (non-Javadoc)
* @see xiaoli.test.IDBUtil#getConnection()
*/
public Connection getConnection() {
// TODO Auto-generated method stub
Connection conn = null;
try {
conn = dataSource.getConnection();
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();