SpringMVC+Spring+hibernate整合及分页

提示：扫一扫查出行
【扫一扫了解最新限行尾号】
复制提示

1. 新建web project

2. 引入jar,

3. 创建包com.tgb.web.controller，下面创建包（dao，entity，service， config，spring，hibernate）

config-> spring-core.xml,spring-servlet.xml,spring-hibernate.xml

1) config下 springmvc配置文件 spring-servlet.xml

2)spring-hibernate.xml

<?xml version="1.0" encoding="UTF-8"?>
<beans xmlns="http://www.springframework.org/schema/beans"
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:context="http://www.springframework.org/schema/context"
xmlns:aop="http://www.springframework.org/schema/aop" xmlns:tx="http://www.springframework.org/schema/tx"
xsi:schemaLocation="http://www.springframework.org/schema/beans
http://www.springframework.org/schema/beans/spring-beans-2.5.xsd
http://www.springframework.org/schema/context
http://www.springframework.org/schema/context/spring-context-2.5.xsd
http://www.springframework.org/schema/aop
http://www.springframework.org/schema/aop/spring-aop-2.5.xsd
http://www.springframework.org/schema/tx
http://www.springframework.org/schema/tx/spring-tx-2.5.xsd"><bean id="dataSource" class="org.springframework.jdbc.datasource.DriverManagerDataSource">
<property name="driverClassName" value="com.mysql.jdbc.Driver"/>
<property name="url" value="jdbc:mysql://localhost/test_ssh"/>
<property name="username" value="root"/>
<property name="password" value="linda0213"/>
</bean><bean id="sessionFactory" class="org.springframework.orm.hibernate4.LocalSessionFactoryBean">
<property name="dataSource" ref="dataSource"/>
<property name="hibernateProperties">
<props>
<prop key="hibernate.dialect">org.hibernate.dialect.MySQLDialect</prop>
<prop key="hibernate.hbm2ddl.auto">update</prop>
<prop key="hibernate.show_sql">true</prop>
<prop key="hibernate.format_sql">true</prop>
</props>
</property>
<property name="configLocations">
<list>
<value>
classpath*:com/tgb/web/controller/hibernate/hibernate.cfg.xml
</value>
</list>
</property>
</bean>
<bean id="transactionManager" class="org.springframework.orm.hibernate4.HibernateTransactionManager">
<property name="sessionFactory" ref="sessionFactory"></property>
</bean> <bean id="transactionBase" class="org.springframework.transaction.interceptor.TransactionProxyFactoryBean" lazy-init="true" abstract="true">

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

<property name="transactionAttributes">
<props>

<prop key="add*">PROPAGATION_REQUIRED,-Exception</prop>
<prop key="update*">PROPAGATION_REQUIRED,-Exception</prop>
<prop key="insert*">PROPAGATION_REQUIRED,-Exception</prop>
<prop key="modify*">PROPAGATION_REQUIRED,-Exception</prop>
<prop key="delete*">PROPAGATION_REQUIRED,-Exception</prop>
<prop key="get*">PROPAGATION_NEVER</prop>
</props>
</property>
</bean> </beans>

3) spring配置文件:spring-core.xml

spring-> spring-import.xml

hibernate->hibernate.cfg.xml

<?xml version='1.0' encoding='utf-8'?>
<!DOCTYPE hibernate-configuration PUBLIC
"-//Hibernate/Hibernate Configuration DTD 3.0//EN"
"http://hibernate.sourceforge.net/hibernate-configuration-3.0.dtd"><hibernate-configuration>
<session-factory>
<mapping class ="com.tgb.web.controller.entity.User" />
</session-factory>
</hibernate-configuration>

web.xml

