Spring.Net+NHibenate+Asp.Net mvc +ExtJs 系列 3 ----数据访问层

IUserDao.cs


    using System.Collections;

using DirectCenter.Model;



namespace DirectCenter.IDAL

{

publicinterface IUserDao

{

User FindById(string userId);

void Delete(User user);

User Save(User user);

User SaveOrUpdate(User user);

}

}

UserDao.cs


    public User Save(User user) 

{

//通过一种方式获取Session

           Session session = SessionFactory.OpenSession();

session.Save(user);

}

UserDao.cs


    using System.Collections;



using Spring.Data.NHibernate.Support;



using DirectCenter.IDAL;

using DirectCenter.Model;



namespace DirectCenter.DAL

{

publicclass UserDao:HibernateDaoSupport,IUserDao

{

public User Save(User user) 

{

HibernateTemplate.Save(user);

return user;

}

public User SaveOrUpdate(User user)

{

HibernateTemplate.SaveOrUpdate(user);

return user;

}

publicvoid Delete(User user) 

{

HibernateTemplate.Delete(user);

}

public User  FindById(string userId) 

{

return  HibernateTemplate.Get(typeof(User), userId) as User;

}



}

}

HibernateTemplate.cs


    ///<summary>

/// Gets or sets the session factory that should be used to create

/// NHibernate ISessions.

///</summary>

///<value>The session factory.</value>

publicoverride ISessionFactory SessionFactory

{

get { return sessionFactory; }

set

{

sessionFactory = value;

}

}





///<summary>

/// Gets or sets the template flush mode.

///</summary>

///<remarks>

/// Default is Auto. Will get applied to any <b>new</b> ISession

/// created by the template.

///</remarks>

///<value>The template flush mode.</value>

publicoverride TemplateFlushMode TemplateFlushMode

{

get { return templateFlushMode; }

set { templateFlushMode = value; }

}



///<summary>

/// Gets or sets a value indicating whether to 

/// cache all queries executed by this template.

///</summary>

///<remarks>

/// If this is true, all IQuery and ICriteria objects created by

/// this template will be marked as cacheable (including all

/// queries through find methods).

///<p>To specify the query region to be used for queries cached

/// by this template, set the QueryCacheRegion property.

///</p>

///</remarks>

///<value><c>true</c> if cache queries; otherwise, <c>false</c>.</value>

publicoverridebool CacheQueries

{

get { return cacheQueries; }

set { cacheQueries = value; }

}





publicobject Load(Type entityType, object id, LockMode lockMode)

{

return Execute(new LoadByTypeHibernateCallback(entityType, id, lockMode),true);



}



internalclass LoadByTypeHibernateCallback : IHibernateCallback

{

private Type entityType;

privateobject id;

private LockMode lockMode;



public LoadByTypeHibernateCallback(Type entityType, object id, LockMode lockMode)

{

this.entityType = entityType;

this.id = id;

this.lockMode = lockMode;



}



///<summary>

/// Gets called by HibernateTemplate with an active

/// Hibernate Session. Does not need to care about activating or closing

/// the Session, or handling transactions.

///</summary>

///<remarks>

///<p>

/// Allows for returning a result object created within the callback, i.e.

/// a domain object or a collection of domain objects. Note that there's

/// special support for single step actions: see HibernateTemplate.find etc.

///</p>

///</remarks>

publicobject DoInHibernate(ISession session)

{

if (lockMode !=null) 

{

return session.Load(entityType, id, lockMode);

}

else 

{

return session.Load(entityType, id);

}

}







}

Dao.xml


    <?xml version="1.0" encoding="utf-8" ?>

<objects xmlns="http://www.springframework.net"

xmlns:db="http://www.springframework.net/database">                    

<!-- 用以我们在其它的应用程序中，配置数据访问 -->

<object type="Spring.Objects.Factory.Config.PropertyPlaceholderConfigurer, Spring.Core">

<property name="ConfigSections" value="databaseSettings"/>

</object>



<!-- 数据库和Nhibernate的相关配置 -->

<db:provider id="DbProvider"

provider="SqlServer-2.0"

connectionString="Data Source=miaozy;Database=DirectCenter;Integrated Security=true;User Instance=false;"/>



<!--SessionFactory对象，其中包括一些比较重要的属性 -->              

<object id="NHibernateSessionFactory" type="Spring.Data.NHibernate.LocalSessionFactoryObject, Spring.Data.NHibernate20">

<property name="DbProvider" ref="DbProvider"/>

<property name="MappingAssemblies">

<list>

<value>DirectCenter.Model</value>

</list>

</property>

<property name="HibernateProperties">

<dictionary>

<entry key="hibernate.connection.provider"

value="NHibernate.Connection.DriverConnectionProvider"/>

<entry key="dialect"

value="NHibernate.Dialect.MsSql2000Dialect"/>

<entry key="hibernate.connection.driver_class"

value="NHibernate.Driver.SqlClientDriver"/>



</dictionary>

</property>

<property name="ExposeTransactionAwareSessionFactory" value="true"/>

</object>



<!--将id为NHibernateSessionFactory的对象注入到HibernateTemplate中-->

<object id="HibernateTemplate" type="Spring.Data.NHibernate.HibernateTemplate">

<property name="SessionFactory" ref="NHibernateSessionFactory"/>

<property name="TemplateFlushMode" value="Auto"/>

<property name="CacheQueries" value="true"/>

</object>



<!-- 我们的数据访问类，将HibernateTemplate注入进来-->

<object id="UserDao" type="DirectCenter.DAL.UserDao, DirectCenter.DAL">

<property name="HibernateTemplate" ref="HibernateTemplate"/>

</object>



<object id="CompanyDao" type="DirectCenter.DAL.CompanyDao, DirectCenter.DAL">

<property name="HibernateTemplate" ref="HibernateTemplate"/>

</object>



<object id="DepartmentDao" type="DirectCenter.DAL.DepartmentDao, DirectCenter.DAL">

<property name="HibernateTemplate" ref="HibernateTemplate"/>

</object>



</objects>

UserDaoTest.cs


    using System;



using NUnit.Framework;

using Spring.Testing.NUnit;



using DirectCenter.Model;

using DirectCenter.IDAL;



namespace DirectCenter.UnitTest

{

[TestFixture]

publicclass UserDaoTest : AbstractTransactionalDbProviderSpringContextTests

{

protectedoverridestring[] ConfigLocations

{

get

{

returnnew String[] { "objects.xml" };

}

}



protected IUserDao UserDao

{

get

{

return applicationContext.GetObject("UserDao") as IUserDao;

}

}

[Test]

publicvoid SaveUserTest()

{

User user =new User();

user.UserID ="buyer000";

user.Password ="1356";

user.UserName ="刘翔";

user.ValidFrom = Convert.ToDateTime("2008-8-18");

user.ValidTo = Convert.ToDateTime("2012-8-18");

user.CreateTime = DateTime.Now;

UserDao.Save(user);

}

}

}