NHibernate1.2 执行多表查询

落日映苍穹つ 2024-02-17 14:12 42阅读 0赞

个人写法可能有点傻···在改进先贴出来！让大家找点思路····

目的：  
将两个表的内容综合到一个集合里，然后邦定到GridView 上  
解决方法：  
1.创建一个综合了两个实体类的一个新的实体类（这个实体类不用有hbm.xml 文件）  
2.将查询到的信息赋值给新实体类  
3.将实体类存放在 ArrayList 中  
4.GridView 直接邦定 ArrayList

\---------------------------------------------------------------------------------------------------------

![Image 1][]对应数据库表的两个实体类

using System;

namespace Entitys  
\{  
/// <summary>  
///  
///功能描述:  
///开发者:  
///建立时间:  
///修订描述:  
///进度描述:  
/// </summary>  
public class UserInfo  
\{  
private int m\_id;  
private string m\_TureName;  
private int m\_age;

public int id  
\{  
get \{ return m\_id; \}  
set \{ m\_id = value; \}  
\}

public string TureName  
\{  
get \{ return m\_TureName; \}  
set \{ m\_TureName = value; \}  
\}

public int age  
\{  
get \{ return m\_age; \}  
set \{ m\_age = value; \}  
\}

\}  
\}

using System;  
using System.Collections;  
using System.Data;

namespace Entitys  
\{  
/// <summary>  
///  
///功能描述:  
///开发者:  
///建立时间:  
///修订描述:  
///进度描述:  
/// </summary>  
public class login  
\{  
private int m\_id;  
private string m\_Uname;  
private string m\_Upwd;  
private DateTime m\_LastTime;

public int id  
\{  
get \{ return m\_id; \}  
set \{ m\_id = value; \}  
\}

public string Uname  
\{  
get \{ return m\_Uname; \}  
set \{ m\_Uname = value; \}  
\}

public string Upwd  
\{  
get \{ return m\_Upwd; \}  
set \{ m\_Upwd = value; \}  
\}

public DateTime LastTime  
\{  
get \{ return m\_LastTime; \}  
set \{ m\_LastTime = value; \}  
\}

\}  
\}

![Image 1][]//新构建的 实体类

using System;  
using System.Collections.Generic;  
using System.Text;  
using Entitys;

namespace CommonEntitys  
\{  
public class UserCollection  
\{  
public UserCollection(login l,UserInfo info)  
\{  
this.id = l.id;  
this.Uname = l.Uname;  
this.Upwd = l.Upwd;  
this.age = info.age;  
this.LastTime = l.LastTime;  
this.TureName = info.TureName;  
\}

private int m\_id;  
private string m\_TureName;  
private int m\_age;

private string m\_Uname;  
private string m\_Upwd;  
private DateTime m\_LastTime;

public int id  
\{  
get \{ return m\_id; \}  
set \{ m\_id = value; \}  
\}

public string TureName  
\{  
get \{ return m\_TureName; \}  
set \{ m\_TureName = value; \}  
\}

public int age  
\{  
get \{ return m\_age; \}  
set \{ m\_age = value; \}  
\}

public string Uname  
\{  
get \{ return m\_Uname; \}  
set \{ m\_Uname = value; \}  
\}

public string Upwd  
\{  
get \{ return m\_Upwd; \}  
set \{ m\_Upwd = value; \}  
\}

public DateTime LastTime  
\{  
get \{ return m\_LastTime; \}  
set \{ m\_LastTime = value; \}  
\}  
\}  
\}

![Image 1][]调用方法

using System;  
using System.Collections.Generic;  
using System.Collections;  
using System.Data;  
using NHibernate.Engine;  
using NHibernate;  
using NHibernate.Expression;  
using NHibernate.Cfg;

/// <summary>  
/// NHibernate执行 多表查询  
/// </summary>  
/// <returns></returns>  
public ArrayList CreateCriteriaTest3()  
\{  
IList list = null;  
ArrayList arr = new ArrayList();  
try  
\{  
string sql = "from login as a , UserInfo as b where a.id=b.id ";

session = cfg.BuildSessionFactory().OpenSession();  
IQuery query = session.CreateQuery(sql);  
list = query.List();

IEnumerator ie = list.GetEnumerator();  
while (ie.MoveNext())  
\{  
object\[\] objs = (object\[\])ie.Current;  
login l = (login)objs\[0\];  
UserInfo info = (UserInfo)objs\[1\];  
UserCollection collection = new UserCollection(l, info);  
arr.Add(collection);  
\}  
\}  
catch (Exception ex)  
\{  
this.m\_error = ex.Message;  
\}  
finally  
\{  
this.session.Close();  
\}  
return arr;  
\}

![Image 1][]展现层调用

protected void Button5\_Click(object sender, EventArgs e)  
\{  
ArrayList list = UserTools.CreateCriteriaTest3();  
this.GridView1.DataSource = list;  
this.GridView1.DataBind();  
\}

\---------------------------------------------------------------------------------------------------------

[Image 1]: