日期:2014-05-16 浏览次数:20597 次
<database jndi-name='jdbc/qmangopmsdb'>
<driver type="com.microsoft.sqlserver.jdbc.SQLServerDriver">
<url>jdbc:sqlserver://localhost:1433;database=pms;</url>
<user>pmsuser1</user>
<password>123456</password>
</driver>
<prepared-statement-cache-size>8</prepared-statement-cache-size>
<max-connections>10</max-connections>
<max-idle-time>20s</max-idle-time>
</database>
public int openConn(String dbName) {
try {
String jndiName = appconf.get(dbName);
DataSource ds = (DataSource) cachtable.get(jndiName);
if (ds == null) {
Context ctx = new InitialContext();
ds = (DataSource) ctx.lookup(jndiName);
cachtable.put(jndiName, ds);
}
conc = ds.getConnection();
return 0;
} catch (Exception e) {
e.printStackTrace();
return -1;
}
}