proxool代码创建数据库连接与获取监控状态-白红宇

proxool代码创建数据库连接与获取监控状态

阅读量：7090 次

发布时间：2019-06-28

本文共 3534 字，大约阅读时间需要 11 分钟。

package com.originalsoft.Test;import java.net.URL;import java.sql.*;import org.logicalcobwebs.proxool.ProxoolException;import org.logicalcobwebs.proxool.ProxoolFacade;import org.logicalcobwebs.proxool.configuration.JAXPConfigurator;import org.logicalcobwebs.proxool.admin.SnapshotIF;/** * @author tank * @date:Apr 15, 2013 6:14:08 PM * @description: * @version : */public class DBConnection {	private static boolean initialized = false;	private static int activeCount = 0;	public static void state() throws ProxoolException{		SnapshotIF snapshot = ProxoolFacade.getSnapshot("mySqlProxool", true);		int curActiveCount = snapshot.getActiveConnectionCount();// 获得活动连接数		int availableCount = snapshot.getAvailableConnectionCount();// 获得可得到的连接数		int maxCount = snapshot.getMaximumConnectionCount();// 获得总连接数//		if (curActiveCount != activeCount)// 当活动连接数变化时输出信息//		{			System.out.println("----------------------------------");			System.out.println(curActiveCount + "(active)  " + availableCount + "(available)  " + maxCount + "(max)");			System.out.println("----------------------------------");			activeCount = curActiveCount;//		}	}	public static Connection getConnection() throws SQLException {		Connection connection = null;		if (!initialized) {			init();		}		connection = DriverManager.getConnection("proxool.mySqlProxool");		try {			SnapshotIF snapshot = ProxoolFacade.getSnapshot("mySqlProxool", true);			int curActiveCount = snapshot.getActiveConnectionCount();// 获得活动连接数			int availableCount = snapshot.getAvailableConnectionCount();// 获得可得到的连接数			int maxCount = snapshot.getMaximumConnectionCount();// 获得总连接数			if (curActiveCount != activeCount)// 当活动连接数变化时输出信息			{				System.out.println("----------------------------------");				System.out.println(curActiveCount + "(active)  " + availableCount + "(available)  " + maxCount + "(max)");				System.out.println("----------------------------------");				activeCount = curActiveCount;			}		} catch (ProxoolException e) {			// TODO Auto-generated catch block			e.printStackTrace();		}		if (connection != null) {			return connection;		} else {			throw new NullPointerException("Didn't get connection, which probably means that no Driver accepted the URL");		}	}	private static void init() {		String fileName = "proxool.xml";		URL resourceURL = null;		try {			if (Thread.currentThread().getContextClassLoader() != null) {				resourceURL = Thread.currentThread().getContextClassLoader().getResource(fileName);			}			if (resourceURL == null) {				resourceURL = DBConnection.class.getClassLoader().getResource(fileName);			}			JAXPConfigurator.configure(resourceURL.getFile(), false);			Class.forName("org.logicalcobwebs.proxool.ProxoolDriver");		} catch (ClassNotFoundException e) {			// TODO Auto-generated catch block			e.printStackTrace();		} catch (ProxoolException e) {			// TODO Auto-generated catch block			e.printStackTrace();		}		initialized = true;	}}

　　注：

mySqlProxool为注册proxool的别名


     
     	
      		
       
        mySqlProxool
         							
       
        jdbc:mysql://127.0.0.1:3306/db
       		
       
        com.mysql.jdbc.Driver
       		
       			
        			
        			
        		
       		
       		
       
        true
       		
       
        select CURRENT_DATE
       		
       
        90000
       		
       
        100
       
       		
       
        300
       		
       
        20
       		
       		
       
        5
       
       		
       
        1200000