SSM框架整合

王海鱼  金牌会员 | 2024-5-16 02:22:02 | 显示全部楼层 | 阅读模式
打印 上一主题 下一主题
楼主

主题 907|帖子 907|积分 2721

SSM框架整合


  • 环境： Maven3.92 、 Mysql8.0、Tomcat7.0
  • 数据库
  1. /*
  2. Navicat Premium Data Transfer
  4. Source Server         : Graude
  5. Source Server Type    : MySQL
  6. Source Server Version : 80035 (8.0.35)
  7. Source Host           : localhost:3306
  8. Source Schema         : ssmbuild
  10. Target Server Type    : MySQL
  11. Target Server Version : 80035 (8.0.35)
  12. File Encoding         : 65001
  14. Date: 01/04/2024 16:15:39
  15. */
  17. SET NAMES utf8mb4;
  18. SET FOREIGN_KEY_CHECKS = 0;
  20. -- ----------------------------
  21. -- Table structure for books
  22. -- ----------------------------
  23. DROP TABLE IF EXISTS `books`;
  24. CREATE TABLE `books`  (
  25.   `bookID` int NOT NULL AUTO_INCREMENT,
  26.   `bookName` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
  27.   `bookCounts` int NULL DEFAULT NULL,
  28.   `detail` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
  29.   PRIMARY KEY (`bookID`) USING BTREE
  30. ) ENGINE = InnoDB AUTO_INCREMENT = 3 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = Dynamic;
  32. -- ----------------------------
  33. -- Records of books
  34. -- ----------------------------
  35. INSERT INTO `books` VALUES (1, 'Java', 1, '从入门到入土');
  36. INSERT INTO `books` VALUES (2, 'MySQL', 2, '从删库到跑路');
  38. SET FOREIGN_KEY_CHECKS = 1;
