Spring+SpringMVC+Mybatis框架整合加测试

1、SSM框架整合

1.1、环境要求

环境：

• IDEA
• Mysql 5.7
• Tomcat 8
• Maven 3.6.3

1.2、数据库环境

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 AUTO_INCREMENT=4 DEFAULT CHARSET=utf8;

INSERT  INTO `books`(`bookID`,`bookName`,`bookCounts`,`detail`) VALUES (1,'Java',1,'从入门到放弃'),(2,'MySQL',10,'从删库到跑路'),(3,'Linux',5,'从进门到进牢');

1.3、基本的环境搭建

1、创建一个maven项目

2、导入pom依赖

<!--  pom依赖  -->
    <dependencies>
        <!--junit-->
        <dependency>
            <groupId>junit</groupId>
            <artifactId>junit</artifactId>
            <version>4.12</version>
            <scope>test</scope>
        </dependency>
        <!--mysql驱动包-->
        <dependency>
            <groupId>mysql</groupId>
            <artifactId>mysql-connector-java</artifactId>
            <version>5.1.47</version>
            <scope>runtime</scope>
        </dependency>

        <!--Druid连接池-->
        <dependency>
            <groupId>com.alibaba</groupId>
            <artifactId>druid</artifactId>
            <version>1.1.21</version>
        </dependency>
        <!--servlet-->
        <dependency>
            <groupId>javax.servlet</groupId>
            <artifactId>javax.servlet-api</artifactId>
            <version>3.1.0</version>
            <scope>provided</scope>
        </dependency>
        <!--mybatis框架-->
        <dependency>
            <groupId>org.mybatis</groupId>
            <artifactId>mybatis</artifactId>
            <version>3.5.2</version>
        </dependency>
        <!-- 整合包 -->
        <!-- mybatis-spring -->
        <dependency>
            <groupId>org.mybatis</groupId>
            <artifactId>mybatis-spring</artifactId>
            <version>2.0.4</version>
        </dependency>
        <!-- spring -->
        <dependency>
            <groupId>org.springframework</groupId>
            <artifactId>spring-webmvc</artifactId>
            <version>5.2.5.RELEASE</version>
        </dependency>
        <!-- spring操作数据库的话、还需要一个spring-jdbc -->
        <!--  spring-jdbc   -->
        <dependency>
            <groupId>org.springframework</groupId>
            <artifactId>spring-jdbc</artifactId>
            <version>5.2.5.RELEASE</version>
        </dependency>
        <!--aop织入包-->
        <dependency>
            <groupId>org.aspectj</groupId>
            <artifactId>aspectjweaver</artifactId>
            <version>1.9.4</version>
        </dependency>
        <!-- 阿里的fastjson  json解析器 -->
        <dependency>
            <groupId>com.alibaba</groupId>
            <artifactId>fastjson</artifactId>
            <version>1.2.73</version>
        </dependency>

        <!-- Lombok  -->
        <dependency>
            <groupId>org.projectlombok</groupId>
            <artifactId>lombok</artifactId>
            <version>1.18.8</version>
            <scope>provided</scope>
        </dependency>
    </dependencies>

3、配置资源过滤

<!--在build中配置resources,来防止我们资源导出失败问题-->
<build>
  <resources>
    <resource>
      <directory>src/main/resources</directory>
      <includes>
        <include>**/*.properties</include>
        <include>**/*.xml</include>
      </includes>
      <filtering>true</filtering>
    </resource>
    <resource>
      <directory>src/main/java</directory>
      <includes>
        <include>**/*.properties</include>
        <include>**/*.xml</include>
      </includes>
      <filtering>true</filtering>
    </resource>
  </resources>
</build>

4、创建基本的项目录

• com.wei.pojo
• com.wei.mapper
• com.wei.service
• com.wei.controller

1. 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>
       
   </configuration>
   

2. applicatinContext.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
           https://www.springframework.org/schema/beans/spring-beans.xsd">
       
   </beans>
   

1.4、编写Mapper层

编写步骤：

1. 实体类

   @Data
   @NoArgsConstructor
   @AllArgsConstructor
   public class Books {
       private int bookID;
       private String bookName;
       private int bookCounts;
       private String detail;
   }
   

