ysoren 发表于 2017-2-6 08:22:16

用tomcat使用连接池连接到MSSQL(转)

　　1. 把 mssql 需要的三个文件拷贝到 java_home\lib\ext 目录中
2. tomcat 的 server.xml 的代码
  　 

http://javaif.com/upimg/allimg/080225/1310570.gif <Context path="/j" docBase="D:Downloadsjsp_lx" reloadable="true" crossContext="true" debug="0"  >


http://javaif.com/upimg/allimg/080225/1310570.gif               
http://javaif.com/upimg/allimg/080225/1310570.gif    <Resource name="jdbc/pmsdb_bh"
http://javaif.com/upimg/allimg/080225/1310570.gif              auth="qjz"
http://javaif.com/upimg/allimg/080225/1310570.gif              type="javax.sql.DataSource"/>
http://javaif.com/upimg/allimg/080225/1310570.gif Javaif.Com
http://javaif.com/upimg/allimg/080225/1310570.gif <ResourceParams name="jdbc/pmsdb_bh">
http://javaif.com/upimg/allimg/080225/1310570.gif
http://javaif.com/upimg/allimg/080225/1310570.gif           <parameter>
http://javaif.com/upimg/allimg/080225/1310570.gif             <name>factory</name> Javaif.Com

http://javaif.com/upimg/allimg/080225/1310570.gif             <value>org.apache.commons.dbcp.BasicDataSourceFactory</value>
http://javaif.com/upimg/allimg/080225/1310570.gif           </parameter>
http://javaif.com/upimg/allimg/080225/1310570.gif           <parameter> Javaif.Com

http://javaif.com/upimg/allimg/080225/1310570.gif                <name>maxActive</name>
http://javaif.com/upimg/allimg/080225/1310570.gif                <value>100</value>
http://javaif.com/upimg/allimg/080225/1310570.gif           </parameter> 
http://javaif.com/upimg/allimg/080225/1310570.gif           <parameter>
http://javaif.com/upimg/allimg/080225/1310570.gif                <name>maxIdle</name>
http://javaif.com/upimg/allimg/080225/1310570.gif                <value>30</value>  

http://javaif.com/upimg/allimg/080225/1310570.gif           </parameter>
http://javaif.com/upimg/allimg/080225/1310570.gif
http://javaif.com/upimg/allimg/080225/1310570.gif           <parameter>
http://javaif.com/upimg/allimg/080225/1310570.gif               <name>maxWait</name> Java世界
http://javaif.com/upimg/allimg/080225/1310570.gif               <value>10000</value>
http://javaif.com/upimg/allimg/080225/1310570.gif           </parameter>
http://javaif.com/upimg/allimg/080225/1310570.gif
http://javaif.com/upimg/allimg/080225/1310570.gif            <parameter>


http://javaif.com/upimg/allimg/080225/1310570.gif     <name>username</name>
http://javaif.com/upimg/allimg/080225/1310570.gif     <value>sa</value>
http://javaif.com/upimg/allimg/080225/1310570.gif    </parameter> Javaif.Com
http://javaif.com/upimg/allimg/080225/1310570.gif    <parameter>
http://javaif.com/upimg/allimg/080225/1310570.gif     <name>password</name>
http://javaif.com/upimg/allimg/080225/1310570.gif     <value>sa</value> 
http://javaif.com/upimg/allimg/080225/1310570.gif    </parameter>
http://javaif.com/upimg/allimg/080225/1310570.gif    
http://javaif.com/upimg/allimg/080225/1310570.gif
http://javaif.com/upimg/allimg/080225/1310570.gif    <!-- Class name for mm.mysql JDBC driver -->
http://javaif.com/upimg/allimg/080225/1310570.gif    <parameter>
http://javaif.com/upimg/allimg/080225/1310570.gif       <name>driverClassName</name>  

http://javaif.com/upimg/allimg/080225/1310570.gif       <value>com.microsoft.jdbc.sqlserver.SQLServerDriver</value>
http://javaif.com/upimg/allimg/080225/1310570.gif    </parameter>
http://javaif.com/upimg/allimg/080225/1310570.gif    <parameter>
http://javaif.com/upimg/allimg/080225/1310570.gif      <name>url</name> Java世界

