操作数据库可以使用hibernate框架的hibernateTemplate来实现。 在spring与hibernate集成并且创建hibernateTemplate的过程中, 可以通过两种配置得到hibernateTemplate对象。
- 通过注入sessionFactory,通过setSessionFactory()方法实现
- 底层源码:
public abstract class HibernateDaoSupport extends DaoSupport {
private HibernateTemplate hibernateTemplate;
/**
* Set the Hibernate SessionFactory to be used by this DAO.
* Will automatically create a HibernateTemplate for the given SessionFactory.
* @see #createHibernateTemplate
* @see #setHibernateTemplate
*/
public final void setSessionFactory(SessionFactory sessionFactory) {
if (this.hibernateTemplate == null || sessionFactory != this.hibernateTemplate.getSessionFactory()) {
this.hibernateTemplate = createHibernateTemplate(sessionFactory);
}
}
/**
* Create a HibernateTemplate for the given SessionFactory.
* Only invoked if populating the DAO with a SessionFactory reference!
* <p>Can be overridden in subclasses to provide a HibernateTemplate instance
* with different configuration, or a custom HibernateTemplate subclass.
* @param sessionFactory the Hibernate SessionFactory to create a HibernateTemplate for
* @return the new HibernateTemplate instance
* @see #setSessionFactory
*/
protected HibernateTemplate createHibernateTemplate(SessionFactory sessionFactory) {
return new HibernateTemplate(sessionFactory);
}
- 实现:编写dao继承HibernateDaoSupport, 注入sessionFactory创建。
dao代码:
@Repository
public class SysUserDaoImpl extends HibernateDaoSupport implements SysUserDao {
@Autowired
public void setSessionFactor(SessionFactory sessionFactory) {
super.setSessionFactory(sessionFactory);
}
@Override
public SysUser findSysUserById(String id) {
return this.getHibernateTemplate().get(SysUser.class, id);
}
}
applicationContext.xml代码:
<!-- 数据源 ,使用c3p0 -->
<bean id="dataSource" class="com.mchange.v2.c3p0.ComboPooledDataSource">
<property name="driverClass" value="${jdbc.driver}" />
<property name="jdbcUrl" value="${jdbc.url}" />
<property name="user" value="${jdbc.username}" />
<property name="password" value="${jdbc.password}" />
<!-- 最大连接数,建议在开发环境中设置小一点,够用即可 -->
<property name="maxPoolSize" value="3" />
<!-- 最小连接数 -->
<property name="minPoolSize" value="1" />
</bean>
<!-- sessionFactory -->
<bean id="sessionFactory" class="org.springframework.orm.hibernate5.LocalSessionFactoryBean">
<!-- 数据库源 -->
<property name="dataSource" ref="dataSource" />
<!-- 设置hibernate属性 -->
<property name="hibernateProperties">
<props>
<!-- 方言 -->
<prop key="hibernate.dialect">org.hibernate.dialect.Oracle10gDialect</prop>
<!-- 日志输出显示sql -->
<prop key="hibernate.show_sql">true</prop>
<!-- 日志输出中格式化sql -->
<prop key="hibernate.format_sql">true</prop>
<!-- 从hbm文件到数据库定义策略,建议设置为none,不检查po类和表结构是否一致 -->
<prop key="hibernate.hbm2ddl.auto">none</prop>
<!-- 配置Hibernate的session管理机制,spring与hibernate整合后采用当session与当前线程绑定 -->
<prop key="hibernate.current_session_context_class">org.springframework.orm.hibernate5.SpringSessionContext</prop>
</props>
</property>
<!-- 加载映射文件 -->
<property name="mappingLocations">
<list>
<value>classpath:com/xxx/xxx/*.hbm.xml</value>
</list>
</property>
</bean>
- 通过注入hibernateTemplate实现,通过setHibernateTemplate()方法实现
- 底层源码:
public abstract class HibernateDaoSupport extends DaoSupport {
private HibernateTemplate hibernateTemplate;
/**
* Set the HibernateTemplate for this DAO explicitly,
* as an alternative to specifying a SessionFactory.
* @see #setSessionFactory
*/
public final void setHibernateTemplate(HibernateTemplate hibernateTemplate) {
this.hibernateTemplate = hibernateTemplate;
}
- 实现:
dao代码:
@Repository
public class SysUserDaoImpl extends HibernateDaoSupport implements SysUserDao {
@Autowired
public void setHT(HibernateTemplate hibernateTeplate) {
super.setHibernateTemplate(hibernateTeplate);
}
@Override
public SysUser findSysUserById(String id) {
return this.getHibernateTemplate().get(SysUser.class, id);
}
}
applicationContext.xml代码:上面的applicationComtext.xml + hibernateTemplate交给spring管理
<bean id="hibernateTemplate" class="org.springframework.orm.hibernate5.HibernateTemplate">
<!-- spring与hibernate整合后默认必须在事务下对数据库执行写操作,如果将checkWriteOperations设置为false则没有事务也可写数据库,这样是为了单独测试dao方便 -->
<property name="checkWriteOperations" value="false"/>
<property name="sessionFactory" ref="sessionFactory"/>
</bean>
网友评论