Nhibernate学习之many-to-many篇

class="baidu_pl">

class="article_content clearfix">

class="htmledit_views">

学习目的:

通过进一步学习Nclass="tags" href="/tags/HIBERNATE.html" title=hibernate>hibernate基础知识，掌握用Nhiberate实现多对多的业务逻辑

开发环境+必要准备

开发环境: windows 2003,Visual studio .Net 2005,Sql server 2005 developer edition

前期准备: 学习上两篇单表操作和many-to-one篇

3．对上篇文章的部分解释

1)bag节点:用于定义System.Collection.IList类型的集合元素。

属性

用法

举例

name

映射的属性（必须）

name=”SalaryList”

table

映射的数据表(可选)table=”Salary”lazy延迟加载(可选)Lazy=true|falsecascade指示级联操作方式（可选）Cascade=allinverse关联由谁负责维护Inverse=”true”table>

当lazy=”true”，父类初始化的时候不会自动加载子类集合

Cascade为级联操作方式，包括：

<table cellspacing="0" cellpadding="3" border="1" style="width: 581px; height: 190px; background-color: rgb(192, 192, 192);">属性用法说明none默认值，不进行级联操作save-updatesave和update级联delete删除级联delete-orphan删除不相关的父对象的子对象allsave/update/delete级联all-delete-orphanall+delete-arphantable>

当inverse=”true”的时候代表由子类维护级联关系。这时候如果只往父类中添加子类，但不设定子类的父类，是不能保存子类的。

4．多对多业务模型

还是用户系统，1个用户职员隶属于多个部门，同时1个部门有多个不同的职员
用户和部门之间的数据关系图为:

5. 实现步骤:
1)User.cs

User.cs

using System;

using System.Collections.Generic;

using System.Text;

namespace Nclass="tags" href="/tags/HIBERNATE.html" title=hibernate>hibernateSample1

