CSQLite数据库访问封装类.doc

C# SQLite数据库 访问封装类 C# 异常处理（Catch Throw）IL分析在客户端配置文件configuration节点下，添加： [html] view plain copy 在CODE上查看代码片派生到我的代码片 connectionStrings add name=localdb connectionString=Data Source=config/local.db;Version=3;UseUTF16Encoding=True; providerName=System.Data.SQLite.SQLiteFactory/ /connectionStrings 其中【localdb】是本地SQLite数据库的名称，【config/local.db】是在当前程序运行目录下SQLite数据库位置 C# SQLite数据库 访问封装类代码： [csharp] view plain copy 在CODE上查看代码片派生到我的代码片 /// summary /// 本类为SQLite数据库帮助静态类,使用时只需直接调用即可,无需实例化 /// /summary public static class SQLiteHelper { // Application.StartupPath public static string LocalDbConnectionString = ConfigurationManager.ConnectionStrings[localdb].ConnectionString; #region ExecuteNonQuery /// summary /// 执行数据库操作(新增、更新或删除) /// /summary /// param name=connectionString连接字符串/param /// param name=cmdSqlCommand对象/param /// returns所受影响的行数/returns public static int ExecuteNonQuery(string connectionString, SQLiteCommand cmd) { int result = 0; if (connectionString == null || connectionString.Length == 0) throw new ArgumentNullException(connectionString); using (SQLiteConnection con = new SQLiteConnection(connectionString)) { SQLiteTransaction trans = null; PrepareCommand(cmd, con, ref trans, true, cmd.CommandType, cmd.CommandText); try { result = cmd.ExecuteNonQuery(); trans.Commit(); } catch (Exception ex) { trans.Rollback(); throw ex; } } return result; } /// summary /// 执行数据库操作(新增、更新或删除) /// /summary /// param name=connectionString连接字符串/param /// param name=commandText执行语句或存储过程名/param