复制代码

  • 导入环境依赖
  1.     <dependencies>
  2.            
  3.         <dependency>
  4. <?xml version="1.0" encoding="UTF-8"?>
  5. <beans xmlns="http://www.springframework.org/schema/beans"
  6.        xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
  7.        xsi:schemaLocation="http://www.springframework.org/schema/beans
  8.         http://www.springframework.org/schema/beans/spring-beans.xsd">
  10.     <import resource="classpath:spring-dao.xml"/>
  11.     <import resource="classpath:spring-service.xml"/>
  12.     <import resource="classpath:spring-mvc.xml"/>
  13. </beans><groupId>mysql</groupId>
  14. <?xml version="1.0" encoding="UTF-8"?>
  15. <beans xmlns="http://www.springframework.org/schema/beans"
  16.        xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
  17.        xsi:schemaLocation="http://www.springframework.org/schema/beans
  18.         http://www.springframework.org/schema/beans/spring-beans.xsd">
  20.     <import resource="classpath:spring-dao.xml"/>
  21.     <import resource="classpath:spring-service.xml"/>
  22.     <import resource="classpath:spring-mvc.xml"/>
  23. </beans><artifactId>mysql-connector-java</artifactId>
  24. <?xml version="1.0" encoding="UTF-8"?>
  25. <beans xmlns="http://www.springframework.org/schema/beans"
  26.        xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
  27.        xsi:schemaLocation="http://www.springframework.org/schema/beans
  28.         http://www.springframework.org/schema/beans/spring-beans.xsd">
  30.     <import resource="classpath:spring-dao.xml"/>
  31.     <import resource="classpath:spring-service.xml"/>
  32.     <import resource="classpath:spring-mvc.xml"/>
  33. </beans><version>8.0.33</version>
  34.         </dependency>
  35.         
  36.         <dependency>
  37. <?xml version="1.0" encoding="UTF-8"?>
  38. <beans xmlns="http://www.springframework.org/schema/beans"
  39.        xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
  40.        xsi:schemaLocation="http://www.springframework.org/schema/beans
  41.         http://www.springframework.org/schema/beans/spring-beans.xsd">
  43.     <import resource="classpath:spring-dao.xml"/>
  44.     <import resource="classpath:spring-service.xml"/>
  45.     <import resource="classpath:spring-mvc.xml"/>
  46. </beans><groupId>junit</groupId>
  47. <?xml version="1.0" encoding="UTF-8"?>
  48. <beans xmlns="http://www.springframework.org/schema/beans"
  49.        xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
  50.        xsi:schemaLocation="http://www.springframework.org/schema/beans
  51.         http://www.springframework.org/schema/beans/spring-beans.xsd">
  53.     <import resource="classpath:spring-dao.xml"/>
  54.     <import resource="classpath:spring-service.xml"/>
  55.     <import resource="classpath:spring-mvc.xml"/>
  56. </beans><artifactId>junit</artifactId>
  57. <?xml version="1.0" encoding="UTF-8"?>
  58. <beans xmlns="http://www.springframework.org/schema/beans"
  59.        xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
  60.        xsi:schemaLocation="http://www.springframework.org/schema/beans
  61.         http://www.springframework.org/schema/beans/spring-beans.xsd">
  63.     <import resource="classpath:spring-dao.xml"/>
  64.     <import resource="classpath:spring-service.xml"/>
  65.     <import resource="classpath:spring-mvc.xml"/>
  66. </beans><version>4.13.1</version>
  67. <?xml version="1.0" encoding="UTF-8"?>
  68. <beans xmlns="http://www.springframework.org/schema/beans"
  69.        xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
  70.        xsi:schemaLocation="http://www.springframework.org/schema/beans
  71.         http://www.springframework.org/schema/beans/spring-beans.xsd">
  73.     <import resource="classpath:spring-dao.xml"/>
  74.     <import resource="classpath:spring-service.xml"/>
  75.     <import resource="classpath:spring-mvc.xml"/>
  76. </beans><scope>test</scope>
  77.         </dependency>
  78.         
  79.         <dependency>
  80. <?xml version="1.0" encoding="UTF-8"?>
  81. <beans xmlns="http://www.springframework.org/schema/beans"
  82.        xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
  83.        xsi:schemaLocation="http://www.springframework.org/schema/beans
  84.         http://www.springframework.org/schema/beans/spring-beans.xsd">
  86.     <import resource="classpath:spring-dao.xml"/>
  87.     <import resource="classpath:spring-service.xml"/>
  88.     <import resource="classpath:spring-mvc.xml"/>
  89. </beans><groupId>com.mchange</groupId>
  90. <?xml version="1.0" encoding="UTF-8"?>
  91. <beans xmlns="http://www.springframework.org/schema/beans"
  92.        xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
  93.        xsi:schemaLocation="http://www.springframework.org/schema/beans
  94.         http://www.springframework.org/schema/beans/spring-beans.xsd">
  96.     <import resource="classpath:spring-dao.xml"/>
  97.     <import resource="classpath:spring-service.xml"/>
  98.     <import resource="classpath:spring-mvc.xml"/>
  99. </beans><artifactId>c3p0</artifactId>
  100. <?xml version="1.0" encoding="UTF-8"?>
  101. <beans xmlns="http://www.springframework.org/schema/beans"
  102.        xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
  103.        xsi:schemaLocation="http://www.springframework.org/schema/beans
  104.         http://www.springframework.org/schema/beans/spring-beans.xsd">
  106.     <import resource="classpath:spring-dao.xml"/>
  107.     <import resource="classpath:spring-service.xml"/>
  108.     <import resource="classpath:spring-mvc.xml"/>
  109. </beans><version>0.9.5.2</version>
  110.         </dependency>
  111.         
  112.         <dependency>
  113. <?xml version="1.0" encoding="UTF-8"?>
  114. <beans xmlns="http://www.springframework.org/schema/beans"
  115.        xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
  116.        xsi:schemaLocation="http://www.springframework.org/schema/beans
  117.         http://www.springframework.org/schema/beans/spring-beans.xsd">
  119.     <import resource="classpath:spring-dao.xml"/>
  120.     <import resource="classpath:spring-service.xml"/>
  121.     <import resource="classpath:spring-mvc.xml"/>
  122. </beans><groupId>javax.servlet</groupId>
  123. <?xml version="1.0" encoding="UTF-8"?>
  124. <beans xmlns="http://www.springframework.org/schema/beans"
  125.        xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
  126.        xsi:schemaLocation="http://www.springframework.org/schema/beans
  127.         http://www.springframework.org/schema/beans/spring-beans.xsd">
  129.     <import resource="classpath:spring-dao.xml"/>
  130.     <import resource="classpath:spring-service.xml"/>
  131.     <import resource="classpath:spring-mvc.xml"/>
  132. </beans><artifactId>servlet-api</artifactId>
  133. <?xml version="1.0" encoding="UTF-8"?>
  134. <beans xmlns="http://www.springframework.org/schema/beans"
  135.        xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
  136.        xsi:schemaLocation="http://www.springframework.org/schema/beans
  137.         http://www.springframework.org/schema/beans/spring-beans.xsd">
  139.     <import resource="classpath:spring-dao.xml"/>
  140.     <import resource="classpath:spring-service.xml"/>
  141.     <import resource="classpath:spring-mvc.xml"/>
  142. </beans><version>2.5</version>
  143.         </dependency>
  144.         
  145.         <dependency>
  146. <?xml version="1.0" encoding="UTF-8"?>
  147. <beans xmlns="http://www.springframework.org/schema/beans"
  148.        xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
  149.        xsi:schemaLocation="http://www.springframework.org/schema/beans
  150.         http://www.springframework.org/schema/beans/spring-beans.xsd">
  152.     <import resource="classpath:spring-dao.xml"/>
  153.     <import resource="classpath:spring-service.xml"/>
  154.     <import resource="classpath:spring-mvc.xml"/>
  155. </beans><groupId>javax.servlet.jsp</groupId>
  156. <?xml version="1.0" encoding="UTF-8"?>
  157. <beans xmlns="http://www.springframework.org/schema/beans"
  158.        xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
  159.        xsi:schemaLocation="http://www.springframework.org/schema/beans
  160.         http://www.springframework.org/schema/beans/spring-beans.xsd">
  162.     <import resource="classpath:spring-dao.xml"/>
  163.     <import resource="classpath:spring-service.xml"/>
  164.     <import resource="classpath:spring-mvc.xml"/>
  165. </beans><artifactId>jsp-api</artifactId>
  166. <?xml version="1.0" encoding="UTF-8"?>
  167. <beans xmlns="http://www.springframework.org/schema/beans"
  168.        xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
  169.        xsi:schemaLocation="http://www.springframework.org/schema/beans
  170.         http://www.springframework.org/schema/beans/spring-beans.xsd">
  172.     <import resource="classpath:spring-dao.xml"/>
  173.     <import resource="classpath:spring-service.xml"/>
  174.     <import resource="classpath:spring-mvc.xml"/>
  175. </beans><version>2.2</version>
  176.         </dependency>
  177.         <dependency>
  178. <?xml version="1.0" encoding="UTF-8"?>
  179. <beans xmlns="http://www.springframework.org/schema/beans"
  180.        xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
  181.        xsi:schemaLocation="http://www.springframework.org/schema/beans
  182.         http://www.springframework.org/schema/beans/spring-beans.xsd">
  184.     <import resource="classpath:spring-dao.xml"/>
  185.     <import resource="classpath:spring-service.xml"/>
  186.     <import resource="classpath:spring-mvc.xml"/>
  187. </beans><groupId>javax.servlet</groupId>
  188. <?xml version="1.0" encoding="UTF-8"?>
  189. <beans xmlns="http://www.springframework.org/schema/beans"
  190.        xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
  191.        xsi:schemaLocation="http://www.springframework.org/schema/beans
  192.         http://www.springframework.org/schema/beans/spring-beans.xsd">
  194.     <import resource="classpath:spring-dao.xml"/>
  195.     <import resource="classpath:spring-service.xml"/>
  196.     <import resource="classpath:spring-mvc.xml"/>
  197. </beans><artifactId>jstl</artifactId>
  198. <?xml version="1.0" encoding="UTF-8"?>
  199. <beans xmlns="http://www.springframework.org/schema/beans"
  200.        xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
  201.        xsi:schemaLocation="http://www.springframework.org/schema/beans
  202.         http://www.springframework.org/schema/beans/spring-beans.xsd">
  204.     <import resource="classpath:spring-dao.xml"/>
  205.     <import resource="classpath:spring-service.xml"/>
  206.     <import resource="classpath:spring-mvc.xml"/>
  207. </beans><version>1.2</version>
  208.         </dependency>
  209.         
  210.         <dependency>
  211. <?xml version="1.0" encoding="UTF-8"?>
  212. <beans xmlns="http://www.springframework.org/schema/beans"
  213.        xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
  214.        xsi:schemaLocation="http://www.springframework.org/schema/beans
  215.         http://www.springframework.org/schema/beans/spring-beans.xsd">
  217.     <import resource="classpath:spring-dao.xml"/>
  218.     <import resource="classpath:spring-service.xml"/>
  219.     <import resource="classpath:spring-mvc.xml"/>
  220. </beans><groupId>org.mybatis</groupId>
  221. <?xml version="1.0" encoding="UTF-8"?>
  222. <beans xmlns="http://www.springframework.org/schema/beans"
  223.        xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
  224.        xsi:schemaLocation="http://www.springframework.org/schema/beans
  225.         http://www.springframework.org/schema/beans/spring-beans.xsd">
  227.     <import resource="classpath:spring-dao.xml"/>
  228.     <import resource="classpath:spring-service.xml"/>
  229.     <import resource="classpath:spring-mvc.xml"/>
  230. </beans><artifactId>mybatis</artifactId>
  231. <?xml version="1.0" encoding="UTF-8"?>
  232. <beans xmlns="http://www.springframework.org/schema/beans"
  233.        xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
  234.        xsi:schemaLocation="http://www.springframework.org/schema/beans
  235.         http://www.springframework.org/schema/beans/spring-beans.xsd">
  237.     <import resource="classpath:spring-dao.xml"/>
  238.     <import resource="classpath:spring-service.xml"/>
  239.     <import resource="classpath:spring-mvc.xml"/>
  240. </beans><version>3.5.9</version>
  241.         </dependency>
  242.         
  243.         <dependency>
  244. <?xml version="1.0" encoding="UTF-8"?>
  245. <beans xmlns="http://www.springframework.org/schema/beans"
  246.        xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
  247.        xsi:schemaLocation="http://www.springframework.org/schema/beans
  248.         http://www.springframework.org/schema/beans/spring-beans.xsd">
  250.     <import resource="classpath:spring-dao.xml"/>
  251.     <import resource="classpath:spring-service.xml"/>
  252.     <import resource="classpath:spring-mvc.xml"/>
  253. </beans><groupId>org.mybatis</groupId>
  254. <?xml version="1.0" encoding="UTF-8"?>
  255. <beans xmlns="http://www.springframework.org/schema/beans"
  256.        xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
  257.        xsi:schemaLocation="http://www.springframework.org/schema/beans
  258.         http://www.springframework.org/schema/beans/spring-beans.xsd">
  260.     <import resource="classpath:spring-dao.xml"/>
  261.     <import resource="classpath:spring-service.xml"/>
  262.     <import resource="classpath:spring-mvc.xml"/>
  263. </beans><artifactId>mybatis-spring</artifactId>
  264. <?xml version="1.0" encoding="UTF-8"?>
  265. <beans xmlns="http://www.springframework.org/schema/beans"
  266.        xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
  267.        xsi:schemaLocation="http://www.springframework.org/schema/beans
  268.         http://www.springframework.org/schema/beans/spring-beans.xsd">
  270.     <import resource="classpath:spring-dao.xml"/>
  271.     <import resource="classpath:spring-service.xml"/>
  272.     <import resource="classpath:spring-mvc.xml"/>
  273. </beans><version>2.0.5</version>
  274.         </dependency>
  275.         
  276.         <dependency>
  277. <?xml version="1.0" encoding="UTF-8"?>
  278. <beans xmlns="http://www.springframework.org/schema/beans"
  279.        xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
  280.        xsi:schemaLocation="http://www.springframework.org/schema/beans
  281.         http://www.springframework.org/schema/beans/spring-beans.xsd">
  283.     <import resource="classpath:spring-dao.xml"/>
  284.     <import resource="classpath:spring-service.xml"/>
  285.     <import resource="classpath:spring-mvc.xml"/>
  286. </beans><groupId>org.springframework</groupId>
  287. <?xml version="1.0" encoding="UTF-8"?>
  288. <beans xmlns="http://www.springframework.org/schema/beans"
  289.        xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
  290.        xsi:schemaLocation="http://www.springframework.org/schema/beans
  291.         http://www.springframework.org/schema/beans/spring-beans.xsd">
  293.     <import resource="classpath:spring-dao.xml"/>
  294.     <import resource="classpath:spring-service.xml"/>
  295.     <import resource="classpath:spring-mvc.xml"/>
  296. </beans><artifactId>spring-webmvc</artifactId>
  297. <?xml version="1.0" encoding="UTF-8"?>
  298. <beans xmlns="http://www.springframework.org/schema/beans"
  299.        xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
  300.        xsi:schemaLocation="http://www.springframework.org/schema/beans
  301.         http://www.springframework.org/schema/beans/spring-beans.xsd">
  303.     <import resource="classpath:spring-dao.xml"/>
  304.     <import resource="classpath:spring-service.xml"/>
  305.     <import resource="classpath:spring-mvc.xml"/>
  306. </beans><version>5.3.27</version>
  307.         </dependency>
  308.         <dependency>
  309. <?xml version="1.0" encoding="UTF-8"?>
  310. <beans xmlns="http://www.springframework.org/schema/beans"
  311.        xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
  312.        xsi:schemaLocation="http://www.springframework.org/schema/beans
  313.         http://www.springframework.org/schema/beans/spring-beans.xsd">
  315.     <import resource="classpath:spring-dao.xml"/>
  316.     <import resource="classpath:spring-service.xml"/>
  317.     <import resource="classpath:spring-mvc.xml"/>
  318. </beans><groupId>org.springframework</groupId>
  319. <?xml version="1.0" encoding="UTF-8"?>
  320. <beans xmlns="http://www.springframework.org/schema/beans"
  321.        xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
  322.        xsi:schemaLocation="http://www.springframework.org/schema/beans
  323.         http://www.springframework.org/schema/beans/spring-beans.xsd">
  325.     <import resource="classpath:spring-dao.xml"/>
  326.     <import resource="classpath:spring-service.xml"/>
  327.     <import resource="classpath:spring-mvc.xml"/>
  328. </beans><artifactId>spring-jdbc</artifactId>
  329. <?xml version="1.0" encoding="UTF-8"?>
  330. <beans xmlns="http://www.springframework.org/schema/beans"
  331.        xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
  332.        xsi:schemaLocation="http://www.springframework.org/schema/beans
  333.         http://www.springframework.org/schema/beans/spring-beans.xsd">
  335.     <import resource="classpath:spring-dao.xml"/>
  336.     <import resource="classpath:spring-service.xml"/>
  337.     <import resource="classpath:spring-mvc.xml"/>
  338. </beans><version>5.3.8</version>
  339.         </dependency>
  340.     </dependencies>
