程序博客网 > 宁波奥派网络

简单的MySQL连接池，支持高并发。

来源：互联网 发布：宁波奥派网络 编辑：程序博客网 时间：2024/05/29 02:48
/** * 连接池类 */package com.junones.test; import java.sql.Connection;import java.sql.SQLException;import java.util.HashMap;import java.util.Map;import java.util.Map.Entry; import com.mysql.jdbc.jdbc2.optional.MysqlDataSource; public class MySQLPool {    private static volatile MySQLPool pool;    private MysqlDataSource ds;    private Map<Connection, Boolean> map;      private String url = "jdbc:mysql://localhost:3306/test";    private String username = "root";    private String password = "root1234";    private int initPoolSize = 10;    private int maxPoolSize = 200;    private int waitTime = 100;         private MySQLPool() {        init();    }         public static MySQLPool getInstance() {        if (pool == null) {            synchronized (MySQLPool.class) {                if(pool == null) {                    pool = new MySQLPool();                }            }        }        return pool;    }         private void init() {        try {            ds = new MysqlDataSource();            ds.setUrl(url);            ds.setUser(username);            ds.setPassword(password);            ds.setCacheCallableStmts(true);            ds.setConnectTimeout(1000);            ds.setLoginTimeout(2000);            ds.setUseUnicode(true);            ds.setEncoding("UTF-8");            ds.setZeroDateTimeBehavior("convertToNull");            ds.setMaxReconnects(5);            ds.setAutoReconnect(true);            map = new HashMap<Connection, Boolean>();            for (int i = 0; i < initPoolSize; i++) {                map.put(getNewConnection(), true);            }        } catch (Exception e) {            e.printStackTrace();        }    }         public Connection getNewConnection() {        try {            return ds.getConnection();        } catch (SQLException e) {            e.printStackTrace();        }        return null;    }         public synchronized Connection getConnection() {        Connection conn = null;        try {            for (Entry<Connection, Boolean> entry : map.entrySet()) {                if (entry.getValue()) {                    conn = entry.getKey();                    map.put(conn, false);                    break;                }            }            if (conn == null) {                if (map.size() < maxPoolSize) {                    conn = getNewConnection();                    map.put(conn, false);                } else {                    wait(waitTime);                    conn = getConnection();                }            }        } catch (Exception e) {            e.printStackTrace();        }        return conn;    }         public void releaseConnection(Connection conn) {        if (conn == null) {            return;        }        try {            if(map.containsKey(conn)) {                if (conn.isClosed()) {                    map.remove(conn);                } else {                    if(!conn.getAutoCommit()) {                        conn.setAutoCommit(true);                    }                    map.put(conn, true);                }            } else {                conn.close();            }        } catch (SQLException e) {            e.printStackTrace();        }    }} /** * 测试类 */package com.junones.test; import java.sql.Connection;import java.sql.ResultSet;import java.sql.SQLException;import java.sql.Statement; public class TestMySQLPool {    private static volatile int a;     private synchronized static void incr() {        a++;    }     public static void main(String[] args) throws InterruptedException {        int times = 10000;        long start = System.currentTimeMillis();        for (int i = 0; i < times; i++) {            new Thread(new Runnable() {                 @Override                public void run() {                     MySQLPool pool = MySQLPool.getInstance();                    Connection conn = pool.getConnection();                    Statement stmt = null;                    ResultSet rs = null;                    try {                        stmt = conn.createStatement();                        rs = stmt.executeQuery("select id, name from t_test");                        while (rs.next()) {                            System.out.println(rs.getInt(1) + ", "                                    + rs.getString(2));                        }                    } catch (SQLException e) {                        e.printStackTrace();                    } finally {                        incr();                        if (rs != null) {                            try {                                rs.close();                            } catch (SQLException e) {                                e.printStackTrace();                            }                        }                        if (stmt != null) {                            try {                                stmt.close();                            } catch (SQLException e) {                            }                        }                        pool.releaseConnection(conn);                    }                }            }).start();        }        while (true) {            if (a == times) {                System.out.println("finished, time:"                        + (System.currentTimeMillis() - start));                break;            }            Thread.sleep(100);        }    }} 测试结果： 1万个并发， 5秒完成。



/**
 * 连接池类
 */
packagecom.junones.test;
 
importjava.sql.Connection;
importjava.sql.SQLException;
importjava.util.HashMap;
importjava.util.Map;
importjava.util.Map.Entry;
 
importcom.mysql.jdbc.jdbc2.optional.MysqlDataSource;
 
