SqliteHelper整理(转载)

转载于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;                     }                 }             }         }       
     }