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