using?System;
using?System.Collections.Generic;
using?System.Configuration;
using?System.Data;
using?System.Data.SqlClient;
using?System.Linq;
using?System.Text;
using?System.Threading.Tasks;

namespace?DBUtility
{
????public?static?class?SqlHelper
????{
????????private?static?readonly?string?connectionString?=?ConfigurationManager.AppSettings[“ConnectionString“];



????????///?

????????///?執(zhí)行SQL語句，返回影響的記錄數(shù)
????????///?

????????///?SQL語句
????????///?影響的記錄數(shù)
????????public?static?int?ExecuteSql（string?SQLString）
????????{
????????????using?（SqlConnection?connection?=?new?SqlConnection（connectionString））
????????????{
????????????????using?（SqlCommand?cmd?=?new?SqlCommand（SQLString?connection））
????????????????{
????????????????????try
????????????????????{
????????????????????????connection.Open（）;
????????????????????????int?rows?=?cmd.ExecuteNonQuery（）;
????????????????????????return?rows;
????????????????????}
????????????????????catch?（System.Data.SqlClient.SqlException?e）
????????????????????{
????????????????????????connection.Close（）;
????????????????????????throw?e;
????????????????????}
????????????????}
????????????}
????????}

????????///?

????????///?執(zhí)行查詢語句，返回DataSet
????????///?

????????///?查詢語句
????????///?DataSet
????????public?static?DataSet?Query（string?SQLString）
????????{
????????????using?（SqlConnection?connection?=?new?SqlConnection（connectionString））
????????????{
????????????????DataSet?ds?=?new?DataSet（）;
????????????????try
????????????????{
????????????????????connection.Open（）;
????????????????????SqlDataAdapter?command?=?new?SqlDataAdapter（SQLString?connection）;
????????????????????command.Fill（ds?“ds“）;
????????????????}
????????????????catch?（System.Data.SqlClient.SqlException?ex）
????????????????{
????????????????????throw?new?Exception（ex.Message）;
????????????????}
????????????????return?ds;
????????????}
????????}
????}
}