publicclassMySQLPool {
    privatestaticvolatile MySQLPool pool;
    privateMysqlDataSource ds;
    privateMap<Connection, Boolean> map;
  
    privateString url = "jdbc:mysql://localhost:3306/test";
    privateString username = "root";
    privateString password = "root1234";
    privateintinitPoolSize = 10;
    privateintmaxPoolSize = 200;
    privateintwaitTime = 100;
     
    privateMySQLPool() {
        init();
    }
     
    publicstaticMySQLPool getInstance() {
        if(pool == null) {
            synchronized(MySQLPool.class) {
                if(pool == null) {
                    pool = newMySQLPool();
                }
            }
        }
        returnpool;
    }
     
    privatevoidinit() {
        try{
            ds = newMysqlDataSource();
            ds.setUrl(url);
            ds.setUser(username);
            ds.setPassword(password);
            ds.setCacheCallableStmts(true);
            ds.setConnectTimeout(1000);
            ds.setLoginTimeout(2000);
            ds.setUseUnicode(true);
            ds.setEncoding("UTF-8");
            ds.setZeroDateTimeBehavior("convertToNull");
            ds.setMaxReconnects(5);
            ds.setAutoReconnect(true);
            map = newHashMap<Connection, Boolean>();
            for(inti = 0; i < initPoolSize; i++) {
                map.put(getNewConnection(),true);
            }
        }catch(Exception e) {
            e.printStackTrace();
        }
    }
     
    publicConnection getNewConnection() {
        try{
            returnds.getConnection();
        }catch(SQLException e) {
            e.printStackTrace();
        }
        returnnull;
    }
     
    publicsynchronizedConnection getConnection() {
        Connection conn = null;
        try{
            for(Entry<Connection, Boolean> entry : map.entrySet()) {
                if(entry.getValue()) {
                    conn = entry.getKey();
                    map.put(conn,false);
                    break;
                }
            }
            if(conn == null) {
                if(map.size() < maxPoolSize) {
                    conn = getNewConnection();
                    map.put(conn,false);
                }else{
                    wait(waitTime);
                    conn = getConnection();
                }
            }
        }catch(Exception e) {
            e.printStackTrace();
        }
        returnconn;
    }
     
    publicvoidreleaseConnection(Connection conn) {
        if(conn == null) {
            return;
        }
        try{
            if(map.containsKey(conn)) {
                if(conn.isClosed()) {
                    map.remove(conn);
                }else{
                    if(!conn.getAutoCommit()) {
                        conn.setAutoCommit(true);
                    }
                    map.put(conn,true);
                }
            }else{
                conn.close();
            }
        }catch(SQLException e) {
            e.printStackTrace();
        }
    }
}
 
/**
 * 测试类
 */
packagecom.junones.test;
 
importjava.sql.Connection;
importjava.sql.ResultSet;
importjava.sql.SQLException;
importjava.sql.Statement;
 
publicclassTestMySQLPool {
    privatestaticvolatile int a;
 
    privatesynchronizedstatic void incr() {
        a++;
    }
 
    publicstaticvoid main(String[] args) throwsInterruptedException {
        inttimes = 10000;
        longstart = System.currentTimeMillis();
        for(inti = 0; i < times; i++) {
            newThread(newRunnable() {
 
                @Override
                publicvoidrun() {
 
                    MySQLPool pool = MySQLPool.getInstance();
                    Connection conn = pool.getConnection();
                    Statement stmt = null;
                    ResultSet rs = null;
                    try{
                        stmt = conn.createStatement();
                        rs = stmt.executeQuery("select id, name from t_test");
                        while(rs.next()) {
                            System.out.println(rs.getInt(1) + ", "
                                    + rs.getString(2));
                        }
                    }catch(SQLException e) {
                        e.printStackTrace();
                    }finally{
                        incr();
                        if(rs != null) {
                            try{
                                rs.close();
                            }catch(SQLException e) {
                                e.printStackTrace();
                            }
                        }
                        if(stmt != null) {
                            try{
                                stmt.close();
                            }catch(SQLException e) {
                            }
                        }
                        pool.releaseConnection(conn);
                    }
                }
            }).start();
        }
        while(true) {
            if(a == times) {
                System.out.println("finished, time:"
                        + (System.currentTimeMillis() - start));
                break;
            }
            Thread.sleep(100);
        }
    }
}
 
测试结果：1万个并发，5秒完成。
0 0
宁波奥派网络 宁波奥派网络
原创粉丝点击
热门IT博客
电脑时间提醒软件电脑时间提醒软件
软件开发团队名字软件开发团队名字
win10有线网络显示红叉
通向财务自由之路 知乎
intent传递数据
聚划算抢购软件
ios 导出沙盒数据
七天网络查分下载
java邮箱的正则表达式
协同办公软件a8
java技术分享
模特法 工时 数据库
mac连不上手机热点
济南seo网络公司
js 判断flash播放完毕
ubuntu添加搜狗输入法
李明linux
网络学会计推荐
淘宝自定义模板代码
js中字符串方法join
热门问题 老师的惩罚 人脸识别 我在镇武司摸鱼那些年 重生之率土为王 我在大康的咸鱼生活 盘龙之生命进化 天生仙种 凡人之先天五行 春回大明朝 姑娘不必设防，我是瞎子 意面的做法简单的方式 意面 经典意面 炒意面 意面热量 意面怎么煮 意面煮多久 飞天意面神教 黑椒意面 肉酱意面 奶油蘑菇意面 番茄意面 意面做法 懒人版黑椒意面 意面酱 芝士意面 虾仁意面 暗涌by肉酱意面 意面煮几分钟 奶油意面 番茄肉酱意面 意面酱做法 意式肉酱面 芝士番茄意面 海鲜意面 意面图片 意面冷水下锅还是沸水下锅 煮意面 意面要煮多久 意面酱料 培根芝士意面 如何煮意面 怎么做意面 意面吃法 海鲜意大利面 意大利番茄面 意面怎么做好吃 意大利面 如何做意面 意面怎么做好吃又简单 意面酱汁制作方法

程序博客网，程序员的互联网技术博客家园。csdn论坛精品 msdn技术资料都在这里