blogjava's web log

blogjava's web log
...

Nhibernate例[导入]

// vo


/**/ ///  create table tabletest(id int,name varchar(20),
     ///  age int,sex varchar(20));
     public   class  Tabletest
     {
         private   int  id;
         private   string  name;
         private   int  age;
         private   string  sex;


//前台
private void button1_Click(object sender, System.EventArgs e)
        {
            //添家字段
            VO.Tabletest vo=new VO.Tabletest();
            vo.Id=int.Parse (this.textBox1.Text );
            vo.Name =this.textBox2.Text ;
            vo.Age =int.Parse(this.textBox3.Text );
            vo.Sex =this.textBox4.Text ;
            BLL.TableTestBll bll=new BLL.TableTestBll();
            bll.addTableTest(vo);
            this.dataGrid1 .DataSource=bll.getTableTest();
        }

        private void button2_Click(object sender, System.EventArgs e)
        {
            //删除一条
            BLL.TableTestBll bll=new BLL.TableTestBll();
            string srt=this.dataGrid1[this.dataGrid1.CurrentRowIndex,0].ToString();
            bll.remove(int.Parse (srt));
            this.dataGrid1 .DataSource=bll.getTableTest();
        }

        private void button3_Click(object sender, System.EventArgs e)
        {
            //更新
            VO.Tabletest vo=new VO.Tabletest();
            vo.Id=int.Parse (this.textBox1.Text );
            vo.Name =this.textBox2.Text ;
            vo.Age =int.Parse(this.textBox3.Text );
            vo.Sex =this.textBox4.Text ;
            BLL.TableTestBll bll=new BLL.TableTestBll();
            bll.updataTable(vo);
            this.dataGrid1 .DataSource=bll.getTableTest();
        }

        private void button5_Click(object sender, System.EventArgs e)
        {
            //得到
            BLL.TableTestBll bll=new BLL.TableTestBll();
            this.dataGrid1.DataSource =bll.getTableTest();
        }




using System;
using NHibernate;
using System.Collections ;
using VO;

namespace BLL
{
    /// <summary>
    /// Class1 的摘要说明。
    /// </summary>
    public class TableTestBll
    {
        public TableTestBll()
        {
        }

        public NHibernate.ISession getSession()
        {
            NHibernate.Cfg.Configuration cfg=new NHibernate.Cfg.Configuration();
            cfg.Configure();
            NHibernate.ISessionFactory sess=cfg.BuildSessionFactory();
            NHibernate.ISession iss=sess.OpenSession();
            return iss;
        }
        public System.Collections.IList getTableTest()
        {
            NHibernate.ISession sess=this.getSession();
            IList list=sess.Find("from Tabletest t");
            return list;
        }
        public void addTableTest(VO.Tabletest vo)
        {
            NHibernate.ISession sess=this.getSession();
            sess.Save(vo,vo.Id);
            sess.Flush();
        }
        public void remove(int id)
        {
            NHibernate.ISession sess=this.getSession();
            sess.Delete ("from Tabletest t where t.Id="+id);
            sess.Flush();
        }
        public void updataTable(Tabletest t)
        {
            NHibernate.ISession sess=this.getSession();
            Tabletest tt=(Tabletest)sess.Load(t.GetType(),t.Id);
            tt.Name =t.Name ;
            tt.Age =t.Age ;
            tt.Sex =t.Sex ;
            sess.SaveOrUpdate(tt);
            sess.Flush();
        }
    }
}


配置文件

<?xml version="1.0" encoding="utf-8" ?>
<hibernate-configuration  xmlns="urn:nhibernate-configuration-2.0" >
    <session-factory name="NHibernate.Test">
        
        <property name="connection.provider">NHibernate.Connection.DriverConnectionProvider</property>
        <property name="connection.driver_class">NHibernate.Driver.SqlClientDriver</property>
        <property name="connection.connection_string">Server=.;initial catalog=student1;User Id=sa;Password=</property>
        <property name="show_sql">true</property>
        <property name="dialect">NHibernate.Dialect.MsSql2000Dialect</property>
        <property name="use_outer_join">true</property>
        
        <property name="query.substitutions">true 1, false 0, yes 1, no 0</property>
        <mapping file="personVO.hbm.xml" />
            
    </session-factory>
    
</hibernate-configuration>

表的配置文件
<?xml version="1.0" encoding="utf-8" ?>
<hibernate-mapping xmlns="urn:nhibernate-mapping-2.0">
    <class name="VO.Tabletest,VO" table="Test">
        <id name="Id" column="id">
            <generator class="native"/>
        </id>
        <property name="Name" column="name"/>
        <property name="Age" column="age"/>
        <property name="Sex" column="sex"/>
    </class>
</hibernate-mapping>

posted on 2006-05-28 14:54 record java and net 阅读(369) 评论(0)  编辑  收藏 所属分类: dot net相关


只有注册用户登录后才能发表评论。
网站导航:
 

导航

常用链接

留言簿(44)

新闻档案

2.动态语言

3.工具箱

9.文档教程

友情链接

搜索

最新评论