轉載于http://www.cnblogs.com/Bytime/archive/2011/10/27/2226004.html

?

下面是全部代碼：

class SqliteHelper ??? { ? ? ?????? private string connStr = ""; ?? ????? public SqliteHelper(string dbName, bool isFullPath) ? ?????? { ?????????? ? if (isFullPath) ??? ?????? ? { ????????? ?????? connStr = @"Data Source=" + dbName + ";Initial Catalog=sqlite;Integrated Security=True;Max Pool Size=10"; ??????????? } ??????????? else ??????????? { ??????????????? connStr = @"Data Source=" + System.Environment.CurrentDirectory + "\\" + dbName + ";Initial Catalog=sqlite;Integrated Security=True;Max Pool Size=10";
???????? ? }
??????? }
??????? ///<summary> ??????? /// 功能: 創建數據庫，帶路徑 ??????? /// [2011-10-24 14:16 Bee]<para /> ???? ??? ///</summary> ??????? ///<param name="dbName"></param>??????? public void CreateDB(string dbName, bool isFullPath) ??????? { ??????????? if (isFullPath) ??????????? { ??????????????? if (!File.Exists(dbName)) ??????????????? { ??????????????????? SQLiteConnection.CreateFile(dbName); ??????????????? } ??????????? } ??????????? else ??????????? { ??????????????? if (!File.Exists(System.Environment.CurrentDirectory + "\\" + dbName)) ??????????????? { ??????????????????? SQLiteConnection.CreateFile(System.Environment.CurrentDirectory + "\\" + dbName); ??????????????? } ??????????? } ??????? }
??????? ///<summary> ??????? /// 功能: 執行sql，不返回 ??????? /// [2011-10-24 14:15 Bee]<para /> ??????? ///</summary> ??????? ///<param name="sqlStr">要執行的sql</param>??????? public void ExecuteSql(string sqlStr) ??????? { ??????????? using (DbConnection conn = new SQLiteConnection(connStr)) ??????????? { ??????????????? conn.Open(); ??????????????? DbCommand comm = conn.CreateCommand(); ??????????????? comm.CommandText = sqlStr; ??????????????? comm.CommandType = CommandType.Text; ??????????????? comm.ExecuteNonQuery(); ??????????? } ??????? }
??????? ///<summary> ??????? /// 功能: 執行sql語句數組 ??????? /// [2011-10-24 14:54 Bee]<para /> ??????? ///</summary> ??????? ///<param name="sqlStr"></param>??????? public void ExecuteSqlList(string[] sqlStr) ??????? { ??????????? using (DbConnection conn = new SQLiteConnection(connStr)) ??????????? { ??????????????? conn.Open(); ??????????????? DbCommand comm = conn.CreateCommand(); ??????????????? foreach (string item in sqlStr) ??????????????? { ??????????????????? comm.CommandText = item; ??????????????????? comm.CommandType = CommandType.Text; ??????????????????? comm.ExecuteNonQuery(); ??????????????? }
??????????? } ??????? }
??????? ///<summary> ??????? /// 功能: 執行sql返回deteset ??????? /// [2011-10-24 14:15 Bee]<para /> ??????? ///</summary> ??????? ///<param name="sqlStr"></param> ??????? ///<returns></returns>??????? public DataSet ExecDataSet(string sqlStr) ??????? { ??????????? using (SQLiteConnection conn = new SQLiteConnection(connStr)) ??????????? { ??????????????? conn.Open(); ??????????????? SQLiteCommand cmd = conn.CreateCommand(); ??????????????? cmd.CommandText = sqlStr; ??????????????? cmd.CommandType = CommandType.Text;
??????????????? SQLiteDataAdapter da = new SQLiteDataAdapter(cmd); ??????????????? DataSet ds = new DataSet(); ??????????????? da.Fill(ds);
??????????????? return ds; ??????????? } ??????? }
??????? ///<summary> ??????? /// 功能: 判斷表是否存在 ??????? /// [2011-10-24 14:14 Bee]<para /> ??????? ///</summary> ??????? ///<param name="tableName"></param> ??????? ///<returns>存在不存在</returns>??????? public bool IsTableExist(string tableName) ??????? { ??????????? using (SQLiteConnection connection = new SQLiteConnection(connStr)) ??????????? { ??????????????? connection.Open(); ??????????????? using (SQLiteCommand command = new SQLiteCommand(connection)) ??????????????? {
??????????????????? command.CommandText = "SELECT COUNT(*) FROM sqlite_master where type='table' and name='" + tableName + "'"; ??????????????????? int iaaa = Convert.ToInt32(command.ExecuteScalar()); ??????????????????? if (Convert.ToInt32(command.ExecuteScalar()) == 0) ??????????????????? { ??????????????????????? return false; ??????????????????? } ??????????????????? else ??????????????????? { ??????????????????????? return true; ??????????????????? } ??????????????? } ??????????? } ??????? } ?????
??? }

總結

以上是生活随笔為你收集整理的SqliteHelper整理(转载)的全部內容，希望文章能夠幫你解決所遇到的問題。

如果覺得生活随笔網站內容還不錯，歡迎將生活随笔推薦給好友。