STSdb数据库的实现使用类

STSdb 3.5是一个开源的key-value存储形式的数据库，它是用微软.net框架C#语言编写的。STSdb 3.5尤其使用于紧急任务或实时系统，如：股市交易，电子通信，实验室数据等，它的主要功能是能够处理大量数据流。

下面用C#对stsdb3.5进行简单封装，使之可以实现数据的简单CURD功能。

需要用到的依赖包：

stsdb3.5 http://stssoft.com/downloads/

Newtonsoft.JSON https://www.newtonsoft.com/json

先实现一个数据保存类对象, 该对象可以有判断数据是否超时的功能，在必要的时候可以用到:

/// <summary>
    /// STSdb3的数据对象
    /// </summary>
    /// <typeparam name="T"></typeparam>
    class Stsdb3Data<T>
    {
        /// <summary>
        /// 唯一标识，不能为空
        /// </summary>
        public string Key { get; set; }
        /// <summary>
        /// 数据值
        /// </summary>
        public T Value { get; set; }

        private DateTime _dtc = DateTime.Now;
        /// <summary>
        /// 构造时间
        /// </summary>
        public DateTime dtc { 
            get{return _dtc;} 
            set{_dtc =value;}
        }
        
        private int _expiry = 0;
        /// <summary>
        /// 超时时间(秒), 默认0永不超时
        /// </summary>
        public int expiry{
            get {return _expiry;}
            set {_expiry = value;}
        }

        /// <summary>
        /// 构造函数
        /// </summary>
        public Stsdb3Data()
        {

        }
        /// <summary>
        /// 构造函数,提供默认值
        /// </summary>
        /// <param name="Value"></param>
        public Stsdb3Data(T Value)
        {
            this.Value = Value;
        }

        /// <summary>
        /// 判断是否已经超时
        /// </summary>
        /// <returns></returns>
        public bool IsExpired()
        {
            if ( this.expiry<=0 )
            {
                return false;
            }
            return (DateTime.Now - this.dtc).Seconds > this.expiry;
        }
    }

　　

操作服务类Service：

/// <summary>
    /// STSdb3本地NoSQL数据库实现类
    /// <para>author: lcs 1125271180@qq.com</para>
    /// </summary>
    public class Stsdb3Service
    {
        public static string dbpath { get; set; }

        public Stsdb3Service()
        {
            if (string.IsNullOrEmpty(dbpath))
            {
                dbpath = Environment.GetFolderPath(Environment.SpecialFolder.CommonApplicationData) + @"vs2008stsdb3.dat";
            }
        }

        /// <summary>
        /// 保存数据对象
        /// </summary>
        /// <typeparam name="T">数据对象包含的数据</typeparam>
        /// <param name="key"></param>
        /// <param name="data">数据对象</param>
        /// <param name="tabname">保存表名</param>
        /// <param name="expiry">超时时长(秒)</param>
        public void Put<T>(string key, T t, string tabname, int expiry)
        {
            using (StorageEngine engine = StorageEngine.FromFile(dbpath))
            {
                var locator = new Locator(tabname);
                var table = engine.Scheme.CreateOrOpenXTable<string, string>(locator);
                var data = new Stsdb3Data<T>() { Key=key,Value=t,expiry=expiry};
                table[key] = JsonConvert.SerializeObject(data);
                table.Commit();
                engine.Scheme.Commit();
                table.Close();
                engine.Dispose();
            }
        }
        /// <summary>
        /// 保存数据对象
        /// </summary>
        /// <typeparam name="T">数据对象包含的数据</typeparam>
        /// <param name="key"></param>
        /// <param name="t">数据对象</param>
        /// <param name="tabname">保存表名</param>
        public void Put<T>(string key, T t, string tabname)
        {
            Put<T>(key, t, tabname, 0);
        }

        /// <summary>
        /// 获取数据
        /// </summary>
        /// <typeparam name="T"></typeparam>
        /// <param name="key"></param>
        /// <param name="tabname"></param>
        /// <returns></returns>
        public T Get<T>(string key, string tabname)
        {
            string json = string.Empty;
            T rest = default(T);
            using (StorageEngine engine = StorageEngine.FromFile(dbpath))
            {
                var locator = new Locator(tabname);
                var table = engine.Scheme.CreateOrOpenXTable<string, string>(locator);
                try
                {
                    var item = table.FirstOrDefault(x => x.Key == key);
                    json = item.Record != null ? item.Record : json;
                    var data = JsonConvert.DeserializeObject<Stsdb3Data<T>>(json);
                    if (data.IsExpired())
                    {
                        Delete(key, tabname); //删除无效的历史数据
                    }
                    else
                    {
                        rest = data.Value;
                    }
                }
                catch
                {
                    //
                }
                table.Close();
                engine.Dispose();
            }

            return rest;
        }

        /// <summary>
        /// 删除数据
        /// </summary>
        /// <param name="key"></param>
        /// <param name="tabname"></param>
        public void Delete(string key, string tabname)
        {
            using (StorageEngine engine = StorageEngine.FromFile(dbpath))
            {
                var locator = new Locator(tabname);
                var table = engine.Scheme.CreateOrOpenXTable<string, string>(locator);
                if (table != null)
                {
                    table.Delete(key);
                    table.Commit();
                    table.Close();
                }
                engine.Dispose();
            }
        }
    }

　　

在以上两个类都实现后，就可以进行测试了.

测试字符串代码如下：

// 初始化
            Stsdb3Service service = new Stsdb3Service();
            // 保存字符串
            string key = "vs2008:k001";
            string val = "我的数据 vs2008";
            string tabname = "vs2008";
            service.Put<string>(key, val, tabname);
            // 读取保存的字符串
            string rest = service.Get<string>(key, tabname);
            MessageBox.Show("" + rest);


            //Delete
            service.Delete(key, tabname);
            
            //再次读取
            rest = service.Get<string>(key, tabname);

            if (rest != null)
            {
                MessageBox.Show("" + rest);
            }
            else
            {
                MessageBox.Show("not any value");
            }

　　

测试自定义对象：

Stsdb3Service service = new Stsdb3Service();
            //测试对象
            string bar = "6912345";
            Book book = new Book() { bar = bar, name = "书本名", dtc = DateTime.Now };
            string bookTabname = "books";
            //保存对象
            service.Put<Book>(book.bar, book, bookTabname);
            // 读取对象
            Book rest = service.Get<Book>(bar, bookTabname);
            if (rest == null)
            {
                MessageBox.Show("rest: no book ...");
            }
            else
            {
                MessageBox.Show("rest: book: " + JsonConvert.SerializeObject(rest));
            }

　　

 补充Book类对象:

public class Book
{
    public string bar { get; set; }
    public string name { get; set; }
    public DateTime dtc { get; set; }
}