• .net db4o数据库初探


    第一次使用db4o数据库,感觉很好用。写了个demo。代码有点乱,看个思路吧。


    using System;
    using System.Collections.Generic;
    using System.Linq;
    using System.Text;
    using Db4objects.Db4o;
    namespace db4oTest
    {
        class db4oTest
        {
            /// <summary>
            /// 插入对象
            /// </summary>
            public void InsertObject()
            {
                IObjectContainer db = Db4oFactory.OpenFile("test.yap");
                var p = new Person("李四妹", SexTypeEnum.女,188);
                var s = new Student();
                s.Name = "张学";
                s.sex = SexTypeEnum.女;
                s.School = "第一中学";
                db.Store(p);
                db.Store(s);
                db.Close();
            }
            /// <summary>
            /// 查询对象
            /// </summary>
            public void QueryObject()
            {
                IObjectContainer db = Db4oFactory.OpenFile("test.yap");
                var personList = db.Query<Person>(o => o.sex == SexTypeEnum.女);
                foreach(var p in personList)
                {
                    if(p is Student)
                    {
                        Console.WriteLine(p.Name + "是个学生");
                    }
    
                    Console.WriteLine(string.Format("{0} {1} {2}", p.Name, p.sex.ToString(), p.height));
                }
                db.Close();
            }
            /// <summary>
            /// 修改值,没有专门的update语句,先查询出来 修改后直接Store提交
            /// </summary>
            public void ChangeValue()
            {
                IObjectContainer db = Db4oFactory.OpenFile("test.yap");
                var personList = db.Query<Person>(o => o.Name=="李四妹");
                foreach (var p in personList)
                {
                    p.Name = "李四妹修改";
                    db.Store(p);
                }
                db.Close();
            }
            /// <summary>
            /// 删除 有专门的delete语句,先查询出来然后delete
            /// </summary>
            public void DeleteObject()
            {
                IObjectContainer db = Db4oFactory.OpenFile("test.yap");
                var personList = db.Query<Person>(o => o.Name.IndexOf("")>=0);
                foreach (var p in personList)
                {
                    db.Delete(p);
                }
                db.Close();
            }
        }
        class Person
        {
            public string Name { get; set; }
            public SexTypeEnum sex { get; set; }
            public int height { get; set; }
            public Person()
            { }
            public Person(string name, SexTypeEnum sex, int height)
            {
                this.Name = name;
                this.sex = sex;
                this.height = height;
            }
        }
        class Student : Person
        {
            public Student()
            { }
            public string School { get; set; }
        }
        enum SexTypeEnum
        {
            男, 女
        }
    }
  • 相关阅读:
    mysql常用语句集锦
    PHP 面向对象
    PHP 数组
    PHP 语句 函数 字符串处理
    PHP 随笔
    mysql常用函数
    数据库 创建 查询 练习
    HTML JavaScript语法练习
    HTML JavaScript练习
    随机数生成的简单原理
  • 原文地址:https://www.cnblogs.com/wqh21/p/db4oDemo.html
Copyright © 2020-2023  润新知