复制代码

  • 静态资源导出问题
  1.     <build>
  2.         <resources>
  3. <?xml version="1.0" encoding="UTF-8"?>
  4. <beans xmlns="http://www.springframework.org/schema/beans"
  5.        xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
  6.        xsi:schemaLocation="http://www.springframework.org/schema/beans
  7.         http://www.springframework.org/schema/beans/spring-beans.xsd">
  9.     <import resource="classpath:spring-dao.xml"/>
  10.     <import resource="classpath:spring-service.xml"/>
  11.     <import resource="classpath:spring-mvc.xml"/>
  12. </beans><resource>
  13. <?xml version="1.0" encoding="UTF-8"?>
  14. <beans xmlns="http://www.springframework.org/schema/beans"
  15.        xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
  16.        xsi:schemaLocation="http://www.springframework.org/schema/beans
  17.         http://www.springframework.org/schema/beans/spring-beans.xsd">
  19.     <import resource="classpath:spring-dao.xml"/>
  20.     <import resource="classpath:spring-service.xml"/>
  21.     <import resource="classpath:spring-mvc.xml"/>
  22. </beans>    <directory>src/main/java</directory>
  23. <?xml version="1.0" encoding="UTF-8"?>
  24. <beans xmlns="http://www.springframework.org/schema/beans"
  25.        xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
  26.        xsi:schemaLocation="http://www.springframework.org/schema/beans
  27.         http://www.springframework.org/schema/beans/spring-beans.xsd">
  29.     <import resource="classpath:spring-dao.xml"/>
  30.     <import resource="classpath:spring-service.xml"/>
  31.     <import resource="classpath:spring-mvc.xml"/>
  32. </beans>    <includes>
  33. <?xml version="1.0" encoding="UTF-8"?>
  34. <beans xmlns="http://www.springframework.org/schema/beans"
  35.        xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
  36.        xsi:schemaLocation="http://www.springframework.org/schema/beans
  37.         http://www.springframework.org/schema/beans/spring-beans.xsd">
  39.     <import resource="classpath:spring-dao.xml"/>
  40.     <import resource="classpath:spring-service.xml"/>
  41.     <import resource="classpath:spring-mvc.xml"/>
  42. </beans>        <include>**/*.properties</include>
  43. <?xml version="1.0" encoding="UTF-8"?>
  44. <beans xmlns="http://www.springframework.org/schema/beans"
  45.        xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
  46.        xsi:schemaLocation="http://www.springframework.org/schema/beans
  47.         http://www.springframework.org/schema/beans/spring-beans.xsd">
  49.     <import resource="classpath:spring-dao.xml"/>
  50.     <import resource="classpath:spring-service.xml"/>
  51.     <import resource="classpath:spring-mvc.xml"/>
  52. </beans>        <include>**/*.xml</include>
  53. <?xml version="1.0" encoding="UTF-8"?>
  54. <beans xmlns="http://www.springframework.org/schema/beans"
  55.        xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
  56.        xsi:schemaLocation="http://www.springframework.org/schema/beans
  57.         http://www.springframework.org/schema/beans/spring-beans.xsd">
  59.     <import resource="classpath:spring-dao.xml"/>
  60.     <import resource="classpath:spring-service.xml"/>
  61.     <import resource="classpath:spring-mvc.xml"/>
  62. </beans>    </includes>
  63. <?xml version="1.0" encoding="UTF-8"?>
  64. <beans xmlns="http://www.springframework.org/schema/beans"
  65.        xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
  66.        xsi:schemaLocation="http://www.springframework.org/schema/beans
  67.         http://www.springframework.org/schema/beans/spring-beans.xsd">
  69.     <import resource="classpath:spring-dao.xml"/>
  70.     <import resource="classpath:spring-service.xml"/>
  71.     <import resource="classpath:spring-mvc.xml"/>
  72. </beans>    <filtering>false</filtering>
  73. <?xml version="1.0" encoding="UTF-8"?>
  74. <beans xmlns="http://www.springframework.org/schema/beans"
  75.        xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
  76.        xsi:schemaLocation="http://www.springframework.org/schema/beans
  77.         http://www.springframework.org/schema/beans/spring-beans.xsd">
  79.     <import resource="classpath:spring-dao.xml"/>
  80.     <import resource="classpath:spring-service.xml"/>
  81.     <import resource="classpath:spring-mvc.xml"/>
  82. </beans></resource>
  83. <?xml version="1.0" encoding="UTF-8"?>
  84. <beans xmlns="http://www.springframework.org/schema/beans"
  85.        xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
  86.        xsi:schemaLocation="http://www.springframework.org/schema/beans
  87.         http://www.springframework.org/schema/beans/spring-beans.xsd">
  89.     <import resource="classpath:spring-dao.xml"/>
  90.     <import resource="classpath:spring-service.xml"/>
  91.     <import resource="classpath:spring-mvc.xml"/>
  92. </beans><resource>
  93. <?xml version="1.0" encoding="UTF-8"?>
  94. <beans xmlns="http://www.springframework.org/schema/beans"
  95.        xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
  96.        xsi:schemaLocation="http://www.springframework.org/schema/beans
  97.         http://www.springframework.org/schema/beans/spring-beans.xsd">
  99.     <import resource="classpath:spring-dao.xml"/>
  100.     <import resource="classpath:spring-service.xml"/>
  101.     <import resource="classpath:spring-mvc.xml"/>
  102. </beans>    <directory>src/main/resources</directory>
  103. <?xml version="1.0" encoding="UTF-8"?>
  104. <beans xmlns="http://www.springframework.org/schema/beans"
  105.        xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
  106.        xsi:schemaLocation="http://www.springframework.org/schema/beans
  107.         http://www.springframework.org/schema/beans/spring-beans.xsd">
  109.     <import resource="classpath:spring-dao.xml"/>
  110.     <import resource="classpath:spring-service.xml"/>
  111.     <import resource="classpath:spring-mvc.xml"/>
  112. </beans>    <includes>
  113. <?xml version="1.0" encoding="UTF-8"?>
  114. <beans xmlns="http://www.springframework.org/schema/beans"
  115.        xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
  116.        xsi:schemaLocation="http://www.springframework.org/schema/beans
  117.         http://www.springframework.org/schema/beans/spring-beans.xsd">
  119.     <import resource="classpath:spring-dao.xml"/>
  120.     <import resource="classpath:spring-service.xml"/>
  121.     <import resource="classpath:spring-mvc.xml"/>
  122. </beans>        <include>**/*.properties</include>
  123. <?xml version="1.0" encoding="UTF-8"?>
  124. <beans xmlns="http://www.springframework.org/schema/beans"
  125.        xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
  126.        xsi:schemaLocation="http://www.springframework.org/schema/beans
  127.         http://www.springframework.org/schema/beans/spring-beans.xsd">
  129.     <import resource="classpath:spring-dao.xml"/>
  130.     <import resource="classpath:spring-service.xml"/>
  131.     <import resource="classpath:spring-mvc.xml"/>
  132. </beans>        <include>**/*.xml</include>
  133. <?xml version="1.0" encoding="UTF-8"?>
  134. <beans xmlns="http://www.springframework.org/schema/beans"
  135.        xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
  136.        xsi:schemaLocation="http://www.springframework.org/schema/beans
  137.         http://www.springframework.org/schema/beans/spring-beans.xsd">
  139.     <import resource="classpath:spring-dao.xml"/>
  140.     <import resource="classpath:spring-service.xml"/>
  141.     <import resource="classpath:spring-mvc.xml"/>
  142. </beans>    </includes>
  143. <?xml version="1.0" encoding="UTF-8"?>
  144. <beans xmlns="http://www.springframework.org/schema/beans"
  145.        xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
  146.        xsi:schemaLocation="http://www.springframework.org/schema/beans
  147.         http://www.springframework.org/schema/beans/spring-beans.xsd">
  149.     <import resource="classpath:spring-dao.xml"/>
  150.     <import resource="classpath:spring-service.xml"/>
  151.     <import resource="classpath:spring-mvc.xml"/>
  152. </beans>    <filtering>false</filtering>
  153. <?xml version="1.0" encoding="UTF-8"?>
  154. <beans xmlns="http://www.springframework.org/schema/beans"
  155.        xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
  156.        xsi:schemaLocation="http://www.springframework.org/schema/beans
  157.         http://www.springframework.org/schema/beans/spring-beans.xsd">
  159.     <import resource="classpath:spring-dao.xml"/>
  160.     <import resource="classpath:spring-service.xml"/>
  161.     <import resource="classpath:spring-mvc.xml"/>
  162. </beans></resource>
  163.         </resources>
  164. </build>