?屬性????????????大小?????日期????時間???名稱
-----------?---------??----------?-----??----
?????目錄???????????0??2018-07-06?16:07??IP電話的設(shè)計(jì)與實(shí)現(xiàn)\
?????文件?????1150852??2018-06-05?19:43??IP電話的設(shè)計(jì)與實(shí)現(xiàn)\IP電話的設(shè)計(jì)與實(shí)現(xiàn).doc
?????文件???????25834??2018-07-06?16:05??IP電話的設(shè)計(jì)與實(shí)現(xiàn)\外文文獻(xiàn).docx
?????文件???????17408??2018-07-06?16:06??IP電話的設(shè)計(jì)與實(shí)現(xiàn)\文獻(xiàn)綜述.doc
?????目錄???????????0??2018-06-18?19:53??IP電話的設(shè)計(jì)與實(shí)現(xiàn)\源代碼\
?????目錄???????????0??2018-06-18?19:53??IP電話的設(shè)計(jì)與實(shí)現(xiàn)\源代碼\.vs\
?????目錄???????????0??2018-06-18?19:53??IP電話的設(shè)計(jì)與實(shí)現(xiàn)\源代碼\.vs\VoiceChatProject\
?????目錄???????????0??2018-06-18?19:53??IP電話的設(shè)計(jì)與實(shí)現(xiàn)\源代碼\.vs\VoiceChatProject\v15\
?????文件??????226304??2018-06-04?16:49??IP電話的設(shè)計(jì)與實(shí)現(xiàn)\源代碼\.vs\VoiceChatProject\v15\.suo
?????目錄???????????0??2018-06-18?19:53??IP電話的設(shè)計(jì)與實(shí)現(xiàn)\源代碼\.vs\VoiceChatProject\v15\Server\
?????目錄???????????0??2018-06-18?19:53??IP電話的設(shè)計(jì)與實(shí)現(xiàn)\源代碼\.vs\VoiceChatProject\v15\Server\sqlite3\
?????文件???????????0??2018-02-26?16:28??IP電話的設(shè)計(jì)與實(shí)現(xiàn)\源代碼\.vs\VoiceChatProject\v15\Server\sqlite3\db.lock
?????文件?????3358720??2018-06-04?16:49??IP電話的設(shè)計(jì)與實(shí)現(xiàn)\源代碼\.vs\VoiceChatProject\v15\Server\sqlite3\storage.ide
?????文件???????32768??2018-06-04?15:11??IP電話的設(shè)計(jì)與實(shí)現(xiàn)\源代碼\.vs\VoiceChatProject\v15\Server\sqlite3\storage.ide-shm
?????文件??????626272??2018-06-04?15:11??IP電話的設(shè)計(jì)與實(shí)現(xiàn)\源代碼\.vs\VoiceChatProject\v15\Server\sqlite3\storage.ide-wal
?????文件??????180736??2018-04-01?12:32??IP電話的設(shè)計(jì)與實(shí)現(xiàn)\源代碼\.vs\VoiceChatProject\v15\_1.suo
?????目錄???????????0??2018-06-18?19:53??IP電話的設(shè)計(jì)與實(shí)現(xiàn)\源代碼\DBUtility\
?????目錄???????????0??2018-07-06?16:08??IP電話的設(shè)計(jì)與實(shí)現(xiàn)\源代碼\DBUtility\Connected?Services\
?????文件????????3179??2018-03-10?15:07??IP電話的設(shè)計(jì)與實(shí)現(xiàn)\源代碼\DBUtility\DBUtility.csproj
?????目錄???????????0??2018-06-18?19:53??IP電話的設(shè)計(jì)與實(shí)現(xiàn)\源代碼\DBUtility\Properties\
?????文件????????1356??2018-02-26?09:25??IP電話的設(shè)計(jì)與實(shí)現(xiàn)\源代碼\DBUtility\Properties\AssemblyInfo.cs
?????文件????????2169??2018-02-26?10:51??IP電話的設(shè)計(jì)與實(shí)現(xiàn)\源代碼\DBUtility\SqlHelper.cs
?????目錄???????????0??2018-06-18?19:53??IP電話的設(shè)計(jì)與實(shí)現(xiàn)\源代碼\DBUtility\bin\
?????目錄???????????0??2018-06-18?19:53??IP電話的設(shè)計(jì)與實(shí)現(xiàn)\源代碼\DBUtility\bin\Debug\
?????文件????????5120??2018-05-18?20:52??IP電話的設(shè)計(jì)與實(shí)現(xiàn)\源代碼\DBUtility\bin\Debug\DBUtility.dll
?????文件???????13824??2018-05-18?20:52??IP電話的設(shè)計(jì)與實(shí)現(xiàn)\源代碼\DBUtility\bin\Debug\DBUtility.pdb
?????文件??????178176??2005-03-18?16:23??IP電話的設(shè)計(jì)與實(shí)現(xiàn)\源代碼\DBUtility\bin\Debug\Microsoft.DirectX.DirectSound.dll
?????文件??????348085??2006-03-07?22:46??IP電話的設(shè)計(jì)與實(shí)現(xiàn)\源代碼\DBUtility\bin\Debug\Microsoft.DirectX.DirectSound.xml
?????文件??????223232??2005-03-18?16:23??IP電話的設(shè)計(jì)與實(shí)現(xiàn)\源代碼\DBUtility\bin\Debug\Microsoft.DirectX.dll
?????文件??????265390??2006-03-07?22:46??IP電話的設(shè)計(jì)與實(shí)現(xiàn)\源代碼\DBUtility\bin\Debug\Microsoft.DirectX.xml
?????目錄???????????0??2018-06-18?19:53??IP電話的設(shè)計(jì)與實(shí)現(xiàn)\源代碼\DBUtility\obj\
............此處省略663個文件信息