学习笔记——尚好房项目（配置ssm环境、测试ssm环境）

2023-02-10
一、配置SSM环境
1、添加日志文件
在“shf-parent/web-admin/src/main/resources”下创建“logback.xml”

1. <?xml version="1.0" encoding="UTF-8"?>
2. <configuration debug="false">
4.    
5.     <property name="LOG_HOME" value="logs" />
7.    
8.     <appender name="STDOUT" class="ch.qos.logback.core.ConsoleAppender">
9.         <encoder class="ch.qos.logback.classic.encoder.PatternLayoutEncoder">
10.             
11.             <pattern>%d{yyyy-MM-dd HH:mm:ss.SSS} [%thread] %-5level %logger{50} - %msg%n</pattern>
12.         </encoder>
13.     </appender>
15.    
16.     <root level="DEBUG">
17.         <appender-ref ref="STDOUT" />
18.     </root>
19. </configuration>

复制代码

2、在“shf-parent/web-admin/src/main/resources”下创建“mybatis-config.xml”

1. <?xml version="1.0" encoding="UTF-8" ?>
2. <!DOCTYPE configuration PUBLIC "-//mybatis.org//DTD Config 3.0//EN"
3.         "http://mybatis.org/dtd/mybatis-3-config.dtd">
4. <configuration>
5.      
6.     <settings>
7.         <setting name="mapUnderscoreToCamelCase" value="true"/>
8.     </settings>
9. </configuration>

复制代码

3、在“shf-parent/web-admin/src/main/resources”下创建spring文件夹，创建“db.properties”
（1）db.properties

1. jdbc.username=数据库用户名
2. jdbc.password=数据库密码
3. jdbc.url=jdbc:mysql://localhost:3306/数据库名称?serverTimezone=Asia/Shanghai
4. jdbc.driverClassName=com.mysql.cj.jdbc.Driver

复制代码

（2）在spring文件夹下
①创建“spring-dao.xml”

1. <?xml version="1.0" encoding="UTF-8" ?>
2. <!DOCTYPE configuration PUBLIC "-//mybatis.org//DTD Config 3.0//EN"
3.         "http://mybatis.org/dtd/mybatis-3-config.dtd">
4. <configuration>
5.      
6.     <settings>
7.         <setting name="mapUnderscoreToCamelCase" value="true"/>
8.     </settings>
9. </configuration><?xml version="1.0" encoding="UTF-8" ?>
10. <!DOCTYPE configuration PUBLIC "-//mybatis.org//DTD Config 3.0//EN"
11.         "http://mybatis.org/dtd/mybatis-3-config.dtd">
12. <configuration>
13.      
14.     <settings>
15.         <setting name="mapUnderscoreToCamelCase" value="true"/>
16.     </settings>
17. </configuration><?xml version="1.0" encoding="UTF-8" ?>
18. <!DOCTYPE configuration PUBLIC "-//mybatis.org//DTD Config 3.0//EN"
19.         "http://mybatis.org/dtd/mybatis-3-config.dtd">
20. <configuration>
21.      
22.     <settings>
23.         <setting name="mapUnderscoreToCamelCase" value="true"/>
24.     </settings>
25. </configuration><?xml version="1.0" encoding="UTF-8" ?>
26. <!DOCTYPE configuration PUBLIC "-//mybatis.org//DTD Config 3.0//EN"
27.         "http://mybatis.org/dtd/mybatis-3-config.dtd">
28. <configuration>
29.      
30.     <settings>
31.         <setting name="mapUnderscoreToCamelCase" value="true"/>
32.     </settings>
33. </configuration>               

复制代码

②创建“spring-service.xml”

1. <?xml version="1.0" encoding="UTF-8" ?>
2. <!DOCTYPE configuration PUBLIC "-//mybatis.org//DTD Config 3.0//EN"
3.         "http://mybatis.org/dtd/mybatis-3-config.dtd">
4. <configuration>
5.      
6.     <settings>
7.         <setting name="mapUnderscoreToCamelCase" value="true"/>
8.     </settings>
9. </configuration>           