http://javaif.com/upimg/allimg/080225/1310570.gif      <value>jdbc:microsoft:sqlserver://127.0.0.1:1433;databasename=pmsdb_bh</value>
http://javaif.com/upimg/allimg/080225/1310570.gif    </parameter>
http://javaif.com/upimg/allimg/080225/1310570.gif
http://javaif.com/upimg/allimg/080225/1310570.gif
http://javaif.com/upimg/allimg/080225/1310570.gif    </ResourceParams>  Java世界
http://javaif.com/upimg/allimg/080225/1310570.gif
http://javaif.com/upimg/allimg/080225/1310570.gif
http://javaif.com/upimg/allimg/080225/1310570.gif       </Context>
http://javaif.com/upimg/allimg/080225/1310570.gif
http://javaif.com/upimg/allimg/080225/1310570.gif

　　Javaif.Com
　　3. web.xml 代码
  Java世界

http://javaif.com/upimg/allimg/080225/1310570.gif<web-app>
http://javaif.com/upimg/allimg/080225/1310570.gif    <display-name>Struts Examples Application</display-name>
http://javaif.com/upimg/allimg/080225/1310570.gif 
http://javaif.com/upimg/allimg/080225/1310570.gif <!-- 开始 -->
http://javaif.com/upimg/allimg/080225/1310570.gif
http://javaif.com/upimg/allimg/080225/1310570.gif<resource-ref>
http://javaif.com/upimg/allimg/080225/1310570.gif     <description>DB Connection</description>
http://javaif.com/upimg/allimg/080225/1310570.gif     <res-ref-name>jdbc/pmsdb_bh</res-ref-name> Java世界
http://javaif.com/upimg/allimg/080225/1310570.gif     <res-type>javax.sql.DataSource</res-type>
http://javaif.com/upimg/allimg/080225/1310570.gif     <res-auth>qjz</res-auth>
http://javaif.com/upimg/allimg/080225/1310570.gif </resource-ref> Javaif.Com
http://javaif.com/upimg/allimg/080225/1310570.gif <!-- 结束 -->
http://javaif.com/upimg/allimg/080225/1310570.gif
http://javaif.com/upimg/allimg/080225/1310570.gif

　　
  
4. 写一个类 Javaif.Com
Java世界
http://javaif.com/upimg/allimg/080225/1310570.gif package zziss.db;
http://javaif.com/upimg/allimg/080225/1310570.gifimport javax.naming.*;
http://javaif.com/upimg/allimg/080225/1310570.gifimport java.sql.Connection;
http://javaif.com/upimg/allimg/080225/1310570.gifimport java.lang.String; Javaif.Com

http://javaif.com/upimg/allimg/080225/1310570.gifimport javax.sql.DataSource;
http://javaif.com/upimg/allimg/080225/13105772.gifhttp://javaif.com/upimg/allimg/080225/13105773.gifpublic class ConnPool...{ Javaif.Com

http://javaif.com/upimg/allimg/080225/13105774.gif      private Connection aConn;
http://javaif.com/upimg/allimg/080225/13105774.gif      private String errorMessage;
http://javaif.com/upimg/allimg/080225/13105776.gifhttp://javaif.com/upimg/allimg/080225/13105777.gif      public ConnPool()...{ 
http://javaif.com/upimg/allimg/080225/13105774.gif          
http://javaif.com/upimg/allimg/080225/13105776.gifhttp://javaif.com/upimg/allimg/080225/13105777.gif          try...{ Java世界

http://javaif.com/upimg/allimg/080225/13105774.gif          Context _context = new InitialContext();
http://javaif.com/upimg/allimg/080225/13105774.gif          DataSource _ds = (DataSource)_context.lookup("java:comp/env/jdbc/pmsdb_bh");
http://javaif.com/upimg/allimg/080225/13105774.gif          if (_ds == null)  