复制代码
一、配置Mybatis


  • 配置mybatis-config映射文件
  1. <?xml version="1.0" encoding="UTF-8" ?>
  2. <!DOCTYPE configuration
  3.         PUBLIC "-//mybatis.org//DTD Config 3.0//EN"
  4.         "http://mybatis.org/dtd/mybatis-3-config.dtd">
  5. <configuration>
  6.          
  8.    
  9.     <typeAliases>
  10.         <package name="com.wfy.pojo"/>
  11.     </typeAliases>
  13.     <mappers>
  14.         <mapper />
  15.     </mappers>
  16. </configuration>
复制代码

  • properties文件
使用的是mysql8.0以上的版本，url要配置时区
配置完成后，测试数据库连接
  1. jdbc.driver=com.mysql.jdbc.Driver
  2. jdbc.url=jdbc:mysql://localhost:3306/ssmbuild?useSSL=true&useUnicode=true&characterEncoding=utf8&serverTimezone=Asia/Shanghai
  3. jdbc.username=root
  4. jdbc.password=root
复制代码

  • 配置实体类(pojo)
  1. package com.wfy.pojo;
  3. import lombok.AllArgsConstructor;
  4. import lombok.Data;
  5. import lombok.NoArgsConstructor;
  7. @Data //使用该注解需要导入lombok依赖，偷懒用的
  8. @AllArgsConstructor//有参构造
  9. @NoArgsConstructor//无参构造
  10. public class Books {
  11.     private int bookID;
  12.     private String bookName;
  13.     private int bookCounts;
  14.     private String detail;
  15. }
