操作类:
using System;
using System.Data;
using System.Text.RegularExpressions;
using System.Xml;
using System.IO;
using System.Collections;
using System.Data.SQLite;
using System.Configuration;//添加.net引用
namespace Tools.Common
{
/// <summary>
/// 对SQLite操作的类
/// 引用:System.Data.SQLite.dll【版本:3.6.23.1(原始文件名:SQlite3.DLL)】
/// </summary>
public class SQLiteHelper
{
/// <summary>
/// 所有成员函数都是静态的,构造函数定义为私有
/// </summary>
private SQLiteHelper()
{
}
/// <summary>
/// 连接字符串
/// </summary>
public static string ConnectionString
{//"Data Source=Test.db3;Pooling=true;FailIfMissing=false";
get
{
////(AppSettings节点下的"SQLiteConnectionString")
string text = ConfigurationManager.AppSettings["SQLiteConnectionString"];
string str2 = ConfigurationManager.AppSettings["IsEncrypt"];
if (str2 == "true")
{
text = DesEncrypt.Decrypt(text);
}
return text;
}
}
private static SQLiteConnection _Conn = null;