http://javaif.com/upimg/allimg/080225/13105776.gifhttp://javaif.com/upimg/allimg/080225/13105777.gif          ...{ 
http://javaif.com/upimg/allimg/080225/13105774.gif               this.errorMessage = "无法找到 jndi 名:java:comp/env/jdbc/pmsdb_bh";
http://javaif.com/upimg/allimg/080225/13105787.gif          } else
http://javaif.com/upimg/allimg/080225/13105776.gifhttp://javaif.com/upimg/allimg/080225/13105777.gif          ...{ 
http://javaif.com/upimg/allimg/080225/13105774.gif               aConn = _ds.getConnection();
http://javaif.com/upimg/allimg/080225/13105774.gif               this.errorMessage = "取得连接对象 connection ";
http://javaif.com/upimg/allimg/080225/13105787.gif          }
http://javaif.com/upimg/allimg/080225/13105787.gif          } Java世界
http://javaif.com/upimg/allimg/080225/13105776.gifhttp://javaif.com/upimg/allimg/080225/13105777.gif          catch(Exception e)...{  

http://javaif.com/upimg/allimg/080225/13105774.gif             this.errorMessage = e.toString();
http://javaif.com/upimg/allimg/080225/13105787.gif          }
http://javaif.com/upimg/allimg/080225/13105774.gif//System.out.println("ok");
http://javaif.com/upimg/allimg/080225/13105787.gif      }
http://javaif.com/upimg/allimg/080225/13105776.gifhttp://javaif.com/upimg/allimg/080225/13105777.gif      public String getErrorMessage()...{  

http://javaif.com/upimg/allimg/080225/13105774.gif          return this.errorMessage;
http://javaif.com/upimg/allimg/080225/13105787.gif      }
http://javaif.com/upimg/allimg/080225/13105776.gifhttp://javaif.com/upimg/allimg/080225/13105777.gif      public Connection getConnection()...{ Java世界

http://javaif.com/upimg/allimg/080225/13105774.gif          return this.aConn;
http://javaif.com/upimg/allimg/080225/13105787.gif      }
http://javaif.com/upimg/allimg/080225/13105774.gif      
http://javaif.com/upimg/allimg/080225/131057109.gif} 
http://javaif.com/upimg/allimg/080225/1310570.gif

　　Javaif.Com
　　5. 调用


　　Javaif.Com

http://javaif.com/upimg/allimg/080225/13105772.gifhttp://javaif.com/upimg/allimg/080225/13105773.gif<%...@ page contentType="text/html;charset=gb2312"%> 
http://javaif.com/upimg/allimg/080225/13105772.gifhttp://javaif.com/upimg/allimg/080225/13105773.gif<%...@ page import ="zziss.db.*" %> Java世界
http://javaif.com/upimg/allimg/080225/13105772.gifhttp://javaif.com/upimg/allimg/080225/13105773.gif<%...@ page import ="java.sql.*" %> 
http://javaif.com/upimg/allimg/080225/1310570.gif<html>
http://javaif.com/upimg/allimg/080225/1310570.gif <head>
http://javaif.com/upimg/allimg/080225/1310570.gif   <title>DB Test</title>
http://javaif.com/upimg/allimg/080225/1310570.gif </head> Javaif.Com
http://javaif.com/upimg/allimg/080225/1310570.gif <body>
http://javaif.com/upimg/allimg/080225/1310570.gif
http://javaif.com/upimg/allimg/080225/13105772.gifhttp://javaif.com/upimg/allimg/080225/13105773.gif <%...  

http://javaif.com/upimg/allimg/080225/13105774.gif   ConnPool cp = new ConnPool();
http://javaif.com/upimg/allimg/080225/13105774.gif   
http://javaif.com/upimg/allimg/080225/131057109.gif %>
http://javaif.com/upimg/allimg/080225/1310570.gif
http://javaif.com/upimg/allimg/080225/1310570.gif <h2>Ms sql server 2000 java search Results</h2>  

http://javaif.com/upimg/allimg/080225/1310570.gif    <%= cp.getErrorMessage() %><br/>
http://javaif.com/upimg/allimg/080225/1310570.gif  
http://javaif.com/upimg/allimg/080225/1310570.gif
http://javaif.com/upimg/allimg/080225/1310570.gif </body>
http://javaif.com/upimg/allimg/080225/1310570.gif</html>  

http://javaif.com/upimg/allimg/080225/1310570.gif
http://javaif.com/upimg/allimg/080225/1310570.gif

 
　　关于怎么使用连接池在 tomcat 的帮助文件中也有
页: [1]
查看完整版本: 用tomcat使用连接池连接到MSSQL(转)