原创转载请注明出处:http://agilestyle.iteye.com/blog/2377160
Project Directory
Maven Dependency
<project xmlns="http://maven.apache.org/POM/4.0.0" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 http://maven.apache.org/maven-v4_0_0.xsd"> <modelVersion>4.0.0</modelVersion> <groupId>org.fool.ms</groupId> <artifactId>mybatis-spring</artifactId> <packaging>war</packaging> <version>1.0-SNAPSHOT</version> <name>mybatis-spring Maven Webapp</name> <url>http://maven.apache.org</url> <dependencies> <dependency> <groupId>org.springframework</groupId> <artifactId>spring-context</artifactId> <version>4.3.8.RELEASE</version> <exclusions> <exclusion> <groupId>commons-logging</groupId> <artifactId>commons-logging</artifactId> </exclusion> </exclusions> </dependency> <dependency> <groupId>org.springframework</groupId> <artifactId>spring-webmvc</artifactId> <version>4.3.8.RELEASE</version> </dependency> <dependency> <groupId>org.springframework</groupId> <artifactId>spring-jdbc</artifactId> <version>4.3.8.RELEASE</version> </dependency> <dependency> <groupId>org.mybatis</groupId> <artifactId>mybatis</artifactId> <version>3.4.4</version> </dependency> <dependency> <groupId>org.mybatis</groupId> <artifactId>mybatis-spring</artifactId> <version>1.3.1</version> </dependency> <dependency> <groupId>com.fasterxml.jackson.core</groupId> <artifactId>jackson-databind</artifactId> <version>2.8.8.1</version> </dependency> <dependency> <groupId>org.apache.commons</groupId> <artifactId>commons-lang3</artifactId> <version>3.5</version> </dependency> <dependency> <groupId>commons-dbcp</groupId> <artifactId>commons-dbcp</artifactId> <version>1.4</version> </dependency> <dependency> <groupId>javax.servlet</groupId> <artifactId>jstl</artifactId> <version>1.2</version> </dependency> <dependency> <groupId>mysql</groupId> <artifactId>mysql-connector-java</artifactId> <version>5.1.42</version> </dependency> <dependency> <groupId>junit</groupId> <artifactId>junit</artifactId> <version>4.12</version> <scope>test</scope> </dependency> </dependencies> <build> <resources> <resource> <directory>src/main/java</directory> <includes> <include>**/*.xml</include> </includes> <filtering>false</filtering> </resource> </resources> <plugins> <plugin> <groupId>org.apache.maven.plugins</groupId> <artifactId>maven-compiler-plugin</artifactId> <version>3.6.1</version> <configuration> <source>1.8</source> <target>1.8</target> </configuration> </plugin> <plugin> <groupId>org.apache.tomcat.maven</groupId> <artifactId>tomcat7-maven-plugin</artifactId> <version>2.2</version> <configuration> <port>8080</port> <path>/ms</path> </configuration> </plugin> </plugins> </build> </project>
web.xml
<?xml version="1.0" encoding="UTF-8"?> <web-app version="3.0" 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_3_0.xsd"> <context-param> <param-name>contextConfigLocation</param-name> <param-value>/WEB-INF/spring/root-context.xml</param-value> </context-param> <listener> <listener-class>org.springframework.web.context.ContextLoaderListener</listener-class> </listener> <servlet> <servlet-name>appServlet</servlet-name> <servlet-class>org.springframework.web.servlet.DispatcherServlet</servlet-class> <init-param> <param-name>contextConfigLocation</param-name> <param-value>/WEB-INF/spring/servlet-context.xml</param-value> </init-param> <load-on-startup>1</load-on-startup> </servlet> <servlet-mapping> <servlet-name>appServlet</servlet-name> <url-pattern>/</url-pattern> </servlet-mapping> <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> <welcome-file-list> <welcome-file>index.jsp</welcome-file> </welcome-file-list> </web-app>
root-context.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: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/tx http://www.springframework.org/schema/tx/spring-tx.xsd http://www.springframework.org/schema/context http://www.springframework.org/schema/context/spring-context.xsd"> <context:annotation-config/> <context:component-scan base-package="org.fool.ms"/> <context:property-placeholder location="classpath:jdbc.properties"/> <bean id="dataSource" class="org.apache.commons.dbcp.BasicDataSource"> <property name="driverClassName" value="${jdbc.driverClassName}"/> <property name="url" value="${jdbc.url}"/> <property name="username" value="${jdbc.username}"/> <property name="password" value="${jdbc.password}"/> </bean> <bean id="sqlSessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean"> <property name="dataSource" ref="dataSource"/> <property name="configLocation" value="classpath:mybatis-config.xml"/> <property name="mapperLocations" value="classpath:org/fool/ms/dao/*.xml"/> </bean> <bean class="org.mybatis.spring.mapper.MapperScannerConfigurer"> <property name="basePackage" value="org.fool.ms.dao"/> <property name="sqlSessionFactoryBeanName" value="sqlSessionFactory"/> </bean> <bean id="txManager" class="org.springframework.jdbc.datasource.DataSourceTransactionManager"> <property name="dataSource" ref="dataSource"/> </bean> <tx:annotation-driven transaction-manager="txManager"/> </beans>
servlet-context.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:mvc="http://www.springframework.org/schema/mvc" xsi:schemaLocation="http://www.springframework.org/schema/mvc http://www.springframework.org/schema/mvc/spring-mvc.xsd http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans.xsd http://www.springframework.org/schema/context http://www.springframework.org/schema/context/spring-context.xsd"> <mvc:annotation-driven/> <mvc:resources location="/resources/" mapping="/resources/**"/> <bean class="org.springframework.web.servlet.view.InternalResourceViewResolver"> <property name="prefix" value="/WEB-INF/views/"/> <property name="suffix" value=".jsp"/> </bean> <context:component-scan base-package="org.fool.ms.controller"/> </beans>
src/main/resources
mybatis-config.xml
<?xml version="1.0" encoding="UTF-8"?> <!DOCTYPE configuration PUBLIC "-//mybatis.org//DTD Config 3.0//EN" "http://mybatis.org/dtd/mybatis-3-config.dtd"> <configuration> <settings> <setting name="cacheEnabled" value="true"/> <setting name="useGeneratedKeys" value="true"/> <setting name="defaultExecutorType" value="REUSE"/> <setting name="lazyLoadingEnabled" value="true"/> <setting name="defaultStatementTimeout" value="25000"/> <setting name="mapUnderscoreToCamelCase" value="true"/> </settings> <typeAliases> <typeAlias type="org.fool.ms.domain.User" alias="user"/> </typeAliases> </configuration>
jdbc.properties
jdbc.databaseName=test jdbc.driverClassName = com.mysql.jdbc.Driver jdbc.url=jdbc:mysql://localhost:3306/${jdbc.databaseName}?useUnicode=true&characterEncoding=UTF-8 jdbc.username=root jdbc.password=123456
schema.sql
drop table if exists t_user;
create table t_user
(
id int(11) not null auto_increment,
username varchar(20) not null,
password varchar(20) not null,
nickname varchar(20) not null,
email varchar(30) not null,
primary key(id)
);
insert into t_user(username, password, nickname, email)
values("mybatis", "mybatis", "mybatis", "mybatis@mvc.org");
insert into t_user(username, password, nickname, email)
values("mybatis", "mybatis", "mybatis", "mybatis@mvc.org");
insert into t_user(username, password, nickname, email)
values("mybatis", "mybatis", "mybatis", "mybatis@mvc.org");
insert into t_user(username, password, nickname, email)
values("mybatis", "mybatis", "mybatis", "mybatis@mvc.org");
insert into t_user(username, password, nickname, email)
values("mybatis", "mybatis", "mybatis", "mybatis@mvc.org");
src/main/java
User.java
package org.fool.ms.domain;
import org.apache.commons.lang3.builder.ToStringBuilder;
import org.apache.commons.lang3.builder.ToStringStyle;
public class User {
private int id;
private String username;
private String password;
private String nickname;
private String email;
public User() {
}
@Override
public String toString() {
return ToStringBuilder.reflectionToString(this, ToStringStyle.SHORT_PREFIX_STYLE);
}
public int getId() {
return id;
}
public void setId(int id) {
this.id = id;
}
public String getUsername() {
return username;
}
public void setUsername(String username) {
this.username = username;
}
public String getPassword() {
return password;
}
public void setPassword(String password) {
this.password = password;
}
public String getNickname() {
return nickname;
}
public void setNickname(String nickname) {
this.nickname = nickname;
}
public String getEmail() {
return email;
}
public void setEmail(String email) {
this.email = email;
}
}
UserDAO.java
package org.fool.ms.dao;
import org.fool.ms.domain.User;
import org.springframework.stereotype.Repository;
import java.util.List;
@Repository
public interface UserDAO {
User getUser(int id);
int deleteUser(int id);
int insertUser(User user);
int updateUser(User user);
List<User> findUsers();
}
user.xml
<?xml version="1.0" encoding="UTF-8"?> <!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" "http://mybatis.org/dtd/mybatis-3-mapper.dtd"> <mapper namespace="org.fool.ms.dao.UserDAO"> <select id="getUser" parameterType="int" resultType="user"> SELECT id, username, password, nickname, email FROM t_user WHERE id = #{id} </select> <delete id="deleteUser" parameterType="int"> DELETE FROM t_user WHERE id = #{id} </delete> <insert id="insertUser" parameterType="user"> INSERT INTO t_user(username, password, nickname, email) VALUES(#{username}, #{password}, #{nickname}, #{email}) </insert> <update id="updateUser" parameterType="user"> UPDATE t_user <set> <if test="username != null">username = #{username}, </if> <if test="password != null">password = #{password}, </if> <if test="nickname != null">nickname = #{nickname}, </if> <if test="email != null">email = #{email}</if> </set> WHERE id = #{id} </update> <select id="findUsers" resultType="user"> SELECT id, username, password, nickname, email FROM t_user </select> </mapper>
UserService.java
package org.fool.ms.service;
import org.fool.ms.domain.User;
import java.util.List;
public interface UserService {
User getUser(int id);
int insertUser(User user);
int deleteUser(int id);
int updateUser(User user);
List<User> findUsers();
}
UserServiceImpl.java
package org.fool.ms.service.impl;
import org.fool.ms.dao.UserDAO;
import org.fool.ms.domain.User;
import org.fool.ms.service.UserService;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;
import org.springframework.transaction.annotation.Propagation;
import org.springframework.transaction.annotation.Transactional;
import java.util.List;
@Service
public class UserSeviceImpl implements UserService {
@Autowired
private UserDAO userDAO;
@Override
@Transactional(propagation = Propagation.SUPPORTS)
public User getUser(int id) {
return this.userDAO.getUser(id);
}
@Override
@Transactional(propagation = Propagation.REQUIRED)
public int insertUser(User user) {
return this.userDAO.insertUser(user);
}
@Override
@Transactional(propagation = Propagation.REQUIRED)
public int deleteUser(int id) {
return this.userDAO.deleteUser(id);
}
@Override
@Transactional(propagation = Propagation.REQUIRED)
public int updateUser(User user) {
return this.userDAO.updateUser(user);
}
@Override
@Transactional(propagation = Propagation.SUPPORTS)
public List<User> findUsers() {
return this.userDAO.findUsers();
}
}
UserController.java
package org.fool.ms.controller;
import org.fool.ms.domain.User;
import org.fool.ms.service.UserService;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Controller;
import org.springframework.ui.Model;
import org.springframework.validation.BindingResult;
import org.springframework.validation.annotation.Validated;
import org.springframework.web.bind.annotation.*;
@Controller
@RequestMapping("/user")
public class UserController {
@Autowired
private UserService userService;
@GetMapping("/{id}")
@ResponseBody
public User getUser(@PathVariable int id) {
return userService.getUser(id);
}
@GetMapping("/users")
public String list(Model model) {
model.addAttribute("users", userService.findUsers());
return "user/list";
}
@GetMapping("/add")
public String add(@ModelAttribute("user") User user, Model model) {
return "user/add";
}
@PostMapping("/add")
public String add(@Validated User user, BindingResult bindingResult) {
if (bindingResult.hasErrors()) {
return "user/add";
}
userService.insertUser(user);
return "redirect:/user/users";
}
@GetMapping("/{id}/update")
public String update(@PathVariable int id, Model model) {
model.addAttribute("user", userService.getUser(id));
return "user/update";
}
@PostMapping("/{id}/update")
public String update(@PathVariable int id, @Validated User user, BindingResult bindingResult) {
if (bindingResult.hasErrors()) {
return "user/update";
}
userService.updateUser(user);
return "redirect:/user/users";
}
@GetMapping("/{id}/delete")
public String delete(@PathVariable int id) {
userService.deleteUser(id);
return "redirect:/user/users";
}
}
src/main/webapp
add.jsp
<%@ page contentType="text/html;charset=UTF-8" language="java" %>
<%@ taglib prefix="form" uri="http://www.springframework.org/tags/form" %>
<html>
<head>
<title>user add</title>
</head>
<body>
<form:form method="post" modelAttribute="user">
<table width="800" align="center" border="1">
<tr>
<td>username:</td>
<td><form:input path="username"/>
<form:errors path="username"/>
</td>
</tr>
<tr>
<td>password:</td>
<td><form:password path="password"/>
<form:errors path="password"/>
</td>
</tr>
<tr>
<td>nickname:</td>
<td><form:input path="nickname"/>
<form:errors path="nickname"/>
</td>
</tr>
<tr>
<td>email:</td>
<td><form:input path="email"/>
<form:errors path="email"/>
</td>
</tr>
<tr>
<td colspan="2" align="center">
<input type="submit" value="add"/>
</td>
</tr>
</table>
</form:form>
</body>
</html>
list.jsp
<%@ page contentType="text/html;charset=UTF-8" language="java" %>
<%@taglib prefix="c" uri="http://java.sun.com/jsp/jstl/core" %>
<html>
<head>
<title>user list</title>
</head>
<body>
<table width="700" align="center" border="1">
<c:forEach items="${users}" var="user">
<tr>
<td><a href="${user.id }">${user.id}</a></td>
<td>${user.username}</td>
<td>${user.password}</td>
<td>${user.nickname}</td>
<td>${user.email}</td>
<td>
<a href="${user.id }/update">update</a>
<a href="${user.id }/delete">delete</a>
</td>
</tr>
</c:forEach>
</table>
</body>
</html>
update.jsp
<%@ page contentType="text/html;charset=UTF-8" language="java" %>
<%@ taglib prefix="form" uri="http://www.springframework.org/tags/form" %>
<html>
<head>
<title>user update</title>
</head>
<body>
<form:form method="post" modelAttribute="user">
<table width="800" align="center" border="1">
<tr>
<td>Username:</td>
<td><form:input path="username" readonly="true"/></td>
</tr>
<tr>
<td>Password:</td>
<td><form:password path="password"/>
<form:errors path="password"/>
</td>
</tr>
<tr>
<td>Nickname:</td>
<td>
<form:input path="nickname"/>
<form:errors path="nickname"/>
</td>
</tr>
<tr>
<td>Email:</td>
<td><form:input path="email"/>
<form:errors path="email"/>
</td>
</tr>
<tr>
<td colspan="2" align="center">
<input type="submit" value="update"/>
</td>
</tr>
</table>
</form:form>
</body>
</html>
index.jsp
<%
response.sendRedirect("user/users");
%>
Test
tomcat7:run
http://localhost:8080/ms/user/users
http://localhost:8080/ms/user/1
http://localhost:8080/ms/user/2/update
http://localhost:8080/ms/user/2/delete
http://localhost:8080/ms/user/add