使用tomcat开发
1、将数据源信息配置在META-INF/context.xml下面
<?xml version="1.0" encoding="UTF-8"?>
<Context docBase="WebSummary" path="/WebSummary" reloadable="true">
<Resource name="grucee/datasource" auth="Container" type="javax.sql.DataSource"
driverClassName="oracle.jdbc.OracleDriver" url="jdbc:oracle:thin:@10.137.7.123:1521:upc"
username="sdd" password="password" maxActive="20" maxIdle="10"
maxWait="-1" />
</Context>
2、使用如下代码获取数据库连接
public static Connection getConnection() throws Exception {
Context ctx = null;
ctx = new InitialContext();
Context envCtx = (Context) ctx.lookup("java:comp/env");
DataSource ds = (DataSource) envCtx.lookup("grucee/datasource");
return ds.getConnection();
}