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

namespace?ItcastCater.DAL
{
????class?SqliteHelper
????{
????????//從配置文件中獲取數(shù)據(jù)庫連接字符串
????????private?static?readonly?string?strSqliteConn?=?ConfigurationManager.ConnectionStrings[“SQLiteConn“].ConnectionString;
????????///?

????????///?由用戶指定sql語句可以不傳SQLiteParameter的參數(shù)但是不能傳null
????????///?

????????///?
????????///?
????????///?
????????public?static?int?ExecuteNonQuery（string?strCmd?params?SQLiteParameter[]?ps）
????????{
????????????using?（SQLiteConnection?SqliteConn?=?new?SQLiteConnection（strSqliteConn））
????????????{
????????????????using?（SQLiteCommand?SqliteCmd?=?new?SQLiteCommand（strCmd?SqliteConn））
????????????????{
????????????????????SqliteCmd.Parameters.AddRange（ps）;
????????????????????SqliteConn.Open（）;
????????????????????return?SqliteCmd.ExecuteNonQuery（）;
????????????????}
????????????}
????????}

????????public?static?object?ExecuteScalar（string?strCmd?params?SQLiteParameter[]?ps）
????????{
????????????using?（SQLiteConnection?SqliteConn?=?new?SQLiteConnection（strSqliteConn））
????????????{
????????????????using?（SQLiteCommand?SqliteCmd?=?new?SQLiteCommand（strCmd?SqliteConn））
????????????????{
????????????????????SqliteCmd.Parameters.AddRange（ps）;
????????????????????SqliteConn.Open（）;
????????????????????return?SqliteCmd.ExecuteScalar（）;
????????????????}
????????????}
????????}

????????public?static?SQLiteDataReader?ExecuteReader（string?strCmd?params?SQLiteParameter[]?ps）
????????{
????????????SQLiteConnection?SqliteConn?=?null;
????????????try
????????????{
????????????????SqliteConn?=?new?SQLiteConnection（strSqliteConn）;
????????????????using?（SQLiteCommand?SqliteCmd?=?new?SQLiteCommand（strCmd?SqliteConn））
????????????????{
????????????????????SqliteCmd.Parameters.AddRange（ps）;
????????????????????SqliteConn.Open（）;
????????????????????return?SqliteCmd.ExecuteReader（CommandBehavior.CloseConnection）;
????????????????}
????????????}
????????????catch?（Exception?e）
????????????{
????????????????if?（SqliteConn?!=?null）
????????????????{
????????????????????SqliteConn.Dispose（）;

????????????????}

????????????????throw?e;
????????????}
????????????
????????}

????????public?static?DataTable?ExecuteTable（string?strCmd?params?SQLiteParameter[]?ps）
????????{
????????????using?（SQLiteDataAdapter?SqliteAdapter?=?new?SQLiteDataAdapter（strCmdstrSqliteConn））
????????????{
????????????????SqliteAdapter.SelectCommand.Parameters.AddRange（ps）;
????????????????DataTable?table?=?new?DataTable（）;
????????????????SqliteAdapter.Fill（table）;
????????????????return?table;
????????????}
????????}
????}

	public?enum?ExecuteMode{
		ExecuteNonQuery
		ExecuteScalar
		ExecuteReader

?屬性????????????大小?????日期????時間???名稱
-----------?---------??----------?-----??----
?????目錄???????????0??2017-09-18?11:22??sqlite相關文件\
?????目錄???????????0??2017-09-18?11:21??sqlite相關文件\SQLite.shell.dll4cs.manage\
?????文件?????8610642??2017-09-18?11:14??sqlite相關文件\SQLite.shell.dll4cs.manage\sqlite-netFx35-setup-bundle-x64-2008-1.0.105.2.exe
?????文件?????7805153??2017-09-18?11:12??sqlite相關文件\SQLite.shell.dll4cs.manage\sqlite-netFx35-setup-bundle-x86-2008-1.0.105.2.exe
?????文件????13158087??2014-04-03?17:49??sqlite相關文件\SQLite.shell.dll4cs.manage\sqlite-netFx40-setup-bundle-x86-2010-1.0.92.0.exe
?????文件??????536064??2014-03-27?02:13??sqlite相關文件\SQLite.shell.dll4cs.manage\sqlite3.exe
?????文件?????5527942??2014-04-03?17:50??sqlite相關文件\SQLite.shell.dll4cs.manage\sqlitestudio-2.1.4.exe
?????文件????????3081??2014-04-27?15:03??sqlite相關文件\SQLiteHelper.cs
?????文件??????847872??2014-04-03?17:48??sqlite相關文件\System.Data.SQLite.dll
?????文件????31850803??2014-04-03?17:50??sqlite相關文件\《SQLite權威指南（第二版）》.（Grant?Allen等）.[PDF]&ckook.pdf