生活随笔
收集整理的這篇文章主要介紹了
proxool数据库连接池用法
小編覺得挺不錯的,現在分享給大家,幫大家做個參考.
? ? ? ? 今天給大家介紹一種新的數據連接池實現方式——proxool數據庫連接池，這是一個健壯、易用的連接池。以下通過一個Demo說明一下怎樣使用：
? ? ? ? 項目結構例如以下：
? ? ? ??DBLink.java文件里的代碼：
package com.ghj.util;import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.ResultSetMetaData;
import java.sql.SQLException;
import java.util.ArrayList;
import java.util.HashMap;
import java.util.List;
import java.util.Map;public class DBLink {private Connection connection;private PreparedStatement preparedStatement;private ResultSet resultSet;static{try {Class.forName("org.logicalcobwebs.proxool.ProxoolDriver"); //載入驅動 }catch (ClassNotFoundException e) {System.out.println("載入驅動失敗！");e.printStackTrace();}}private Connection getConn(){try {if(connection==null||connection.isClosed()){connection = DriverManager.getConnection("proxool.mysqlsource"); //獲取連接 }} catch (SQLException e) {System.out.println("獲取連接失敗。");e.printStackTrace();}return connection;}public List<Map<String, Object>> select(String sql, Object [] params){List<Map<String, Object>> list = new ArrayList<Map<String, Object>>();try{connection = this.getConn();preparedStatement = connection.prepareStatement(sql);if(params != null){for(int i =0; i<params.length; i++){preparedStatement.setObject(i+1, params[i]);//逐一給問號賦值}}resultSet = preparedStatement.executeQuery();ResultSetMetaData rsmd = resultSet.getMetaData();int columnCount = rsmd.getColumnCount();while(resultSet.next()){Map<String, Object> map = new HashMap<String, Object>();for(int i =1; i<=columnCount;i++){String columnName = rsmd.getColumnName(i);Object obj = null;if(rsmd.getColumnTypeName(i).equals("DATE")){obj = resultSet.getString(columnName);}else{obj = resultSet.getObject(columnName);}map.put(columnName, obj);}list.add(map);}}catch(SQLException e){e.printStackTrace();}finally{close();}return list;}private void close(){try {if(resultSet != null){resultSet.close();}} catch (SQLException e) {e.printStackTrace();}try {if(preparedStatement != null){preparedStatement.close();}} catch (SQLException e) {e.printStackTrace();}try {connection.close();} catch (SQLException e) {e.printStackTrace();}}
}
? ? ? ??proxool.xml文件里的代碼：
<?xml version="1.0" encoding="UTF-8"?>
<proxool-config><proxool><alias>mysqlsource</alias><driver-url>jdbc:mysql://localhost:3306/test</driver-url><driver-class>com.mysql.jdbc.Driver</driver-class><driver-properties><property name="user" value="root" /><property name="password" value="root" /></driver-properties><!-- 保留線程處于睡眠狀態的最長時間 --><house-keeping-sleep-time>60000</house-keeping-sleep-time><maximum-connection-count>30</maximum-connection-count><minimum-connection-count>10</minimum-connection-count><!-- 連接池中可用的連接數量（空暇狀態） --><prototype-count>5</prototype-count><maximum-new-connections>1</maximum-new-connections><simultaneous-build-throttle>1</simultaneous-build-throttle><!-- 連接池使用狀態 --><statistics>30s,10m,1d</statistics><!-- 連接池日志類型 --><statistics-log-level>ERROR</statistics-log-level><!-- 假設為true,那么每一個被運行的SQL語句將會在運行期被log記錄(DEBUG LEVEL) --><trace>true</trace><house-keeping-test-sql>select CURRENT_DATE</house-keeping-test-sql></proxool>
</proxool-config>
? ? ? ??web.xml文件里的代碼：
<?xml version="1.0" encoding="UTF-8"?>
<web-app version="3.0" xmlns="http://java.sun.com/xml/ns/javaee"xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"xsi:schemaLocation="http://java.sun.com/xml/ns/javaee http://java.sun.com/xml/ns/javaee/web-app_3_0.xsd"><!-- 連接池 --><servlet><servlet-name>ServletConfigurator</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></init-param><load-on-startup>1</load-on-startup></servlet><welcome-file-list><welcome-file>index.jsp</welcome-file></welcome-file-list>
</web-app>
? ? ? ??index.jsp文件里的代碼：
<%@ page language="java" contentType="text/html; charset=UTF-8" pageEncoding="UTF-8"%>
<%@page import="com.ghj.util.DBLink,java.util.List,java.util.Map"%><!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html><head><title>首頁</title></head><body><table width="100%" border="1px"><tr><th>序號 </th><th>班級名稱</th><th>開班日期</th><th>結束日期</th><th>狀態</th><th>操作</th></tr><%String sql = "SELECT id, class_name, begin_date, end_date, state FROM class ";DBLink db = new DBLink();List<Map<String, Object>> list = db.select(sql, null);int index = 0;for (Map<String, Object> map : list) {index = index + 1;int id = Integer.parseInt(map.get("id").toString());String className = map.get("class_name").toString();String beginDate = map.get("begin_date").toString();String endDate = map.get("end_date").toString();int state = Integer.parseInt(map.get("state").toString());String stateName = (state == 0 ? "未啟用" : "啟用");%><tr align="center"><td><%=index%></td><td><%=className%></td><td><%=beginDate%></td><td><%=endDate%></td><td><%=stateName%></td><td>【<a href="###" οnclick="">改動</a>】【<a href="###" οnclick="">查看</a>】【<a href="###" οnclick="">刪除</a>】</td></tr><%}%></table></body>
</html>
? ? ? ??【
0分下載演示樣例】
總結
以上是生活随笔為你收集整理的proxool数据库连接池用法的全部內容，希望文章能夠幫你解決所遇到的問題。
如果覺得生活随笔網站內容還不錯，歡迎將生活随笔推薦給好友。
