问题描述
usingSystem;usingSystem.Collections.Generic;usingSystem.Text;usingSystem.Data;usingSystem.Data.SqlClient;usingSystem.Configuration;namespaceBll{///<summary>///数据访问基类///</summary>publicabstractclassDbHelperSQL{publicDbHelperSQL(){}///<summary>///连接数据库对象///</summary>protectedstaticstringconnstr=ConfigurationManager.ConnectionStrings["connstring"].ConnectionString;#region公用方法///<summary>///参数化检查登录用户///</summary>///<paramname="strSql"></param>///<paramname="cmdParms"></param>///<returns></returns>publicstaticboolExists(stringstrSql,paramsSqlParameter[]cmdParms){objectobj=GetSingle(strSql,cmdParms);intcmdresult;//结果if((Object.Equals(obj,null))||(Object.Equals(obj,System.DBNull.Value))){cmdresult=0;}else{cmdresult=int.Parse(obj.ToString());}if(cmdresult==0){returnfalse;}else{returntrue;}}#endregion#region执行简单的SQL语句///<summary>///执行SQL语句,返回影响的记录数///</summary>///<paramname="strSql">SQL语句</param>///<returns>影响的记录数</returns>publicstaticintExecuteSql(stringstrSql){using(SqlConnectionconn=newSqlConnection(connstr)){using(SqlCommandcomm=newSqlCommand(strSql,conn)){try{conn.Open();introws=comm.ExecuteNonQuery();returnrows;}catch(System.Data.SqlClient.SqlExceptione){conn.Close();thrownewException(e.Message);}}}}///<summary>///执行一条计算查询结果语句,返回查询结果(object)。///</summary>///<paramname="strSql"></param>///<returns></returns>publicstaticobjectGetSingle(stringstrSql){using(SqlConnectionconn=newSqlConnection(connstr)){using(SqlCommandcomm=newSqlCommand(strSql,conn)){try{conn.Open();objectobj=comm.ExecuteScalar();if((Object.Equals(obj,null))||(Object.Equals(obj,System.DBNull.Value))){returnnull;}else{returnobj;}}catch(System.Data.SqlClient.SqlExceptione){conn.Close();thrownewException(e.Message);}}}}///<summary>///执行连接式查询语句,返回SqlDataReader///</summary>///<paramname="strSql"></param>///<returns></returns>publicstaticSqlDataReaderExecuteReader(stringstrSql){SqlConnectionconn=newSqlConnection(connstr);SqlCommandcomm=newSqlCommand(strSql,conn);try{conn.Open();SqlDataReadermyReader=comm.ExecuteReader();returnmyReader;}catch(System.Data.SqlClient.SqlExceptione){thrownewException(e.Message);}}///<summary>///执行非连接式查询语句,返回DataSet///</summary>///<paramname="strSql"></param>///<returns></returns>publicstaticDataSetQuery(stringstrSql){using(SqlConnectionconn=newSqlConnection(connstr)){DataSetds=newDataSet();try{conn.Open();SqlDataAdaptercmd=newSqlDataAdapter(strSql,conn);cmd.Fill(ds,"ds");}catch(System.Data.SqlClient.SqlExceptione){thrownewException(e.Message);}returnds;}}#endregion#region执行带参数的SQL语句///<summary>///执行SQL语句,返回影响的记录数///</summary>///<paramname="strSQL">SQL语句</param>///<paramname="cmdParms"></param>///<returns>影响的记录数</returns>publicstaticintExecuteSql(stringstrSQL,paramsSqlParameter[]cmdParms){using(SqlConnectionconn=newSqlConnection(connstr)){using(SqlCommandcomm=newSqlCommand()){try{PrepareCommand(comm,conn,strSQL,cmdParms);introws=comm.ExecuteNonQuery();comm.Parameters.Clear();returnrows;}catch(System.Data.SqlClient.SqlExceptione){thrownewException(e.Message);}}}}///<summary>///SQL语句的参数化赋值///</summary>///<paramname="comm">SqlCommand对象</param>///<paramname="conn">SqlConnection对象</param>///<paramname="cmdText">Sql语句</param>///<paramname="cmdParms">SQL参数</param>publicstaticvoidPrepareCommand(SqlCommandcomm,SqlConnectionconn,stringcmdText,SqlParameter[]cmdParms){if(conn.State!=ConnectionState.Open){conn.Open();}comm.Connection=conn;comm.CommandText=cmdText;comm.CommandType=CommandType.Text;if(cmdParms!=null){foreach(SqlParameterparmincmdParms){comm.Parameters.Add(parm);}}}///<summary>///执行一条计算查询结果语句,返回查询结果(object)。///</summary>///<paramname="strSQL"></param>///<paramname="cmdParms"></param>///<returns></returns>publicstaticobjectGetSingle(stringstrSQL,paramsSqlParameter[]cmdParms){using(SqlConnectionconn=newSqlConnection(connstr)){using(SqlCommandcmd=newSqlCommand(strSQL,conn)){try{if(cmdParms!=null){foreach(SqlParameterparmincmdParms){cmd.Parameters.Add(parm);}}conn.Open();objectobj=cmd.ExecuteScalar();cmd.Parameters.Clear();if((Object.Equals(obj,null))||(Object.Equals(obj,System.DBNull.Value))){returnnull;}else{returnobj;}}catch(System.Data.SqlClient.SqlExceptione){thrownewException(e.Message);}}}}///<summary>///执行查询语句,返回DataSet///</summary>///<paramname="SQLString">查询语句</param>///<returns>DataSet</returns>publicstaticDataSetQuery(stringstrSQL,paramsSqlParameter[]cmdParms){using(SqlConnectionconn=newSqlConnection(connstr)){SqlCommandcomm=newSqlCommand(strSQL,conn);using(SqlDataAdapterda=newSqlDataAdapter(comm)){DataSetds=newDataSet();try{if(cmdParms!=null){foreach(SqlParameterparmincmdParms){comm.Parameters.Add(parm);}}da.Fill(ds,"ds");comm.Parameters.Clear();}catch(System.Data.SqlClient.SqlExceptione){thrownewException(e.Message);}returnds;}}}#endregion}}
解决方案
解决方案二:
撸主先学习一下ado.net的五大对象,这个搞清楚了,回过头来再看上面的代码。
解决方案三:
解析什么?你是要一行行给你解析么?
解决方案四:
楼主有这个,你就可以操作数据库了。
解决方案五:
要翻译给你听么
解决方案六:
这不是已经连注释都有了么?不可能让人给你一行行解释吧。。。
解决方案七:
这不就是sqlhelper么,还用解释嘛
解决方案八:
加断点调试跑一边你就知道每一句都是干什么的了,不行的话就删掉某句,报错也会告诉你是干什么的
解决方案九:
引用楼主qq_28199389的回复:
usingSystem;usingSystem.Collections.Generic;usingSystem.Text;usingSystem.Data;usingSystem.Data.SqlClient;usingSystem.Configuration;namespaceBll{///<summary>///数据访问基类///</summary>publicabstractclassDbHelperSQL{publicDbHelperSQL(){}///<summary>///连接数据库对象///</summary>protectedstaticstringconnstr=ConfigurationManager.ConnectionStrings["connstring"].ConnectionString;#region公用方法///<summary>///参数化检查登录用户///</summary>///<paramname="strSql"></param>///<paramname="cmdParms"></param>///<returns></returns>publicstaticboolExists(stringstrSql,paramsSqlParameter[]cmdParms){objectobj=GetSingle(strSql,cmdParms);intcmdresult;//结果if((Object.Equals(obj,null))||(Object.Equals(obj,System.DBNull.Value))){cmdresult=0;}else{cmdresult=int.Parse(obj.ToString());}if(cmdresult==0){returnfalse;}else{returntrue;}}#endregion#region执行简单的SQL语句///<summary>///执行SQL语句,返回影响的记录数///</summary>///<paramname="strSql">SQL语句</param>///<returns>影响的记录数</returns>publicstaticintExecuteSql(stringstrSql){using(SqlConnectionconn=newSqlConnection(connstr)){using(SqlCommandcomm=newSqlCommand(strSql,conn)){try{conn.Open();introws=comm.ExecuteNonQuery();returnrows;}catch(System.Data.SqlClient.SqlExceptione){conn.Close();thrownewException(e.Message);}}}}///<summary>///执行一条计算查询结果语句,返回查询结果(object)。///</summary>///<paramname="strSql"></param>///<returns></returns>publicstaticobjectGetSingle(stringstrSql){using(SqlConnectionconn=newSqlConnection(connstr)){using(SqlCommandcomm=newSqlCommand(strSql,conn)){try{conn.Open();objectobj=comm.ExecuteScalar();if((Object.Equals(obj,null))||(Object.Equals(obj,System.DBNull.Value))){returnnull;}else{returnobj;}}catch(System.Data.SqlClient.SqlExceptione){conn.Close();thrownewException(e.Message);}}}}///<summary>///执行连接式查询语句,返回SqlDataReader///</summary>///<paramname="strSql"></param>///<returns></returns>publicstaticSqlDataReaderExecuteReader(stringstrSql){SqlConnectionconn=newSqlConnection(connstr);SqlCommandcomm=newSqlCommand(strSql,conn);try{conn.Open();SqlDataReadermyReader=comm.ExecuteReader();returnmyReader;}catch(System.Data.SqlClient.SqlExceptione){thrownewException(e.Message);}}///<summary>///执行非连接式查询语句,返回DataSet///</summary>///<paramname="strSql"></param>///<returns></returns>publicstaticDataSetQuery(stringstrSql){using(SqlConnectionconn=newSqlConnection(connstr)){DataSetds=newDataSet();try{conn.Open();SqlDataAdaptercmd=newSqlDataAdapter(strSql,conn);cmd.Fill(ds,"ds");}catch(System.Data.SqlClient.SqlExceptione){thrownewException(e.Message);}returnds;}}#endregion#region执行带参数的SQL语句///<summary>///执行SQL语句,返回影响的记录数///</summary>///<paramname="strSQL">SQL语句</param>///<paramname="cmdParms"></param>///<returns>影响的记录数</returns>publicstaticintExecuteSql(stringstrSQL,paramsSqlParameter[]cmdParms){using(SqlConnectionconn=newSqlConnection(connstr)){using(SqlCommandcomm=newSqlCommand()){try{PrepareCommand(comm,conn,strSQL,cmdParms);introws=comm.ExecuteNonQuery();comm.Parameters.Clear();returnrows;}catch(System.Data.SqlClient.SqlExceptione){thrownewException(e.Message);}}}}///<summary>///SQL语句的参数化赋值///</summary>///<paramname="comm">SqlCommand对象</param>///<paramname="conn">SqlConnection对象</param>///<paramname="cmdText">Sql语句</param>///<paramname="cmdParms">SQL参数</param>publicstaticvoidPrepareCommand(SqlCommandcomm,SqlConnectionconn,stringcmdText,SqlParameter[]cmdParms){if(conn.State!=ConnectionState.Open){conn.Open();}comm.Connection=conn;comm.CommandText=cmdText;comm.CommandType=CommandType.Text;if(cmdParms!=null){foreach(SqlParameterparmincmdParms){comm.Parameters.Add(parm);}}}///<summary>///执行一条计算查询结果语句,返回查询结果(object)。///</summary>///<paramname="strSQL"></param>///<paramname="cmdParms"></param>///<returns></returns>publicstaticobjectGetSingle(stringstrSQL,paramsSqlParameter[]cmdParms){using(SqlConnectionconn=newSqlConnection(connstr)){using(SqlCommandcmd=newSqlCommand(strSQL,conn)){try{if(cmdParms!=null){foreach(SqlParameterparmincmdParms){cmd.Parameters.Add(parm);}}conn.Open();objectobj=cmd.ExecuteScalar();cmd.Parameters.Clear();if((Object.Equals(obj,null))||(Object.Equals(obj,System.DBNull.Value))){returnnull;}else{returnobj;}}catch(System.Data.SqlClient.SqlExceptione){thrownewException(e.Message);}}}}///<summary>///执行查询语句,返回DataSet///</summary>///<paramname="SQLString">查询语句</param>///<returns>DataSet</returns>publicstaticDataSetQuery(stringstrSQL,paramsSqlParameter[]cmdParms){using(SqlConnectionconn=newSqlConnection(connstr)){SqlCommandcomm=newSqlCommand(strSQL,conn);using(SqlDataAdapterda=newSqlDataAdapter(comm)){DataSetds=newDataSet();try{if(cmdParms!=null){foreach(SqlParameterparmincmdParms){comm.Parameters.Add(parm);}}da.Fill(ds,"ds");comm.Parameters.Clear();}catch(System.Data.SqlClient.SqlExceptione){thrownewException(e.Message);}returnds;}}}#endregion}}
哪句不明白?,可以加我qq:1658026873啊