HibernateTemplate实现CRUD操作_使用hibernatetemplate完成curd

package com.siwuxie095.entity;

public class User {

private Integer uid;

private String username;

private String address;

public Integer getUid() {

return uid;

}

publicvoid setUid(Integer uid) {

this.uid = uid;

}

public String getUsername() {

return username;

}

publicvoid setUsername(String username) {

this.username = username;

}

public String getAddress() {

return address;

}

publicvoid setAddress(String address) {

this.address = address;

}

@Override

public String toString() {

return"User [uid=" + uid +", username=" + username +

", address=" + address +"]";

}

}

package com.siwuxie095.action;

import com.opensymphony.xwork2.ActionSupport;

import com.siwuxie095.service.UserService;

public class UserActionextends ActionSupport {

private UserService userService;

publicvoid setUserService(UserService userService) {

this.userService = userService;

}

@Override

public String execute()throws Exception {

//userService.add();

userService.find();

return"none";

}

}

package com.siwuxie095.service;

import org.springframework.transaction.annotation.Transactional;

import com.siwuxie095.dao.UserDao;

/**

*在 Service层进行声明式事务管理

*即加上注解 @Transactional

*

*使用 HibernateTemplate实现 CRUD操作，

*一定要加上事务管理，否则将报错

*/

@Transactional

public class UserService {

private UserDao userDao;

publicvoid setUserDao(UserDao userDao) {

this.userDao = userDao;

}

publicvoid add() {

userDao.add();

}

publicvoid find() {

userDao.find();

}

}

package com.siwuxie095.dao;

public interface UserDao {

publicvoid add();

publicvoid find();

}

package com.siwuxie095.dao.impl;

import java.util.List;

import org.springframework.orm.hibernate5.HibernateTemplate;

import com.siwuxie095.dao.UserDao;

import com.siwuxie095.entity.User;

public class UserDaoImplimplements UserDao {

private HibernateTemplate hibernateTemplate;

publicvoid setHibernateTemplate(HibernateTemplate hibernateTemplate) {

this.hibernateTemplate = hibernateTemplate;

}

@Override

publicvoid add() {

User user=new User();

user.setUsername("小白");

user.setAddress("中国");

hibernateTemplate.save(user);

/*

* HibernateTemplate还有 update()、delete()方法，

*都是直接传入对象即可

*/

}

@Override

publicvoid find() {

//根据 id查询

User user=hibernateTemplate.get(User.class,1);

System.out.println(user);

System.out.println("------------------");

//查询所有

List<User> list=(List<User>) hibernateTemplate.find("from User");

for (User user1 : list) {

System.out.println(user1);

}

System.out.println("------------------");

//根据条件查询

List<User> listx=(List<User>) hibernateTemplate.find("from User where username=?","小黑");

for (User user2 : listx) {

System.out.println(user2);

}

/*

* HibernateTemplate的 findByCriteria()方法可以做到分页查询

*

* find()方法则无法做到

*/

}

}

<?xmlversion="1.0"encoding="UTF-8"?>

<!DOCTYPE hibernate-mapping PUBLIC

"-//Hibernate/Hibernate Mapping DTD 3.0//EN"

"http://www.hibernate.org/dtd/hibernate-mapping-3.0.dtd">

<hibernate-mapping>

<classname="com.siwuxie095.entity.User"table="t_user">

<idname="uid"column="uid">

<generatorclass="native"></generator>

</id>

<propertyname="username"column="username"></property>

<propertyname="address"column="address"></property>

</class>

</hibernate-mapping>

<?xmlversion="1.0"encoding="UTF-8"?>

<!DOCTYPE hibernate-configuration PUBLIC

"-//Hibernate/Hibernate Configuration DTD 3.0//EN"

"http://www.hibernate.org/dtd/hibernate-configuration-3.0.dtd">

<hibernate-configuration>

<session-factory>

<propertyname="hibernate.show_sql">true</property>

<propertyname="hibernate.format_sql">true</property>

<!--注意：只有配置 hibernate.hbm2ddl.auto为 update，才能自动创建表 -->

<propertyname="hibernate.hbm2ddl.auto">update</property>

<propertyname="hibernate.dialect">org.hibernate.dialect.MySQLDialect</property>

<!--

原来的配置：

<property name="hibernate.current_session_context_class">thread</property>

在 SSH框架整合中会报错，要么将这个配置删了，要么改成如下配置

参考链接：http://blog.csdn.net/maoyuanming0806/article/details/61417995

-->

<propertyname="hibernate.current_session_context_class">

org.springframework.orm.hibernate5.SpringSessionContext

</property>

<mappingresource="com/siwuxie095/entity/User.hbm.xml"/>

</session-factory>

</hibernate-configuration>

<?xmlversion="1.0"encoding="UTF-8"?>

<beansxmlns="http://www.springframework.org/schema/beans"

xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"