<?xml version="1.0" encoding="UTF-8"?>
<web-app xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns="http://java.sun.com/xml/ns/javaee" xmlns:web="http://java.sun.com/xml/ns/javaee/web-app_2_5.xsd" xsi:schemaLocation="http://java.sun.com/xml/ns/javaee http://java.sun.com/xml/ns/javaee/web-app_3_0.xsd" version="3.0">
<display-name></display-name>
<welcome-file-list>
<welcome-file>index.jsp</welcome-file>
</welcome-file-list>
<context-param>
<param-name>contextConfigLocation</param-name>
<param-value>classpath*:config/spring-*.xml</param-value>
</context-param>
<listener>
<listener-class>org.springframework.web.context.ContextLoaderListener</listener-class>
</listener>
<servlet>
<servlet-name>springMVC</servlet-name>
<servlet-class>org.springframework.web.servlet.DispatcherServlet</servlet-class>
<init-param>
<param-name>contextConfigLocation</param-name>
<param-value>classpath*:config/spring-servlet.xml</param-value>
</init-param>
<load-on-startup>1</load-on-startup>
</servlet>
<filter>
<filter-name>characterEncodingFilter</filter-name>
<filter-class>org.springframework.web.filter.CharacterEncodingFilter</filter-class>
<init-param>
<param-name>encoding</param-name>
<param-value>UTF-8</param-value>
</init-param>
<init-param>
<param-name>forceEncoding</param-name>
<param-value>true</param-value>
</init-param>
</filter>
<filter-mapping>
<filter-name>characterEncodingFilter</filter-name>
<url-pattern>/*</url-pattern>
</filter-mapping>
<servlet-mapping>
<servlet-name>springMVC</servlet-name>
<url-pattern>/</url-pattern>
</servlet-mapping>

<filter>
<filter-name>openSession</filter-name>
<filter-class>org.springframework.orm.hibernate4.support.OpenSessionInViewFilter</filter-class>
</filter>
<filter-mapping>
<filter-name>openSession</filter-name>
<url-pattern>/*</url-pattern>
</filter-mapping>
</web-app>

4. 建实体类

entity->User.java

package com.tgb.web.controller.entity;import javax.persistence.Column;
import javax.persistence.Entity;
import javax.persistence.GeneratedValue;
import javax.persistence.Id;
import javax.persistence.Table;@Entity
@Table(name="T_USER")
public class User {
@Id
@GeneratedValue
@Column(length=32)
private Long id;public Long getId() {
return id;
}
public void setId(Long id) {
this.id = id;
}
@Column(length=32)
private String userName;
@Column(length=32)
private String age;
public String getUserName() {
return userName;
}
public void setUserName(String userName) {
this.userName = userName;
}
public String getAge() {
return age;
}
public void setAge(String age) {
this.age = age;
}
}

5. 建DAO层

dao->IUserDao.java, UserDao.java

1) IUserDao.java接口文件

package com.tgb.web.controller.dao;
import java.util.List;
import com.tgb.web.controller.entity.User;
public interface IUserDAO {
public void addUser(User user);
public List<User> getAllUser();
public boolean delUser(Long id);
public User getUser(Long id);
public boolean updateUser(User user);
public List<User> getForPage(int offset, int length);
public Long getAllRowCount();
}

2) UserDao.java 实体类

package com.tgb.web.controller.dao;
import java.util.List;
import org.hibernate.Query;
import org.hibernate.SessionFactory;import com.tgb.web.controller.entity.User;public class UserDAO implements IUserDAO {private SessionFactory sessionFactory;
public SessionFactory getSessionFactory() {
return sessionFactory;
}public void setSessionFactory(SessionFactory sessionFactory) {
this.sessionFactory = sessionFactory;
}@Override
public void addUser(User user) {
sessionFactory.getCurrentSession().save(user);
}@Override
public List<User> getAllUser() {
String hql = "FROM User";
Query query = sessionFactory.getCurrentSession().createQuery(hql);
return query.list();
}@Override
public boolean delUser(Long id) {
String hql = "DELETE User u WHERE u.id=?";
Query query = sessionFactory.getCurrentSession().createQuery(hql);
query.setString(0, String.valueOf(id));return (query.executeUpdate()>0);
}@Override
public User getUser(Long id) {
String hql = "FROM User u WHERE u.id=?";
Query query = sessionFactory.getCurrentSession().createQuery(hql);
query.setString(0, String.valueOf(id));
return (User)query.uniqueResult();
}@Override
public boolean updateUser(User user) {
String hql = "UPDATE User u SET u.userName=? ,u.age=? WHERE u.id=?";
Query query = sessionFactory.getCurrentSession().createQuery(hql);
query.setString(0, String.valueOf(user.getUserName()));
query.setString(1, String.valueOf(user.getAge()));
query.setString(2, String.valueOf(user.getId()));return (query.executeUpdate()>0);
}@Override
public List<User> getForPage(int offset, int length) {
List<User> userList=null;
String hql = "FROM User";
Query query = sessionFactory.getCurrentSession().createQuery(hql);
query.setFirstResult(offset);
query.setMaxResults(length);
userList=query.list();
return userList;
}@Override
public Long getAllRowCount() {
String hql = "SELECT COUNT(*) FROM User";
Query query = sessionFactory.getCurrentSession().createQuery(hql);
return Long.parseLong(query.uniqueResult().toString());
}}

6. 建service层

service->IUserManager.java, UserManager.java

1) IUserManager.java接口

package com.tgb.web.controller.service;import java.util.List;import com.tgb.web.controller.entity.Page;
import com.tgb.web.controller.entity.User;public interface IUserManager {
public void addUser(User user);
public List<User> getAllUser();
public boolean delUser(Long id);
public User getUser(Long id);
public boolean updateUser(User user);
public Page getForPage(int offset, int length);
public Long getAllRowCount();
}

2) UserManager.java实现类

package com.tgb.web.controller.service;import java.util.List;import com.tgb.web.controller.dao.IUserDAO;
import com.tgb.web.controller.entity.Page;
import com.tgb.web.controller.entity.User;public class UserManager implements IUserManager{
private IUserDAO userDao;public IUserDAO getUserDao() {
return userDao;
}public void setUserDao(IUserDAO userDao) {
this.userDao = userDao;
}@Override
public void addUser(User user) {
userDao.addUser(user);
}@Override
public List<User> getAllUser() {
return userDao.getAllUser();
}@Override
public boolean delUser(Long id) {
return userDao.delUser(id);
}@Override
public User getUser(Long id) {
return userDao.getUser(id);
}@Override
public boolean updateUser(User user) {
return userDao.updateUser(user);
}@Override
public Page getForPage(int currentPage, int pageSize) {
Page page = new Page();
int allRow = userDao.getAllRowCount().intValue();
int offset = page.countOffset(currentPage, pageSize);
List<User> list= userDao.getForPage(offset, pageSize);
page.setPageNo(currentPage);
page.setPageSize(pageSize);
page.setTotalRecords(allRow);
page.setList(list);
return page;
}@Override
public Long getAllRowCount() {
return userDao.getAllRowCount();
}
}

7. 建controller

controller包下新建controller文件

UserController.java

package com.tgb.web.controller;import java.io.IOException;
import java.io.PrintWriter;
import java.util.List;import javax.annotation.Resource;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;import org.springframework.stereotype.Controller;
import org.springframework.web.bind.annotation.RequestMapping;import com.tgb.web.controller.entity.Page;
import com.tgb.web.controller.entity.User;
import com.tgb.web.controller.service.IUserManager;@Controller
@RequestMapping("/user")
public class UserController {
@Resource(name="userManager")
private IUserManager userManager;@RequestMapping("/addUser")
public String addUser(User user){
userManager.addUser(user);
return "redirect:/user/getAllUsers";
}
@RequestMapping("/toAddUser")
public String toAddUser(){
return "/addUser";
}@RequestMapping("/delUser")
public void delUser(Long id,HttpServletResponse response){
String result = "{\"result\":\"error\"}";
if(userManager.delUser(id)){
result = "{\"result\":\"success\"}";
}
PrintWriter out = null;
response.setContentType("application/json");
try {
out=response.getWriter();
out.write(result);
} catch (IOException e) {
e.printStackTrace();
}
}@RequestMapping("/getAllUser")
public String getAllUser(HttpServletRequest request){
List<User> users = userManager.getAllUser();
request.setAttribute("users", users);
return "/userManager";
}@RequestMapping("/getAllUsers")
public String getAllUsers(HttpServletRequest request){
try {
String pageNo = request.getParameter("pageNo");
if (pageNo == null) {
pageNo = "1";
}
Page page = userManager.getForPage(Integer.valueOf(pageNo), 10);
request.setAttribute("page", page);
List<User> pageusers = page.getList();
request.setAttribute("pageusers", pageusers);
} catch (Exception e) {
e.printStackTrace();
}
return "/userManagerPage";
}@RequestMapping("/getUser")
public String getUser(Long id,HttpServletRequest request){
User user = userManager.getUser(id);
request.setAttribute("user", user);
return "/editUser";
}@RequestMapping("/updateUser")
public String updateUser(User user,HttpServletRequest request, HttpServletResponse response){
if(userManager.updateUser(user)){
return "redirect:/user/getAllUsers";
}
else{
return "error";
}}}

8. 建显示层jsp文件

userManager.jsp

addUser.jsp

editUser.jsp

IE端访问:

http://localhost:8080/springMVCSSH2/user/getAllUser

分页的话, 在entity里新建Page.java

package com.tgb.web.controller.entity;
import java.util.List;public class Page<E> {
// 结果集
private List<E> list; // 查询记录总数
private int totalRecords; // 每页多少条记录
private int pageSize; // 第几页
private int pageNo; /**
* @return 总页数
* */
public int getTotalPages(){
return (totalRecords+pageSize-1)/pageSize;
} /**
* 计算当前页开始记录
* @param pageSize 每页记录数
* @param currentPage 当前第几页
* @return 当前页开始记录号
*/
public int countOffset(int currentPage,int pageSize){
int offset = pageSize*(currentPage-1);
return offset;
} /**
* @return 首页
* */
public int getTopPageNo(){
return 1;
} /**
* @return 上一页
* */
public int getPreviousPageNo(){
if(pageNo<=1){
return 1;
}
return pageNo-1;
} /**
* @return 下一页
* */
public int getNextPageNo(){
if(pageNo>=getBottomPageNo()){
return getBottomPageNo();
}
return pageNo+1;
} /**
* @return 尾页
* */
public int getBottomPageNo(){
return getTotalPages();
} public List<E> getList() {
return list;
} public void setList(List<E> list) {
this.list = list;
} public int getTotalRecords() {
return totalRecords;
} public void setTotalRecords(int totalRecords) {
this.totalRecords = totalRecords;
} public int getPageSize() {
return pageSize;
} public void setPageSize(int pageSize) {
this.pageSize = pageSize;
} public int getPageNo() {
return pageNo;
} public void setPageNo(int pageNo) {
this.pageNo = pageNo;
}}

