模拟100用户并发访问数据库，结果测的MySQL并发访问数是大概是100，否则会抛出 too many connection 异常

编写数据库连接工具类

package com.security.ljh.secutiryDemo;

import java.sql.*;
/**
 * 连接数据库
 */
public class MysqlUtils {
    private static  final String URL="jdbc:mysql://localhost:3306/test";
    static {
            try {
                //从8.X开始 com.mysql.jdbc.Driver 驱动过时了
                //取而代之的是com.mysql.cj.jdbc.Driver
                //这里使用的是mysql-connector-java.5.x.jar
                Class.forName("com.mysql.jdbc.Driver");
            } catch (ClassNotFoundException e) {
                e.printStackTrace();
            }
    }
    public static Connection createConn() throws SQLException {
            return DriverManager.getConnection(URL,"userName","password");
    }
}

接下来模拟100用户同时访问数据库

import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.concurrent.CountDownLatch;

/**
 * Created by hp on 2019/5/31.
 */
public class Test {
    private static final int THREADS = 100;//模拟100用户并发访问数据库
    private static CountDownLatch countDownLatch = new CountDownLatch(THREADS);//倒计时计数器

    public static void main(String[] args) {
        for (int i = 0; i < THREADS; i++) {
            new Thread(() -> {//创建100个线程模拟用户
                countDownLatch.countDown();//计数器减一
                try {
                    countDownLatch.await();//当计数器没有减为0时，线程一直等待
                    Connection conn = null;
                    try {
                        //执行到这里，100个线程同时访问数据库
                        conn = MysqlUtils.createConn();//获取连接
                        //执行操作
                        PreparedStatement preparedStatement = conn.prepareStatement("select COUNT(title) c from video");
                        ResultSet resultSet = preparedStatement.executeQuery();
                        System.out.println(resultSet.next());
                        System.out.println(resultSet.getObject("c"));
                    } catch (SQLException e) {
                        e.printStackTrace();
                    } finally {
                        try {
                            conn.close();//关闭连接
                        } catch (SQLException e) {
                            e.printStackTrace();
                        }
                    }
                } catch (InterruptedException e) {
                    e.printStackTrace();
                }
            }).start();
        }

    }
}