NetQuickJamesFrame/DBHelp/SQLite.cs

这里只显示每个文件的开头 60 行。登录后可以解锁完整代码。

微信扫码关注公众号，代码整理好后第一时间通知你。

using System;
using System.Collections.Generic;
using System.Data.SQLite;
using System.Linq;
using System.Text;

namespace NetQuickJamesFrame.DBHelp
{
    public class SQLite
    {

        private string dbPath;

        public SQLite(string dbPath)
        {
            this.dbPath = dbPath;
        }

        /// <summary>
        /// ExecuteNonQuery using for insert, update, delete
        /// </summary>
        /// <param name="sql"></param>
        /// <returns></returns>
        public int executeNonQuery(string sql)
        {
            int result = -1;
            SQLiteConnection conn = new SQLiteConnection("data source=" + dbPath);
            try
            {
                if (conn.State != System.Data.ConnectionState.Open)
                {
                    conn.Open();
                    SQLiteCommand cmd = new SQLiteCommand(sql, conn);
                    result = cmd.ExecuteNonQuery();
                    conn.Close();
                }
            }
            catch (Exception ex)
            {
                conn.Close();
                throw new Exception(ex.Message);
            }
            return result;
        }

        /// <summary>
        /// executeReader using for select
        /// </summary>
        /// <param name="sql"></param>
        /// <returns></returns>
        public List<string> executeReader(string sql)
        {
            List<string> result = new List<string>();
            SQLiteConnection conn = new SQLiteConnection("data source=" + dbPath);
            try
            {
                if (conn.State != System.Data.ConnectionState.Open)
                {
                    conn.Open();
                    SQLiteCommand cmd = new SQLiteCommand(sql, conn);