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

2023-02-10

一、配置SSM环境

1、添加日志文件

在“shf-parent/web-admin/src/main/resources”下创建“logback.xml”

<?xml version="1.0" encoding="UTF-8"?><configuration debug="false">    <!--定义日志文件的存储地址 logs为当前项目的logs目录 还可以设置为../logs -->    <property name="LOG_HOME" value="logs" />    <!--控制台日志， 控制台输出 -->    <appender name="STDOUT" class="ch.qos.logback.core.ConsoleAppender">        <encoder class="ch.qos.logback.classic.encoder.PatternLayoutEncoder">            <!--格式化输出：%d表示日期，%thread表示线程名，%-5level：级别从左显示5个字符宽度,%msg：日志消息，%n是换行符-->            <pattern>%d{yyyy-MM-dd HH:mm:ss.SSS} [%thread] %-5level %logger{50} - %msg%n</pattern>        </encoder>    </appender>    <!-- 日志输出级别 -->    <root level="DEBUG">        <appender-ref ref="STDOUT" />    </root></configuration>

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

<?xml version="1.0" encoding="UTF-8" ?><!DOCTYPE configuration PUBLIC "-//mybatis.org//DTD Config 3.0//EN"        "http://mybatis.org/dtd/mybatis-3-config.dtd"><configuration>     <!--开启驼峰命名自动映射-->    <settings>        <setting name="mapUnderscoreToCamelCase" value="true"/>    </settings></configuration>

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

（1）db.properties

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

（2）在spring文件夹下

①创建“spring-dao.xml”

<?xml version="1.0" encoding="UTF-8"?><beans xmlns="http://www.springframework.org/schema/beans"       xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"       xmlns:context="http://www.springframework.org/schema/context"       xmlns:mybatis-spring="http://mybatis.org/schema/mybatis-spring"       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://mybatis.org/schema/mybatis-spring http://mybatis.org/schema/mybatis-spring.xsd"><!--    引入外部文件-->    <context:property-placeholder location="classpath:db.properties"></context:property-placeholder>    <!--    配置数据源-->    <bean class="com.alibaba.druid.pool.DruidDataSource" id="dataSource" destroy-method="close">        <!--        配置连接数据库的相关属性-->        <property name="username" value="${jdbc.username}"></property>        <property name="password" value="${jdbc.password}"></property>        <property name="url" value="${jdbc.url}"></property>        <property name="driverClassName" value="${jdbc.driverClassName}"></property>    </bean><!--    整合mybatis--><!--    1、配置sqlsessionFactoryBean-->    <bean class="org.mybatis.spring.SqlSessionFactoryBean" id="sqlSessionFactoryBean"><!--        配置数据源属性-->        <property name="dataSource" ref="dataSource"></property><!--        配置mybatis的全局配置文件的路径-->        <property name="configLocation" value="classpath:mybatis-config.xml"></property><!--        配置给实体类包下所有的类起别名-->        <property name="typeAliasesPackage" value="com.hh.entity"></property><!--        配置mapper映射文件的路径-->        <property name="mapperLocations" value="classpath:mapper/*.xml"></property>    </bean><!--    2、扫描mapper工具-->    <mybatis-spring:scan base-package="com.hh.dao"></mybatis-spring:scan></beans>

②创建“spring-service.xml”

<?xml version="1.0" encoding="UTF-8"?><beans xmlns="http://www.springframework.org/schema/beans"       xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"       xmlns:context="http://www.springframework.org/schema/context" xmlns:tx="http://www.springframework.org/schema/tx"       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"><!--    配置扫描的包-->    <context:component-scan base-package="com.hh.service"></context:component-scan>    <!--    配置事务管理器-->    <bean class="org.springframework.jdbc.datasource.DataSourceTransactionManager" id="transactionManager"><!--        配置数据源属性-->        <property name="dataSource" ref="dataSource"></property>    </bean>    <!--    开启事务注解支持-->    <tx:annotation-driven></tx:annotation-driven></beans>

③创建“spring-mvc.xml”

<?xml version="1.0" encoding="UTF-8"?><beans xmlns="http://www.springframework.org/schema/beans"       xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"       xmlns:context="http://www.springframework.org/schema/context"       xmlns:aop="http://www.springframework.org/schema/aop"       xmlns:mvc="http://www.springframework.org/schema/mvc"       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/aop        http://www.springframework.org/schema/aop/spring-aop.xsd        http://www.springframework.org/schema/mvc        http://www.springframework.org/schema/mvc/spring-mvc.xsd">    <!--包扫描-->    <context:component-scan base-package="com.hh.controller" />    <!-- 没有匹配上的url全部按默认方式（就是直接访问）访问，避免拦截静态资源 -->    <mvc:default-servlet-handler/>    <!-- 开启mvc注解-->    <mvc:annotation-driven>        <mvc:message-converters register-defaults="true">            <!-- 配置Fastjson支持 -->            <bean class="com.alibaba.fastjson.support.spring.FastJsonHttpMessageConverter">                <property name="supportedMediaTypes">                    <list>                        <value>text/html;charset=UTF-8</value>                        <value>application/json</value>                    </list>                </property>            </bean>        </mvc:message-converters>    </mvc:annotation-driven>    <!--视图解析器-->    <bean id="templateResolver" class="org.thymeleaf.spring5.templateresolver.SpringResourceTemplateResolver">        <!--配置前缀-->        <property name="prefix" value="/WEB-INF/templates/"></property>        <!--配置后缀-->        <property name="suffix" value=".html"></property>        <!--配置编码格式-->        <property name="characterEncoding" value="UTF-8"></property>        <!--设置缓存为null-->        <property name="cacheable" value="false"></property>        <!--配置模板模式,        HTML5:表示严格模式        LEGACYHTML5：表示宽松模式-->        <property name="templateMode" value="LEGACYHTML5"></property>    </bean>    <!--配置spring的视图解析器-->    <bean id="viewResolver" class="org.thymeleaf.spring5.view.ThymeleafViewResolver">        <!--设置编码格式-->        <property name="characterEncoding" value="UTF-8"></property>        <!--设置模板引擎-->        <property name="templateEngine" ref="templateEngine"/>    </bean>    <!--配置模板引擎-->    <bean id="templateEngine" class="org.thymeleaf.spring5.SpringTemplateEngine">        <!--引用视图解析器-->        <property name="templateResolver" ref="templateResolver"></property>    </bean></beans>

