PhotonServer服务器端（二）

谁借莪１个温暖的怀抱￠ 2021-09-16 13:38 272阅读 0赞

**目录**

7.nhibernate程序包的引入（我上传的资源里面有此版本的nhibernate程序包）

8.nhibernate数据库连接配置

9.进行类和表的映射

10.创建会话session进行添加操作

11.利用NHibernate进行事务操作

12.创建NHibernateHelper管理会话工厂

13.利用NHibernate进行更新、删除、通过ID查询的操作

14.通过CreateCriteria进行复杂查询

15.多个查询条件的添加和得到查询的集合结果

--------------------

## 7.nhibernate程序包的引入（我上传的资源里面有此版本的nhibernate程序包） ##

![70][]

![70 1][]

## 8.nhibernate数据库连接配置 ##

![70 2][] ![70 3][]![70 4][]

<?xml version="1.0" encoding="utf-8" ?>
    <hibernate-configuration xmlns="urn:nhibernate-configuration-2.2">
      <session-factory>
        <property name="connection.provider">NHibernate.Connection.DriverConnectionProvider</property>
        <property name="dialect">NHibernate.Dialect.MsSqlCeDialect</property>
        <property name="connection.driver_class">NHibernate.Driver.MySqlDataDriver</property>
        <property name="connection.connection_string">Server=localhost;Database=my_schema;UserId=root;Password=root</property>
        <property name="show_sql">true</property>
      </session-factory>
    </hibernate-configuration>

## 9.进行类和表的映射 ##

新建两个文件夹Mappings，Model。在Mappings下面新建xml文件“User.hbm.xml”，并将其属性中的生成操作设为嵌入的资源。在Model文件夹下新建类User。

![70 5][]![70 6][]![70 7][]

namespace Lijiang.Model
    {
        class User
        {
            public virtual int Id { get; set; }
            public virtual string Username { get; set; }
            public virtual string Password { get; set; }
        }
    }

<?xml version="1.0" encoding="utf-8" ?>
    <hibernate-mapping xmlns="urn:nhibernate-mapping-2.2"
                       assembly="Lijiang"
                       namespace="Lijiang.Model">
    
      <class name="User" table="users">
        <id name="Id" column="id" type="Int32">
          <generator class="native" />
        </id>
        <property name="Username" column="username" type="String" />
        <property name="Password" column="password" type="String" />
      </class>
    
    </hibernate-mapping>

## 10.创建会话session进行添加操作 ##

![70 8][]=》![70 9][]

## 11.利用NHibernate进行事务操作  ##

using System;
    using NHibernate;
    using NHibernate.Cfg;
    using Lijiang.Model;
    
    namespace Lijiang
    {
        class Program
        {
            static void Main(string[] args)
            {
                var configuration = new Configuration();
                configuration.Configure();//解析hibernate.cfg.xml     
                configuration.AddAssembly("Lijiang");//解析映射文件 User.hbm.xml...
    
                ISessionFactory sessionFactory = null;
                ISession session = null;
                ITransaction transaction = null;
                try
                {
                    sessionFactory = configuration.BuildSessionFactory();
                    session = sessionFactory.OpenSession();//打开一个跟数据库的回话
    
                    transaction = session.BeginTransaction();//事务(在连续的几个操作中，只要有一个操作失败，则所有的操作都会失败！哪怕之前的几个操作是成功的)
                    User user1 = new User() { Username = "dfhsfahfgdfhrtadgds123", Password = "5475" };
                    User user2 = new User() { Username = "dfhsfahfgdfhrtadgds1234", Password = "5475" };
                    //下面这种方式是运行不成功的。虽然可以添加user1，但是user2的用户名和user1重复，所以user2会操作失败，所以全过程的操作是不会成功的
                    //User user1 = new User() { Username = "wwww", Password = "1212" };
                    //User user2 = new User() { Username = "wwww", Password = "1212" };
                    session.Save(user1);
                    session.Save(user2);
                    transaction.Commit();
                }
                catch(Exception e)
                {
                    Console.WriteLine(e);
                }finally
                {
                    if(transaction !=null)
                    {
                        transaction.Dispose();
                    }
                    if(session !=null)
                    {
                        session.Close();
                    }
                    if(sessionFactory !=null)
                    {
                        sessionFactory.Close();
                    }
                }  
                Console.ReadKey();
            }
        }
    }

![70 10][]=》![70 11][]

## 12.创建NHibernateHelper管理会话工厂 ##

![70 12][]

*  IUserManager.cs:

using Lijiang.Model;
    using System.Collections.Generic;
    
    namespace Lijiang.Manager
    {
        interface IUserManager
        {
            void Add(User user);
            void Update(User user);
            void Remove(User user);
            User GetById(int id);
            User GetByUsername(string username);
            ICollection<User> GetAllUsers();
        }
    }

*  UserManager.cs:

*  NHibernateHelper.cs:

