创建一个连接池操作类
using MySql.Data.MySqlClient; using System; using System.Collections.Generic; using System.Linq; using System.Text; using System.Timers; namespace CommonAssistant { public class MySqlConnectionPool { private readonly string sqlConnect = string.Empty; public MySqlConnectionPool(string Connection) { sqlConnect = Connection; //定时器轮询连接,清理不在使用的连接 var timer = new Timer(); timer.Enabled = true; timer.Elapsed += (a, b) => { //轮询连接池连接,删除满足条件的连接 delwithConnectPool("remove"); Console.WriteLine( "连接数:"+getCount()); }; timer.Interval = 1000 * 10; //10分钟一次 timer.AutoReset = true;//一直执行 } private static List<ConnectionItem> listConnects = new List<ConnectionItem>(); private static readonly object obj_getConnects = new object(); public Tuple<bool