Jfianl 多数据源连接

来源:互联网 发布:淘宝号如何注册 编辑:程序博客网 时间:2024/06/05 02:04
public void configPlugin(Plugins me) {// TODO Auto-generated method stubC3p0Plugin c3p0Plugin2k = new C3p0Plugin(getProperty("jdbc2000Url"), getProperty("user2000"), getProperty("password2000"),getProperty("driverClassName"));me.add(c3p0Plugin2k);ActiveRecordPlugin ap = new ActiveRecordPlugin(c3p0Plugin2k);ap.setShowSql(true);ap.setDialect(new AnsiSqlDialect());me.add(ap);//多数据库C3p0Plugin c3p0Plugin2k_at = new C3p0Plugin(getProperty("jdbc2000Url_at"), getProperty("user2000_at"), getProperty("password2000_at"),getProperty("driverClassName_at"));me.add(c3p0Plugin2k_at);//参数中at为数据源别名,取数据时使用Db.use("at").find(ls_sql),如不指定Db.find(ls_sql)则默认取上面第一个数据连接ActiveRecordPlugin ap_at = new ActiveRecordPlugin("at",c3p0Plugin2k_at);ap_at.setShowSql(true);ap_at.setDialect(new AnsiSqlDialect());me.add(ap_at);}