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; } } } }
}
