概述
前文記錄了Spring MVC的常用功能和MyBatis的基本用法骄酗。在實際的項目開發(fā)中,需要進行整合国葬,從而使用Spring的依賴注入來減少代碼的耦合,使用Spring MVC處理請求并作出響應,使用MyBatis完成數(shù)據庫操作汇四。
數(shù)據準備
在前文創(chuàng)建的mybatis數(shù)據庫中刪除表tb_user重新創(chuàng)建該表接奈,同時新建一張表tb_book,表設計和測試數(shù)據如下:
創(chuàng)建/配置項目
創(chuàng)建項目的步驟此處不再贅述通孽,與SpringMVC創(chuàng)建相同(前文鏈接:http://www.reibang.com/p/fde4557c527c)序宦。
項目目錄結構如圖:
打開項目的pom文件,添加Spring背苦、Spring MVC互捌、Mybatis和連接MySQL數(shù)據庫的包依賴:
<?xml version="1.0" encoding="UTF-8"?>
<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/xsd/maven-4.0.0.xsd">
<modelVersion>4.0.0</modelVersion>
<groupId>com.snow</groupId>
<artifactId>ssmbookproject</artifactId>
<version>1.0-SNAPSHOT</version>
<packaging>war</packaging>
<name>ssmbookproject Maven Webapp</name>
<!-- FIXME change it to the project's website -->
<url>http://www.example.com</url>
<properties>
<project.build.sourceEncoding>UTF-8</project.build.sourceEncoding>
<maven.compiler.source>1.7</maven.compiler.source>
<maven.compiler.target>1.7</maven.compiler.target>
<!-- spring版本號 -->
<spring.version>4.3.10.RELEASE</spring.version>
<!-- mybatis版本號 -->
<mybatis.version>3.4.6</mybatis.version>
</properties>
<dependencies>
<dependency>
<groupId>junit</groupId>
<artifactId>junit</artifactId>
<version>4.11</version>
<scope>test</scope>
</dependency>
<!-- 數(shù)據庫 -->
<dependency>
<groupId>mysql</groupId>
<artifactId>mysql-connector-java</artifactId>
<version>5.1.37</version>
<scope>runtime</scope>
</dependency>
<dependency>
<!--jdbc連接池-->
<groupId>c3p0</groupId>
<artifactId>c3p0</artifactId>
<version>0.9.1.2</version>
</dependency>
<!-- DAO: MyBatis -->
<dependency>
<groupId>org.mybatis</groupId>
<artifactId>mybatis</artifactId>
<version>3.3.0</version>
</dependency>
<dependency>
<groupId>org.mybatis</groupId>
<artifactId>mybatis-spring</artifactId>
<version>1.2.3</version>
</dependency>
<!-- Servlet web -->
<dependency>
<groupId>taglibs</groupId>
<artifactId>standard</artifactId>
<version>1.1.2</version>
</dependency>
<dependency>
<groupId>jstl</groupId>
<artifactId>jstl</artifactId>
<version>1.2</version>
</dependency>
<!--Gson-->
<dependency>
<groupId>com.google.code.gson</groupId>
<artifactId>gson</artifactId>
<version>2.8.2</version>
</dependency>
<dependency>
<groupId>javax.servlet</groupId>
<artifactId>javax.servlet-api</artifactId>
<version>3.1.0</version>
</dependency>
<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-jdbc</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-webmvc</artifactId>
<version>${spring.version}</version>
</dependency>
<dependency>
<groupId>org.springframework</groupId>
<artifactId>spring-test</artifactId>
<version>${spring.version}</version>
</dependency>
<dependency>
<groupId>org.projectlombok</groupId>
<artifactId>lombok</artifactId>
<version>1.16.22</version>
</dependency>
</dependencies>
<build>
<finalName>bookproj</finalName>
<pluginManagement><!-- lock down plugins versions to avoid using Maven defaults (may be moved to parent pom) -->
<plugins>
<plugin>
<artifactId>maven-clean-plugin</artifactId>
<version>3.1.0</version>
</plugin>
<!-- see http://maven.apache.org/ref/current/maven-core/default-bindings.html#Plugin_bindings_for_war_packaging -->
<plugin>
<artifactId>maven-resources-plugin</artifactId>
<version>3.0.2</version>
</plugin>
<plugin>
<artifactId>maven-compiler-plugin</artifactId>
<version>3.8.0</version>
</plugin>
<plugin>
<artifactId>maven-surefire-plugin</artifactId>
<version>2.22.1</version>
</plugin>
<plugin>
<artifactId>maven-war-plugin</artifactId>
<version>3.2.2</version>
</plugin>
<plugin>
<artifactId>maven-install-plugin</artifactId>
<version>2.5.2</version>
</plugin>
<plugin>
<artifactId>maven-deploy-plugin</artifactId>
<version>2.8.2</version>
</plugin>
</plugins>
</pluginManagement>
</build>
</project>
在項目的resources目錄下創(chuàng)建jdbc.properties文件,編寫如下內容:
jdbc.driver=com.mysql.jdbc.Driver
jdbc.url=jdbc:mysql://localhost:3306/mybatis?useUnicode=true&characterEncoding=utf8
jdbc.username=root
#“****”是mysql數(shù)據庫密碼
jdbc.password=****
#最大連接數(shù)
maxPoolSize=20
#最小連接數(shù)
minPoolSize=10
#連接超時時間
checkoutTimeout=60000
#失敗重連次數(shù)
acquireRetryAttempts=3
在項目的resources目錄下創(chuàng)建applicationContext.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.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/springtx.xsd">
<!--配合MyBatis-->
<!--數(shù)據庫配置文件-->
<context:property-placeholder location="classpath:jdbc.properties"/>
<!--數(shù)據庫連接池-->
<bean id="dataSource" class="com.mchange.v2.c3p0.ComboPooledDataSource">
<!--配置連接池屬性-->
<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="maxPoolSize" value="${maxPoolSize}"/>
<property name="minPoolSize" value="${minPoolSize}"/>
<property name="autoCommitOnClose" value="false"/>
<property name="checkoutTimeout" value="${checkoutTimeout}"/>
<property name="acquireRetryAttempts" value="${acquireRetryAttempts}"/>
</bean>
<!-- 配置 SqlSessionFactory 對象-->
<bean id="sqlSessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean">
<!--注入數(shù)據庫連接池-->
<property name="dataSource" ref="dataSource"/>
<!-- MyBaties 配置?件 -->
<property name="configLocation" value="classpath:mybatis-config.xml"/>
<!-- 掃描mapper 需要的 xml ?件 -->
<property name="mapperLocations" value="classpath:mapper/*.xml"/>
</bean>
<!-- 配置掃描 mapper 接?包秕噪, 動態(tài)實現(xiàn) mapper 接?, 注?到 Spring 容器中 -->
<bean class="org.mybatis.spring.mapper.MapperScannerConfigurer">
<!-- 注? sqlSessionFactory -->
<property name="sqlSessionFactoryBeanName" value="sqlSessionFactory"/>
<!-- 給出需要掃描 mapper 接?包 -->
<property name="basePackage" value="com.snow.mapper"/>
</bean>
<!--spring-service-->
<!-- 掃描 service 包下所有使?注解的類型 -->
<context:component-scan base-package="com.snow.service"/>
<!-- 配置事務管理器 -->
<bean id="transactionManager"
class="org.springframework.jdbc.datasource.DataSourceTransactionManager">
<!-- 注?數(shù)據庫連接池 -->
<property name="dataSource" ref="dataSource"/>
</bean>
</beans>
在項目的resources目錄下創(chuàng)建springmvc-sevlet.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:p="http://www.springframework.org/schema/p"
xmlns:context="http://www.springframework.org/schema/context"
xmlns:mvc="http://www.springframework.org/schema/mvc"
xsi:schemaLocation="http://www.springframework.org/schema/beans
http://www.springframework.org/schema/beans/spring-beans.xsd
http://www.springframework.org/schema/mvc
http://www.springframework.org/schema/mvc/spring-mvc-4.0.xsd
http://www.springframework.org/schema/context
http://www.springframework.org/schema/context/spring-context.xsd">
<!--spring可以自動掃描base-package設置的包或子包下的java類腌巾,如果掃描到有spring相關注解的類,則注冊為spring的bean-->
<context:component-scan base-package="com.snow.controller"/>
<!-- 配置注解驅動 -->
<mvc:annotation-driven/>
<!-- 視圖解析器 -->
<bean class="org.springframework.web.servlet.view.InternalResourceViewResolver">
<!--前綴-->
<property name="prefix" value="/WEB-INF/views/"/>
<!--后綴-->
<property name="suffix" value=".jsp"/>
</bean>
<!--靜態(tài)資源默認servlet配置:1铲觉、加?對靜態(tài)資源js澈蝙、gif、png的處理撵幽;2灯荧、允許使?"/"做整體映射-->
<mvc:default-servlet-handler/>
</beans>
在項目的web.xml文件中編寫如下內容:
<!DOCTYPE web-app PUBLIC
"-//Sun Microsystems, Inc.//DTD Web Application 2.3//EN"
"http://java.sun.com/dtd/web-app_2_3.dtd" >
<web-app>
<display-name>ssmbookproject</display-name>
<welcome-file-list>
<welcome-file>login.jsp</welcome-file>
</welcome-file-list>
<!--Spring MVC 配置并添加監(jiān)聽-->
<context-param>
<param-name>contextConfigLocation</param-name>
<param-value>classpath:applicationContext.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>
</filter>
<filter-mapping>
<filter-name>encodingFilter</filter-name>
<url-pattern>/*</url-pattern>
</filter-mapping>
<listener>
<listener-class>org.springframework.web.context.ContextLoaderListener</listener-class>
</listener>
<!--配置前端控制器 進行請求分發(fā) DispatcherServlet本質也是一個Servlet -->
<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:springmvc-sevlet.xml</param-value>
</init-param>
<!--標記容器啟動的時候就啟動這個servlet-->
<load-on-startup>1</load-on-startup>
</servlet>
<servlet-mapping>
<servlet-name>SpringMVC</servlet-name>
<!--攔截所有-->
<url-pattern>/</url-pattern>
</servlet-mapping>
</web-app>
程序開發(fā)
編寫POJO
在com.snow.domain包中創(chuàng)建User.java類文件,編寫如下程序:
@Data
public class User implements Serializable {
private Integer id;
private String loginname;
private String password;
private String username;
private String phone;
private String address;
}
再創(chuàng)建Book.java類文件盐杂,編寫如下程序:
@Data
public class Book implements Serializable {
private Integer id;
private String name;
private String author;
private String publication;
private Date publicationdate;
private Double price;
private String image;
private String remark;
}
編寫mapper接口
在com.snow.mapper包中創(chuàng)建UserMapper.java接口文件漏麦,編寫如下程序:
public interface UserMapper {
User findWithLoginnameAndPassword(@Param("loginname") String loginname, @Param("password") String password);
}
再創(chuàng)建BookMapper.java接口文件,編寫如下程序:
public interface BookMapper {
List<Book> findAll();
}
編寫Service和ServiceImpl
在com.snow.service包中創(chuàng)建UserService.java接口文件况褪,編寫如下程序:
public interface UserService {
User login(String loginname, String password);
}
再創(chuàng)建BookService.java接口文件撕贞,編寫如下程序:
public interface BookService {
List<Book> getAll();
}
在com.snow.service.impl包中創(chuàng)建UserServiceImpl.java類文件,編寫如下程序:
@Service
public class UserServiceImpl implements UserService {
@Autowired
private UserMapper userMapper;
@Override
public User login(String loginname, String password){
return userMapper.findWithLoginnameAndPassword(loginname,password);
}
}
再創(chuàng)建BookServiceImpl.java類文件测垛,編寫如下程序:
@Service
public class BookServiceImpl implements BookService {
@Autowired
private BookMapper bookMapper;
@Override
public List<Book> getAll(){
return bookMapper.findAll();
}
}
編寫Controller
在com.snow.controller包中創(chuàng)建UserController.java類文件捏膨,編寫如下程序:
@Controller
public class UserController {
@Autowired
private UserService userService;
@RequestMapping(value = "/login")
public ModelAndView login(String loginname, String password, ModelAndView modelAndView, HttpSession httpSession) {
User user = userService.login(loginname, password);
if (user != null) {
httpSession.setAttribute("user", user);
modelAndView.setView(new RedirectView("main"));
} else {
modelAndView.setViewName("error");
}
return modelAndView;
}
}
再創(chuàng)建BookController.java類文件,編寫如下程序:
@Controller
public class BookController {
@Autowired
private BookService bookService;
@RequestMapping(value = "/main")
public String main(Model model) {
List<Book> bookList = bookService.getAll();
model.addAttribute("bookList", bookList);
return "main";
}
}
編寫映射文件
在項目的resources目錄下創(chuàng)建mapper目錄食侮,在目錄中創(chuàng)建UserMapper.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="com.snow.mapper.UserMapper">
<resultMap id="BaseResultMap" type="com.snow.domain.User">
<id column="id" property="id" jdbcType="INTEGER"/>
<result column="loginname" property="loginname" jdbcType="VARCHAR"/>
<result column="password" property="password" jdbcType="VARCHAR"/>
<result column="username" property="username" jdbcType="VARCHAR"/>
<result column="phone" property="phone" jdbcType="VARCHAR"/>
<result column="address" property="address" jdbcType="VARCHAR"/>
</resultMap>
<sql id="Base_Column_List">
id, loginname, password, username, phone, address
</sql>
<select id="findWithLoginnameAndPassword" resultMap="BaseResultMap" parameterType="java.lang.String">
select
<include refid="Base_Column_List"/>
from tb_user
where loginname = #{loginname,jdbcType=VARCHAR}
and password = #{password,jdbcType=VARCHAR}
</select>
</mapper>
再創(chuàng)建BookMapper.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="com.snow.mapper.BookMapper">
<resultMap id="BaseResultMap" type="com.snow.domain.Book">
<id column="id" property="id" jdbcType="INTEGER"/>
<result column="name" property="name" jdbcType="VARCHAR"/>
<result column="author" property="author" jdbcType="VARCHAR"/>
<result column="publicationdate" property="publicationdate" jdbcType="DATE"/>
<result column="publication" property="publication" jdbcType="VARCHAR"/>
<result column="price" property="price" jdbcType="DOUBLE"/>
<result column="image" property="image" jdbcType="VARCHAR"/>
<result column="remark" property="remark" jdbcType="VARCHAR"/>
</resultMap>
<sql id="Base_Column_List">
id, name, author, publicationdate, publication, price, image, remark
</sql>
<select id="findAll" resultMap="BaseResultMap" parameterType="com.snow.domain.Book">
select
<include refid="Base_Column_List"/>
from tb_book
</select>
</mapper>
編寫頁面
在項目的webapp目錄下創(chuàng)建images目錄锯七,將數(shù)據庫中書的封面圖和頁面的背景圖放在該目錄下:
在項目的webapp目錄下链快,創(chuàng)建base.css文件,編寫如下程序:
body{
background-image: url(images/backImage.jpg);
background-size:cover;
}
在項目的webapp目錄下眉尸,創(chuàng)建login.jsp文件域蜗,編寫如下程序:
<%--
Created by IntelliJ IDEA.
User: Dcl_Snow
Date: 2019/10/25
Time: 10:00
To change this template use File | Settings | File Templates.
--%>
<%@ page contentType="text/html;charset=UTF-8" language="java" %>
<html>
<head>
<title>登錄頁面</title>
<link rel="stylesheet" type="text/css" href="base.css"/>
</head>
<body>
<center>
<h3>登錄頁面</h3>
<form action="login" method="post">
<table>
<tr>
<td><label>登錄名:</label></td>
<td><input type="text" id="loginname" name="loginname"></td>
</tr>
<tr>
<td><label>密 碼:</label></td>
<td><input type="password" id="password" name="password"></td>
</tr>
<tr>
<td><input type="submit" value="登錄"></td>
</tr>
</table>
</form>
</center>
</body>
</html>
在項目的WEB-INF目錄下巨双,創(chuàng)建views目錄,在該目錄下創(chuàng)建main.jsp文件霉祸,編寫如下程序:
<%@ taglib prefix="C" uri="http://java.sun.com/jsp/jstl/core" %>
<%--
Created by IntelliJ IDEA.
User: Dcl_Snow
Date: 2019/10/25
Time: 10:00
To change this template use File | Settings | File Templates.
--%>
<%@ page isELIgnored="false" %>
<%@ page contentType="text/html;charset=UTF-8" language="java" %>
<html>
<head>
<title>首頁</title>
<link rel="stylesheet" type="text/css" href="base.css"/>
</head>
<body>
<center>
歡迎[${sessionScope.user.username}]
<table border="1">
<tr>
<th>書名</th>
<th>封面</th>
<th>作者</th>
<th>價格</th>
</tr>
<C:forEach items="${requestScope.bookList}" var="book">
<tr>
<td>${book.name}</td>
<td><img src="images/${book.image}" height="200"></td>
<td>${book.author}</td>
<td>${book.price}</td>
</tr>
</C:forEach>
</table>
</center>
</body>
</html>
再創(chuàng)建error.jsp文件筑累,編寫如下程序:
<%--
Created by IntelliJ IDEA.
User: Dcl_Snow
Date: 2019/10/25
Time: 10:00
To change this template use File | Settings | File Templates.
--%>
<%@ page contentType="text/html;charset=UTF-8" language="java" %>
<html>
<head>
<title>錯誤頁面</title>
<link rel="stylesheet" type="text/css" href="base.css"/>
</head>
<body>
<center>
<h1><font color="red">用戶名或密碼錯誤!</font></h1>
</center>
</body>
</html>
配置Tomcat
為項目配置Tomcat后丝蹭,啟動慢宗,瀏覽器訪問:http://localhost:8080/。
登錄頁面:
輸入錯誤的用戶名或密碼:
輸入正確的用戶名和密碼: