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";
}