using NHibernate;
    using NHibernate.Cfg;
    
    namespace Lijiang
    {
        class NHibernateHelper
        {
            private static ISessionFactory  _sessionFactory;
            private static ISessionFactory  SessionFactory
            {
                get
                {
                    if(_sessionFactory ==null)
                    {
                        var configuration = new Configuration();
                        configuration.Configure();//解析hibernate.cfg.xml     
                        configuration.AddAssembly("Lijiang");//解析映射文件 User.hbm.xml...
    
                        _sessionFactory = configuration.BuildSessionFactory();
                    }
                    return _sessionFactory;
                }
            }
            public static ISession OpenSession()
            {
                return SessionFactory.OpenSession(); 
            }
        }
    }

*   Program.cs:

using Lijiang.Model;
    using Lijiang.Manager;
    
    namespace Lijiang
    {
        class Program
        {
            static void Main(string[] args)
            {
                User user = new User() { Username = "eeee", Password = "3333" };
                IUserManager userManager = new UserManager();
                userManager.Add(user);
    
                Console.ReadKey();
            }
        }
    }

![70 13][] =》 ![70 14][]

## 13.利用NHibernate进行更新、删除、通过ID查询的操作 ##

using System;
    using System.Collections.Generic;
    using Lijiang.Model;
    using NHibernate;
    
    namespace Lijiang.Manager
    {
        class UserManager : IUserManager
        {
            public void Add(User user)
            {
                //ISession session = NHibernateHelper.OpenSession();
                //session.Save(user);
                //session.Close();如果使用下面的using，就不用写session.Close()来释放session了，因为using会自动释放。下面的嵌套是先释放transacion,再释放session。
                using(ISession session = NHibernateHelper.OpenSession())
                {
                    using (ITransaction transaction=session .BeginTransaction())
                    {
                        session.Save(user);
                        transaction.Commit();
                    }
                }
            }
    
            public ICollection<User> GetAllUsers()
            {
                throw new NotImplementedException();
            }
    
            public User GetById(int id)
            {
                using (ISession session = NHibernateHelper.OpenSession())
                {
                    using (ITransaction transaction = session.BeginTransaction())
                    {
                        User user = session.Get<User>(id);
                        transaction.Commit();
                        return user;
                    }
                }
            }
    
            public User GetByUsername(string username)
            {
                throw new NotImplementedException();
            }
    
            public void Remove(User user)
            {
                using (ISession session = NHibernateHelper.OpenSession())
                {
                    using (ITransaction transaction = session.BeginTransaction())
                    {
                        session.Delete(user);//根据主键来更新，所以需保证user里面主键有值
                        transaction.Commit();
                    }
                }
            }
    
            public void Update(User user)
            {
                using (ISession session = NHibernateHelper.OpenSession())
                {
                    using (ITransaction transaction = session.BeginTransaction())
                    {
                        session.Update(user);//根据主键来更新，所以需保证user里面主键有值
                        transaction.Commit();
                    }
                }
            }
        }
    }

using Lijiang.Model;
    using Lijiang.Manager;
    using System;
    
    namespace Lijiang
    {
        class Program
        {
            static void Main(string[] args)
            {
                User user1 = new User() { Username = "eeeeEEE", Password = "3333444" };
                User user2 = new User() { Id=5 };
    
                IUserManager userManager = new UserManager();
    
                userManager.Add(user1);
                userManager.Remove(user2);
    
                User user3 = userManager.GetById(2);
                Console.WriteLine(user3.Username);
                Console.WriteLine(user3.Password);
    
                Console.ReadKey();
            }
        }
    }

![70 15][]=>![70 16][]![70 17][]

## 14.通过CreateCriteria进行复杂查询 ##

UserManager:(记得引入命名空间 using NHibernate.Criterion;)

public User GetByUsername(string username)
            {
                using (ISession session = NHibernateHelper.OpenSession())
                {
                    User user = session.CreateCriteria(typeof(User)).Add(Restrictions.Eq("Username", username)).UniqueResult<User>();
                    return user;
                }
            }

using Lijiang.Model;
    using Lijiang.Manager;
    using System;
    
    namespace Lijiang
    {
        class Program
        {
            static void Main(string[] args)
            {
                IUserManager userManager = new UserManager();
                User user = userManager.GetByUsername("eeee");
                Console.WriteLine(user.Username);
                Console.WriteLine(user.Password);
                Console.ReadKey();
            }
        }
    }

![70 18][]=>![70 19][]

##  15.多个查询条件的添加和得到查询的集合结果 ##

*  查询所有记录

public ICollection<User> GetAllUsers()
            {
                using (ISession session = NHibernateHelper.OpenSession())
                {
                    IList<User> users = session.CreateCriteria(typeof(User)).List<User>();
                    return users;
                }
            }