复制代码

  • dao层（数据访问层）


  • BookMapper
  1. package com.wfy.dao;
  3. import com.wfy.pojo.Books;
  4. import org.apache.ibatis.annotations.Param;
  6. import java.util.List;
  8. public interface BookMapper {
  9.     //增
  10.      int addBook(Books books);
  11.     //删
  12.     int deleteBook(@Param("bookID") int bookID);
  13.     //改
  14.     int updateBook(Books books);
  15.     //查(一本)
  16.     Books queryBookById(@Param("bookID")int bookID);
  17.     //查（全部）
  18.     List<Books> queryAllBook();
  19. }
复制代码

  • BookMapper.xml映射文件
  1. <?xml version="1.0" encoding="UTF-8" ?>
  2. <!DOCTYPE mapper
  3.         PUBLIC "-//mybatis.org//DTD Config 3.0//EN"
  4.         "http://mybatis.org/dtd/mybatis-3-mapper.dtd">
  5. <mapper namespace="com.wfy.dao.BookMapper">
  7.       
  8.     <insert id="addBook" parameterType="Books">
  9.         insert into ssmbuild.books( bookName, bookCounts, detail)
  10.         values(#{bookName},#{bookCounts},#{detail})
  11.     </insert>
  12.         
  13.     <delete id="deleteBook" parameterType="int" >
  14.         delete from ssmbuild.books where bookID=#{bookID}
  15.     </delete>
  16.    
  17.     <update id="updateBook" parameterType="Books">
  18.         update ssmbuild.books
  19.         set bookName=#{bookName},bookCounts=#{bookCounts},detail=#{detail}
  20.         where bookID=#{bookID}
  21.     </update>
  22.    
  23.     <select id="queryBookById" resultType="Books">
  24.         select * from ssmbuild.books
  25. <?xml version="1.0" encoding="UTF-8"?>
  26. <beans xmlns="http://www.springframework.org/schema/beans"
  27.        xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
  28.        xsi:schemaLocation="http://www.springframework.org/schema/beans
  29.         http://www.springframework.org/schema/beans/spring-beans.xsd">
  31.     <import resource="classpath:spring-dao.xml"/>
  32.     <import resource="classpath:spring-service.xml"/>
  33.     <import resource="classpath:spring-mvc.xml"/>
  34. </beans>     where bookID=#{bookID}
  35.     </select>
  36.    
  37.     <select id="queryAllBook" resultType="Books">
  38.         select * from ssmbuild.books
  39.     </select>
  41. </mapper>
复制代码

  • service层（业务层）
使用service层去调用dao层，最大的作用就是解耦
即一个service层可以调用多个dao层


  • 接口Bookservice
  1. package com.wfy.service;
  2. import com.wfy.pojo.Books;
  3. import java.util.List;
  5. public interface BookService {
  6.     //增
  7.     int addBook(Books books);
  8.     //删
  9.     int deleteBook( int bookID);
  10.     //改
  11.     int updateBook(Books books);
  12.     //查(一本)
  13.     Books queryBookById(int bookID);
  14.     //查（全部）
  15.     List<Books> queryAllBook();
  16. }
复制代码

  • BookseviceImpl
  1. package com.wfy.service;
  3. import com.wfy.dao.BookMapper;
  4. import com.wfy.pojo.Books;
  6. import java.util.List;
  8. public class BookServiceImpl implements BookService{
  9.     //service层调用dao层：组合dao层
  10.     private BookMapper bookMapper;
  12.     public void setBookMapper(BookMapper bookMapper) {
  13.         this.bookMapper = bookMapper;
  14.     }
  16.     @Override
  17.     public int addBook(Books books) {
  18.         return bookMapper.addBook(books);
  19.     }
  21.     @Override
  22.     public int deleteBook(int bookID) {
  23.         return bookMapper.deleteBook(bookID);
  24.     }
  26.     @Override
  27.     public int updateBook(Books books) {
  28.         return bookMapper.updateBook(books);
  29.     }
  31.     @Override
  32.     public Books queryBookById(int bookID) {
  33.         return queryBookById(bookID);
  34.     }
  36.     @Override
  37.     public List<Books> queryAllBook() {
  38.         return bookMapper.queryAllBook();
  39.     }
  40. }
复制代码
二、配置Spring

2.1、spring-dao层配置
  1. <?xml version="1.0" encoding="UTF-8" ?>
  2. <!DOCTYPE configuration
  3.         PUBLIC "-//mybatis.org//DTD Config 3.0//EN"
  4.         "http://mybatis.org/dtd/mybatis-3-config.dtd">
  5. <configuration>
  6.          
  8.    
  9.     <typeAliases>
  10.         <package name="com.wfy.pojo"/>
  11.     </typeAliases>
  13.     <mappers>
  14.         <mapper />
  15.     </mappers>
  16. </configuration><?xml version="1.0" encoding="UTF-8" ?>
  17. <!DOCTYPE configuration
  18.         PUBLIC "-//mybatis.org//DTD Config 3.0//EN"
  19.         "http://mybatis.org/dtd/mybatis-3-config.dtd">
  20. <configuration>
  21.          
  23.    
  24.     <typeAliases>
  25.         <package name="com.wfy.pojo"/>
  26.     </typeAliases>
  28.     <mappers>
  29.         <mapper />
  30.     </mappers>
  31. </configuration><?xml version="1.0" encoding="UTF-8" ?>
  32. <!DOCTYPE configuration
  33.         PUBLIC "-//mybatis.org//DTD Config 3.0//EN"
  34.         "http://mybatis.org/dtd/mybatis-3-config.dtd">
  35. <configuration>
  36.          
  38.    
  39.     <typeAliases>
  40.         <package name="com.wfy.pojo"/>
  41.     </typeAliases>
  43.     <mappers>
  44.         <mapper />
  45.     </mappers>
  46. </configuration><?xml version="1.0" encoding="UTF-8" ?>
  47. <!DOCTYPE configuration
  48.         PUBLIC "-//mybatis.org//DTD Config 3.0//EN"
  49.         "http://mybatis.org/dtd/mybatis-3-config.dtd">
  50. <configuration>
  51.          
  53.    
  54.     <typeAliases>
  55.         <package name="com.wfy.pojo"/>
  56.     </typeAliases>
  58.     <mappers>
  59.         <mapper />
  60.     </mappers>
  61. </configuration><?xml version="1.0" encoding="UTF-8"?>
  62. <beans xmlns="http://www.springframework.org/schema/beans"
  63.        xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
  64.        xsi:schemaLocation="http://www.springframework.org/schema/beans
  65.         http://www.springframework.org/schema/beans/spring-beans.xsd">
  67.     <import resource="classpath:spring-dao.xml"/>
  68.     <import resource="classpath:spring-service.xml"/>
  69.     <import resource="classpath:spring-mvc.xml"/>
  70. </beans><?xml version="1.0" encoding="UTF-8"?>
  71. <beans xmlns="http://www.springframework.org/schema/beans"
  72.        xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
  73.        xsi:schemaLocation="http://www.springframework.org/schema/beans
  74.         http://www.springframework.org/schema/beans/spring-beans.xsd">
  76.     <import resource="classpath:spring-dao.xml"/>
  77.     <import resource="classpath:spring-service.xml"/>
  78.     <import resource="classpath:spring-mvc.xml"/>
  79. </beans>
复制代码
2.2、spring-service层配置
  1. <?xml version="1.0" encoding="UTF-8" ?>
  2. <!DOCTYPE configuration
  3.         PUBLIC "-//mybatis.org//DTD Config 3.0//EN"
  4.         "http://mybatis.org/dtd/mybatis-3-config.dtd">
  5. <configuration>
  6.          
  8.    
  9.     <typeAliases>
  10.         <package name="com.wfy.pojo"/>
  11.     </typeAliases>
  13.     <mappers>
  14.         <mapper />
  15.     </mappers>
  16. </configuration><?xml version="1.0" encoding="UTF-8"?>
  17. <beans xmlns="http://www.springframework.org/schema/beans"
  18.        xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
  19.        xsi:schemaLocation="http://www.springframework.org/schema/beans
  20.         http://www.springframework.org/schema/beans/spring-beans.xsd">
  22.     <import resource="classpath:spring-dao.xml"/>
  23.     <import resource="classpath:spring-service.xml"/>
  24.     <import resource="classpath:spring-mvc.xml"/>
  25. </beans><?xml version="1.0" encoding="UTF-8"?>
  26. <beans xmlns="http://www.springframework.org/schema/beans"
  27.        xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
  28.        xsi:schemaLocation="http://www.springframework.org/schema/beans
  29.         http://www.springframework.org/schema/beans/spring-beans.xsd">
  31.     <import resource="classpath:spring-dao.xml"/>
  32.     <import resource="classpath:spring-service.xml"/>
  33.     <import resource="classpath:spring-mvc.xml"/>
  34. </beans>
复制代码
三、配置SpringMVC
  1. <?xml version="1.0" encoding="UTF-8" ?>
  2. <!DOCTYPE configuration
  3.         PUBLIC "-//mybatis.org//DTD Config 3.0//EN"
  4.         "http://mybatis.org/dtd/mybatis-3-config.dtd">
  5. <configuration>
  6.          
  8.    
  9.     <typeAliases>
  10.         <package name="com.wfy.pojo"/>
  11.     </typeAliases>
  13.     <mappers>
  14.         <mapper />
  15.     </mappers>
  16. </configuration>      
复制代码
三层整合applicationContext.xml
  1. <?xml version="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.        xsi:schemaLocation="http://www.springframework.org/schema/beans
  5.         http://www.springframework.org/schema/beans/spring-beans.xsd">
  7.     <import resource="classpath:spring-dao.xml"/>
  8.     <import resource="classpath:spring-service.xml"/>
  9.     <import resource="classpath:spring-mvc.xml"/>
  10. </beans>
复制代码
免责声明：如果侵犯了您的权益，请联系站长，我们会及时删除侵权内容，谢谢合作！更多信息从访问主页：qidao123.com:ToB企服之家，中国第一个企服评测及商务社交产业平台。
回复

使用道具 举报

0 个回复

倒序浏览
返回列表

快速回复

高级模式
B Color Image Link Quote Code Smilies
您需要登录后才可以回帖 登录 or 立即注册

本版积分规则

王海鱼

金牌会员
这个人很懒什么都没写!

楼主热帖

标签云

存储 挺好的 服务器
微信订阅号
微信服务号
微信客服
小程序
H5
关于我们 商务合作 网站地图
©Copyright 2022-2024 杭州祥升科技有限公司 版权所有 浙ICP备20004199号
快速回复 返回顶部 返回列表