代码 /*
*作者:牛腩
*创建时间:-1-:43:14
*Email:164423073@
*说明:对SQLite数据库的增删查改操作的封装类
*/
usingSystem;
usingSystem.Collections.Generic;
usingSystem.Linq;
usingSystem.Text;
usingSystem.Data;
usingSystem.Data.SQLite;
usingSystem.Web.Configuration;
usingSystem.Web;
namespaceNiunan.Tg029.Hr.Utility
{
publicclassSQLiteHelper
{
privateSQLiteConnectionconn=null;
privateSQLiteCommandcmd=null;
privateSQLiteDataReadersdr=null;
publicSQLiteHelper()
{
//stringconnStr=WebConfigurationManager.ConnectionStrings["connStr"].ToString();
stringconnStr="DataSource="+HttpContext.Current.Server.MapPath("~/test/test.sqlite");
conn=newSQLiteConnection(connStr);
}
///<summary>创建Command对象
///
///</summary>
///<paramname="sql">SQL语句</param>
publicvoidCreateCommand(stringsql){
conn.Open();
cmd=newSQLiteCommand(sql,conn);
}
///<summary>添加参数
///
///</summary>
///<paramname="paramName">参数名称</param>
///<paramname="value">值</param>
publicvoidAddParameter(stringparamName,objectvalue){
cmd.Parameters.Add(newSQLiteParameter(paramName,value));
}
///<summary>执行不带参数的增删改SQL语句
///
///</summary>
///<paramname="cmdText">增删改SQL语句</param>
///<paramname="ct">命令类型</param>
///<returns></returns>
publicboolExecuteNonQuery()
{
intres;
try
{
res=cmd.ExecuteNonQuery();
if(res>0)
{
returntrue;
}
}
catch(Exceptionex)
{
throwex;
}
finally
{
if(conn.State==ConnectionState.Open)
{
conn.Close();
}
}
returnfalse;
}
///<summary>执行查询SQL语句
///
///</summary>
///<paramname="cmdText">查询SQL语句</param>
///<returns></returns>
publicDataTableExecuteQuery()
{
DataTabledt=newDataTable();
using(sdr=cmd.ExecuteReader(CommandBehavior.CloseConnection))
{
dt.Load(sdr);
}
returndt;
}
///<summary>返回查询SQL语句查询出的结果的第一行第一列的值
///
///</summary>
///<returns></returns>
publicstringExecuteScalar()
{
stringres="";
try
{
objectobj=cmd.ExecuteScalar();
if(obj!=null)
{
res=obj.ToString();
}
}
catch(Exceptionex)
{
throwex;
}
finally
{
if(conn.State==ConnectionState.Open)
{
conn.Close();
}
}
returnres;
}
}
}
使用示例看附件吧,蛮简单的一个封装,特此记录,以备不时之需!!!
附件下载:/download/sqlitetest.7z