1.2-JDBC数据池连接

1. tomcat 修改配置文件：xxx\conf\context.xml

添加：

<Context>


    <!-- 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" />
    -->
      <Resource name="jdbc/news" auth="Container" type="javax.sql.DataSource"
      maxActive="100" maxIdle="30" maxWait="10000" username="root"
      password="root" driverClassName="com.mysql.jdbc.Driver"
      url="jdbc:mysql://127.0.0.1:3306/dept?
              useUnicode=true&amp;characterEncoding=utf-8" />


</Context>

2.项目 webroot->web-inf\web.xml

   添加：

<welcome-file-list>
    <welcome-file>index.jsp</welcome-file>
  </welcome-file-list>
  <resource-ref>


    <res-ref-name>jdbc/dept</res-ref-name>


    <res-type>javax.sql.DataSource</res-type>


    <res-auth>Container</res-auth>


</resource-ref>
</web-app>

3. BaseDao中代码更改

//获取连接  

public  static  Connection  getConnection(){

//加载驱动
/*try {
Class.forName(Contants.driver);
conn =  DriverManager.getConnection(Contants.url, Contants.user, Contants.pwd);
} catch (ClassNotFoundException e) {
// TODO Auto-generated catch block
e.printStackTrace();
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}*/

Context ctx;
try {
ctx=new InitialContext();
DataSource ds=(DataSource)ctx.lookup("java:comp/env/jdbc/dept");
} catch (NamingException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}


return conn;


}