在UserDao.java里加入新方法

@Override
public List<User> getForPage(int offset, int length) {
List<User> userList=null;
String hql = "FROM User";
Query query = sessionFactory.getCurrentSession().createQuery(hql);
query.setFirstResult(offset);
query.setMaxResults(length);
userList=query.list();
return userList;
}@Override
public Long getAllRowCount() {
String hql = "SELECT COUNT(*) FROM User";
Query query = sessionFactory.getCurrentSession().createQuery(hql);
return Long.parseLong(query.uniqueResult().toString());
}

UserManage.java里调用dao方法

@Override
public Page getForPage(int currentPage, int pageSize) {
Page page = new Page();
int allRow = userDao.getAllRowCount().intValue();
int offset = page.countOffset(currentPage, pageSize);
List<User> list= userDao.getForPage(offset, pageSize);
page.setPageNo(currentPage);
page.setPageSize(pageSize);
page.setTotalRecords(allRow);
page.setList(list);
return page;
}@Override
public Long getAllRowCount() {
return userDao.getAllRowCount();
}

UserController里调用

@RequestMapping("/getAllUsers")
public String getAllUsers(HttpServletRequest request){
try {
String pageNo = request.getParameter("pageNo");
if (pageNo == null) {
pageNo = "1";
}
Page page = userManager.getForPage(Integer.valueOf(pageNo), 10);
request.setAttribute("page", page);
List<User> pageusers = page.getList();
request.setAttribute("pageusers", pageusers);
} catch (Exception e) {
e.printStackTrace();
}
return "/userManagerPage";
}

