数据统计方法的封装
数据统计方法的源代码:
- string conString = "data source=127.0.0.1;database=codematic;user
id=sa;- password=";
- SqlConnection myConnection = new SqlConnection(conString);
- string strSql = "select count(*) from P_Product";
- SqlCommand myCommand = new SqlCommand(strSql, myConnection);
- myConnection.Open();
- int count = (int)myCommand.ExecuteScalar();
- myConnection.Close();
封装后的方法:
- //<summary>
- //执行一条计算查询结果语句,返回查询结果(object)
- //</summary>
- //<param name="StrSql">计算查询结果语句</param>
- //<returns>查询结果(object)</returns>
- public static object GetSingle(string StrSql)
- {
- using (SqlConnection connection = new SqlConnection(conString))
- {
- using (SqlCommand cmd = new SqlCommand(StrSql, connection))
- {
- connection.Open();
- object obj = cmd.ExecuteScalar();
- if((Object.Equals(obj,null))||(Object.Equals(obj,System.DBNull.Value)))
- {
- return null;
- }
- else
- {
- return obj;
- }
- }
- }
- }
- 调用代码:
- string strSql = " select count(*) from P_Product ";
- string num = DbHelperSQL.GetSingle(strSql).ToString();
联系客服