1 环境
搭建SpringMVC+Spring+Hibernate4 ,Maven环境、 需要MySQL 数据库支持,使用的编程工具Eclipse
搭建完毕后的项目架构如下:
2 新建Maven项目
2.1 新建Maven项目
2.2 选择web项目
点击【finish】
3 新建的项目架构
新建完毕,项目报错,并且缺少目录。修改如下:
3.1 显示所有的目录
目录结构为:
src/main/resources
src/main/java
src/test/resources
src/test/java
【右键项目】-->【Build Path】--> 【Configure Build Path】
会看见所有的目录,没有看见的目录拉其滚动条就可看见
然后点击【Apply】-->【OK】即可。
如果没有出现,则重复以上步骤,然后双击【Allow ouput folders for source folders】,再进行【Apply】。
最后项目结构如下:
以上结构还需要添加一些东西,选中【项目右键】--> 【Build Path】--> 【new Source Folder】--> 【输入文件夹名称】--> 【Finish】.
这里新建src/test/resources
目录如下:
3.2 修改项目的编辑版本
默认项目的编译级别是1.5 ,有一些JDK的新特性可能会报错,所以需要更换项目的编译级别。修改如下:
【右键项目】-->【Properties】
去掉选择,更换编译版本1.8
选择【Project Facets】然后修改Java版本,因为安装的是JDK1.8 所以选择1.8
然后点击【Apply】-->【OK】
3.3 加入依赖
结果工程还是报错,因为缺少类javax.servlet.http.HttpServlet,此类在javax包中。
在pom.xml中加入以下依赖:
<!-- JSP相关 -->
<dependency>
<groupId>jstl</groupId>
<artifactId>jstl</artifactId>
<version>1.2</version>
</dependency>
<dependency>
<groupId>javax.servlet</groupId>
<artifactId>servlet-api</artifactId>
<version>2.5</version>
<scope>provided</scope>
</dependency>
<dependency>
<groupId>javax.servlet</groupId>
<artifactId>jsp-api</artifactId>
<version>2.0</version>
<scope>provided</scope>
</dependency>
查看项目:
3.4 设置部署程序集(Web Deployment Assembly)
右键项目,选择[properties] -->[Deployment Assembly] 如下图:
4 Spring与Hibernate的整合
4.1 基本配置
4.1.1 添加依赖(pom.xml)
<!-- spring -->
<dependency>
<groupId>org.springframework</groupId>
<artifactId>spring-core</artifactId>
<version>${spring.version}</version>
</dependency>
<dependency>
<groupId>org.springframework</groupId>
<artifactId>spring-beans</artifactId>
<version>${spring.version}</version>
</dependency>
<dependency>
<groupId>org.springframework</groupId>
<artifactId>spring-context</artifactId>
<version>${spring.version}</version>
</dependency>
<dependency>
<groupId>org.springframework</groupId>
<artifactId>spring-tx</artifactId>
<version>${spring.version}</version>
</dependency>
<dependency>
<groupId>org.springframework</groupId>
<artifactId>spring-web</artifactId>
<version>${spring.version}</version>
</dependency>
<dependency>
<groupId>org.springframework</groupId>
<artifactId>spring-test</artifactId>
<version>${spring.version}</version>
<scope>test</scope>
</dependency>
<!-- 使用SpringMVC需配置 -->
<dependency>
<groupId>org.springframework</groupId>
<artifactId>spring-webmvc</artifactId>
<version>${spring.version}</version>
</dependency>
<!-- 关系型数据库整合时需配置 如hibernate jpa等 -->
<dependency>
<groupId>org.springframework</groupId>
<artifactId>spring-orm</artifactId>
<version>${spring.version}</version>
</dependency>
<!-- hibernate -->
<dependency>
<groupId>org.hibernate</groupId>
<artifactId>hibernate-core</artifactId>
<version>${hibernate.version}</version>
</dependency>
<dependency>
<groupId>org.hibernate</groupId>
<artifactId>hibernate-ehcache</artifactId>
<version>${hibernate.version}</version>
</dependency>
<!-- 二级缓存ehcache -->
<dependency>
<groupId>net.sf.ehcache</groupId>
<artifactId>ehcache</artifactId>
<version>2.9.0</version>
</dependency>
<!-- log4j -->
<dependency>
<groupId>log4j</groupId>
<artifactId>log4j</artifactId>
<version>1.2.17</version>
</dependency>
<!-- mysql连接 -->
<dependency>
<groupId>mysql</groupId>
<artifactId>mysql-connector-java</artifactId>
<version>5.1.34</version>
</dependency>
<!-- c3p0数据源 -->
<dependency>
<groupId>com.mchange</groupId>
<artifactId>c3p0</artifactId>
<version>0.9.5-pre10</version>
</dependency>
<!-- json -->
<dependency>
<groupId>com.alibaba</groupId>
<artifactId>fastjson</artifactId>
<version>1.2.3</version>
</dependency>
<dependency>
<groupId>com.fasterxml.jackson.core</groupId>
<artifactId>jackson-annotations</artifactId>
<version>${jackson.version}</version>
</dependency>
<dependency>
<groupId>com.fasterxml.jackson.core</groupId>
<artifactId>jackson-core</artifactId>
<version>${jackson.version}</version>
</dependency>
<dependency>
<groupId>com.fasterxml.jackson.core</groupId>
<artifactId>jackson-databind</artifactId>
<version>${jackson.version}</version>
</dependency>
<!-- aop -->
<dependency>
<groupId>org.aspectj</groupId>
<artifactId>aspectjweaver</artifactId>
<version>1.8.4</version>
</dependency>
<!-- JSP相关 -->
<dependency>
<groupId>jstl</groupId>
<artifactId>jstl</artifactId>
<version>1.2</version>
</dependency>
<dependency>
<groupId>javax.servlet</groupId>
<artifactId>servlet-api</artifactId>
<version>2.5</version>
<scope>provided</scope>
</dependency>
<dependency>
<groupId>javax.servlet</groupId>
<artifactId>jsp-api</artifactId>
<version>2.0</version>
<scope>provided</scope>
</dependency>
4.1.2 configure.properties
#application configs
#jdbc c3p0 config
jdbc.driver=com.mysql.jdbc.Driver
jdbc.url=jdbc:mysql://localhost:3306/db_test?useUnicode=true&characterEncoding=utf-8
jdbc.username=root
jdbc.password=123456
#hibernate config
hibernate.dialect=org.hibernate.dialect.MySQLDialect
hibernate.show_sql=true
hibernate.format_sql=true
hibernate.hbm2ddl.auto=create
hibernate.cache.use_second_level_cache=true
hibernate.cache.use_query_cache=true
hibernate.cache.region.factory_class=org.hibernate.cache.ehcache.EhCacheRegionFactory
hibernate.cache.provider_configuration_file_resource_path=ehcache.xml
4.1.3 spring.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"
xsi:schemaLocation="http://www.springframework.org/schema/beans
http://www.springframework.org/schema/beans/spring-beans-4.1.xsd
http://www.springframework.org/schema/context
http://www.springframework.org/schema/context/spring-context-4.1.xsd">
<!-- 加载配置文件 -->
<context:property-placeholder location="classpath:configer.properties"/>
<!-- 扫描service自动注入为bean -->
<context:component-scan base-package="cn.ssh.student" />
</beans>
4.1.4 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:tx="http://www.springframework.org/schema/tx"
xmlns:aop="http://www.springframework.org/schema/aop"
xsi:schemaLocation="
http://www.springframework.org/schema/beans
http://www.springframework.org/schema/beans/spring-beans-4.1.xsd
http://www.springframework.org/schema/tx
http://www.springframework.org/schema/tx/spring-tx-4.1.xsd
http://www.springframework.org/schema/aop
http://www.springframework.org/schema/aop/spring-aop-4.1.xsd">
<!-- 配置数据源 c3p0 -->
<bean id="dataSource" class="com.mchange.v2.c3p0.ComboPooledDataSource"
destroy-method="close">
<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="checkoutTimeout" value="30000" />
<!-- 每60秒检查所有连接池中的空闲连接。默认值: 0,不检查 -->
<property name="idleConnectionTestPeriod" value="30" />
<!-- 连接数据库连接池最大空闲时间 -->
<property name="maxIdleTime" value="30" />
<!-- 连接池初始化连接数 -->
<property name="initialPoolSize" value="5" />
<property name="minPoolSize" value="5" />
<property name="maxPoolSize" value="20" />
<!--当连接池中的连接耗尽的时候c3p0一次同时获取的连接数。默认值: 3 -->
<property name="acquireIncrement" value="5" />
</bean>
<!-- 配置hibernate的SessionFactory -->
<bean id="sessionFactory"
class="org.springframework.orm.hibernate4.LocalSessionFactoryBean">
<!-- 注入数据源 相关信息看源码 -->
<property name="dataSource" ref="dataSource" />
<!-- hibernate配置信息 -->
<property name="hibernateProperties">
<props>
<prop key="hibernate.dialect">${hibernate.dialect}</prop>
<prop key="hibernate.show_sql">${hibernate.show_sql}</prop>
<prop key="hibernate.format_sql">${hibernate.format_sql}</prop>
<prop key="hibernate.hbm2ddl.auto">${hibernate.hbm2ddl.auto}</prop>
<!-- 开启二级缓存 ehcache -->
<prop key="hibernate.cache.use_second_level_cache">${hibernate.cache.use_second_level_cache}</prop>
<prop key="hibernate.cache.use_query_cache">${hibernate.cache.use_query_cache}</prop>
<prop key="hibernate.cache.region.factory_class">${hibernate.cache.region.factory_class}</prop>
<prop key="hibernate.cache.provider_configuration_file_resource_path">${hibernate.cache.provider_configuration_file_resource_path}
</prop>
</props>
</property>
<!-- 扫描hibernate注解配置的entity -->
<property name="packagesToScan" value="cn.ssh.entity" />
</bean>
<!-- 配置事务管理器 -->
<bean id="transactionManager"
class="org.springframework.orm.hibernate4.HibernateTransactionManager">
<property name="sessionFactory" ref="sessionFactory" />
</bean>
<aop:aspectj-autoproxy/>
</beans>
4.1.5 Log4j的配置
### set log levels ###
log4j.rootLogger = INFO , C , D , E
### console ###
log4j.appender.C = org.apache.log4j.ConsoleAppender
log4j.appender.C.Target = System.out
log4j.appender.C.layout = org.apache.log4j.PatternLayout
log4j.appender.C.layout.ConversionPattern = [student][%p] [%-d{yyyy-MM-dd HH:mm:ss}] %C.%M(%L) | %m%n
### log file ###
log4j.appender.D = org.apache.log4j.DailyRollingFileAppender
log4j.appender.D.File = ./logs/student.log
log4j.appender.D.Append = true
log4j.appender.D.Threshold = INFO
log4j.appender.D.layout = org.apache.log4j.PatternLayout
log4j.appender.D.layout.ConversionPattern = [student][%p] [%-d{yyyy-MM-dd HH:mm:ss}] %C.%M(%L) | %m%n
### exception ###
log4j.appender.E = org.apache.log4j.DailyRollingFileAppender
log4j.appender.E.File = ./logs/student_error.log
log4j.appender.E.Append = true
log4j.appender.E.Threshold = ERROR
log4j.appender.E.layout = org.apache.log4j.PatternLayout
log4j.appender.E.layout.ConversionPattern = [student][%p] [%-d{yyyy-MM-dd HH:mm:ss}] %C.%M(%L) | %m%n
配置结构截图:
4.2 编写Entity
User代码:package cn.ssh.student.entity;
import java.io.Serializable;
import javax.persistence.Entity;
import javax.persistence.GeneratedValue;
import javax.persistence.GenerationType;
import javax.persistence.Id;
import javax.persistence.Table;
@Entity
@Table(name = "t_user")
public class User implements Serializable {
@Id
// 配置自动增长
@GeneratedValue(strategy = GenerationType.IDENTITY)
private Integer id;
private String userName;
private String password;
private Integer age;
private static final long serialVersionUID = 1L;
public Integer getId() {
return id;
}
public void setId(Integer id) {
this.id = id;
}
public String getUserName() {
return userName;
}
public void setUserName(String userName) {
this.userName = userName == null ? null : userName.trim();
}
public String getPassword() {
return password;
}
public void setPassword(String password) {
this.password = password == null ? null : password.trim();
}
public Integer getAge() {
return age;
}
public void setAge(Integer age) {
this.age = age;
}
@Override
public String toString() {
return "User [id=" + id + ", userName=" + userName + ", password=" + password + ", age=" + age + "]";
}
}
4.3 Dao层
4.3.1 GenericDao接口
package cn.ssh.student.dao;
import java.io.Serializable;
import java.util.List;
public interface GenericDao<T, PK extends Serializable> {
T load(PK id);
T get(PK id);
List<T> findAll();
void persist(T entity);
PK save(T entity);
void saveOrUpdate(T entity);
void delete(PK id);
void flush();
}
4.3.2 UserDao接口
package cn.ssh.student.dao;
import cn.ssh.student.entity.User;
public interface UserDao extends GenericDao<User, Integer> {
}
4.3.3 UserDao接口实现类
package cn.ssh.student.dao.impl;
import java.util.List;
import org.hibernate.Session;
import org.hibernate.SessionFactory;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Repository;
import cn.ssh.student.dao.UserDao;
import cn.ssh.student.entity.User;
@Repository
public class UserDaoImpl implements UserDao {
@Autowired
private SessionFactory sessionFactory;
private Session getCurrentSession() {
return this.sessionFactory.getCurrentSession();
}
@Override
public User load(String id) {
return (User) this.getCurrentSession().load(User.class, id);
}
@Override
public User get(String id) {
return (User) this.getCurrentSession().get(User.class, id);
}
@SuppressWarnings("unchecked")
@Override
public List<User> findAll() {
List<User> Users = this.getCurrentSession().createQuery("from User").setCacheable(true).list();
return Users;
}
@Override
public void persist(User entity) {
this.getCurrentSession().persist(entity);
}
@Override
public String save(User entity) {
return (String) this.getCurrentSession().save(entity);
}
@Override
public void saveOrUpdate(User entity) {
this.getCurrentSession().saveOrUpdate(entity);
}
@Override
public void delete(String id) {
User entity = this.load(id);
this.getCurrentSession().delete(entity);
}
@Override
public void flush() {
this.getCurrentSession().flush();
}
}
项目架构:
4.4 Service层
4.4.1 UserService接口
package cn.ssh.student.service;
import java.util.List;
import cn.ssh.student.entity.User;
public interface UserService {
User load(Integer id);
User get(Integer id);
List<User> findAll();
void persist(User entity);
Integer save(User entity);
void saveOrUpdate(User entity);
void delete(Integer id);
void flush();
}
4.4.2 UserService接口实现类
package cn.ssh.student.service.impl;
import java.util.List;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;
import org.springframework.transaction.annotation.Transactional;
import cn.ssh.student.dao.UserDao;
import cn.ssh.student.entity.User;
import cn.ssh.student.service.UserService;
@Service
public class UserServiceImpl implements UserService {
@Autowired
private UserDao userDao;
@Override
@Transactional(readOnly = true)
public User load(Integer id) {
return userDao.load(id);
}
@Override
@Transactional(readOnly = true)
public User get(Integer id) {
return userDao.get(id);
}
@Override
@Transactional(readOnly = true)
public List<User> findAll() {
return userDao.findAll();
}
@Override
@Transactional
public void persist(User entity) {
userDao.persist(entity);
}
@Override
@Transactional
public Integer save(User entity) {
return userDao.save(entity);
}
@Override
@Transactional
public void saveOrUpdate(User entity) {
userDao.saveOrUpdate(entity);
}
@Override
@Transactional
public void delete(Integer id) {
userDao.delete(id);
}
@Override
@Transactional
public void flush() {
userDao.flush();
}
}
4.5 测试
测试代码:
package cn.ssh.student.service;
import java.util.List;
import org.apache.log4j.Logger;
import org.junit.Test;
import org.junit.runner.RunWith;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.test.context.ContextConfiguration;
import org.springframework.test.context.junit4.SpringJUnit4ClassRunner;
import cn.ssh.student.entity.User;
@RunWith(SpringJUnit4ClassRunner.class)
@ContextConfiguration(locations = { "classpath:spring.xml", "classpath:spring-hibernate.xml" })
public class UserServiceTest {
private static final Logger LOGGER = Logger.getLogger(UserServiceTest.class);
@Autowired
private UserService userService;
@Test
public void testLoad() {
System.out.println(userService);
}
@Test
public void testGet() {
User user = userService.get(5);
System.out.println(user);
}
@Test
public void testFindAll() {
List<User> users = userService.findAll();
System.out.println(users);
}
@Test
public void testPersist() {
}
@Test
public void testSave() {
User user = new User();
user.setAge(1);
user.setPassword("123");
user.setUserName("李四");
userService.save(user);
}
@Test
public void testSaveOrUpdate() {
}
@Test
public void testDelete() {
}
@Test
public void testFlush() {
}
}
执行testLoad()测试方法,测试成功,数据库自动生成表:
5 整合SpringMVC
5.1 spring-mvc.xml
<?xml version="1.0" encoding="UTF-8"?>
<beans xmlns="http://www.springframework.org/schema/beans"
xmlns:mvc="http://www.springframework.org/schema/mvc" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xmlns:p="http://www.springframework.org/schema/p" xmlns:context="http://www.springframework.org/schema/context"
xsi:schemaLocation="http://www.springframework.org/schema/beans
http://www.springframework.org/schema/beans/spring-beans-4.1.xsd
http://www.springframework.org/schema/context
http://www.springframework.org/schema/context/spring-context-4.1.xsd
http://www.springframework.org/schema/mvc
http://www.springframework.org/schema/mvc/spring-mvc-4.1.xsd">
<!-- 自动扫描@Controller注入为bean -->
<context:component-scan base-package="cn.ssh.student.controller" />
<!-- 以下为SpringMVC配置 -->
<mvc:annotation-driven>
<!-- 返回json数据,@response使用 -->
<mvc:message-converters register-defaults="true">
<bean
class="org.springframework.http.converter.json.MappingJackson2HttpMessageConverter">
<property name="supportedMediaTypes">
<list>
<value>text/html;charset=UTF-8</value>
<value>application/json;charset=UTF-8</value>
</list>
</property>
</bean>
</mvc:message-converters>
</mvc:annotation-driven>
<!-- 对模型视图名称的解析,即在模型视图名称添加前后缀 -->
<bean
class="org.springframework.web.servlet.view.InternalResourceViewResolver">
<property name="viewClass"
value="org.springframework.web.servlet.view.JstlView" />
<property name="prefix" value="/" />
<property name="suffix" value=".jsp" />
</bean>
</beans>
spring-mvc的配置信息可以直接整合在spring-hibernate.xml这个配置文件中。
5.2 web.xml
<?xml version="1.0" encoding="UTF-8"?>
<web-app version="2.5" xmlns="http://java.sun.com/xml/ns/javaee"
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xsi:schemaLocation="http://java.sun.com/xml/ns/javaee
http://java.sun.com/xml/ns/javaee/web-app_2_5.xsd">
<display-name>Archetype Created Web Application</display-name>
<context-param>
<param-name>contextConfigLocation</param-name>
<param-value>classpath:spring.xml,classpath:spring-hibernate.xml</param-value>
</context-param>
<filter>
<filter-name>encodingFilter</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>encodingFilter</filter-name>
<url-pattern>/*</url-pattern>
</filter-mapping>
<!-- openSessionInView配置 作用是延迟session关闭到view层 -->
<filter>
<filter-name>openSessionInViewFilter</filter-name>
<filter-class>org.springframework.orm.hibernate4.support.OpenSessionInViewFilter</filter-class>
<init-param>
<param-name>singleSession</param-name>
<param-value>true</param-value>
</init-param>
</filter>
<filter-mapping>
<filter-name>openSessionInViewFilter</filter-name>
<url-pattern>*.jsp</url-pattern>
</filter-mapping>
<!-- 监听servletContext,启动contextConfigLocation中的spring配置信息 -->
<listener>
<listener-class>org.springframework.web.context.ContextLoaderListener</listener-class>
</listener>
<!-- 防止spring内存溢出监听器 -->
<listener>
<listener-class>org.springframework.web.util.IntrospectorCleanupListener</listener-class>
</listener>
<!-- Spring MVC servlet -->
<servlet>
<description>spring mvc servlet</description>
<servlet-name>SpringMVC</servlet-name>
<servlet-class>org.springframework.web.servlet.DispatcherServlet</servlet-class>
<init-param>
<param-name>contextConfigLocation</param-name>
<!-- 此处配置的是SpringMVC的配置文件 -->
<param-value>classpath:spring-mvc.xml</param-value>
</init-param>
<load-on-startup>1</load-on-startup>
</servlet>
<servlet-mapping>
<servlet-name>SpringMVC</servlet-name>
<url-pattern>*.do</url-pattern>
</servlet-mapping>
<!-- 配置session超时时间,单位分钟 -->
<session-config>
<session-timeout>30</session-timeout>
</session-config>
<welcome-file-list>
<welcome-file>/index.jsp</welcome-file>
</welcome-file-list>
</web-app>
6 项目运行
内置tomcat运行
启动时为:tomcat7:run 因为在配置pom.xml中配置了tomcat插件的名字。
启动项目:
点击【Run】
启动成功:
7 用户管理
7.1 增加用户
页面预览
添加界面效果如图:
输入内容,并提交
7.1.1 后台代码
Controller层:
// 添加
@RequestMapping("/add")
public String add(User user) {
userService.save(user);
// 重定向到查询所有用户
return "redirect:getAll.do";
}
// 查询所有的用户
@RequestMapping("/getAll")
public String getAll(Model model) {
List<User> list = userService.findAll();
model.addAttribute("userList", list);
return "show";
}
Service层:
@Override
@Transactional
public Integer save(User entity) {
return userDao.save(entity);
}
@Override
@Transactional(readOnly = true)
public List<User> findAll() {
return userDao.findAll();
}
7.1.2 页面代码
<%@ page language="java" contentType="text/html; charset=UTF-8"
pageEncoding="UTF-8" %>
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<title>Insert title here</title>
</head>
<body>
<form action="student/add.do" method="post">
姓名:<input name="userName" />
年龄:<input name="age" />
密码:<input name="password"/>
<input type="submit"/>
</form>
</body>
</html>
查看所有页面代码(show.jsp):
<%@ page language="java" contentType="text/html; charset=UTF-8"
pageEncoding="UTF-8"%>
<%@ taglib prefix="c" uri="http://java.sun.com/jsp/jstl/core"%>
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<head>
<title>测试</title>
</head>
<body>
<c:forEach var="user" items="${userList}">
${user.id} ${user.userName} <a href="delete.do?id=${user.id }">删除</a> <a href="proupdate.do?id=${user.id }">更新</a> <br/>
</c:forEach>
<a href="/add.jsp">新增</a>
</body>
</html>
7.2 查找用户
在浏览器中输入地址:http://localhost:8080/student/getById.do?id=2
7.2.1 后台代码
Controller层:
// 查询某一个用户
@RequestMapping("/getById")
public String getById(Integer id, Model model) {
User user = userService.get(id);
model.addAttribute("user", user);
// 转发到showUser.jsp页面
return "showUser";
}
Service层
@Override
@Transactional(readOnly = true)
public User get(Integer id) {
return userDao.get(id);
}
7.2.2 页面代码
showUser.jsp:
<%@ page language="java" contentType="text/html; charset=UTF-8"
pageEncoding="UTF-8" %>
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<head>
<title>查询单个用户</title>
</head>
<body>
${user.id} ${user.userName}
</body>
</html>
7.3 修改用户
查询所有用户,地址:http://localhost:8080/student/getAll.do
点击王武后面的【更新】
结果:
7.3.1 后台代码
Controller层:
@RequestMapping("/update")
public String update(User user){
userService.saveOrUpdate(user);
// 更新成功,重定向查询所有
return "redirect:getAll.do";
}
//更新之前
@RequestMapping("/proupdate")
public String proUpdate(Integer id,Model model){
User user = userService.get(id);
model.addAttribute("user",user);
return "update";
}
Service层:
@Override
@Transactional(readOnly = true)
public User get(Integer id) {
return userDao.get(id);
}
@Override
@Transactional
public void saveOrUpdate(User entity) {
userDao.saveOrUpdate(entity);
}
7.3.2 页面代码
update.jsp:
<%@ page language="java" contentType="text/html; charset=UTF-8"
pageEncoding="UTF-8"%>
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<title>Insert title here</title>
</head>
<body>
<form action="update.do" method="post">
<input type="hidden" name="id" value="${user.id }"/>
姓名:<input name="userName" value="${user.userName }" />
年龄:<input name="age" value="${user.age }"/>
密码:<input name="password" value="${user.password }"/>
<input type="submit"/>
</form>
</body>
</html>
7.4 删除用户
点击【删除】
7.4.1 后台代码
Controller层:
// 删除某一个用户
@RequestMapping("/delete")
public String delete(Integer id,Model model) {
userService.delete(id);
// 重定向到查询所有的用户
return "redirect:getAll.do";
}
Service层:
@Override
@Transactional
public void delete(Integer id) {
userDao.delete(id);
}
8 项目下载
9 参考博客
http://blog.csdn.net/Ethan_Fu/article/details/49449369