新建显示层jsp文件 UserManagerPage.jsp

<%@ page language="java" import="java.util.*" pageEncoding="UTF-8"%>
<%@taglib prefix="c" uri="http://java.sun.com/jsp/jstl/core" %><!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<script type="text/javascript" src="../js/jquery-1.4.2.min.js"></script>
<title>My JSP 'addUser.jsp' starting page</title>
<script type="text/javascript">
function del(id){
$.get("/springMVCSSH2/user/delUser?id="+id,function(data){
alert(data.result);
if("success"==data.result){
alert("删除成功");
window.location.reload();
}
else{
alert("删除失败");
}
});
}
</script>
</head>
<body>
<a href="/springMVCSSH2/user/toAddUser">添加用户</a>
<table border="1">
<tbody>
<tr>
<th>姓名</th>
<th>年龄</th>
<th>编辑</th>
</tr>
<c:if test="${!empty pageusers }">
<c:forEach items="${pageusers }" var="u">
<tr>
<td>${u.userName}</td>
<td>${u.age}</td>
<td>
<a href="/springMVCSSH2/user/getUser?id=${u.id}">编辑</a>
<a href="javascript:del('${u.id }')">删除</a>
</td>
</tr>
</c:forEach>
</c:if>
<tr>
<td colspan="6" align="center">共${page.totalRecords}条记录共${page.totalPages}页当前第${page.pageNo}页<br> <a href="/springMVCSSH2/user/getAllUsers?pageNo=${page.topPageNo }"><input type="button" name="fristPage" value="首页" /></a>
<c:choose>
<c:when test="${page.pageNo!=1}"> <a href="/springMVCSSH2/user/getAllUsers?pageNo=${page.previousPageNo }"><input type="button" name="previousPage" value="上一页" /></a> </c:when>
<c:otherwise> <input type="button" disabled="disabled" name="previousPage" value="上一页" /> </c:otherwise>
</c:choose>
<c:choose>
<c:when test="${page.pageNo != page.totalPages}">
<a href="/springMVCSSH2/user/getAllUsers?pageNo=${page.nextPageNo }"><input type="button" name="nextPage" value="下一页" /></a>
</c:when>
<c:otherwise> <input type="button" disabled="disabled" name="nextPage" value="下一页" /> </c:otherwise>
</c:choose>
<a href="/springMVCSSH2/user/getAllUsers?pageNo=${page.bottomPageNo }"><input type="button" name="lastPage" value="尾页" /></a>
</td>
</tr></tbody>
</table>
</body>
</html>