日期:2014-05-16 浏览次数:20524 次
<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; } }