mysql 数据层_我的MySql 数据访问层

最新推荐文章于 2023-02-19 21:30:19 发布

ZzzCola

最新推荐文章于 2023-02-19 21:30:19 发布

阅读量179

点赞数

文章标签： mysql 数据层

本文链接：https://blog.csdn.net/weixin_32115711/article/details/113158667

版权

usingSystem;usingSystem.Data;usingSystem.Configuration;usingSystem.Web;usingSystem.Web.Security;usingSystem.Web.UI;usingSystem.Web.UI.WebControls;usingSystem.Web.UI.WebControls.WebParts;usingSystem.Web.UI.HtmlControls;//Myself usingusingMySql.Data.MySqlClient;usingSystem.Web.Configuration;/**///myDataTable 的摘要说明///publicclassmyDataTable

{publicstringClient_Str;publicmyDataTable(stringMy_str)

{TODO: 在此处添加构造函数逻辑//Client_Str=My_str;//通过构造函数传递strng给class类的全局变量strng;}publicvoidmysql_EXE()//执行SQL但不返回数据{stringmyConn_str=WebConfigurationManager.ConnectionStrings["MySqlConnectionString"].ConnectionString;

MySqlConnection myConn=newMySqlConnection(myConn_str);

MySqlCommand myComm=newMySqlCommand(Client_Str);//myConn.Open();myComm.Connection=myConn;try{if(myComm.Connection.State.ToString()=="Closed") myComm.Connection.Open();

myComm.ExecuteNonQuery();

}catch(Exception ex)

{

Session["Error"]=ex.ToString();

Response.Redirect("error.aspx");

}finally{

myComm.Dispose();

myComm.Connection.Close();

myConn.Dispose();

myConn.Close();

}//myConn.Close();}publicDataTable myTable()//执行SQL并返回DataTable数据{stringmyConn_str=WebConfigurationManager.ConnectionStrings["MySqlConnectionString"].ConnectionString;

MySqlConnection myConn=newMySqlConnection(myConn_str);

MySqlCommand myComm=newMySqlCommand(Client_Str);//myConn.Open();myComm.Connection=myConn;try{if(myComm.Connection.State.ToString()=="Closed") myComm.Connection.Open();

myComm.ExecuteNonQuery();

}catch(Exception ex)

{

Session["Error"]=ex.ToString();

Response.Redirect("error.aspx");

}finally{

myComm.Dispose();

myComm.Connection.Close();

myConn.Dispose();

myConn.Close();

}//myConn.Close();MySqlDataAdapter myAdapter=newMySqlDataAdapter(myComm);

DataTable table=newDataTable();

myAdapter.Fill(table);returntable;

}publicvoidDelete_procedure()//“删除”的存储过程{stringstr_orgid=Client_Str;//获得orgidstringmyConn_str=WebConfigurationManager.ConnectionStrings["MySqlConnectionString"].ConnectionString;

MySqlConnection myConn=newMySqlConnection(myConn_str);

MySqlCommand myComm=newMySqlCommand("DELETEDB", myConn);//(Client_Str);//myComm.Connection = myConn;try{if(myComm.Connection.State.ToString()=="Closed") myComm.Connection.Open();

myComm.CommandType=CommandType.StoredProcedure;

MySqlParameter myParameter;

myParameter=newMySqlParameter("?m_orgid", MySqlDbType.String);

myParameter.Value=str_orgid;

myParameter.Direction=ParameterDirection.Input;

myComm.Parameters.Add(myParameter);//myComm.CommandText = "DELETEDB";//存储过程名//myComm.Parameters.Add("m_orgid", str_orgid);myComm.ExecuteNonQuery();

}catch(Exception ex)

{

Session["Error"]=ex.ToString();

Response.Redirect("error.aspx");

}finally{

myComm.Dispose();

myComm.Connection.Close();

myConn.Dispose();

myConn.Close();

}

}publicintMy_ExecuteScalar()//执行SQL并返回int记录数{stringstr_orgid=Client_Str;//获得orgidintRe_result=0;stringmyConn_str=WebConfigurationManager.ConnectionStrings["MySqlConnectionString"].ConnectionString;

MySqlConnection myConn=newMySqlConnection(myConn_str);

MySqlCommand myComm=newMySqlCommand(Client_Str,myConn);try{if(myComm.Connection.State.ToString()=="Closed") myComm.Connection.Open();//cmd.CommandText = "select count(*) from region";//Int32 count = (int32)cmd.ExecuteScalar();Re_result=Convert.ToInt32(myComm.ExecuteScalar());

}catch(Exception ex)

{

Session["Error"]=ex.ToString();

Response.Redirect("error.aspx");

}finally{

myComm.Dispose();

myComm.Connection.Close();

myConn.Dispose();

myConn.Close();

}returnRe_result;

}