（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”文件

<?xml version="1.0" encoding="UTF-8"?><web-app xmlns="http://xmlns.jcp.org/xml/ns/javaee"         xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"         xsi:schemaLocation="http://xmlns.jcp.org/xml/ns/javaee http://xmlns.jcp.org/xml/ns/javaee/web-app_4_0.xsd"         version="4.0">    <display-name>web</display-name><!--    配置POST请求请求乱码问题的过滤器-->    <filter>        <filter-name>CharacterEncodingFilter</filter-name>        <filter-class>org.springframework.web.filter.CharacterEncodingFilter</filter-class>        <init-param>            <param-name>encoding</param-name>            <param-value>UTF-8</param-value>        </init-param>        <init-param>            <param-name>forceRequestEncoding</param-name>            <param-value>true</param-value>        </init-param>        <init-param>            <param-name>forceResponseEncoding</param-name>            <param-value>true</param-value>        </init-param>    </filter>    <filter-mapping>        <filter-name>CharacterEncodingFilter</filter-name>        <url-pattern>/*</url-pattern>    </filter-mapping><!--    配置前端控制器DispatcherServlet-->    <servlet>        <servlet-name>dispatcherServlet</servlet-name>        <servlet-class>org.springframework.web.servlet.DispatcherServlet</servlet-class>        <init-param>            <param-name>contextConfigLocation</param-name>            <param-value>classpath:spring/spring-mvc.xml</param-value>        </init-param>    </servlet>    <servlet-mapping>        <servlet-name>dispatcherServlet</servlet-name>        <url-pattern>/</url-pattern>    </servlet-mapping>    <!--    配置当前WEB应用的初始化参数-->    <context-param>        <param-name>contextConfigLocation</param-name>        <param-value>classpath:/spring/spring-*.xml</param-value>    </context-param>    <!--    配置监听器-->    <listener>        <listener-class>org.springframework.web.context.ContextLoaderListener</listener-class>    </listener></web-app>

二、测试SSM环境

1、添加表

2、添加实体

3、添加RoleDao

在“shf-parent/web-admin/src/main/java/com.hh.dao”下创建RoleDao接口

public interface RoleDao {    List findAll();}

4、添加RoleDao.xml映射文件

<?xml version="1.0" encoding="UTF-8" ?><!DOCTYPE mapper        PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN"        "http://mybatis.org/dtd/mybatis-3-mapper.dtd"><mapper namespace="com.hh.dao.RoleDao">    <!-- 用于select查询公用抽取的列 -->    <sql id="columns">        select id,role_name,role_code,description,create_time,update_time,is_deleted    </sql><!--   查询所有-->    <select id="findAll" resultType="role">        <include refid="columns"></include>        from acl_role        where is_deleted = 0    </select>    </mapper>

5、添加service

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

public interface RoleService {    List findAll();}

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

@Servicepublic class RoleServiceImpl implements RoleService {    @Autowired    private RoleDao roleDao;    @Override    public List findAll() {        return roleDao.findAll();    }}

6、添加controller

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

@Controller@RequestMapping("/role")public class RoleController {    @Autowired    private RoleService roleService;    @RequestMapping    public String index(Map map){        //调用RoleService中获取所有的角色的方法        List roleList = roleService.findAll();        //将所有的角色放到request域中        map.put("list",roleList);        //渲染数据的页面        return "role/index";    }}

7、添加页面

在“shf-parent/web-admin/src/main/webapp/WEN-INF”下创建“templates/role/index.html”

<!DOCTYPE html><html lang="en" xmlns:th="http://www.thymeleaf.org"><head>    <meta charset="UTF-8">    <title>Title</title></head><body><table>    <tr th:each="item,it : ${list}">        <td class="text-center" th:text="${it.count}">11</td>        <td th:text="${item.roleName}">22</td>        <td th:text="${item.roleCode}">33</td>        <td th:text="${item.description}">33</td>        <td th:text="${#dates.format(item.createTime,'yyyy-MM-dd HH:mm:ss')}" >33</td>    </tr></table></body></html>