跟着 狂神说Java ssm整合做完之后做的记录，算是ssm整合的一个基本模板吧

配置环境

开发环境

IntelliJ IDEA 2020.1 x64jdk 1.8MySQL Server 5.5Maven 3.3.9Tomcat 9Navicat Premium 15

数据库环境

创建一个存放书籍数据的数据库表

CREATE DATABASE `ssmbuild`; USE `ssmbuild`; DROP TABLE IF EXISTS `books`; CREATE TABLE `books` ( `bookID` INT(10) NOT NULL AUTO_INCREMENT COMMENT '书id', `bookName` VARCHAR(100) NOT NULL COMMENT '书名', `bookCounts` INT(11) NOT NULL COMMENT '数量', `detail` VARCHAR(200) NOT NULL COMMENT '描述', KEY `bookID` (`bookID`) ) ENGINE=INNODB DEFAULT CHARSET=utf8 INSERT INTO `books`(`bookID`,`bookName`,`bookCounts`,`detail`)VALUES (1,'Java',1,'从入门到放弃'), (2,'MySQL',10,'从删库到跑路'), (3,'Linux',5,'从进门到进牢');

基本环境搭建

新建maven项目ssm-integration，不选择任何骨架，直接next。

建立完成之后添加web的支持。右键add framework support,添加web的支持

导入pom相关的依赖

<?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>cn.ysk</groupId> <artifactId>ssm-integration</artifactId> <version>1.0-SNAPSHOT</version> <dependencies> <!--Junit--> <dependency> <groupId>junit</groupId> <artifactId>junit</artifactId> <version>4.12</version> </dependency> <!--数据库驱动--> <dependency> <groupId>mysql</groupId> <artifactId>mysql-connector-java</artifactId> <version>5.1.47</version> </dependency> <!-- 数据库连接池 --> <dependency> <groupId>com.alibaba</groupId> <artifactId>druid</artifactId> <version>1.1.12</version> </dependency> <!--Servlet - JSP --> <dependency> <groupId>javax.servlet</groupId> <artifactId>servlet-api</artifactId> <version>2.5</version> </dependency> <dependency> <groupId>javax.servlet.jsp</groupId> <artifactId>jsp-api</artifactId> <version>2.2</version> </dependency> <dependency> <groupId>javax.servlet</groupId> <artifactId>jstl</artifactId> <version>1.2</version> </dependency> <!--Mybatis--> <dependency> <groupId>org.mybatis</groupId> <artifactId>mybatis</artifactId> <version>3.5.2</version> </dependency> <dependency> <groupId>org.mybatis</groupId> <artifactId>mybatis-spring</artifactId> <version>2.0.2</version> </dependency> <!--Spring--> <dependency> <groupId>org.springframework</groupId> <artifactId>spring-webmvc</artifactId> <version>5.1.9.RELEASE</version> </dependency> <dependency> <groupId>org.springframework</groupId> <artifactId>spring-jdbc</artifactId> <version>5.1.9.RELEASE</version> </dependency> <dependency> <groupId>org.projectlombok</groupId> <artifactId>lombok</artifactId> <version>1.18.4</version> </dependency> <dependency> <groupId>com.fasterxml.jackson.core</groupId> <artifactId>jackson-databind</artifactId> <version>2.10.3</version> </dependency> </dependencies> <!--Maven资源过滤设置--> <build> <resources> <resource> <directory>src/main/java</directory> <includes> <include>**/*.properties</include> <include>**/*.xml</include> </includes> <filtering>false</filtering> </resource> <resource> <directory>src/main/resources</directory> <includes> <include>**/*.properties</include> <include>**/*.xml</include> </includes> <filtering>false</filtering> </resource> </resources> </build> </project>

建立基本结构和配置框架

编写mybatis层

