在Web应用中使用XML文件配置数据源
来源: 时间:06-12-30 点击: 点击这里收藏本文
e.printStackTrace();
}
}
/* (non-Javadoc)
* @see javax.servlet.ServletContextListener#contextDestroyed(javax.servlet.ServletContextEvent)
*/
public void contextDestroyed(ServletContextEvent arg0) {
// TODO Auto-generated method stub
sctx=null;
}
}
(六) 在Web.xml中配置数据源，配置代码如下：
<!-- configure the oracle datasource by XML files -->
<context-param>
<param-name>OracleDataSourceConfigXML</param-name>
<param-value>/WEB-INF/oracle.xml</param-value>
</context-param>
<context-param>
<param-name>OracleDataSourceConfig</param-name>
<param-value>zy.pro.wd.xml.OracleConfig</param-value>
</context-param>
<listener>
<listener-class>zy.pro.wd.listener.OracleDataSourceListener</listener-class>
</listener>
<!-- configure the MSSQL datasource using XML files -->
<context-param>
<param-name>MSSQLDataSourceConfigXML</param-name>
<param-value>/WEB-INF/mssql.xml</param-value>
</context-param>
<context-param>
<param-name>MSSQLDataSourceConfig</param-name>
<param-value>zy.pro.wd.xml.MSSQLConfig</param-value>
</context-param>
<listener>
<listener-class>zy.pro.wd.listener.MSSQLDataSourceListener</listener-class>
</listener>
(七) 测试配置是否成功，我们在jsp中测试
（1） 测试MS SQL SERVER的JSP页面mssqlDataSourceDemo.jsp,代码如下：
<%@ page language="java" import="javax.naming.*" %>
把此文章收藏到：
