今天在整合为数据库发现在配置中实现的赋值方式,可以用代码实现。特记录下共以后参考:
代码:
// 操作数据库
Connection conn;
String strDatabase ="northeasttycoon";
try {
String url = "jdbc:sqlserver:127.0.0.1:1433;DatabaseName=strDatabase;";
Properties pro = new Properties();
pro.setProperty("initialSize", "10");
pro.setProperty("maxActive", "100");
pro.setProperty("maxIdle", "70");
pro.setProperty("minIdle", "10");
pro.setProperty("testOnBorrow", "true");
pro.setProperty("validationQuery", "select 1");
pro.setProperty("removeAbandonedTimeout", "120");
pro.setProperty("removeAbandoned", "true");
pro.setProperty("username", strUserName);
pro.setProperty("pa