复制代码

③创建“spring-mvc.xml”

1. <?xml version="1.0" encoding="UTF-8" ?>
2. <!DOCTYPE configuration PUBLIC "-//mybatis.org//DTD Config 3.0//EN"
3.         "http://mybatis.org/dtd/mybatis-3-config.dtd">
4. <configuration>
5.      
6.     <settings>
7.         <setting name="mapUnderscoreToCamelCase" value="true"/>
8.     </settings>
9. </configuration><?xml version="1.0" encoding="UTF-8" ?>
10. <!DOCTYPE configuration PUBLIC "-//mybatis.org//DTD Config 3.0//EN"
11.         "http://mybatis.org/dtd/mybatis-3-config.dtd">
12. <configuration>
13.      
14.     <settings>
15.         <setting name="mapUnderscoreToCamelCase" value="true"/>
16.     </settings>
17. </configuration><?xml version="1.0" encoding="UTF-8" ?>
18. <!DOCTYPE configuration PUBLIC "-//mybatis.org//DTD Config 3.0//EN"
19.         "http://mybatis.org/dtd/mybatis-3-config.dtd">
20. <configuration>
21.      
22.     <settings>
23.         <setting name="mapUnderscoreToCamelCase" value="true"/>
24.     </settings>
25. </configuration><?xml version="1.0" encoding="UTF-8" ?>
26. <!DOCTYPE configuration PUBLIC "-//mybatis.org//DTD Config 3.0//EN"
27.         "http://mybatis.org/dtd/mybatis-3-config.dtd">
28. <configuration>
29.      
30.     <settings>
31.         <setting name="mapUnderscoreToCamelCase" value="true"/>
32.     </settings>
33. </configuration><?xml version="1.0" encoding="UTF-8" ?>
34. <!DOCTYPE configuration PUBLIC "-//mybatis.org//DTD Config 3.0//EN"
35.         "http://mybatis.org/dtd/mybatis-3-config.dtd">
36. <configuration>
37.      
38.     <settings>
39.         <setting name="mapUnderscoreToCamelCase" value="true"/>
40.     </settings>
41. </configuration>           text/html;charset=UTF-8<?xml version="1.0" encoding="UTF-8" ?>
42. <!DOCTYPE configuration PUBLIC "-//mybatis.org//DTD Config 3.0//EN"
43.         "http://mybatis.org/dtd/mybatis-3-config.dtd">
44. <configuration>
45.      
46.     <settings>
47.         <setting name="mapUnderscoreToCamelCase" value="true"/>
48.     </settings>
49. </configuration>   application/json<?xml version="1.0" encoding="UTF-8" ?>
50. <!DOCTYPE configuration PUBLIC "-//mybatis.org//DTD Config 3.0//EN"
51.         "http://mybatis.org/dtd/mybatis-3-config.dtd">
52. <configuration>
53.      
54.     <settings>
55.         <setting name="mapUnderscoreToCamelCase" value="true"/>
56.     </settings>
57. </configuration><?xml version="1.0" encoding="UTF-8" ?>
58. <!DOCTYPE configuration PUBLIC "-//mybatis.org//DTD Config 3.0//EN"
59.         "http://mybatis.org/dtd/mybatis-3-config.dtd">
60. <configuration>
61.      
62.     <settings>
63.         <setting name="mapUnderscoreToCamelCase" value="true"/>
64.     </settings>
65. </configuration><?xml version="1.0" encoding="UTF-8" ?>
66. <!DOCTYPE configuration PUBLIC "-//mybatis.org//DTD Config 3.0//EN"
67.         "http://mybatis.org/dtd/mybatis-3-config.dtd">
68. <configuration>
69.      
70.     <settings>
71.         <setting name="mapUnderscoreToCamelCase" value="true"/>
72.     </settings>
73. </configuration><?xml version="1.0" encoding="UTF-8" ?>
74. <!DOCTYPE configuration PUBLIC "-//mybatis.org//DTD Config 3.0//EN"
75.         "http://mybatis.org/dtd/mybatis-3-config.dtd">
76. <configuration>
77.      
78.     <settings>
79.         <setting name="mapUnderscoreToCamelCase" value="true"/>
80.     </settings>
81. </configuration><?xml version="1.0" encoding="UTF-8" ?>
82. <!DOCTYPE configuration PUBLIC "-//mybatis.org//DTD Config 3.0//EN"
83.         "http://mybatis.org/dtd/mybatis-3-config.dtd">
84. <configuration>
85.      
86.     <settings>
87.         <setting name="mapUnderscoreToCamelCase" value="true"/>
88.     </settings>
89. </configuration><?xml version="1.0" encoding="UTF-8" ?>
90. <!DOCTYPE configuration PUBLIC "-//mybatis.org//DTD Config 3.0//EN"
91.         "http://mybatis.org/dtd/mybatis-3-config.dtd">
92. <configuration>
93.      
94.     <settings>
95.         <setting name="mapUnderscoreToCamelCase" value="true"/>
96.     </settings>
97. </configuration><?xml version="1.0" encoding="UTF-8" ?>
98. <!DOCTYPE configuration PUBLIC "-//mybatis.org//DTD Config 3.0//EN"
99.         "http://mybatis.org/dtd/mybatis-3-config.dtd">
100. <configuration>
101.      
102.     <settings>
103.         <setting name="mapUnderscoreToCamelCase" value="true"/>
104.     </settings>
105. </configuration><?xml version="1.0" encoding="UTF-8" ?>
106. <!DOCTYPE configuration PUBLIC "-//mybatis.org//DTD Config 3.0//EN"
107.         "http://mybatis.org/dtd/mybatis-3-config.dtd">
108. <configuration>
109.      
110.     <settings>
111.         <setting name="mapUnderscoreToCamelCase" value="true"/>
112.     </settings>
113. </configuration><?xml version="1.0" encoding="UTF-8" ?>
114. <!DOCTYPE configuration PUBLIC "-//mybatis.org//DTD Config 3.0//EN"
115.         "http://mybatis.org/dtd/mybatis-3-config.dtd">
116. <configuration>
117.      
118.     <settings>
119.         <setting name="mapUnderscoreToCamelCase" value="true"/>
120.     </settings>
121. </configuration><?xml version="1.0" encoding="UTF-8" ?>
122. <!DOCTYPE configuration PUBLIC "-//mybatis.org//DTD Config 3.0//EN"
123.         "http://mybatis.org/dtd/mybatis-3-config.dtd">
124. <configuration>
125.      
126.     <settings>
127.         <setting name="mapUnderscoreToCamelCase" value="true"/>
128.     </settings>
129. </configuration>              