2. 接口以及Mapper.xml

   public interface BookMapper {
       //增加一本书
       int addBook(Books books);
       //删除一本书
       int deleteBookById(@Param("bookID") int id);
       //更新一本书
       int updateBook(Books books);
       //查询一本书
       Books queryBookById(int id);
       //查询所有书
       List<Books> queryAllBook();
   }
   

   <?xml version="1.0" encoding="UTF-8" ?>
   <!DOCTYPE mapper
           PUBLIC "-//mybatis.org//DTD Config 3.0//EN"
           "http://mybatis.org/dtd/mybatis-3-mapper.dtd">
   <mapper namespace="com.wei.mapper.BookMapper">
   
       <insert id="addBook" parameterType="books">
           insert into books (bookName,bookCounts,detail)
           values (#{bookName},#{bookCounts},#{detail});
       </insert>
   
       <delete id="deleteBookById" parameterType="int">
           delete from books where bookID = #{bookID}
       </delete>
   
       <update id="updateBook" parameterType="bookd">
           update books 
           set bookName = #{bookName},bookCounts = #{bookCounts},detail = #{detail}
           where bookID = #{bookID};
       </update>
   
       <select id="queryBookById" resultType="books">
           select * from books where bookID = #{bookID};
       </select>
   
       <select id="queryAllBook" resultType="books">
           select * from books
       </select>
   </mapper>
   

3. 编写mybatis核心配置文件

   <?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>
   <!-- 设置别名 -->
       <typeAliases>
           <package name="com.wei.pojo"/>
       </typeAliases>
   
   </configuration>
   

4. 项目目录图

1.5、编写Service层

1. 编写servicej接口

   public interface BookService {
       //增加一本书
       int addBook(Books books);
       //删除一本书
       int deleteBookById(int id);
       //更新一本书
       int updateBook(Books books);
       //查询一本书
       Books queryBookById(int id);
       //查询所有书
       List<Books> queryAllBook();
   }
   

2. 接口实现类

   @Service
   public class BookServiceImpl implements BookService {
       @Autowired
       private BookMapper bookMapper;
       @Override
       public int addBook(Books books) {
           return bookMapper.addBook(books);
       }
   
       @Override
       public int deleteBookById(int id) {
           return bookMapper.deleteBookById(id);
       }
   
       @Override
       public int updateBook(Books books) {
           return bookMapper.updateBook(books);
       }
   
       @Override
       public Books queryBookById(int id) {
           return bookMapper.queryBookById(id);
       }
   
       @Override
       public List<Books> queryAllBook() {
           return bookMapper.queryAllBook();
       }
   }
   

3. 编写spring-mapper.xml —> 里面配置的数据源以及一些其他的、都交给spring托管

   jdbc.driver=com.mysql.jdbc.Driver
   jdbc.url=jdbc:mysql://localhost:3306/ssmbuild?useSSL=true&useUnicode=true&characterEncoding=utf-8
   jdbc.username=root
   jdbc.password=123456
   

   <?xml version="1.0" encoding="utf8"?>
   <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
           https://www.springframework.org/schema/beans/spring-beans.xsd
           http://www.springframework.org/schema/context
           https://www.springframework.org/schema/context/spring-context.xsd">
       <!-- 1.关联数据库配置文件  -->
       <context:property-placeholder location="classpath:database.properties"/>
   
       <!-- 2、连接池   -->
       <bean id="dataSource" class="com.alibaba.druid.pool.DruidDataSource">
           <property name="driver" value="${jdbc.driver}"/>
           <property name="url" value="${jdbc.url}"/>
           <property name="username" value="${jdbc.username}"/>
           <property name="password" value="${jdbc.password}"/>
       </bean>
       <!-- 3、创建SqlSessionFactory  -->
       <bean id="sqlSessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean">
           <property name="dataSource" ref="dataSource"/>
           <!-- 绑定mybatis配置文件  -->
           <property name="configLocation"  value="classpath:mybatis-config.xml"/>
           <!-- 自动扫描mapping.xml文件 -->
           <property name="mapperLocations" value="classpath:com/wei/mapper/*.xml"/>
       </bean>
       <!--  4、配置，Mapper接口扫描包  -->
       <bean class="org.mybatis.spring.mapper.MapperScannerConfigurer">
           <!-- 注入：sqlSessionFactory  -->
           <property name="sqlSessionFactoryBeanName" value="sqlSessionFactory"/>
           <!-- 要扫描的Mapper包  -->
           <property name="basePackage" value="com.wei.mapper"/>
       </bean>
   
   </beans>
   

4. 编写spring-service.xml

<?xml version="1.0" encoding="utf8"?>
<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"
       xmlns:aop="http://www.springframework.org/schema/aop"
       xsi:schemaLocation="http://www.springframework.org/schema/beans
        https://www.springframework.org/schema/beans/spring-beans.xsd
        http://www.springframework.org/schema/context
        https://www.springframework.org/schema/context/spring-context.xsd
        http://www.springframework.org/schema/tx
        https://www.springframework.org/schema/tx/spring-tx.xsd
        http://www.springframework.org/schema/aop
        https://www.springframework.org/schema/aop/spring-aop.xsd">

    <!-- 1、扫描service下的包注解生效   -->
    <context:component-scan base-package="com.wei.service"/>

    <!-- 配置声明式事务 -->
    <bean id="transactionManager" class="org.springframework.jdbc.datasource.DataSourceTransactionManager">
        <constructor-arg ref="dataSource" />
    </bean>
    <!-- 结合aop实现事务的织入  -->
    <!-- 配置事务通知   -->
    <tx:advice id="txAdvice" transaction-manager="transactionManager">
        <tx:attributes>
            <!--
               给那些方法添加事务
               name：是方法、name值为*就是给所有方法添加事务
               propagation:事务的传播特性、默认REQUIRED
               read-only:设置为true的话就是只能读不能做修改的操作
              -->
            <tx:method name="add" propagation="REQUIRED"/>
            <tx:method name="query" read-only="true"/>
            <tx:method name="*" propagation="REQUIRED"/>
        </tx:attributes>
    </tx:advice>
    <!-- 配置事务切入-->
    <aop:config>
        <!-- 定义切入点  -->
        <aop:pointcut id="txPointcut" expression="execution(* com.wei.mapper.*.*(..))"/>
        <!-- 定义通知  -->
        <aop:advisor advice-ref="txAdvice" pointcut-ref="txPointcut"/>
    </aop:config>

</beans>

1. 项目目录图
   

1.6、编写Controller层

编写springMVC这层时要注意：将普通的maven项目变成web项目、因为我自己是先创建普通的项目、然后在变成web项目的、

变成web项目的方法是：选中项目右键—》选中 Add Framework Support-- > 然后选中图下web application的

代码编写

1. 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">
       <!-- 配置DispatchServlet : 这个是springMVC的核心：请求分发器：前端控制器   -->
       <servlet>
           <servlet-name>springmvc</servlet-name>
           <servlet-class>org.springframework.web.servlet.DispatcherServlet</servlet-class>
           <!--  DispatcherServlet 要绑定spring的配置文件   -->
           <init-param>
               <param-name>contextConfigLocation</param-name>
               <param-value>classpath:applicationContext.xml</param-value>
           </init-param>
           <!--  启动级别   -->
           <load-on-startup>1</load-on-startup>
       </servlet>
       <!--
           在springMVC中   /   /*
           /:  只配置所有的请求，不会配置jsp页面
           /*: 置所有的请求，包括jsp页面
         -->
       <servlet-mapping>
           <servlet-name>springmvc</servlet-name>
           <url-pattern>/</url-pattern>
       </servlet-mapping>
   
       <!--  配置SpringMVC的乱码过滤器    -->
       <filter>
           <filter-name>encoding</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>encoding</filter-name>
           <url-pattern>/*</url-pattern>
       </filter-mapping>
   </web-app>
   

2. spring-mvc.xml编写

   <?xml version="1.0" encoding="utf8"?>
   <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/beans
           https://www.springframework.org/schema/beans/spring-beans.xsd
           http://www.springframework.org/schema/context
           https://www.springframework.org/schema/context/spring-context.xsd
            http://www.springframework.org/schema/mvc
           https://www.springframework.org/schema/mvc/spring-mvc.xsd">
       <!--  1、开启注解驱动  -->
       <mvc:annotation-driven/>
       <!--  2、静态资源过滤  -->
       <mvc:default-servlet-handler/>
       <!--  3、扫描包  -->
       <context:component-scan base-package="com.wei.controller"/>
       <!-- 4、视图接解析器  -->
       <bean id="internalResourceViewResolver" class="org.springframework.web.servlet.view.InternalResourceViewResolver">
           <property name="prefix" value="/WEB-INF/jsp/"/>
           <property name="suffix" value=".jsp"/>
       </bean>
       <!-- 处理请求时返回json字符串的中文乱码问题 -->
       <mvc:annotation-driven>
           <mvc:message-converters>
               <bean class="org.springframework.http.converter.StringHttpMessageConverter">
                   <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>
   </beans>
   

3. 将所有的配置引入applicationContext.xml中

   <?xml version="1.0" encoding="utf8"?>
   <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
           https://www.springframework.org/schema/beans/spring-beans.xsd">
   
       <import resource="classpath:spring-mapper.xml"/>
       <import resource="classpath:spring-service.xml"/>
       <import resource="classpath:spring-mvc.xml"/>
   
   </beans>
   

4. 编写controller

   @Controller
   @RestController
   public class BookController {
       @Autowired
       private BookService bookService;
   
       @RequestMapping("/t1")
       public String Test(){
           List<Books> books = bookService.queryAllBook();
           return JSON.toJSONString(books);
       }
   }
   

5. 配置Tomcat

6. 还有注意一个点检查这个地方有没有lib文件

   

   为什么会出现这个原因、因为是我是直接创建一个模块、不是通过maven构建的maven项目、然后将模块构建成web项目、

7. 此时的目录结构

   

8. 配置好tomcat启动的运行结果

整合教程来源之b战up主
up主/主页:https://space.bilibili.com/95256449