SSM框架整合

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企服之家，中国第一个企服评测及商务社交产业平台。