复制代码

（3）在“shf-parent/web-admin/src/main/resources”下创建mapper文件夹
（4）在“shf-parent/web-admin/src/main/java”下创建包“com.hh.controller”、“com.hh.dao”、“com.hh.service”
4、配置“shf-parent/web-admin/src/main/webapp/WEB-INF/web.xml”文件

1.     web            CharacterEncodingFilter        org.springframework.web.filter.CharacterEncodingFilter                    encoding            UTF-8<?xml version="1.0" encoding="UTF-8" ?>
2. <!DOCTYPE configuration PUBLIC "-//mybatis.org//DTD Config 3.0//EN"
3.         "http://mybatis.org/dtd/mybatis-3-config.dtd">
4. <configuration>
5.      
6.     <settings>
7.         <setting name="mapUnderscoreToCamelCase" value="true"/>
8.     </settings>
9. </configuration>       forceRequestEncoding            true<?xml version="1.0" encoding="UTF-8" ?>
10. <!DOCTYPE configuration PUBLIC "-//mybatis.org//DTD Config 3.0//EN"
11.         "http://mybatis.org/dtd/mybatis-3-config.dtd">
12. <configuration>
13.      
14.     <settings>
15.         <setting name="mapUnderscoreToCamelCase" value="true"/>
16.     </settings>
17. </configuration>       forceResponseEncoding            true<?xml version="1.0" encoding="UTF-8" ?>
18. <!DOCTYPE configuration PUBLIC "-//mybatis.org//DTD Config 3.0//EN"
19.         "http://mybatis.org/dtd/mybatis-3-config.dtd">
20. <configuration>
21.      
22.     <settings>
23.         <setting name="mapUnderscoreToCamelCase" value="true"/>
24.     </settings>
25. </configuration>   CharacterEncodingFilter        /*                dispatcherServlet        org.springframework.web.servlet.DispatcherServlet                    contextConfigLocation            classpath:spring/spring-mvc.xml<?xml version="1.0" encoding="UTF-8" ?>
26. <!DOCTYPE configuration PUBLIC "-//mybatis.org//DTD Config 3.0//EN"
27.         "http://mybatis.org/dtd/mybatis-3-config.dtd">
28. <configuration>
29.      
30.     <settings>
31.         <setting name="mapUnderscoreToCamelCase" value="true"/>
32.     </settings>
33. </configuration>   dispatcherServlet        /                    contextConfigLocation        classpath:/spring/spring-*.xml                    org.springframework.web.context.ContextLoaderListener   

复制代码

二、测试SSM环境
1、添加表
2、添加实体
3、添加RoleDao
在“shf-parent/web-admin/src/main/java/com.hh.dao”下创建RoleDao接口

1. public interface RoleDao {
2.     List<Role> findAll();
3. }

复制代码

4、添加RoleDao.xml映射文件

1.                 select id,role_name,role_code,description,create_time,update_time,is_deleted<?xml version="1.0" encoding="UTF-8" ?>
2. <!DOCTYPE configuration PUBLIC "-//mybatis.org//DTD Config 3.0//EN"
3.         "http://mybatis.org/dtd/mybatis-3-config.dtd">
4. <configuration>
5.      
6.     <settings>
7.         <setting name="mapUnderscoreToCamelCase" value="true"/>
8.     </settings>
9. </configuration>   from acl_role        where is_deleted = 0        

复制代码

5、添加service
①在“shf-parent/web-admin/src/main/java/com.hh.service”中创建“RoleService"

1. public interface RoleService {
2.     List<Role> findAll();
3. }

复制代码

②在“shf-parent/web-admin/src/main/java/com.hh.service”中创建“impl.RoleServiceImpl"

1. @Service
2. public class RoleServiceImpl implements RoleService {
4.     @Autowired
5.     private RoleDao roleDao;
6.     @Override
7.     public List<Role> findAll() {
8.         return roleDao.findAll();
9.     }
10. }

复制代码

6、添加controller
在“shf-parent/web-admin/src/main/java/com.hh.controller”中创建“RoleController"

1. @Controller
2. @RequestMapping("/role")
3. public class RoleController {
4.     @Autowired
5.     private RoleService roleService;
7.     @RequestMapping
8.     public String index(Map map){
9.         //调用RoleService中获取所有的角色的方法
10.         List<Role> roleList = roleService.findAll();
11.         //将所有的角色放到request域中
12.         map.put("list",roleList);
13.         //渲染数据的页面
14.         return "role/index";
15.     }
16. }

复制代码

7、添加页面
在“shf-parent/web-admin/src/main/webapp/WEN-INF”下创建“templates/role/index.html"

1. <!DOCTYPE html>
2. <html lang="en" xmlns:th="http://www.thymeleaf.org">
3. <head>
4.     <meta charset="UTF-8">
5.     <title>Title</title>
6. </head>
7. <body>
8. <table>
9.     <tr th:each="item,it : ${list}">
10.         <td class="text-center" th:text="${it.count}">11</td>
11.         <td th:text="${item.roleName}">22</td>
12.         <td th:text="${item.roleCode}">33</td>
13.         <td th:text="${item.description}">33</td>
14.         <td th:text="${#dates.format(item.createTime,'yyyy-MM-dd HH:mm:ss')}" >33</td>
15.     </tr>
16. </table>
17. </body>
18. </html>

复制代码