DBHelper类.doc

下载文档 降价啦

2
0
约2.07万字
约 16页
2017-12-20 发布于河南
举报
版权申诉
保障服务

DBHelper类.doc

1、本文档共16页，可阅读全部内容。
2、原创力文档（book118）网站文档一经付费（服务费），不意味着购买了该文档的版权，仅供个人/单位学习、研究之用，不得用于商业用途，未经授权，严禁复制、发行、汇编、翻译或者网络传播等，侵权必究。
3、本站所有内容均由合作方或网友上传，本站不对文档的完整性、权威性及其观点立场正确性做任何保证或承诺！文档内容仅供研究参考，付费前请自行鉴别。如您付费，意味着您自己接受本站规则且自行承担风险，本站不退款、不进行额外附加服务；查看《如何避免下载的几个坑》。如果您已付费下载过本站文档，您可以点击这里二次下载。
4、如文档侵犯商业秘密、侵犯著作权、侵犯人身权等，请点击“版权申诉”（推荐），也可以打举报电话：400-050-0827(电话支持时间：9:00-18:30)。

DBHelper类

using?System;?? using?System.Collections.Generic;?? using?System.Linq;?? using?System.Text;?? using?System.Data.SqlClient;???? using?System.Collections;?? using?System.Data;?? using?System.Configuration;?? using?System.Web;?? ?? ?? public?sealed?class?SqlHelper?? {?? ?? ????public?static?string?connectionString?=?ConfigurationManager.ConnectionStrings[db_JXCconn].ConnectionString;?? ?? ????public?SqlHelper()?? ????{?? ????}?? ? ????#region?公用方法?? ????public?static?int?GetMaxID(string?FieldName,?string?TableName)?? ????{?? ????????string?strsql?=?select?max(?+?FieldName?+?)+1?from??+?TableName;?? ????????object?obj?=?SqlHelper.GetSingle(strsql);?? ????????if?(obj?==?null)?? ????????{?? ????????????return?1;?? ????????}?? ????????else?? ????????{?? ????????????return?int.Parse(obj.ToString());?? ????????}?? ????}?? ?? ????public?static?bool?Exists(string?strSql)?? ????{?? ????????object?obj?=?SqlHelper.GetSingle(strSql);?? ????????int?cmdresult;?? ????????if?((Object.Equals(obj,?null))?||?(Object.Equals(obj,?System.DBNull.Value)))?? ????????{?? ????????????cmdresult?=?0;?? ????????}?? ????????else?? ????????{?? ????????????cmdresult?=?int.Parse(obj.ToString());?? ????????}?? ????????if?(cmdresult?==?0)?? ????????{?? ????????????return?false;?? ????????}?? ????????else?? ????????{?? ????????????return?true;?? ????????}?? ????}?? ?? ????public?static?bool?Exists(string?strSql,?params?SqlParameter[]?cmdParms)?? ????{?? ????????object?obj?=?SqlHelper.GetSingle(strSql,?cmdParms);?? ????????int?cmdresult;?? ????????if?((Object.Equals(obj,?null))?||?(Object.Equals(obj,?System.DBNull.Value)))?? ????????{?? ????????????cmdresult?=?0;?? ????????}?? ????????else?? ????????{?? ????????????cmdresult?=?int.Parse(obj.ToString());?? ????????}?? ????????if?(cmdresult?==?0)?? ????????{?? ????????????return?false;?? ????????}?? ????????else?? ????????{?? ????????????return?true;?? ????????}?? ????}?? ????#endregion?? ? ????#region??执行简单SQL语句?? ????///?summary?? ????///?执行SQL语句，返回影响的记录数?