Config.java
public void configPlugin(Plugins me) {
loadPropertyFile("classes/config.properties");
C3p0Plugin cp = new C3p0Plugin(getProperty("jdbc.url"), getProperty("jdbc.username"), getProperty("jdbc.password"), getProperty("jdbc.driverClassName")); //关键:使用C3P0
me.add(cp);
ActiveRecordPlugin arp = new ActiveRecordPlugin(cp);
me.add(arp);
arp.setDialect(new AnsiSqlDialect());//关键:使用AnsiSqlDialect
arp.setContainerFactory(new CaseInsensitiveContainerFactory());
}
config.properties
jdbc.driverClassName=com.microsoft.sqlserver.jdbc.SQLServerDriver
jdbc.url=jdbc:sqlserver://localhost:1433;DatabaseName=dbname
jdbc.username=sa
jdbc.password=123456
jdbc.dbType=sqlserver
数据库用的:sqlserver 2005 配置信息也修改了: /** * 配置插件 */public void configPlugin(Plugins me) {// 配置C3p0数据库连接池插件C3p0Plugin c3p0Plugin = new C3p0Plugin(getProperty( jdbcUrl ), getProperty( user ), g
数据库用的:sqlserver 2005
配置信息也修改了: