c# sqlite数据库的初始化,不在文件就新建文件,不存在表就新建表。存在就使用旧的,可以更新参数,不存在参数名称就新建。

   /// <summary>
        /// //初始化数据库
        /// </summary>
        public MySqlite(string sBaseName = "MyDatabase.sqlite")
        {
            m_dbConnection = new SQLiteConnection("Data Source=" + sBaseName + ";Version=3;");
            m_dbConnection.Open();
            try
            {
                string sql = "SELECT COUNT(*) FROM " + sTableName + "";
                SQLiteCommand command = new SQLiteCommand(sql, m_dbConnection);
                command.ExecuteScalar();
            }
            catch (Exception ex)
            {
                string sql = "create table " + sTableName + " (name varchar(20), value varchar(20))";
                SQLiteCommand command = new SQLiteCommand(sql, m_dbConnection);
                command.ExecuteNonQuery();
            }
        } 
        /// <summary>
        /// ///数据库sqlite连接
        /// </summary>
        SQLiteConnection m_dbConnection;
        /// <summary>
        /// ///表名
        /// </summary>
        string sTableName = "param";

     /// <summary>
        /// /保存数值
        /// </summary>
        /// <param name="name">名称</param>
        /// <param name="value">数值</param>
        /// <returns>返回错误信息</returns>
        public void Set(string name, string value)
        {
            string sql = string.Empty;
            sql = "delete from " + sTableName + " where name = '" + name + "'";
            SQLiteCommand command = new SQLiteCommand(sql, m_dbConnection);
            command.ExecuteNonQuery();

            sql = "insert into " + sTableName + " (name, value) values ('" + name + "', '" + value + "')";
            command = new SQLiteCommand(sql, m_dbConnection);
            command.ExecuteNonQuery();
        }
        /// <summary>
        /// //获取名称对应的数值
        /// </summary>
        /// <param name="name">名称</param>
        /// <returns>数值</returns>
        public string Get(string name)
        {
            string sql = "select * from " + sTableName + " where name = '" + name + "'";
            SQLiteCommand command = new SQLiteCommand(sql, m_dbConnection);
            SQLiteDataReader reader = command.ExecuteReader();
            while (reader.Read())
            {
                string value = reader["value"].ToString();
                return value;
            }
            return "";
        }


版权声明:本文为qq_32066515原创文章,遵循CC 4.0 BY-SA版权协议,转载请附上原文出处链接和本声明。