Play FrameWork 如何在一个项目中链接多个数据库

1.配置

application.conf   中引入数据库配置文件       include "db-mysql-test-data.conf"

2.设置配置文件,一个默认数据库，和其他数据库

db: {
  default: {
    driver: "com.mysql.jdbc.Driver",
    url: "jdbc:mysql://localhost:3306/newlingmi?useUnicode=true&characterEncoding=UTF-8"
    user: "root"
    password: "root"
    logStatements: true
  }
  sqlsdb: {
    driver: "com.microsoft.sqlserver.jdbc.SQLServerDriver",
    url: "jdbc:sqlserver://kissfly:3433;DatabaseName=kissfly"
    user: "kissfly"
    password: "kissfly"
    logStatements: true
  }
}

3.非默认数据库的实体类进行save/find等操作时要指定数据库。

public static Finder<Long, JMOneCategory> find = new Finder<Long, JMOneCategory>(
			Config.SQLSERVER_DBNAME, Long.class, JMOneCategory.class);
List<JMOneCategory> oclist = find.where().findList();
oc.save(Config.SQLSERVER_DBNAME);

public class Config {
    
    public static final String SQLSERVER_DBNAME = "sqlsdb";

}