Proxool数据库连接配置问题

最新推荐文章于 2024-10-16 17:43:33 发布

iteye_17017

最新推荐文章于 2024-10-16 17:43:33 发布

阅读量136

点赞数

分类专栏： sqlserver 文章标签：配置管理 log4j JDBC SQL Java

本文链接：https://blog.csdn.net/iteye_17017/article/details/82007462

版权

sqlserver 专栏收录该内容

2 篇文章 0 订阅

订阅专栏

web.xml 配置信息

<?xml version="1.0" encoding="UTF-8"?>
<web-app version="2.4" xmlns="http://java.sun.com/xml/ns/j2ee"
    xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
    xsi:schemaLocation="http://java.sun.com/xml/ns/j2ee 
    http://java.sun.com/xml/ns/j2ee/web-app_2_4.xsd">
    <listener>
        <listener-class>
            org.springframework.web.context.ContextLoaderListener
        </listener-class>
    </listener>
    <filter>
        <filter-name>struts2</filter-name>
        <filter-class>
            org.apache.struts2.dispatcher.FilterDispatcher
        </filter-class>
    </filter>
    <filter-mapping>
        <filter-name>struts2</filter-name>
        <url-pattern>/*</url-pattern>
    </filter-mapping>
    <context-param>
        <param-name>contextConfigLocation</param-name>
        <param-value>
            /WEB-INF/applicationContext-*.xml,classpath*:applicationContext-*.xml
        </param-value>
    </context-param>

    <!--###########   log4j的WebAppRoot设置   ##################-->
    <context-param>   
    <param-name>log4jExposeWebAppRoot</param-name>   
    <param-value>false</param-value>   
    </context-param>         
      <!--###########   初始化日志系统   ##################-->
      <context-param>
        <param-name>log4jConfigLocation</param-name>
        <param-value>/WEB-INF/classes/log4j.properties</param-value>
      </context-param>
      <!--##########    Spring默认刷新Log4j配置文件的间隔,单位为millisecond   #########-->
      <context-param>
        <param-name>log4jRefreshInterval</param-name>
        <param-value>60000</param-value>
      </context-param>
      <!--###########   log4j日志系统的启动监听器   ##################-->
      <listener>
        <listener-class>org.springframework.web.util.Log4jConfigListener</listener-class>
      </listener>
    <!--  数据源配置  -->
    <resource-ref>
        <description>DB Connection</description>
        <res-ref-name>JDBC/PIMS</res-ref-name>
        <res-type>javax.sql.DataSource</res-type>
        <res-auth>Container</res-auth>
    </resource-ref>
    <!-- 加入proxool数据源的连接方式 -->
    <servlet>
         <servlet-name>proxoolServletConfigurator</servlet-name>
         <servlet-class>org.logicalcobwebs.proxool.configuration.ServletConfigurator</servlet-class>
         <init-param>
               <param-name>xmlFile</param-name>
               <param-value>WEB-INF/proxool.xml</param-value><!--这里对应刚才建立的xml配置文件名-->
         </init-param>
         <load-on-startup>1</load-on-startup>
   </servlet>
    <!-- proxool提供的管理监控工具，可查看当前数据库连接情况-->
   <servlet>
        <servlet-name>Admin</servlet-name>
          <servlet-class>org.logicalcobwebs.proxool.admin.servlet.AdminServlet</servlet-class>
   </servlet>
   <servlet-mapping>
        <servlet-name>Admin</servlet-name>
        <url-pattern>/admin</url-pattern>
   </servlet-mapping>
</web-app>

proxool.xml 配置

<?xml version="1.0" encoding="UTF-8"?>
<something-else-entirely>
    <proxool>
        <alias>JDBC/PIMS</alias>
        <driver-url>jdbc:sqlserver://localhost:1433;DatabaseName=bmsh</driver-url>
        <driver-class>com.microsoft.sqlserver.jdbc.SQLServerDriver</driver-class>
        <driver-properties>
            <property name="user" value="sa"/>
              <property name="password" value="sa"/>
        </driver-properties>
         <maximum-active-time>60000</maximum-active-time>  
        <maximum-connection-count>500</maximum-connection-count>
        <house-keeping-test-sql>select CURRENT_DATE</house-keeping-test-sql>
      </proxool>
</something-else-entirely>

调试页面test.jsp

<%@ page language="java" pageEncoding="UTF-8"%>
<%@ page contentType="text/html; charset=UTF-8"%>
<%@   page   import="java.sql.*"%>   
<%@   page   import="javax.sql.*"%>   
<%@   page   import="javax.naming.*"%>   
<HTML> 
<HEAD> 
<TITLE>JSP测试页面</TITLE> 
</HEAD> 
<BODY> 
<%out.println("<h1>Hello，test JNDI ! </h1>");%> 
  <%       Context jndiCntx = new InitialContext();;
           Context envContext = (Context) jndiCntx.lookup("java:comp/env"); 
           DataSource ds = (DataSource) envContext.lookup("JDBC/PIMS");    
           Connection conn=ds.getConnection();    
          Statement st=conn.createStatement();     
        String   sql="select   *   from   tbl_custfee";    
       ResultSet   rs=st.executeQuery(sql);    
     while(rs.next())   {%>    
    您的第一个字段内容为：<%=rs.getString(1)%>    
     您的第二个字段内容为：<%=rs.getString(2)%>    
     <br> 
     <%}%>    
  <%out.print("使用jdbc驱动操作数据库操作成功");%>    
  <%rs.close();    
  st.close();    
  conn.close();    
  %>   
</BODY> 
</HTML>