转载于

 

下面是全部代码：

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";             }         }         ///
         /// 功能: 创建数据库，带路径         /// [2011-10-24 14:16 Bee]
           

    ///         ///        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);                 }             }         }         ///
         /// 功能: 执行sql，不返回         /// [2011-10-24 14:15 Bee]
               ///
         ///要执行的sql        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();             }         }         ///
         /// 功能: 执行sql语句数组         /// [2011-10-24 14:54 Bee]
               ///
         ///        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();                 }             }         }         ///
         /// 功能: 执行sql返回deteset         /// [2011-10-24 14:15 Bee]
               ///
         ///         ///
             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;             }         }         ///
         /// 功能: 判断表是否存在         /// [2011-10-24 14:14 Bee]
               ///
         ///         ///
     
      存在不存在
             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;                     }                 }             }         }            }