Tomcat 数据源配置，中文路径乱码解决

一，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" />