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;
	}