sql和mysql同时配置_jfinal同时配置mssql和mysql混动数据源

config.txt

#mysql配置

jdbcUrl = jdbc:mysql://127.0.0.1/basedata?characterEncoding=utf8&zeroDateTimeBehavior=convertToNull

user = root

password = 123456

#mssql配置

driver = com.microsoft.sqlserver.jdbc.SQLServerDriver

jdbcsqlUrl = jdbc:sqlserver://127.0.0.1:1433;instance=sql2012;DatabaseName=basedata

sqluser=sa

sqlpassword=123456

configplugin

public static C3p0Plugin createC3p0Plugin() {

return new C3p0Plugin(PropKit.get("jdbcsqlUrl"), PropKit.get("sqluser"), PropKit.get("sqlpassword"), PropKit.get("driver"));

}

public static DruidPlugin createDruidPlugin() {

DruidPlugin dp = new DruidPlugin(PropKit.get("jdbcUrl"), PropKit.get("user"), PropKit.get("password"));

dp.addFilter(new StatFilter());

WallFilter wall = new WallFilter();

wall.setDbType("mysql");

dp.addFilter(wall);

return dp;

}

public void configPlugin(Plugins me) {

C3p0Plugin c3p0Plugin = createC3p0Plugin();

me.add(c3p0Plugin);

// 配置mssql的ActiveRecord插件

ActiveRecordPlugin arp = new ActiveRecordPlugin("mssql",c3p0Plugin);

me.add(arp);

arp.setDialect(new AnsiSqlDialect());

arp.setContainerFactory(new CaseInsensitiveContainerFactory());

DruidPlugin druidPlugin = createDruidPlugin();

me.add(druidPlugin);

// 配置mysql的ActiveRecord插件

ActiveRecordPlugin druidarp = new ActiveRecordPlugin("mysql",druidPlugin);

druidarp.setShowSql(PropKit.getBoolean("devMode", false));

druidarp.setDevMode(PropKit.getBoolean("devMode", false));

me.add(druidarp);

me.add(new EhCachePlugin());

// 所有配置在 MappingKit 中搞定

_MappingKit.mapping(arp);

_MysqlMappingKit.mapping(druidarp);

}

调用方法

//mssql

public Page paginate(int pageNumber, int pageSize) {

return JobPersonInfo.dao.use("mssql").paginate(pageNumber, pageSize, "select *", "from table1");

}

//mysql

public Page mysqlpaginate(int pageNumber, int pageSize) {

return AppVersion.dao.use("mysql").paginate(pageNumber, pageSize, "select *", "from table2");

}