获取connection

此理为获得连接池的connection。

 

获得connection：

 

InitialContext ctx = new InitialContext();
Context envContext = (Context)ctx.lookup("java:comp/env");
DataSource ds = (DataSource)envContext.lookup("jdbc/chargingPoleDB");
this.conn = ds.getConnection();
return this.conn;

 

web.xml中配置：

 

<resource-ref>
  <description>DB Connection</description>
  <res-ref-name>jdbc/chargingPoleDB</res-ref-name>
  <res-type>javax.sql.DataSource</res-type>
  <res-auth>Container</res-auth>
 </resource-ref>

 

META-INF文件夹下创建context.xml文件，内容：

 

<Context path="" reloadable="true" crossContext="true">
 <Resource name="jdbc/chargingPoleDB" auth="Container" type="javax.sql.DataSource" maxActive="100" maxIdle="30" maxWait="10000" username="root" password="wisdom"
 driverClassName="com.mysql.jdbc.Driver" url="jdbc:mysql://192.168.1.230:3306/chargingPole" />

    <!-- Default set of monitored resources -->
    <WatchedResource>WEB-INF/web.xml</WatchedResource>

    <!-- Uncomment this to disable session persistence across Tomcat restarts -->
    <!--
    <Manager pathname="" />
    -->

    <!-- Uncomment this to enable Comet connection tacking (provides events
         on session expiration as well as webapp lifecycle) -->
    <!--
    <Valve className="org.apache.catalina.valves.CometConnectionManagerValve" />
    -->

</Context>

 

http://tisty.iteye.com/blog/281268