MySQL连接池

1.

using System;
using System.Collections;
using MySql.Data.MySqlClient;

namespace Helper
{
    /// <summary>
    /// MySQL连接池
    /// </summary>
    public static class MySQLConnPool
    {
        //private static string connStr = "server=localhost;User ID=root;Password=qwer1234;database=test;";//连接字符串
        private static ArrayList poolLs = new ArrayList();//连接池
        private static int max = 20;//连接池最大数量

        /// <summary>
        /// 获取连接对象
        /// </summary>
        /// <param name="connStr">数据库连接字符串</param>
        /// <returns></returns>
        public static MySqlConnection GetConn(string connStr)
        {
            lock (poolLs)
            {
                MySqlConnection retConn = null;//超出线程池大小限制时返回null
                if (poolLs.Count > 0)
                {
                    retConn = (MySqlConnection)poolLs[0];//获取池中第一个
                    poolLs.RemoveAt(0);//从池中移除
                }
                else
                {
                    retConn = new MySqlConnection(connStr);//连接池中没有连接,创建一个
                    retConn.Open();
                }
                return retConn;
            }
        }

        /// <summary>
        /// 关闭连接或添加到连接池
        /// </summary>
        /// <param name="conn"></param>
        public static void Close(MySqlConnection conn)
        {
            lock (poolLs)
            {
                if (poolLs.Count < max)//连接池只保留最大数量的连接
                {
                    poolLs.Add(conn);//连接池数量小于限制,将连接添加到连接池
                }
                else
                {
                    conn.Close();//线程池超出数量限制,关闭连接
                }
            }
        }
    }
}

2.

using System;
using System.Web.Mvc;
using System.Data;
using MySql.Data.MySqlClient;
using Helper;


namespace MVC4.Controllers
{
    public class testController : Controller
    {
        private static string connStr = "server=localhost;User ID=root;Password=12345678;database=test;";
        public ActionResult Index()
        {
            MySqlConnection conn = MySQLConnPool.GetConn(connStr);
            MySqlCommand cmd = new MySqlCommand("Select * from us_BaseInfo", conn);
            MySqlDataReader dr = cmd.ExecuteReader();
            if (dr.Read())
            {
            }
            dr.Close();//关闭MySqlDataReader
            MySQLConnPool.Close(conn);
            return View();
        }
    }
}