mybatis 的核心配置文件 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"> <!--mybatis主配置文件--> <configuration> <!--settings：控制mybatis全局行为--> <!-- <settings> &lt;!&ndash;设置mybatis输出日志&ndash;&gt; <setting name="logImpl" value="STDOUT_LOGGING"/> </settings>--> <!--设置别名--> <typeAliases> <!--name:实体类所在的包名 给包中的类注册别名，注册后可以直接使用别名，而不用使用 全限定的类名 --> <package name="cn.ysk.pojo"/> </typeAliases> <!-- sql mapper(sql映射文件)的位置--> <mappers> <!-- name：是包名， 这个包中的所有mapper.xml一次都能加载 --> <package name="cn\ysk\dao\BookMapper.xml"/> </mappers> </configuration>

数据库配置文件 jdbc.properties

jdbc.driver = com.mysql.jdbc.Driver jdbc.url = jdbc:mysql://localhost:3306/ssmbuild jdbc.username = root jdbc.password = 123

编写数据库对应的实体类 使用lombok插件 Books.java

package cn.ysk.pojo; import lombok.AllArgsConstructor; import lombok.Data; import lombok.NoArgsConstructor; @Data @NoArgsConstructor @AllArgsConstructor public class Books { private int bookId; private String bookName; private int bookCounts; private String detail; }

编写dao层的mapper接口 BookMapper.java

