• 系列一、Spring + SpringMVC + MyBatis整合

    一、概述

    整合 Spring、SpringMVC、MyBatis。

    二、整合步骤

    2.1、pom

    2. 	
    3. 	
    4. 		org.projectlombok
    5. 		lombok
    6. 		1.18.22
    7. 	
    8. 	
    9. 		org.slf4j
    10. 		slf4j-api
    11. 		1.7.32
    12. 	
    13. 	
    14. 		ch.qos.logback
    15. 		logback-classic
    16. 		1.2.10
    17. 	
    18.  
    19. 	
    20. 	
    21. 		com.alibaba
    22. 		fastjson
    23. 		1.2.76
    24. 	
    25. 	
    26. 		org.apache.commons
    27. 		commons-collections4
    28. 		4.3
    29. 	
    30. 	
    31. 		org.apache.commons
    32. 		commons-lang3
    33. 		3.11
    34. 	
    35. 	
    36. 		cn.hutool
    37. 		hutool-all
    38. 		5.7.22
    39. 	
    40. 	
    41. 		com.fasterxml.jackson.core
    42. 		jackson-databind
    43. 		2.12.1
    44. 	
    45.  
    46. 	
    47. 		org.apache.logging.log4j
    48. 		log4j-web
    49. 		2.12.1
    50. 	
    51.  
    52. 	
    53. 	
    54. 		org.springframework
    55. 		spring-webmvc
    56. 		5.3.4
    57. 	
    58. 	
    59. 		org.mybatis
    60. 		mybatis
    61. 		3.5.6
    62. 	
    63. 	
    64. 		org.mybatis
    65. 		mybatis-spring
    66. 		2.0.6
    67. 	
    68. 	
    69. 		mysql
    70. 		mysql-connector-java
    71. 		8.0.26
    72. 	
    73. 	
    74. 		org.springframework
    75. 		spring-jdbc
    76. 		5.3.4
    77. 	
    78. 	
    79. 		org.springframework
    80. 		spring-aop
    81. 		5.3.4
    82. 	
    83.  
    84. 	
    85. 		org.springframework
    86. 		spring-beans
    87. 		5.3.4
    88. 	
    89. 	
    90. 		org.springframework
    91. 		spring-context
    92. 		5.3.4
    93. 	
    94. 	
    95. 		org.springframework
    96. 		spring-core
    97. 		5.3.4
    98. 	
    99. 	
    100. 		org.springframework
    101. 		spring-expression
    102. 		5.3.4
    103. 	
    104. 	
    105. 		org.springframework
    106. 		spring-tx
    107. 		5.3.4
    108. 	
    109.  
    110. 	
    111. 	
    112. 		cglib
    113. 		cglib
    114. 		3.1
    115. 	
    116. 	
    117. 		aopalliance
    118. 		aopalliance
    119. 		1.0
    120. 	
    121. 	
    122. 		org.aspectj
    123. 		aspectjweaver
    124. 		1.9.19
    125. 	
    126.  
    128.  
    130. 	
    131. 	
    132. 		
    133. 			src/main/java
    134. 			
    135. 				**/*.xml
    136. 			
    137. 		
    138. 		
    139. 			src/main/resources
    140. 		
    141. 	
    143. 	
    144. 		
    145. 			org.apache.maven.plugins
    146. 			maven-compiler-plugin
    147. 			3.10.1
    148. 			
    149. 				8
    150. 				8
    151. 			
    152. 		
    153.

    2.2、db.properties

    1. db.driver=com.mysql.cj.jdbc.Driver
    2. db.url=jdbc:mysql://localhost:3306/20231106_ssm?useSSL=false&useUnicode=true&characterEncoding=UTF8&serverTimezone=GMT
    3. db.username=root
    4. db.password=123456

    2.3、init.sql

    1. drop DATABASE if EXISTS 20231106_ssm;
    2. create DATABASE 20231106_ssm;
    3. use 20231106_ssm;
    4.  
    5. CREATE TABLE `user`  (
    6.                          `id` int NOT NULL AUTO_INCREMENT COMMENT '主键',
    7.                          `username` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '用户名',
    8.                          `password` varchar(60) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '密码',
    9.                          `age` int NULL DEFAULT NULL COMMENT '年龄',
    10.                          PRIMARY KEY (`id`) USING BTREE
    11. ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = Dynamic;
    12.  
    13. INSERT INTO `user` VALUES (1, 'zhangsan', 'zhangsan123', 23);
    14. INSERT INTO `user` VALUES (2, 'lisi', 'lisi123', 24);

    2.4、applicationContext.xml

    1. "1.0" encoding="UTF-8"?>
    2. <beans xmlns="http://www.springframework.org/schema/beans"
    3.        xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
    4.        xmlns:context="http://www.springframework.org/schema/context"
    5.        xmlns:tx="http://www.springframework.org/schema/tx"
    6.        xmlns:aop="http://www.springframework.org/schema/aop"
    7.        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 http://www.springframework.org/schema/tx http://www.springframework.org/schema/tx/spring-tx.xsd http://www.springframework.org/schema/aop https://www.springframework.org/schema/aop/spring-aop.xsd">
    8.     <context:property-placeholder location="classpath:db.properties"/>
    9.  
    10.     <context:component-scan base-package="org.star" use-default-filters="true">
    11.         <context:exclude-filter type="annotation" expression="org.springframework.stereotype.Controller"/>
    12.     context:component-scan>
    13.  
    14.     <bean class="org.springframework.jdbc.datasource.DriverManagerDataSource" id="dataSource">
    15.         <property name="driverClassName" value="${db.driver}"/>
    16.         <property name="url" value="${db.url}"/>
    17.         <property name="username" value="${db.username}"/>
    18.         <property name="password" value="${db.password}"/>
    19.     bean>
    20.  
    21.     <bean class="org.mybatis.spring.SqlSessionFactoryBean" id="sqlSessionFactoryBean">
    22.         <property name="dataSource" ref="dataSource"/>
    23.         <property name="typeAliasesPackage" value="org.star.entity.model"/>
    24.         <property name="configuration">
    25.             <bean class="org.apache.ibatis.session.Configuration">
    26.                 <property name="logImpl" value="org.apache.ibatis.logging.stdout.StdOutImpl">property>
    27.                 <property name="cacheEnabled" value="true">property>
    28.             bean>
    29.         property>
    30.         <property name="mapperLocations" value="classpath:mappers/*.xml"/>
    31.         
    32.     bean>
    33.     <bean class="org.mybatis.spring.mapper.MapperScannerConfigurer" id="mapperScannerConfigurer">
    34.         <property name="sqlSessionFactoryBeanName" value="sqlSessionFactoryBean"/>
    35.         <property name="basePackage" value="org.star.mapper"/>
    36.     bean>
    37.  
    38.     
    39.     <bean id="transactionManager" class="org.springframework.jdbc.datasource.DataSourceTransactionManager">
    40.         <property name="dataSource" ref="dataSource">property>
    41.     bean>
    42.  
    43.     
    44.     <tx:advice id="txAdvice" transaction-manager="transactionManager">
    45.         
    46.         <tx:attributes>
    47.             
    48.             <tx:method name="*" propagation="REQUIRED" isolation="DEFAULT"/>
    49.         tx:attributes>
    50.     tx:advice>
    51.  
    52.     <aop:config>
    53.         <aop:pointcut id="txPointCut" expression="execution(* org.star.service.UserService.*(..))"/>
    54.         <aop:advisor advice-ref="txAdvice" pointcut-ref="txPointCut">aop:advisor>
    55.     aop:config>
    56.  
    57. beans>

    2.5、dispatcherServlet.xml

    1. "1.0" encoding="UTF-8"?>
    2. <beans xmlns="http://www.springframework.org/schema/beans"
    3.        xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
    4.        xmlns:context="http://www.springframework.org/schema/context"
    5.        xmlns:mvc="http://www.springframework.org/schema/mvc"
    6.        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/mvc https://www.springframework.org/schema/mvc/spring-mvc.xsd">
    7.  
    8.     <context:component-scan base-package="org.star" use-default-filters="false">
    9.         <context:include-filter type="annotation" expression="org.springframework.stereotype.Controller"/>
    10.     context:component-scan>
    11.     <mvc:annotation-driven/>
    12.  
    13. beans>

    2.6、web.xml

    1. "1.0" encoding="UTF-8"?>
    2. <web-app xmlns="http://xmlns.jcp.org/xml/ns/javaee"
    3.          xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
    4.          xsi:schemaLocation="http://xmlns.jcp.org/xml/ns/javaee http://xmlns.jcp.org/xml/ns/javaee/web-app_4_0.xsd"
    5.          version="4.0">
    6.  
    7.     
    8.     <context-param>
    9.         <param-name>contextConfigLocationparam-name>
    10.         <param-value>classpath:applicationContext.xmlparam-value>
    11.     context-param>
    12.     <listener>
    13.         <listener-class>org.springframework.web.context.ContextLoaderListenerlistener-class>
    14.     listener>
    15.  
    16.     
    17.     <servlet>
    18.         <servlet-name>springmvcservlet-name>
    19.         <servlet-class>org.springframework.web.servlet.DispatcherServletservlet-class>
    20.         <init-param>
    21.             <param-name>contextConfigLocationparam-name>
    22.             <param-value>classpath:dispatcherServlet.xmlparam-value>
    23.         init-param>
    24.     servlet>
    25.     <servlet-mapping>
    26.         <servlet-name>springmvcservlet-name>
    27.         <url-pattern>/url-pattern>
    28.     servlet-mapping>
    29.  
    30.     
    31.     <filter>
    32.         <filter-name>encodingFilterfilter-name>
    33.         <filter-class>org.springframework.web.filter.CharacterEncodingFilterfilter-class>
    34.         <init-param>
    35.             <param-name>encodingparam-name>
    36.             <param-value>UTF-8param-value>
    37.         init-param>
    38.         <init-param>
    39.             <param-name>forceRequestEncodingparam-name>
    40.             <param-value>trueparam-value>
    41.         init-param>
    42.         <init-param>
    43.             <param-name>forceResponseEncodingparam-name>
    44.             <param-value>trueparam-value>
    45.         init-param>
    46.     filter>
    47.     <filter-mapping>
    48.         <filter-name>encodingFilterfilter-name>
    49.         <url-pattern>/*url-pattern>
    50.     filter-mapping>
    51.  
    52. web-app>

    2.7、UserDO

    1. /**
    2.  * @Author : 一叶浮萍归大海
    3.  * @Date: 2023/11/6 11:34
    4.  * @Description:
    5.  */
    6. @Data
    7. @AllArgsConstructor
    8. @NoArgsConstructor
    9. @Accessors(chain = true)
    10. @ToString(callSuper = true)
    11. public class UserDO implements Serializable {
    12.     /**
    13.      * 编号
    14.      */
    15.     private Integer id;
    16.  
    17.     /**
    18.      * 用户名
    19.      */
    20.     private String username;
    21.  
    22.     /**
    23.      * 密码
    24.      */
    25.     private String password;
    26.  
    27.     /**
    28.      * 年龄
    29.      */
    30.     private Integer age;
    31. }

    2.8、UserMappper

    1. /**
    2.  * @Author : 一叶浮萍归大海
    3.  * @Date: 2023/11/6 11:35
    4.  * @Description:
    5.  */
    6. public interface UserMapper {
    7.  
    8.     /**
    9.      * 添加用户
    10.      * @param param
    11.      */
    12.     void saveUser(UserDO param);
    13.  
    14.     /**
    15.      * 查询所有的用户
    16.      * @return
    17.      */
    18.     List listAllUser();
    19.  
    20.     /**
    21.      * 根据id查询用户
    22.      * @param id
    23.      * @return
    24.      */
    25.     UserDO getUserById(Integer id);
    26. }

    2.9、UserMapper.xml

    1. mapper
    2.         PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN"
    3.         "http://mybatis.org/dtd/mybatis-3-mapper.dtd">
    4.  
    5. <mapper namespace="org.star.mapper.UserMapper">
    6.  
    7.     <insert id="saveUser">
    8.         insert into `user`(username,password,age) values (#{username},#{password},#{age})
    9.     insert>
    10.  
    11.  
    12.     <select id="listAllUser" resultType="userDO">
    13.         select * from `user`
    14.     select>
    15.  
    16.     <select id="getUserById" resultType="userDO">
    17.         select * from `user` where id = #{id}
    18.     select>
    19. mapper>

    2.10、UserService

    1. /**
    2.  * @Author : 一叶浮萍归大海
    3.  * @Date: 2023/11/6 11:36
    4.  * @Description:
    5.  */
    6. @Service
    7. public class UserService {
    8.  
    9.     @Autowired
    10.     private UserMapper userMapper;
    11.  
    12.     @Transactional(propagation = Propagation.REQUIRED,rollbackFor = Exception.class)
    13.     public List listAllUser() {
    14.  
    15.         return userMapper.listAllUser();
    16.     }
    17.  
    18.     public void saveUser(UserDO param) {
    19.         userMapper.saveUser(param);
    20.     }
    21.  
    22.     /**
    23.      * 不加此注解的话，将会执行多次数据库查询
    24.      * 参考：https://blog.51cto.com/u_15942107/6019692
    25.      * @param id
    26.      * @return
    27.      */
    28.     @Transactional(propagation = Propagation.REQUIRED,rollbackFor = Exception.class)
    29.     public UserDO getUserById(Integer id) {
    30.         UserDO u1 = userMapper.getUserById(id);
    31.         UserDO u2 = userMapper.getUserById(id);
    32.         UserDO u3 = userMapper.getUserById(id);
    33.         System.out.println(u1);
    34.         System.out.println(u2);
    35.         System.out.println(u3);
    36.  
    37.         return userMapper.getUserById(id);
    38.     }
    39. }

    2.11、UserController

    1. @Slf4j
    2. @RestController
    3. public class UserController {
    4.  
    5.     @Autowired
    6.     private UserService userService;
    7.  
    8.     @PostMapping("/saveUser")
    9.     public String saveUser(@RequestBody UserDO param) {
    10.         log.info("UserController saveUser param:{}", param);
    11.         userService.saveUser(param);
    12.         return "SUCCESS";
    13.     }
    14.  
    15.     @GetMapping("/listAllUser")
    16.     public List listAllUser() {
    17.         log.info("=================>listAllUser");
    18.         return userService.listAllUser();
    19.     }
    20.  
    21.     @GetMapping("/getUserById/{id}")
    22.     public UserDO getUserById(@PathVariable("id") Integer id) {
    23.         log.info("=================>getUserById id:{}",id);
    24.         return userService.getUserById(id);
    25.     }
    26.  
    27. }

    三、测试

    http://localhost:8080/listAllUser

    四、项目结构

  • 相关阅读:
    Qt 天气预报程序解析
    Express的基本使用app.post()app.get()res.send()
    学生个人单页面网页作业 学生网页设计成品 静态HTML网页单页制作 dreamweaver网页设计与制作代码 web前端期末大作业
    B站每日自动签到&传统单节点网站的 Serverless 上云
    C#通过FTP与异构系统实现业务接口
    [入门到吐槽系列] Webix 10分钟入门 一 管理后台制作
    three.js调试工具dat.gui使用
    目标检测YOLO实战应用案例100讲-基于YOLOv5的航拍图像旋转目标检测
    《计算机体系结构量化研究方法第六版》1.2 计算机的分类
    【计算机系统结构】指令级高度并行的超级计算机
  • 原文地址：https://blog.csdn.net/HelloWorld20161112/article/details/134247298