栏目分类:
子分类:
返回
名师互学网用户登录
快速导航关闭
当前搜索
当前分类
子分类
实用工具
热门搜索
名师互学网 > IT > 软件开发 > 后端开发 > Java

简单实现数据库链接池

Java 更新时间: 发布时间: IT归档 最新发布 模块sitemap 名妆网 法律咨询 聚返吧 英语巴士网 伯小乐 网商动力

简单实现数据库链接池

package com.example.demo.hmjuc.day17;

import com.example.demo.hmjuc.Sleep;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import java.util.Properties;
import java.util.Random;
import java.util.concurrent.atomic.AtomicIntegerArray;


public class TestPool {

    public static void main(String[] args) {
        Pool pool = new Pool(2);
        for (int i = 0; i < 5; i++) {
            new Thread(() -> {
                Connection borrow = pool.borrow();
                Sleep.sleep(new Random().nextInt(1000));
                pool.free(borrow);
            }).start();
        }

    }
}


class Pool {
    
    private final Integer poolSize;
    
    private Connection[] connections;
    
    private AtomicIntegerArray statusArray;

    
    public Pool(Integer poolSize) {
        this.poolSize = poolSize;
        this.connections = new Connection[poolSize];
        this.statusArray = new AtomicIntegerArray(poolSize);

        for (int i = 0; i < poolSize; i++) {
            connections[i] = createConnection();
        }
    }

    
    public Connection borrow() {
        while (true) {
            for (int i = 0; i < poolSize; i++) {
                if (statusArray.get(i) == 0 && statusArray.compareAndSet(i, 0, 1)) {
                    return connections[i];
                }
            }
            // 没有可用链接等待
            synchronized (this) {
                try {
                    this.wait();
                } catch (InterruptedException e) {
                    e.printStackTrace();
                }
            }
        }
    }

    
    public void free(Connection conn) {
        for (int i = 0; i < poolSize; i++) {
            if (connections[i] == conn) {
                statusArray.set(i, 0);
                synchronized (this) {
                    this.notify();
                }
                break;
            }
        }
    }

    
    private Connection createConnection() {
        // 获取数据库驱动
        Connection conn = null;
        Properties props = new Properties();
        try {
            Class.forName("com.mysql.cj.jdbc.Driver");
            DriverManager.setLoginTimeout(10);
            props.setProperty("user", "root");
            props.setProperty("password", "root");
            // 设置可以获取remarks信息
            props.setProperty("remarks", "true");
            // 设置可以获取tables remarks信息(mysql时必须设置)
            props.setProperty("useInformationSchema", "true");
            conn = DriverManager.getConnection("jdbc:mysql://127.0.0.1:3306/delivery?serverTimezone=GMT%2B8&useSSL=false&useOldAliasMetadataBehavior=true&useUnicode=true&characterEncoding=utf8", props);
            conn.setAutoCommit(true);
        } catch (Exception e) {
            e.printStackTrace();
            close(conn);
        }
        return conn;
    }

    
    private static void close(Object obj) {
        if (obj == null) {
            return;
        }
        if (obj instanceof ResultSet) {
            try {
                ((ResultSet) obj).close();
            } catch (SQLException e) {
                e.printStackTrace();
            }
        } else if (obj instanceof Statement) {
            try {
                ((Statement) obj).close();
            } catch (SQLException e) {
                e.printStackTrace();
            }
        } else if (obj instanceof Connection) {
            Connection c = (Connection) obj;
            try {
                if (!c.isClosed()) {
                    c.close();
                }
            } catch (SQLException e) {
                e.printStackTrace();
            }
        }
    }


}

转载请注明:文章转载自 www.mshxw.com
本文地址:https://www.mshxw.com/it/950984.html
我们一直用心在做
关于我们 文章归档 网站地图 联系我们

版权所有 (c)2021-2022 MSHXW.COM

ICP备案号:晋ICP备2021003244-6号