spring集成hibernate

spring集成hibernate
1.配置datasource的bean
<!-- 配置数据源的bean -->

<bean id="datasrc" class="org.springframework.jdbc.datasource.DriverManagerDataSource">
 <property name="driverClassName" value="com.mysql.jdbc.Driver"></property>
 <property name="url" value="jdbc:mysql://localhost:3306/spring"></property>
 <property name="username" value="root"></property>
 <property name="password" value=""></property>
</bean>

 
2.实现接口,对应接口的实现类

import org.springframework.orm.hibernate3.HibernateTemplate;

public class UserDaoImpl implements UserDao {

 private HibernateTemplate ht;
 
 @Override
 public boolean addUser(User user) {
  try{
   ht.save(user);
  }catch(Exception e){
   e.printStackTrace();
  }
  return false;
 }
}

 
3.配置sessionfactory的bean

<!-- 配置SessionFactory的Bean -->
<bean id="sessionfactory" class="org.springframework.orm.hibernate3.LocalSessionFactoryBean">
 <property name="dataSource" ref="datasrc"></property>
 <!-- 配置映射文件 -->
 <property name="mappingResources">
  <list>
   <value>com/dowebber/spring5/user.hbm.xml</value>
  </list>
 </property>
 <property name="hibernateProperties">
  <props>
   <prop key="hibernate.show_sql">true</prop>
   <prop key="hibernate.format_sql">true</prop>
   <prop key="hibernate.dialect">org.hibernate.dialect.MySQLDialect</prop>
  </props>
 </property>
</bean>

 4.配置hibernatetemplate的bean
<!-- 配置HibernateTemplate的Bean-->

<bean id="hibernatetemplate" class="org.springframework.orm.hibernate3.HibernateTemplate">
 <property name="sessionFactory" ref="sessionfactory"></property>
</bean>

 
5.配置实现类的bean

<!-- 配置接口的实现类的Bena-->
<bean id="userdao" class="com.dowebber.spring5.UserDaoImpl">
 <property name="ht" ref="hibernatetemplate"></property>
</bean>

 
6.实现事务管理器的bean

<!-- 配置事务的bean 使用hibernate的事务类,spring提供 -->
<bean id="transactionmanager" class="org.springframework.orm.hibernate3.HibernateTransactionManager">
 <property name="sessionFactory" ref="sessionfactory"></property>
</bean>

 

7.代理的bean

<!-- 配置代理的bean -->
<bean id="userdaoproxy" class="org.springframework.transaction.interceptor.TransactionProxyFactoryBean">
 <property name="target" ref="userdao"></property>
 <property name="proxyInterfaces" value="com.dowebber.spring5.UserDao"></property>
 <property name="transactionAttributes">
  <props>
   <prop key="*">PROPAGATION_REQUIRED,-Exception</prop>
  </props>
 </property>
</bean>

 

设置完成,设置测试类

 public static void main(String[] args) {
  
  ApplicationContext context = new ClassPathXmlApplicationContext("com/dowebber/spring5/spring.xml");
  
//  User user = new User();
//  user.setPassword("21988121");
//  user.setUsername("zhougege");
//  
  UserDao dao = (UserDao)context.getBean("userdaoproxy");
//  
//  dao.addUser(user);
  
  System.out.println(dao.getUserByNameAndPass("zhougege","21988121").getUserid());;
  
  System.out.println("done...");
  
 }

 

其他方法的实现:
 

@Override
 public User getUserByNameAndPass(String username, String password) {
  String [] arg = new String[]{"username","password"};
  Object [] values = new Object[]{username,password};
  String hql = "from User where username=:username and password=:password";
  User user = (User) ht.findByNamedParam(hql,arg,values).get(0);
  return user;
 }