如何用Jfinal连接多个数据库

<!-- https://mvnrepository测试数据/artifact/com.microsoft.sqlserver/mssql-jdbc -->

< dependency >

  < groupId >com.microsoft.sqlserver</ groupId >

  < artifactId >mssql-jdbc</ artifactId >

  < version >7.4.1.jre8</ version >

  < scope >test</ scope >

</ dependency >

<!-- https://mvnrepository测试数据/artifact/mysql/mysql-connector-java -->

< dependency >

  < groupId >mysql</ groupId >

  < artifactId >mysql-connector-java</ artifactId >

  < version >8.0.12</ version >

</ dependency >

driver = com.microsoft.sqlserver.jdbc.SQLServerDriver

jdbcUrl = jdbc:sqlserver: //localhost ;Database= test

user = sa

password = 123456

devMode = true

jdbcUrl2 = jdbc:mysql: //localhost/test ?characterEncoding=utf-8&useSSL= false &serverTimezone=GMT

user2 = root

password2 =123456

devMode2 = true

public void configPlugin(Plugins me) {

    // 连接sqlserver数据库

    C3p0Plugin c3p0Plugin = new C3p0Plugin(getProperty( "jdbcUrl" ), getProperty( "user" ), getProperty( "password" ), getProperty( "driver" ));

  me.add(c3p0Plugin);

  // 给数据源添加别名sqlserver

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

  // 添加sqlserver方言 SqlServer方言在jfinal2.0以上才引入

  arp.setDialect( new SqlServerDialect());

  me.add(arp);

  // 连接mysql数据库

    C3p0Plugin c3p0Plugin2 = new C3p0Plugin(getProperty( "jdbcUrl2" ), getProperty( "user2" ), getProperty( "password2" ));

  me.add(c3p0Plugin2);

  // 给数据源添加别名mysql

  ActiveRecordPlugin arp2 = new ActiveRecordPlugin( "mysql" ,c3p0Plugin2);

  // 添加mysql方言

  arp2.setDialect( new MysqlDialect());

  me.add(arp2);

}

// 查询sqlserver的test表

List<Record> rs = Db.use( "sqlserver" ).find( "select * from test" );

// 查询mysql的test表       

List<Record> rs1 = Db.use( "mysql" ).find( "select * from test" );