1.配置Tomcat服务器的context.xml文件
<Context reloadable="true">
<WatchedResource>WEB-INF/web.xml</WatchedResource>
<Resource name="jdbc/oracleds" auth="Container"
type="javax.sql.DataSource"
maxActive="100" maxIdle="30" maxWait="10000"
username="scott" password="password"
driverClassName="oracle.jdbc.OracleDriver"
url="jdbc:oracle:thin:@192.168.0.1:1521:orcl"/>
</Context>
2.将jdbc的驱动包放到tomcat的安装目录的lib目录下
3.配置web.xml
<resource-ref>
<res-ref-name>jdbc/oracleds</res-ref-name>
<res-type>javax.sql.DataSource</res-type>
<res-auth>Container</res-auth>
</resource-ref>
4.程序中使用数据源:
Context context=null;
DataSource ds=null;
Connection conn=null;
try {
Context initContext = new InitialContext();
Context envContext = (Context)initContext.lookup("java:/comp/env");
ds = (DataSource)envContext.lookup("jdbc/oracleds");
conn = ds.getConnection();
。。。。。