(Oracle功能篇) Oracle 数据库连接池

- 日理万妓 2023-10-18 22:40 153阅读 0赞

使用：proxool-0.9.1.zip

[http://ncu.dl.sourceforge.net/project/proxool/proxool/0.9.1/proxool-0.9.1.zip][http_ncu.dl.sourceforge.net_project_proxool_proxool_0.9.1_proxool-0.9.1.zip]

![Center][]

相关代码：

package yerasel;  
      
    import java.sql.Connection;  
    import java.sql.DriverManager;  
    import java.sql.ResultSet;  
    import java.sql.ResultSetMetaData;  
      
    import java.sql.Statement;  
      
    import org.logicalcobwebs.proxool.configuration.JAXPConfigurator;  
      
    public class Test {  
      
        int beginIndex = 0; // 待取记录起始数  
        int endIndex = 10;  // 待取得记录终止跳  
        String MySQLdbTableName = "usrpsw";  
        String MySQLreq = "select * from " + MySQLdbTableName + " limit " + beginIndex + ", " + endIndex;  
          
        /** 
         * proxool方式测试 
         *  
         * @throws Exception 
         */  
        public void test2() throws Exception {  
            // Java应用中先要加载配置文件，否则谁知道你配置给谁用的  
            JAXPConfigurator  
                    .configure("proxool.xml", false);  
              
              
              
            // 1：注册驱动类，这次这个驱动已经不是Oracle的驱动了，是Proxool专用的驱动  
            Class.forName("org.logicalcobwebs.proxool.ProxoolDriver");  
            // 2：创建数据库连接，这个参数是一个字符串，是数据源的别名，在配置文件中配置的timalias，参数格式为：proxool.数据源的别名  
            Connection conn = DriverManager.getConnection("proxool.mysql");  
            for(int i = 0; i< 20; i++)  
                 conn = DriverManager.getConnection("proxool.mysql");  
            // 3：创建执行SQL的对象  
            Statement stmt = conn.createStatement();  
            // 4：执行SQL，并获取返回结果  
            ResultSet res = stmt.executeQuery(MySQLreq);  
            // 5：处理返回结果，此处打印查询结果  
            ResultSetMetaData rsmd = res.getMetaData();  
            int columnCount = rsmd.getColumnCount();  
            int rowCount = 0;  
            while (res.next()) {  
                System.out.print(rowCount + " ");  
                rowCount++;  
                for (int j = 1; j <= columnCount; j++) {// 循环处理  
                    String strRes = res.getString(j);  
                    System.out.print(strRes + "|\t");  
                }  
                System.out.println();  
            }  
            // 6：关闭数据库连接  
            conn.close();  
        }  
      
        public static void main(String[] args) throws Exception {  
            Test obj = new Test();  
            obj.test2();  
        }  
      
    }

编写相关的配置文件：

<?xml version="1.0" encoding="UTF-8"?>   
    <something-else-entirely>   
            <proxool>   
                    <alias>mysql</alias>   
                       
                    <driver-url>jdbc:mysql://127.0.0.1:3306/mysqlconn</driver-url>   
                       
                    <driver-class>com.mysql.jdbc.Driver</driver-class>   
                       
                    <driver-properties>   
                            <property name="user" value="root"/>   
                               
                            <property name="password" value="123456"/>   
                               
                    </driver-properties>   
                       
                    <maximum-connection-count>5</maximum-connection-count>   
                       
                    <minimum-connection-count>1</minimum-connection-count>   
                       
                    <house-keeping-sleep-time>90000</house-keeping-sleep-time>   
                       
                    <maximum-new-connections>6</maximum-new-connections>   
                       
                    <prototype-count>5</prototype-count>   
                       
                    <test-before-use>true</test-before-use>   
                       
                    <house-keeping-test-sql>show tables</house-keeping-test-sql>   
            </proxool>   
    </something-else-entirely>

注意，在程序中发起了过多线程，目的就是检验线程限制是否有效。

数据库内容如下：

![Center 1][]

[http_ncu.dl.sourceforge.net_project_proxool_proxool_0.9.1_proxool-0.9.1.zip]: http://ncu.dl.sourceforge.net/project/proxool/proxool/0.9.1/proxool-0.9.1.zip
[Center]: https://img-blog.csdn.net/20130806161819671?watermark/2/text/aHR0cDovL2Jsb2cuY3Nkbi5uZXQvemhvdXpoaXdlbmdhbmc=/font/5a6L5L2T/fontsize/400/fill/I0JBQkFCMA==/dissolve/70/gravity/Center
[Center 1]: https://img-blog.csdn.net/20130806162112093?watermark/2/text/aHR0cDovL2Jsb2cuY3Nkbi5uZXQvemhvdXpoaXdlbmdhbmc=/font/5a6L5L2T/fontsize/400/fill/I0JBQkFCMA==/dissolve/70/gravity/Center