MySQL的isnullorempty_mysqlEasyHelper(待完善)

classmysqlEasyHeper{private string _conStr = "server=localhost; user id=root; port=3308; password=root; charset=utf8; pooling=true";privateMySqlConnection _con;public stringconState{get{return _con == null ? "": _con.State.ToString();

}

}publicMySqlConnection con{get{if(_con == null){

getConn();

}return this._con;

}

}publicmysqlEasyHeper(){try{

_con= newMySqlConnection(_conStr);

_con.Open();

}catch(Exception e) {throwe;

}

}privateMySqlConnection getConn(){try{

_con= newMySqlConnection(_conStr);

_con.Open();

}catch(Exception) {return null;

}return_con;

}private void excuteNoQuery(stringqueryStr, MySqlConnection connect){if(String.IsNullOrEmpty(queryStr)) return;

MySqlCommand query= newMySqlCommand(queryStr, connect);

query.ExecuteNonQuery();

}public void createDatabase(stringdataName){if(string.IsNullOrEmpty(dataName))return;string sql = "create database if not exists" + dataName + ";";

excuteNoQuery(sql, _con);

}publicDataTable showDataBases(){string sql = "show databases;";

DataTable dt= null;

MySqlDataAdapter adapter= null;try{

MySqlCommand query= newMySqlCommand(sql, _con);

adapter= newMySqlDataAdapter();

dt= newDataTable();

adapter.SelectCommand=query;

adapter.Fill(dt);

}catch(Exception e) {return null;

}finally{

adapter.Dispose();

}returndt;

}public voiddispose(){if(_con != null){if (_con.State ==ConnectionState.Open) {

_con.Close();

}

_con.Dispose();

}

}public voiddbPoolTest(){string _conStr = "server=localhost; user id=root; port=3308; password=root; charset=utf8; pooling=false";

MySqlConnection conn= newMySqlConnection(_conStr);

conn.Open();

conn.Close();

}

}