xmlns:aop="http://www.springframework.org/schema/aop"

xmlns:context="http://www.springframework.org/schema/context"

xmlns:tx="http://www.springframework.org/schema/tx"

xsi:schemaLocation="

http://www.springframework.org/schema/beans

http://www.springframework.org/schema/beans/spring-beans.xsd

http://www.springframework.org/schema/aop

http://www.springframework.org/schema/aop/spring-aop.xsd

http://www.springframework.org/schema/context

http://www.springframework.org/schema/context/spring-context.xsd

http://www.springframework.org/schema/tx

http://www.springframework.org/schema/tx/spring-tx.xsd">

<!-- (1) -->

<!--配置 C3P0连接池 -->

<beanid="dataSource"class="com.mchange.v2.c3p0.ComboPooledDataSource">

<propertyname="driverClass"value="com.mysql.jdbc.Driver"/>

<!--

jdbc:mysql:///test_db是 jdbc:mysql://localhost:3306/test_db的简写

-->

<propertyname="jdbcUrl"value="jdbc:mysql:///test_db"/>

<propertyname="user"value="root"/>

<propertyname="password"value="8888"/>

</bean>

<!-- SessionFactory对象的创建交给 Spring进行管理 -->

<beanid="sessionFactory"

class="org.springframework.orm.hibernate5.LocalSessionFactoryBean">

<!--

因为在 Hibernate核心配置文件中，没有数据库配置，

而是在 Spring的核心配置文件中进行配置，所以需要

注入 dataSource

LocalSessionFactoryBean中有相关属性，所以可以

注入

-->

<propertyname="dataSource"ref="dataSource"></property>

<!--指定 Hibernate核心配置文件的位置 -->

<propertyname="configLocations"value="classpath:hibernate.cfg.xml"></property>

</bean>

<!-- (2) -->

<!--配置 Action对象 -->

<beanid="userAction"class="com.siwuxie095.action.UserAction" scope="prototype">

<propertyname="userService"ref="userService"></property>

</bean>

<!--配置 Service对象 -->

<beanid="userService"class="com.siwuxie095.service.UserService">

<propertyname="userDao"ref="userDaoImpl"></property>

</bean>

<!--配置 Dao实现类对象 -->

<beanid="userDaoImpl"class="com.siwuxie095.dao.impl.UserDaoImpl">

<propertyname="hibernateTemplate"ref="hibernateTemplate"></property>

</bean>

<!--配置 HibernateTemplate对象 -->

<beanid="hibernateTemplate"class="org.springframework.orm.hibernate5.HibernateTemplate">

<!--注入 SessionFactory对象 -->

<propertyname="sessionFactory"ref="sessionFactory"></property>

</bean>

<!-- (3) -->

<!--配置事务管理器 HibernateTransactionManager -->

<beanid="transactionManager"

class="org.springframework.orm.hibernate5.HibernateTransactionManager">

<!--注入 SessionFactory 对象 -->

<propertyname="sessionFactory"ref="sessionFactory"></property>

</bean>

<!--开启事务注解 -->

<tx:annotation-driventransaction-manager="transactionManager"/>

</beans>

<?xmlversion="1.0"encoding="UTF-8"?>

<!DOCTYPE struts PUBLIC

"-//Apache Software Foundation//DTD Struts Configuration 2.3//EN"

"http://struts.apache.org/dtds/struts-2.3.dtd">

<struts>

<packagename="demo"extends="struts-default"namespace="/">

<!--

此时，class属性对应 Spring核心配置文件中 Bean的 id

如果还写 Action类的全限定名，Action对象就会创建两次

-->

<actionname="user"class="userAction"></action>

</package>

</struts>

<?xmlversion="1.0"encoding="UTF-8"?>

<web-app xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"xmlns="http://xmlns.jcp.org/xml/ns/javaee" xsi:schemaLocation="http://xmlns.jcp.org/xml/ns/javaeehttp://xmlns.jcp.org/xml/ns/javaee/web-app_3_1.xsd"version="3.1">

<welcome-file-list>

<welcome-file>index.jsp</welcome-file>

</welcome-file-list>

<filter>

<!--配置 Struts2的核心过滤器 -->

<filter-name>struts2</filter-name>

<filter-class>org.apache.struts2.dispatcher.ng.filter.StrutsPrepareAndExecuteFilter</filter-class>

</filter>

<filter-mapping>

<filter-name>struts2</filter-name>

<url-pattern>/*</url-pattern>

</filter-mapping>

<!--配置 Spring的监听器 ContextLoaderListener -->

<listener>

<listener-class>org.springframework.web.context.ContextLoaderListener</listener-class>

</listener>

<!--配置 Spring核心配置文件的位置（路径） -->

<context-param>

<param-name>contextConfigLocation</param-name>

<param-value>classpath:applicationContext.xml</param-value>

</context-param>

</web-app>