一,Tomcat 数据源配置
1.在context.xml文件中配置
<?xml version='1.0' encoding='utf-8'?>
<Context>
<!-- Default set of monitored resources -->
<WatchedResource>WEB-INF/web.xml</WatchedResource>
<!-- DB2 数据源 -->
<Resource name="jdbc/mydb2" auth="Container"
type="javax.sql.DataSource" driverClassName="com.ibm.db2.jcc.DB2Driver"
url="jdbc:db2://192.9.203.32:50000/ZSZLEMR"
username="dev_v3" password="dev" maxActive="20" maxIdle="10"
maxWait="-1"/>
<!-- Oracle 数据源 -->
<Resource name="jdbc/myorcl" auth="Container"
type="javax.sql.DataSource" driverClassName="oracle.jdbc.driver.OracleDriver"
url="jdbc:oracle:thin:@localhost:1521:orcl"
username="emr" password="emr" maxActive="20" maxIdle="10"
maxWait="-1"/>
</Context>
2.在Web项目的Web.xml里配置
<!-- DB2数据源 --> <resource-ref> <description>mydb2 Datasource example</description> <res-ref-name>jdbc/mydb2</res-ref-name> <res-type>javax.sql.DataSource</res-type> <res-auth>Container</res-auth> </resource-ref>
<!-- Oracle数据源 --> <resource-ref> <description>mydb2 Datasource example</description> <res-ref-name>jdbc/myorcl</res-ref-name> <res-type>javax.sql.DataSource</res-type> <res-auth>Container</res-auth> </resource-ref>
3.BaseDao 里的代码
public Connection getConnection() { Connection conn = null; try { Context initContext = new InitialContext(); Context envContext = (Context) initContext.lookup("java:/comp/env"); DataSource ds = (DataSource) envContext.lookup("jdbc/mydb2"); //查找数据源名称 conn = ds.getConnection(); } catch (Exception e) { e.printStackTrace(); } return conn; }
4.中文路径问题解决,让Web项目可以访问中文路径的文件
修改Tomcat的server.xml文件,加上URIEncoding="UTF-8" 这是要根据你项目的整体编码修改
<Connector port="8080" protocol="HTTP/1.1" connectionTimeout="20000" redirectPort="8443" URIEncoding="UTF-8" />