namespace?Smart.DBUtility?{
????using?System;
????using?System.Collections.Generic;
????using?System.Collections;
????using?System.Text;
????using?System.Data;
????using?System.Data.OleDb;
????using?System.Configuration;

????public?abstract?class?AccessHelper?{
????????///?

????????///?數(shù)據(jù)庫連接字符串（web.config來配置）ConnectionStrings
????????///?連接字符串示例格式：Provider=Microsoft.Jet.Oledb.4.0;Data?Source=|DataDirectory|db1.mdb
????????///?

????????public?static?string?connectionString?=?ConfigurationManager.AppSettings[“ConnectionStrings“];

????????#region?公用方法
????????///?

????????///?判斷是否存在某表的某個字段
????????///?

????????///?表名稱
????????///?列名稱
????????///?是否存在
????????public?static?bool?ColumnExists（string?tableName?string?columnName）?{
????????????string?sql?=?“select?count（1）?from?syscolumns?where?[id]=object_id（‘“?+?tableName?+?“‘）?and?[name]=‘“?+?columnName?+?“‘“;
????????????object?res?=?GetSingle（sql）;
????????????if?（res?==?null）?{
????????????????return?false;
????????????}
????????????return?Convert.ToInt32（res）?>?0;
????????}
????????public?static?int?GetMaxID（string?FieldName?string?TableName）?{
????????????string?strsql?=?“select?max（“?+?FieldName?+?“）+1?from?“?+?TableName;
????????????object?obj?=?GetSingle（strsql）;
????????????if?（obj?==?null）?{
????????????????return?1;
????????????}?else?{
????????????????return?int.Parse（obj.ToString（））;
????????????}
????????}
????????public?static?bool?Exists（string?strSql）?{
????????????object?obj?=?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?TabExists（string?TableName）?{
????????????string?strsql?=?“select?count（*）?from?sysobjects?where?id?=?object_id（N‘[“?+?TableName?+?“]‘）?and?objectPROPERTY（id?N‘IsUserTable‘）?=?1“;
????????????//string?strsql?=?“SELECT?count（*）?FROM?sys.objects?WHERE?object_id?=?object_ID（N‘[dbo].[“?+?TableName?+?“]‘）?AND?type?in?（N‘U‘）“;
????????????object?obj?=?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?boo

?屬性????????????大小?????日期????時間???名稱
-----------?---------??----------?-----??----
?????目錄???????????0??2016-04-10?13:00??SmartSpider-master\
?????文件??????????33??2016-04-10?13:00??SmartSpider-master\.gitignore
?????文件?????????602??2016-04-10?13:00??SmartSpider-master\MSBuild.bat
?????文件????????1361??2016-04-10?13:00??SmartSpider-master\README.md
?????目錄???????????0??2016-04-10?13:00??SmartSpider-master\SmartDBUtility\
?????文件???????29693??2016-04-10?13:00??SmartSpider-master\SmartDBUtility\AccessHelper.cs
?????文件????????3850??2016-04-10?13:00??SmartSpider-master\SmartDBUtility\Jsonhelper.cs
?????文件?????????175??2016-04-10?13:00??SmartSpider-master\SmartDBUtility\MySqlHelper.cs
?????文件???????70972??2016-04-10?13:00??SmartSpider-master\SmartDBUtility\OracleHelper.cs
?????目錄???????????0??2016-04-10?13:00??SmartSpider-master\SmartDBUtility\Properties\
?????文件????????1386??2016-04-10?13:00??SmartSpider-master\SmartDBUtility\Properties\AssemblyInfo.cs
?????文件????????3194??2016-04-10?13:00??SmartSpider-master\SmartDBUtility\SmartDBUtility.csproj
?????文件???????29425??2016-04-10?13:00??SmartSpider-master\SmartDBUtility\SqlServerHelper.cs
?????文件????????4079??2016-04-10?13:00??SmartSpider-master\SmartDBUtility\TreeJsonhelper.cs
?????目錄???????????0??2016-04-10?13:00??SmartSpider-master\SmartDBUtility\bin\
?????目錄???????????0??2016-04-10?13:00??SmartSpider-master\SmartDBUtility\bin\Debug\
?????文件??????701816??2016-04-10?13:00??SmartSpider-master\SmartDBUtility\bin\Debug\System.Web.Extensions.dll
?????目錄???????????0??2016-04-10?13:00??SmartSpider-master\SmartSecurity\
?????文件????????6151??2016-04-10?13:00??SmartSpider-master\SmartSecurity\Encrypter.cs
?????文件????????1538??2016-04-10?13:00??SmartSpider-master\SmartSecurity\MD5.cs
?????目錄???????????0??2016-04-10?13:00??SmartSpider-master\SmartSecurity\Properties\
?????文件????????1382??2016-04-10?13:00??SmartSpider-master\SmartSecurity\Properties\AssemblyInfo.cs
?????文件????????2319??2016-04-10?13:00??SmartSpider-master\SmartSecurity\SmartSecurity.csproj
?????目錄???????????0??2016-04-10?13:00??SmartSpider-master\SmartSpider-V2.0\
?????目錄???????????0??2016-04-10?13:00??SmartSpider-master\SmartSpider-V2.0\Document\
?????文件?????????201??2016-04-10?13:00??SmartSpider-master\SmartSpider-V2.0\Document\readme.txt
?????目錄???????????0??2016-04-10?13:00??SmartSpider-master\SmartSpider-V2.0\Document\設(shè)計草圖\
?????文件??????196753??2016-04-10?13:00??SmartSpider-master\SmartSpider-V2.0\Document\設(shè)計草圖\001.jpg
?????文件??????198566??2016-04-10?13:00??SmartSpider-master\SmartSpider-V2.0\Document\設(shè)計草圖\002.jpg
?????文件??????250417??2016-04-10?13:00??SmartSpider-master\SmartSpider-V2.0\Document\設(shè)計草圖\003.jpg
?????文件??????278291??2016-04-10?13:00??SmartSpider-master\SmartSpider-V2.0\Document\設(shè)計草圖\004.jpg
............此處省略188個文件信息