NHibernate1.2 执行sql 邦定GridView！！！！！！！！！！！！！

小咪咪 2024-02-17 14:12 43阅读 0赞

\-----------实体类（不是映射的自己封装的）---------------

using NHibernate.Engine;

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

//图方便我这里都写成了 string 类型了  
namespace CommonEntitys  
\{  
public class UserTest  
\{  
public UserTest()  
\{

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

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

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

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

public string 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 string LastTime  
\{  
get \{ return m\_LastTime; \}  
set \{ m\_LastTime = value; \}  
\}  
\}  
\}

\-----------方法--------------

using NHibernate.Engine;  
using NHibernate;  
using NHibernate.Expression;  
using NHibernate.Cfg;  
  
public class UserAccess  
\{  
public UserAccess()  
\{  
cfg.AddAssembly("Entitys");  
//session = cfg.BuildSessionFactory().OpenSession();  
\}

private NHibernate.Cfg.Configuration cfg = new NHibernate.Cfg.Configuration();  
private ISession session = null;  
private ITransaction tran = null;  
  
/// <summary>  
/// NHibernate 执行 sql  
/// </summary>  
/// <returns></returns>  
public ArrayList SqlCommand()  
\{  
ArrayList list = new ArrayList();  
ISessionFactoryImplementor imp = (ISessionFactoryImplementor)cfg.BuildSessionFactory();  
IDbConnection conn = imp.OpenConnection();  
IDbCommand cmd = imp.ConnectionProvider.GetConnection().CreateCommand();  
try  
\{  
cmd.Connection = conn;

/ /注意下面的 login 和 UserInfo 为映射文件  
 cmd.CommandText = "select \* from login a,userinfo b where a.id=b.id";  
IDataReader read = cmd.ExecuteReader();  
UserTest user;  
  
while (read.Read())  
\{

//这里为了省事我就不以一对一应了  
user = new UserTest();  
user.age = read.GetValue(0).ToString();  
user.id = read.GetValue(1).ToString();  
user.LastTime = read.GetValue(2).ToString();  
user.TureName = read.GetValue(3).ToString();  
user.Uname = read.GetValue(4).ToString();  
user.Upwd = read.GetValue(5).ToString();  
list.Add(user);  
\}  
\}  
catch (Exception ex)  
\{  
this.m\_error = ex.Message;  
\}  
finally  
\{  
imp.CloseConnection(conn);  
\}  
return list;  
\}

\------------展现层调用--------------------

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