C#_SQLite操作类库

/**************************************
* 作用：SQLLite Server操作实现
* 作者：Nick.Yan
* 日期: 2009-03-29
* 网址：www.redglove.net
**************************************/

using System;
using System.Collections;
using System.Collections.Specialized;
using System.Data;
using System.Data.SQLite;//这个可以去网上下载
using System.Configuration;

public class SQLiteHelper
{
    //数据库连接字符串(web.config来配置)，可以动态更改SQLString支持多数据库.        
    public static string connectionString = "Data Source=" + 
               System.Web.HttpContext.Current.Server.MapPath(
                    ConfigurationManager.AppSettings["SQLString"]);

    public SQLiteHelper() { }

    #region 公用方法

    public static int GetMaxID(string FieldName, string TableName)
    {
        string strsql = "select max(" + FieldName + ")+1 from " + TableName;
        object obj = GetSingle(strsql);
        if (obj == null)

        {
            return 1;
        }
        else
        {
            return int.Parse(obj.ToString());
        }
    }

    public static bool Exists(string strSql)
    {
        object obj = GetSingle(strSql);
        int cmdresult;
        if ((Object.Equals(obj, null)) || (Object.Equals(obj, System.DBNull.Value)))
        {
            cmdresult = 0;
        }
        else
        {
            cmdresult = int.Parse(obj.ToString());
        }
        if (cmdresult == 0)
        {
            return false;
        }
        else
        {
            return true;
        }
    }