{

public class User

{

private int _id;

private class="tags" href="/tags/STRING.html" title=string>string _name;

private class="tags" href="/tags/STRING.html" title=string>string _pwd;

private System.Collections.IList _departmentsList;

/// <summary>

/// 编号

/// </summary>

public virtual int Id

{

get

{

return _id;

}

set

{

_id = value;

}

/// <summary>

/// 名称

/// </summary>

public virtual class="tags" href="/tags/STRING.html" title=string>string Name

{

get

{

return _name;

}

set

{

_name = value;

}

/// <summary>

/// 密码

/// </summary>

public virtual class="tags" href="/tags/STRING.html" title=string>string Pwd

{

get

{

return _pwd;

}

set

{

_pwd = value;

}

/// <summary>

/// 工资列表

/// </summary>

public System.Collections.IList DepartmentsList

{

get

{

return _departmentsList;

}

set

{

_departmentsList = value;

}

2)User.hbm.xml

User.hbm.xml

3) Departments.cs

Departments

4) Departments.hbm.xml

Departments.hbm.xml

5) 数据操作类

UserDepartmentFixure.cs

using System;

using System.Collections.Generic;

using System.Text;

using System.Collections;

using NHibernate;

using NHibernate.Cfg;

using NHibernate.Tool.hbm2ddl;

namespace Nclass="tags" href="/tags/HIBERNATE.html" title=hibernate>hibernateSample1

{

public class UserDepartmentFixure

{

private ISessionFactory _sessions;

public void Configure()

{

Configuration cfg = GetConfiguration();

_sessions = cfg.BuildSessionFactory();

}

Configuration GetConfiguration()

{

class="tags" href="/tags/STRING.html" title=string>string cfgPath = @"E:/my project/nclass="tags" href="/tags/HIBERNATE.html" title=hibernate>hibernate study/simle 1/NHibernateStudy1/Nclass="tags" href="/tags/HIBERNATE.html" title=hibernate>hibernateSample1/class="tags" href="/tags/HIBERNATE.html" title=hibernate>hibernate.cfg.xml";

Configuration cfg = new Configuration().Configure(cfgPath);

return cfg;

}

public void ExportTables()

{

Configuration cfg = GetConfiguration();

new SchemaExport(cfg).Create(true, true);

}

public User CreateUser(String name,class="tags" href="/tags/STRING.html" title=string>string pwd)

{

User u = new User();

u.Name = name;

u.Pwd = pwd;

u.DepartmentsList = new ArrayList();

ISession session = _sessions.OpenSession();

ITransaction tx = class="tags" href="/tags/NULL.html" title=null>null;

try

{

tx = session.BeginTransaction();

session.Save(u);

tx.Commit();

}

catch (HibernateException e)

{

if (tx != class="tags" href="/tags/NULL.html" title=null>null) tx.Rollback();

throw e;

}

finally

{

session.Close();

}

return u;

}

public Departments CreateDepartments(User u, class="tags" href="/tags/STRING.html" title=string>string name)

{

Departments item = new Departments();

item.Name=name;

u.DepartmentsList.Add(item);

item.UsersList.Add(u);

ISession session = _sessions.OpenSession();

ITransaction tx = class="tags" href="/tags/NULL.html" title=null>null;

try

{

tx = session.BeginTransaction();

session.Save(item);

tx.Commit();

}

catch (HibernateException e)

{

if (tx != class="tags" href="/tags/NULL.html" title=null>null) tx.Rollback();

throw e;

}

finally

{

session.Close();

}

return item;

}

public Departments GetDepartments(int depID)

{

ISession session = _sessions.OpenSession();

ITransaction tx = class="tags" href="/tags/NULL.html" title=null>null;

try

{

tx = session.BeginTransaction();

Departments item = (Departments)session.Load(typeof(Departments),

depID);

tx.Commit();

return item;

}

catch (HibernateException e)

{

if (tx != class="tags" href="/tags/NULL.html" title=null>null) tx.Rollback();

return class="tags" href="/tags/NULL.html" title=null>null;

}

finally

{

session.Close();

}

return class="tags" href="/tags/NULL.html" title=null>null;

}

public User GetUser(int uid)

{

ISession session = _sessions.OpenSession();

ITransaction tx = class="tags" href="/tags/NULL.html" title=null>null;

try

{

tx = session.BeginTransaction();

User item = (User)session.Load(typeof(User),

uid);

tx.Commit();

return item;

}

catch (HibernateException e)

{

if (tx != class="tags" href="/tags/NULL.html" title=null>null) tx.Rollback();

return class="tags" href="/tags/NULL.html" title=null>null;

}

finally

{

session.Close();

}

return class="tags" href="/tags/NULL.html" title=null>null;

}

public void Delete(int uid)

{

ISession session = _sessions.OpenSession();

ITransaction tx = class="tags" href="/tags/NULL.html" title=null>null;

try

{

tx = session.BeginTransaction();

Departments item = session.Load(typeof(Departments), uid) as Departments;

session.Delete(item);

tx.Commit();

}

catch (HibernateException e)

{

if (tx != class="tags" href="/tags/NULL.html" title=null>null) tx.Rollback();

throw e;

}

finally

{

session.Close();

}

6)单元测试类

UnitTest1.cs

using System;

using System.Text;

using System.Collections.Generic;

using Microsoft.VisualStudio.TestTools.UnitTesting;

using Nclass="tags" href="/tags/HIBERNATE.html" title=hibernate>hibernateSample1;

namespace TestProject1

{

/// <summary>

/// UnitTest1 的摘要说明

/// </summary>

[TestClass]

public class UnitTest1

{

public UnitTest1()

{

// TODO: 在此处添加构造函数逻辑

}

Nclass="tags" href="/tags/HIBERNATE.html" title=hibernate>hibernateSample1.UserDepartmentFixure usf = new UserDepartmentFixure();

其他测试属性

[TestMethod]

public void Test1()

{

usf.Configure();

usf.ExportTables();

User u = usf.CreateUser(Guid.NewGuid().ToString(), "ds");

Assert.IsTrue(u.Id>0);

Departments s = usf.CreateDepartments(u, "政治部");

Assert.IsTrue(s.DepID > 0);

Departments s1 = usf.CreateDepartments(u, "事业部");

Assert.IsTrue(s1.DepID > 0);

usf.Delete(s1.DepID);

s1 = usf.GetDepartments(s1.DepID);

Assert.IsNull(s1);

User u1 = usf.GetUser(1);

Assert.IsTrue(u1.DepartmentsList.Count>0);

}

到现在为止，终于更加体会到nclass="tags" href="/tags/HIBERNATE.html" title=hibernate>hibernate的强大了。继续努力，fight!
files: /Files/jillzhang/simple3.rar
上几篇文章:   Nclass="tags" href="/tags/HIBERNATE.html" title=hibernate>hibernate学习之起步篇-1
               Nclass="tags" href="/tags/HIBERNATE.html" title=hibernate>hibernate分析之华山论剑篇
               Nclass="tags" href="/tags/HIBERNATE.html" title=hibernate>hibernate学习起步之many-to-one篇