SQLiteApplication/DB/DatabaseHelper.cs

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

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

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Data.SQLite;
using NetQuickJamesFrame.Log;
using System.Windows.Forms;
using System.Data;
using System.Data.SqlClient;

namespace SQLiteApplication.DB
{
    class DatabaseHelper
    {
        LogHelper LOGGER = new LogHelper();

        /// <summary>
        /// create DB
        /// </summary>
        /// <returns></returns>
        public int CreateDB(string DBName)
        {
            try
            {
                SQLiteConnection.CreateFile(DBName);
                return 0;
            }
            catch (Exception ex)
            {
                LOGGER.writeLog(LogHelper.LOG_LEVEL.ERROR, ex.Message);
                throw new Exception("create " + DBName + " failed", ex);
            }
        }

        /// <summary>
        /// create Table
        /// </summary>
        /// <param name="tableName"></param>
        /// <param name="col_Type"></param>
        /// <returns></returns>
        public int createTable(string tableName, Dictionary<string, string> col_Type)
        {
            string dbPath = Application.StartupPath + "\\" + Conf.dbDirect + "\\" + Conf.dbName;

            int result = -1;
            SQLiteConnection conn = new SQLiteConnection("data source=" + dbPath);
            try
            {
                if (conn.State != System.Data.ConnectionState.Open)
                {
                    conn.Open();
                    SQLiteCommand cmd = new SQLiteCommand();
                    cmd.Connection = conn;
                    string col_Type_Str = toTableCol(col_Type);
                    cmd.CommandText = " CREATE TABLE " + tableName + " ( " + col_Type_Str + " ) ";
                    return cmd.ExecuteNonQuery();
                }
            }
            catch (Exception ex)
            {