package cn.ysk.dao; import cn.ysk.pojo.Books; import org.apache.ibatis.annotations.Param; import java.util.List; public interface BookDao { //增加一本书 int addBook(Books books); //删除一本书 int deleteBookById(@Param("bookId") int id); //修改一本书 int updateBook(Books books); //根据id查询一本书 Books selectBookById(@Param("bookId") int id); //查询所有的书 List<Books> selectAllBook(); }

编写BookMapper对应的sql映射文件 BookMapper.xml

注意：这里接口名与Mybatis的映射文件名最好一致，否则可能会出现 org.apache.ibatis.binding.BindingException: Invalid bound statement (not found)

<?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="cn.ysk.dao.BookMapper"> <insert id="addBook" parameterType="Books"> insert into books (bookName,bookCounts,detail) values (#{bookName},#{bookCounts},#{detail}); </insert> <delete id="deleteBookById" parameterType="Integer"> delete from books where bookID=#{bookID}; </delete> <update id="updateBook" parameterType="Books"> update books set bookName=#{bookName},bookCounts=#{bookCounts}, detail=#{detail} where bookID=#{bookID}; </update> <select id="selectBookById" resultType="Books"> select * from books where bookID=#{bookID}; </select> <select id="selectAllBook" resultType="Books"> select * from books; </select> <select id="queryBookByName" resultType="Books"> select * from books where bookName = #{bookName} </select> </mapper>

编写service层的接口和实现类

BookService.java

package cn.ysk.service; import cn.ysk.pojo.Books; import java.util.List; public interface BookService { //增加一本书 int addBook(Books books); //删除一本书 int deleteBookById(int id); //修改一本书 int updateBook(Books books); //根据id查询一本书 Books queryBookById(int id); //查询所有的书 List<Books> queryAllBook(); Books queryBookByName(String bookName); }

BookServiceImpl.java

package cn.ysk.service.impl; import cn.ysk.dao.BookMapper; import cn.ysk.pojo.Books; import cn.ysk.service.BookService; import java.util.List; public class BookServiceImpl implements BookService { //调用dao层的操作，设置一个set接口，方便Spring管理 private BookMapper bookMapper; public void setBookMapper(BookMapper bookMapper) { this.bookMapper = bookMapper; } public int addBook(Books books) { return bookMapper.addBook(books); } @Override public Books queryBookByName(String bookName) { return bookMapper.queryBookByName(bookName); } public int deleteBookById(int id) { return bookMapper.deleteBookById(id); } public int updateBook(Books books) { return bookMapper.updateBook(books); } public Books queryBookById(int id) { return bookMapper.selectBookById(id); } public List<Books> queryAllBook() { return bookMapper.selectAllBook(); } }

编写spring层

Spring就是一个大杂烩，一个容器！

配置Spring整合MyBatis，我们这里数据源使用druid连接池；

编写Spring整合Mybatis的相关的配置文件；spring-dao.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 https://www.springframework.org/schema/context/spring-context.xsd"> <!-- 把数据库的配置信息，写在一个独立的文件，编译修改数据库的配置内容 spring知道jdbc.properties文件的位置 --> <context:property-placeholder location="classpath:jdbc.properties"/> <!--声明数据源DataSource, 作用是连接数据库的--> <bean id="myDataSource" class="com.alibaba.druid.pool.DruidDataSource" init-method="init" destroy-method="close"> <!--set注入给DruidDataSource提供连接数据库信息 --> <!-- 使用属性配置文件中的数据，语法 ${key} --> <property name="url" value="${jdbc.url}" /><!--setUrl()--> <property name="username" value="${jdbc.username}"/> <property name="password" value="${jdbc.password}" /> </bean> <!--声明的是mybatis中提供的SqlSessionFactoryBean类，这个类内部创建SqlSessionFactory的 SqlSessionFactory sqlSessionFactory = new .. --> <bean id="sqlSessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean"> <!--set注入，把数据库连接池付给了dataSource属性--> <property name="dataSource" ref="myDataSource" /> <!--mybatis主配置文件的位置 configLocation属性是Resource类型，读取配置文件 它的赋值，使用value，指定文件的路径，使用classpath:表示文件的位置 --> <property name="configLocation" value="classpath:mybatis-config.xml" /> </bean> <!--创建dao对象，使用SqlSession的getMapper（StudentDao.class） MapperScannerConfigurer:在内部调用getMapper()生成每个dao接口的代理对象。 --> <bean class="org.mybatis.spring.mapper.MapperScannerConfigurer"> <!--指定SqlSessionFactory对象的id--> <property name="sqlSessionFactoryBeanName" value="sqlSessionFactory"/> <!--指定包名， 包名是dao接口所在的包名。 MapperScannerConfigurer会扫描这个包中的所有接口，把每个接口都执行 一次getMapper()方法，得到每个接口的dao对象。 创建好的dao对象放入到spring的容器中的。 dao对象的默认名称是 接口名首字母小写 --> <property name="basePackage" value="cn.ysk.dao"/> </bean> </beans>

spring整合service层 spring-service.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 https://www.springframework.org/schema/context/spring-context.xsd"> <!--配置<context:component-scan base-package="" />扫描的包及其子包， 只有当遇到了@Component @Controller@Service这些注解时spring才会注册对应的bean， 配置扫描多个包，可以通过“,”逗号隔开：--> <!--扫描service相关的bean--> <context:component-scan base-package="cn.ysk.service"/> <!--BookServiceImpl注入到IOC容器中--> <bean id="BookServiceImpl" class="cn.ysk.service.impl.BookServiceImpl"> <property name="bookMapper" ref="bookMapper"/> </bean> <!-- 配置事务管理器 --> <bean id="transactionManager" class="org.springframework.jdbc.datasource.DataSourceTransactionManager"> <!-- 注入数据库连接池 --> <property name="dataSource" ref="myDataSource" /> </bean> </beans>

编写springmvc层

web.xml

<?xml version="1.0" encoding="UTF-8"?> <web-app xmlns="http://xmlns.jcp.org/xml/ns/javaee" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://xmlns.jcp.org/xml/ns/javaee http://xmlns.jcp.org/xml/ns/javaee/web-app_4_0.xsd" version="4.0"> <!--DispatcherServlet--> <servlet> <servlet-name>DispatcherServlet</servlet-name> <servlet-class>org.springframework.web.servlet.DispatcherServlet</servlet-class> <init-param> <param-name>contextConfigLocation</param-name> <!--一定要注意:我们这里加载的是总的配置文件!!!--> <param-value>classpath:applicationContext.xml</param-value> </init-param> <load-on-startup>1</load-on-startup> </servlet> <servlet-mapping> <servlet-name>DispatcherServlet</servlet-name> <url-pattern>/</url-pattern> </servlet-mapping> <!--encodingFilter--> <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> <!--Session过期时间--> <session-config> <session-timeout>15</session-timeout> </session-config> </web-app>

spring-mvc.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:mvc="http://www.springframework.org/schema/mvc" 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/mvc https://www.springframework.org/schema/mvc/spring-mvc.xsd http://www.springframework.org/schema/context https://www.springframework.org/schema/context/spring-context.xsd"> <!-- 配置SpringMVC --> <!-- 1.开启SpringMVC注解驱动 --> <mvc:annotation-driven /> <!-- 2.静态资源默认servlet配置--> <mvc:default-servlet-handler/> <!-- 3.配置jsp 显示ViewResolver视图解析器 --> <bean class="org.springframework.web.servlet.view.InternalResourceViewResolver"> <property name="viewClass" value="org.springframework.web.servlet.view.JstlView" /> <property name="prefix" value="/WEB-INF/jsp/" /> <property name="suffix" value=".jsp" /> </bean> <!-- 4.扫描web相关的bean --> <context:component-scan base-package="cn.ysk.controller" /> </beans>

Spring配置整合文件，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" xsi:schemaLocation="http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans.xsd"> <import resource="classpath:spring-dao.xml"/> <import resource="classpath:spring-service.xml"/> <import resource="classpath:spring-mvc.xml"/> </beans>

代码部分

编写Controller层 和 视图层

编写BookController.java ，共七个方法

package cn.ysk.controller; import cn.ysk.pojo.Books; import cn.ysk.service.BookService; import org.springframework.beans.factory.annotation.Autowired; import org.springframework.beans.factory.annotation.Qualifier; import org.springframework.stereotype.Controller; import org.springframework.ui.Model; import org.springframework.web.bind.annotation.PathVariable; import org.springframework.web.bind.annotation.RequestMapping; import java.util.ArrayList; import java.util.List; @Controller @RequestMapping("/book") public class BookController { //controller调用service层 @Autowired @Qualifier("BookServiceImpl") private BookService bookService; //查询全部的书籍 @RequestMapping("/allBook") public String listAllBook(Model model){ List<Books> booksList = bookService.queryAllBook(); model.addAttribute("booksList",booksList); return "allBook"; } //跳转到增加书籍的界面 @RequestMapping("/toAddBook") public String toAddBook(){ return "addBook"; } //增加书籍的操作 @RequestMapping("/addBook") public String addBook(Books books) { System.out.println("增加的书籍： "+ books); bookService.addBook(books); return "redirect:/book/allBook"; } //跳转到修改书籍的界面 @RequestMapping("/toUpdateBook") public String toUpdateBook(int id,Model model){ Books books = bookService.queryBookById(id); model.addAttribute("QbBook", books); return "updateBook"; } //修改书籍的操作 @RequestMapping("/updateBook") public String updateBook(Books books){ int i = bookService.updateBook(books); if(i>0){ System.out.println("修改成功！"); } return "redirect:/book/allBook"; } //删除书籍 @RequestMapping("/del/{bookID}") public String deleteBook(@PathVariable("bookID") int id){ int i = bookService.deleteBookById(id); if(i>0){ System.out.println("书籍删除成功！"); } return "redirect:/book/allBook"; } //查询书籍 @RequestMapping("queryBook") public String queryBook(String queryBookName,Model model){ Books books = bookService.queryBookByName(queryBookName); List<Books> list = new ArrayList<>(); list.add(books); if(books == null) { list = bookService.queryAllBook(); model.addAttribute("error", "未查到！"); } model.addAttribute("booksList",list); return "allBook"; } }

首页 index.jsp

<%@ page language="java" contentType="text/html; charset=UTF-8" pageEncoding="UTF-8" %> <!DOCTYPE HTML> <html> <head> <title>首页</title> <style type="text/css"> a { text-decoration: none; color: black; font-size: 18px; } h3 { width: 180px; height: 38px; margin: 100px auto; text-align: center; line-height: 38px; background: deepskyblue; border-radius: 4px; } </style> </head> <body> <h3> <a href="${pageContext.request.contextPath}/book/allBook">点击进入列表页</a> </h3> </body> </html>

书籍列表页面 allbook.jsp

<%@ taglib prefix="c" uri="http://java.sun.com/jsp/jstl/core" %> <%@ page contentType="text/html;charset=UTF-8" language="java" %> <html> <head> <title>书籍列表</title> <meta name="viewport" content="width=device-width, initial-scale=1.0"> <!-- 引入 Bootstrap --> <link href="https://cdn.bootcss.com/bootstrap/3.3.7/css/bootstrap.min.css" rel="stylesheet"> </head> <body> <div class="container"> <div class="row clearfix"> <div class="col-md-12 column"> <div class="page-header"> <h1> <small>书籍列表 —— 显示所有书籍</small> </h1> </div> </div> </div> <div class="row"> <div class="col-md-4 column"> <a class="btn btn-primary" href="${pageContext.request.contextPath}/book/toAddBook">新增</a> </div> <div class="col-md-4 column"></div> <div class="col-md-4 column"> <form class="form-inline" action="${pageContext.request.contextPath}/book/queryBook" method="post" style="float: right"> <span style="color: red;font-weight: bold">${error}</span> <input type="text" name="queryBookName" class="form-control" placeholder="请输入要查询书籍的名称"> <input type="submit" value="查询" class="btn btn-primary"> </form> </div> </div> <div class="row clearfix"> <div class="col-md-12 column"> <table class="table table-hover table-striped"> <thead> <tr> <th>书籍编号</th> <th>书籍名字</th> <th>书籍数量</th> <th>书籍详情</th> <th>操作</th> </tr> </thead> <tbody> <c:forEach var="book" items="${booksList}"> <tr> <td>${book.bookID}</td> <td>${book.bookName}</td> <td>${book.bookCounts}</td> <td>${book.detail}</td> <td> <a href="${pageContext.request.contextPath}/book/toUpdateBook?id=${book.bookID}">更改</a> | <a href="${pageContext.request.contextPath}/book/del/${book.bookID}">删除</a> </td> </tr> </c:forEach> </tbody> </table> </div> </div> </div>

添加书籍页面 add.jsp

<%@ taglib prefix="c" uri="http://java.sun.com/jsp/jstl/core" %> <%@ page contentType="text/html;charset=UTF-8" language="java" %> <html> <head> <title>新增书籍</title> <meta name="viewport" content="width=device-width, initial-scale=1.0"> <!-- 引入 Bootstrap --> <link href="https://cdn.bootcss.com/bootstrap/3.3.7/css/bootstrap.min.css" rel="stylesheet"> </head> <body> <div class="container"> <div class="row clearfix"> <div class="col-md-12 column"> <div class="page-header"> <h1> <small>新增书籍</small> </h1> </div> </div> </div> <form action="${pageContext.request.contextPath}/book/addBook" method="post"> 书籍名称：<input type="text" name="bookName"><br><br><br> 书籍数量：<input type="text" name="bookCounts"><br><br><br> 书籍详情：<input type="text" name="detail"><br><br><br> <input type="submit" value="添加"> </form> </div>

修改书籍页面 update.jsp

<%@ taglib prefix="c" uri="http://java.sun.com/jsp/jstl/core" %> <%@ page contentType="text/html;charset=UTF-8" language="java" %> <html> <head> <title>修改信息</title> <meta name="viewport" content="width=device-width, initial-scale=1.0"> <!-- 引入 Bootstrap --> <link href="https://cdn.bootcss.com/bootstrap/3.3.7/css/bootstrap.min.css" rel="stylesheet"> </head> <body> <div class="container"> <div class="row clearfix"> <div class="col-md-12 column"> <div class="page-header"> <h1> <small>修改信息</small> </h1> </div> </div> </div> <form action="${pageContext.request.contextPath}/book/updateBook" method="post"> <input type="hidden" name="bookID" value="${QbBook.bookID}"/> 书籍名称：<input type="text" name="bookName" value="${QbBook.bookName}"/> 书籍数量：<input type="text" name="bookCounts" value="${QbBook.bookCounts}"/> 书籍详情：<input type="text" name="detail" value="${QbBook.detail}"/> <input type="submit" value="提交"/> </form> </div>

最后的项目结构图