using Lijiang.Model;
    using Lijiang.Manager;
    using System;
    
    namespace Lijiang
    {
        class Program
        {
            static void Main(string[] args)
            {
                IUserManager userManager = new UserManager();
                ICollection<User> users = userManager.GetAllUsers();
                foreach (User u in users)
                {
                    Console.WriteLine(u.Username + " " + u.Password);
                }
                Console.ReadKey();
            }
        }
    }

![70 20][]=》![70 21][]

*  验证用户名和密码是否输入正确

UserManager.cs：

public bool  VerifyUser(string username,string password)
            {
                using (ISession session = NHibernateHelper.OpenSession())
                {
                    User user = session.CreateCriteria(typeof(User)).Add(Restrictions.Eq("Username", username)).Add(Restrictions.Eq("Password", password)).UniqueResult<User>();
                    if (user == null)
                    {
                        return false;
                    }
                    return true;
                }
            }

using Lijiang.Manager;
    using System;
    
    namespace Lijiang
    {
        class Program
        {
            static void Main(string[] args)
            {
                IUserManager userManager = new UserManager();
                Console.WriteLine(userManager.VerifyUser("eeee", "3333"));//存在，返回true
                Console.WriteLine(userManager.VerifyUser("eeeem", "3333"));//不存在，返回false
                Console.ReadKey();
            }
        }
    }

![70 20][]=》![70 22][]

[70]: /images/20210725/db818c2487e6442dbc94dd18c46b9fb3.png
[70 1]: /images/20210725/8f051cb6bea540b18329f40d973e7a07.png
[70 2]: https://img-blog.csdn.net/20181001102523355?watermark/2/text/aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzQwMzIzMjU2/font/5a6L5L2T/fontsize/400/fill/I0JBQkFCMA==/dissolve/70
[70 3]: https://img-blog.csdn.net/20181001102610227?watermark/2/text/aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzQwMzIzMjU2/font/5a6L5L2T/fontsize/400/fill/I0JBQkFCMA==/dissolve/70
[70 4]: /images/20210725/7ed25ef750a3401b9867073e818548fd.png
[70 5]: https://img-blog.csdn.net/20181001103117822?watermark/2/text/aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzQwMzIzMjU2/font/5a6L5L2T/fontsize/400/fill/I0JBQkFCMA==/dissolve/70
[70 6]: https://img-blog.csdn.net/20181001103147461?watermark/2/text/aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzQwMzIzMjU2/font/5a6L5L2T/fontsize/400/fill/I0JBQkFCMA==/dissolve/70
[70 7]: /images/20210725/8e2a9f0b87354737b05ac1175ca4037c.png
[70 8]: https://img-blog.csdn.net/20181001105609206?watermark/2/text/aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzQwMzIzMjU2/font/5a6L5L2T/fontsize/400/fill/I0JBQkFCMA==/dissolve/70
[70 9]: /images/20210725/edf9f73f06364bbc9f0fc8bb2b67c41f.png
[70 10]: https://img-blog.csdn.net/20181001111228783?watermark/2/text/aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzQwMzIzMjU2/font/5a6L5L2T/fontsize/400/fill/I0JBQkFCMA==/dissolve/70
[70 11]: /images/20210725/feeb93f6517b4bb3aeb6b6a8dfadc26e.png
[70 12]: /images/20210725/a93ec50a424f4eba88956a38c10a71d9.png
[70 13]: https://img-blog.csdn.net/20181001150949944?watermark/2/text/aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzQwMzIzMjU2/font/5a6L5L2T/fontsize/400/fill/I0JBQkFCMA==/dissolve/70
[70 14]: /images/20210725/9cfdf0b319e2459a81738289d2fda014.png
[70 15]: https://img-blog.csdn.net/20181001154049811?watermark/2/text/aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzQwMzIzMjU2/font/5a6L5L2T/fontsize/400/fill/I0JBQkFCMA==/dissolve/70
[70 16]: https://img-blog.csdn.net/201810011541295?watermark/2/text/aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzQwMzIzMjU2/font/5a6L5L2T/fontsize/400/fill/I0JBQkFCMA==/dissolve/70
[70 17]: /images/20210725/9eb9f8e365264d23b0fc8aa254179f68.png
[70 18]: https://img-blog.csdn.net/20181001155829859?watermark/2/text/aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzQwMzIzMjU2/font/5a6L5L2T/fontsize/400/fill/I0JBQkFCMA==/dissolve/70
[70 19]: /images/20210725/a60644f3508f499f8496c62e1a3a8539.png
[70 20]: https://img-blog.csdn.net/20181001161114804?watermark/2/text/aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzQwMzIzMjU2/font/5a6L5L2T/fontsize/400/fill/I0JBQkFCMA==/dissolve/70
[70 21]: /images/20210725/a6b5e5ec77c54670b00dc2121bb7f927.png
[70 22]: /images/20210725/58995775adce4a43a8c81a84de2ca02d.png