tomcat 配备连接池

tomcat 配置连接池

1.在conf/context.xm.添加

<Resource name="jdbc/ugc" auth="Container" type="javax.sql.DataSource"        driverClassName="oracle.jdbc.driver.OracleDriver"        url="jdbc:oracle:thin:@172.16.5.134:1521:zzpoi"        username="lnydjc"        password="lnydjc"        maxActive="100"        maxIdle="20"        maxWait="3000"></Resource><ResourceLink global="jdbc/ugc" name="jdbc/ugc" type="javax.sql.DataSource"/>

  2.在java类获取connection

public Connection getConnection() {String sDBDriver = "oracle.jdbc.driver.OracleDriver";if (conn == null) {boolean getConnFromDS = false;if (dbConnString == null || dbConnString.equals(""))getConnFromDS = true;if (getConnFromDS) {try {InitialContext ctx = new InitialContext();DataSource ds = (DataSource) ctx.lookup("java:comp/env/jdbc/ugc");conn = ds.getConnection();} catch (Exception e) {e.printStackTrace();}} else {try {Class.forName(sDBDriver).newInstance();conn = DriverManager.getConnection(dbConnString, user, pwd);} catch (Exception e) {e.printStackTrace();}}}return conn;}