请你帮帮忙

[lyf2941]

C#实现mysql 连接池

[lyf2941]

private string GetConnString()
{
return
"UserID=root;" +
"Password= ;" +
"Host=192.168.1.22;" +
"Port=3306;" +
"Database=test;" +
"Protocol=TCP;" +
"Charset = utf8;" +
"Compress=false;" +
"Connect Timeout=15;" +//连接超时
"Pooling=true;" +//允许连接池
"Min Pool Size=0;" +//最小连接数
"Max Pool Size=100;" +// //最大连接数
"Connection Lifetime=20"; //设置连接的生命周期

}

private String getsql()
{
//使用连接池实现数据库连接
ConnString = GetConnString();
conn = new MySqlConnection(ConnString);
conn.Open();

MySqlCommand cmd = new MySqlCommand("getbalance", conn);
cmd.CommandType = System.Data.CommandType.StoredProcedure;

MySqlParameter name_parameter = new MySqlParameter("?id2", MySqlDbType.Double);
name_parameter.Value = 8001000;
cmd.Parameters.Add(name_parameter);
MySqlParameter id_parameter = new MySqlParameter("?balance2", MySqlDbType.Double);
id_parameter.Direction = System.Data.ParameterDirection.Output;
cmd.Parameters.Add(id_parameter);
cmd.ExecuteNonQuery();
Double d = (Double)id_parameter.Value;
String dstr=d.ToString();
return dstr;
}