• SSM整合

    目录

    一、ContextLoaderListener

    二、准备工作

    ⚪导入依赖

    ⚪创建表

    ⚪配置web.xml 

    ⚪配置SpringMVC.xml

    ⚪配置Spring.xml

    ⭐搭建MyBatis环境 

    ⚪创建属性文件jdbc.properties 

    ⚪配置mybatis-config.xml

    ⚪创建日志文件log4j.xml

    ⚪项目结构 

    ⚪实体类

    三、测试功能

    1.查询所有的员工信息

    ⚪创建接口EmployeeService

    ⚪创建实现类EmployeeServiceImpl 

    ⚪创建控制层组件EmployeeController 

    ⚪创建页面

    二、数据分页

    一、ContextLoaderListener

    Spring提供了监听器ContextLoaderListener，实现ServletContextListener接口

    可监听 ServletContext的状态，在web服务器的启动，读取Spring的配置文件，创建Spring的IOC容器。

    web 应用中必须在web.xml中配置

    1. <listener>
    3. <listenerclass>org.springframework.web.context.ContextLoaderListenerlistener-class>
    4. listener>
    6. <context-param>
    7. <param-name>contextConfigLocationparam-name>
    8. <param-value>classpath:spring.xmlparam-value>
    9. context-param>

    二、准备工作

    ⚪导入依赖

    1. "1.0" encoding="UTF-8"?>
    2. <project xmlns="http://maven.apache.org/POM/4.0.0"
    3.          xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
    4.          xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 http://maven.apache.org/xsd/maven-4.0.0.xsd">
    5.     <modelVersion>4.0.0modelVersion>
    6.  
    7.     <groupId>com.atguigu.ssmgroupId>
    8.     <artifactId>ssmartifactId>
    9.     <version>1.0-SNAPSHOTversion>
    10.  
    11.     <packaging>warpackaging>
    12.     <properties>
    13.         
    14.         <spring.version>5.3.1spring.version>
    15.     properties>
    16.     <dependencies>
    17.     <dependency>
    18.         <groupId>org.springframeworkgroupId>
    19.         <artifactId>spring-contextartifactId>
    20.         <version>${spring.version}version>
    21.     dependency>
    22.     <dependency>
    23.         <groupId>org.springframeworkgroupId>
    24.         <artifactId>spring-beansartifactId>
    25.         <version>${spring.version}version>
    26.     dependency>
    27.     
    28.     <dependency>
    29.         <groupId>org.springframeworkgroupId>
    30.         <artifactId>spring-webartifactId>
    31.         <version>${spring.version}version>
    32.     dependency>
    33.     <dependency>
    34.         <groupId>org.springframeworkgroupId>
    35.         <artifactId>spring-webmvcartifactId>
    36.         <version>${spring.version}version>
    37.     dependency>
    38.     <dependency>
    39.         <groupId>org.springframeworkgroupId>
    40.         <artifactId>spring-jdbcartifactId>
    41.         <version>${spring.version}version>
    42.     dependency>
    43.     <dependency>
    44.         <groupId>org.springframeworkgroupId>
    45.         <artifactId>spring-aspectsartifactId>
    46.         <version>${spring.version}version>
    47.     dependency>
    48.     <dependency>
    49.         <groupId>org.springframeworkgroupId>
    50.         <artifactId>spring-testartifactId>
    51.         <version>${spring.version}version>
    52.     dependency>
    53.     
    54.     <dependency>
    55.         <groupId>org.mybatisgroupId>
    56.         <artifactId>mybatisartifactId>
    57.         <version>3.5.7version>
    58.     dependency>
    59.     
    60.     <dependency>
    61.         <groupId>org.mybatisgroupId>
    62.         <artifactId>mybatis-springartifactId>
    63.         <version>2.0.6version>
    64.     dependency>
    65.     
    66.     <dependency>
    67.         <groupId>com.alibabagroupId>
    68.         <artifactId>druidartifactId>
    69.         <version>1.0.9version>
    70.     dependency>
    71.     
    72.     <dependency>
    73.         <groupId>junitgroupId>
    74.         <artifactId>junitartifactId>
    75.         <version>4.12version>
    76.         <scope>testscope>
    77.     dependency>
    78.     
    79.     <dependency>
    80.         <groupId>mysqlgroupId>
    81.         <artifactId>mysql-connector-javaartifactId>
    82.         <version>8.0.16version>
    83.     dependency>
    84.     
    85.     <dependency>
    86.         <groupId>log4jgroupId>
    87.         <artifactId>log4jartifactId>
    88.         <version>1.2.17version>
    89.     dependency>
    90.         <dependency>
    91.             <groupId>com.github.pagehelpergroupId>
    92.             <artifactId>pagehelperartifactId>
    93.             <version>5.2.0version>
    94.         dependency>
    95.         
    96.         <dependency>
    97.             <groupId>ch.qos.logbackgroupId>
    98.             <artifactId>logback-classicartifactId>
    99.             <version>1.2.3version>
    100.         dependency>
    101.         
    102.         <dependency>
    103.             <groupId>javax.servletgroupId>
    104.             <artifactId>javax.servlet-apiartifactId>
    105.             <version>3.1.0version>
    106.             <scope>providedscope>
    107.         dependency>
    108.         <dependency>
    109.             <groupId>com.fasterxml.jackson.coregroupId>
    110.             <artifactId>jackson-databindartifactId>
    111.             <version>2.12.1version>
    112.         dependency>
    113.         
    114.         <dependency>
    115.             <groupId>commons-fileuploadgroupId>
    116.             <artifactId>commons-fileuploadartifactId>
    117.             <version>1.3.1version>
    118.         dependency>
    119.         
    120.         <dependency>
    121.             <groupId>org.thymeleafgroupId>
    122.             <artifactId>thymeleaf-spring5artifactId>
    123.             <version>3.0.12.RELEASEversion>
    124.         dependency>
    125.     dependencies>
    126.  
    127. project>

    ⚪创建表

    1. CREATE TABLE `t_emp` (
    2. `emp_id` int(11) NOT NULL AUTO_INCREMENT,
    3. `emp_name` varchar(20) DEFAULT NULL,
    4. `age` int(11) DEFAULT NULL,
    5. `sex` char(1) DEFAULT NULL,
    6. `email` varchar(50) DEFAULT NULL,
    7. PRIMARY KEY (`emp_id`)
    8. ) ENGINE=InnoDB DEFAULT CHARSET=utf8

    ⚪配置web.xml 

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

    ⚪配置SpringMVC.xml

    1. "1.0" encoding="UTF-8"?>
    2. <beans xmlns="http://www.springframework.org/schema/beans"
    3.        xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
    4.        xmlns:context="http://www.springframework.org/schema/context"
    5.        xmlns:mvc="http://www.springframework.org/schema/mvc"
    6.        xsi:schemaLocation="http://www.springframework.org/schema/beans
    7.        http://www.springframework.org/schema/beans/spring-beans-4.2.xsd
    8.        http://www.springframework.org/schema/mvc
    9.        http://www.springframework.org/schema/mvc/spring-mvc-4.2.xsd
    10.        http://www.springframework.org/schema/context
    11.        http://www.springframework.org/schema/context/spring-context-4.2.xsd">
    12.     
    13.     <context:component-scan base-package="com.atguigu.ssm.controller">context:component-scan>
    14.  
    15.     
    16.     <bean id="viewResolver"
    17.           class="org.thymeleaf.spring5.view.ThymeleafViewResolver">
    18.         <property name="order" value="1"/>
    19.         <property name="characterEncoding" value="UTF-8"/>
    20.         <property name="templateEngine">
    21.             <bean class="org.thymeleaf.spring5.SpringTemplateEngine">
    22.                 <property name="templateResolver">
    23.                     <bean
    24.                             class="org.thymeleaf.spring5.templateresolver.SpringResourceTemplateResolver">
    25.                         
    26.                         <property name="prefix" value="/WEB-INF/templates/"/>
    27.                         
    28.                         <property name="suffix" value=".html"/>
    29.                         <property name="templateMode" value="HTML5"/>
    30.                         <property name="characterEncoding" value="UTF-8" />
    31.                     bean>
    32.                 property>
    33.             bean>
    34.         property>
    35.     bean>
    36.  
    37.     
    38.     <mvc:default-servlet-handler/>
    39.  
    40.     
    41.     <mvc:annotation-driven/>
    42.  
    43.     
    44.     <mvc:view-controller path="/" view-name="index">mvc:view-controller>
    45.  
    46.     
    47.     <bean id="multipartResolver" class="org.springframework.web.multipart.commons.CommonsMultipartResolver">bean>
    48.  
    49.     
    50.     <bean class="org.springframework.web.servlet.handler.SimpleMappingExceptionResolver">bean>
    51. beans>

    ⚪配置Spring.xml

    1. "1.0" encoding="UTF-8"?>
    2. <beans xmlns="http://www.springframework.org/schema/beans"
    3.        xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
    4.        xmlns:context="http://www.springframework.org/schema/context"
    5.        xmlns:mvc="http://www.springframework.org/schema/mvc" xmlns:tx="http://www.springframework.org/schema/tx"
    6.        xsi:schemaLocation="http://www.springframework.org/schema/beans
    7.        http://www.springframework.org/schema/beans/spring-beans-4.2.xsd
    8.        http://www.springframework.org/schema/mvc
    9.        http://www.springframework.org/schema/mvc/spring-mvc-4.2.xsd
    10.        http://www.springframework.org/schema/context
    11.        http://www.springframework.org/schema/context/spring-context-4.2.xsd http://www.springframework.org/schema/tx http://www.springframework.org/schema/tx/spring-tx.xsd">
    12.  
    13.     
    14.     <context:component-scan base-package="com.atguigu.ssm">
    15.         
    16.         <context:exclude-filter type="annotation" expression="org.springframework.stereotype.Controller"/>
    17.     context:component-scan>
    18.  
    19.     
    20.     <context:property-placeholder location="classpath:jdbc.properties">context:property-placeholder>
    21.  
    22.     
    23.     <bean id="dataSource" class="com.alibaba.druid.pool.DruidDataSource">
    24.         <property name="driverClassName" value="${jdbc.driver}">property>
    25.         <property name="url" value="${jdbc.url}">property>
    26.         <property name="username" value="${jdbc.username}">property>
    27.         <property name="password" value="${jdbc.password}">property>
    28.     bean>
    29.  
    30.     
    31.     <bean id="transactionManager" class="org.springframework.jdbc.datasource.DataSourceTransactionManager">
    32.         <property name="dataSource" ref="dataSource">property>
    33.     bean>
    34.     
    35.     <tx:annotation-driven transaction-manager="transactionManager"/>
    36.  
    37.     
    38.     <bean class="org.mybatis.spring.SqlSessionFactoryBean">
    39.         
    40.         <property name="configLocation" value="classpath:mybatis-config.xml">property>
    41.         
    42.         <property name="dataSource" ref="dataSource">property>
    43.         
    44.         <property name="typeAliasesPackage" value="com.atguigu.ssm.pojo">property>
    45.         
    46.         
    47.         
    48.         <property name="plugins">
    49.             <array>
    50.                 <bean class="com.github.pagehelper.PageInterceptor">bean>
    51.             array>
    52.         property>
    53.     bean>
    54.  
    55.     
    56.     <bean class="org.mybatis.spring.mapper.MapperScannerConfigurer">
    57.         <property name="basePackage" value="com.atguigu.ssm.mapper">property>
    58.     bean>
    59. beans>

    ⭐搭建MyBatis环境 

    ⚪创建属性文件jdbc.properties 

    1. jdbc.driver=com.mysql.cj.jdbc.Driver
    2. jdbc.url=jdbc:mysql://localhost:3306/ssm?serverTimezone=UTC
    3. jdbc.username=root
    4. jdbc.password=123456

    ⚪配置mybatis-config.xml

    1. "1.0" encoding="UTF-8" ?>
    2. configuration
    3.         PUBLIC "-//mybatis.org//DTD Config 3.0//EN"
    4.         "http://mybatis.org/dtd/mybatis-3-config.dtd">
    5. <configuration>
    6.     
    7.  
    8.     
    10.     <settings>
    11.         
    12.         <setting name="mapUnderscoreToCamelCase" value="true"/>
    13.     settings>
    14.  
    15.     
    17.  
    22.  
    23.     
    38.  
    39.     
    44.     
    48. configuration>

    ⚪创建日志文件log4j.xml

    1. "1.0" encoding="UTF-8" ?>
    2. log4j:configuration SYSTEM "log4j.dtd">
    3. <log4j:configuration xmlns:log4j="http://jakarta.apache.org/log4j/">
    4.     <appender name="STDOUT" class="org.apache.log4j.ConsoleAppender">
    5.         <param name="Encoding" value="UTF-8" />
    6.         <layout class="org.apache.log4j.PatternLayout">
    7.             <param name="ConversionPattern" value="%-5p %d{MM-dd HH:mm:ss,SSS}
    8. %m (%F:%L) \n" />
    9.         layout>
    10.     appender>
    11.     <logger name="java.sql">
    12.         <level value="debug" />
    13.     logger>
    14.     <logger name="org.apache.ibatis">
    15.         <level value="info" />
    16.     logger>
    17.     <root>
    18.         <level value="debug" />
    19.         <appender-ref ref="STDOUT" />
    20.     root>
    21. log4j:configuration>

    ⚪项目结构 

    ⚪实体类

    1. package com.atguigu.ssm.pojo;
    2.  
    3. public class Employee {
    4.     private Integer empId;
    5.     private String empName;
    6.     private Integer age;
    7.     private String gender;
    8.     private String email;
    9.  
    10.     public Employee(Integer empId, String empName, Integer age, String gender, String email) {
    11.         this.empId = empId;
    12.         this.empName = empName;
    13.         this.age = age;
    14.         this.gender = gender;
    15.         this.email = email;
    16.     }
    17.  
    18.     public Employee() {
    19.     }
    20.  
    21.     public Integer getEmpId() {
    22.         return empId;
    23.     }
    24.  
    25.     public void setEmpId(Integer empId) {
    26.         this.empId = empId;
    27.     }
    28.  
    29.     public String getEmpName() {
    30.         return empName;
    31.     }
    32.  
    33.     public void setEmpName(String empName) {
    34.         this.empName = empName;
    35.     }
    36.  
    37.     public Integer getAge() {
    38.         return age;
    39.     }
    40.  
    41.     public void setAge(Integer age) {
    42.         this.age = age;
    43.     }
    44.  
    45.     public String getGender() {
    46.         return gender;
    47.     }
    48.  
    49.     public void setGender(String gender) {
    50.         this.gender = gender;
    51.     }
    52.  
    53.     public String getEmail() {
    54.         return email;
    55.     }
    56.  
    57.     public void setEmail(String email) {
    58.         this.email = email;
    59.     }
    60.  
    61.     @Override
    62.     public String toString() {
    63.         return "Employee{" +
    64.                 "empId=" + empId +
    65.                 ", empName='" + empName + '\'' +
    66.                 ", age=" + age +
    67.                 ", gender='" + gender + '\'' +
    68.                 ", email='" + email + '\'' +
    69.                 '}';
    70.     }
    71. }

    三、测试功能

    1.查询所有的员工信息

    ⚪创建接口EmployeeService

    1. public interface EmployeeService {
    2.     /**
    3.      * 查询所有的员工信息
    4.      * @return
    5.      */
    6.     List getAllEmployee();
    7. }

    ⚪创建实现类EmployeeServiceImpl 

    1. @Transactional
    2. @Service
    3. public class EmployeeServiceImpl implements EmployeeService {
    4.  
    5.     @Autowired
    6.     private EmployeeMapper employeeMapper;
    7.  
    8.     public List getAllEmployee() {
    9.         return employeeMapper.getAllEmployee();
    10.     }
    11. }

    ⚪创建控制层组件EmployeeController 

    1. @Controller
    2. public class EmployeeController {
    3.     @Autowired
    4.     private EmployeeService employeeService;
    5.  
    6.  
    7.     @RequestMapping(value = "/employee",method = RequestMethod.GET)
    8.     public String getAllEmployee(Model model){
    9.         //查询所有的员工信息
    10.         List list = employeeService.getAllEmployee();
    11.         //将员工信息在请求域中共享
    12.         model.addAttribute("list",list);
    13.         //跳转到employee_list.html
    14.         return "employee_list";
    15.     }
    16. }

    ⚪创建页面

    1. html>
    2. <html lang="en" xmlns:th="http://www.thymeleaf.org">
    3. <head>
    4.     <meta charset="UTF-8">
    5.     <title>员工列表title>
    6.     <link rel="stylesheet" th:href="@{/static/css/index_work.css}">
    7. head>
    8. <body>
    9.     <table>
    10.         <tr>
    11.             <th colspan="6">员工列表th>
    12.         tr>
    13.         <tr>
    14.             <th>流水号th>
    15.             <th>员工姓名th>
    16.             <th>年龄th>
    17.             <th>性别th>
    18.             <th>邮箱th>
    19.             <th>操作th>
    20.         tr>
    21.         <tr th:each="employee,status : ${list}">
    22.             <td th:text="${status.count}">td>
    23.             <td th:text="${employee.empName}">td>
    24.             <td th:text="${employee.age}">td>
    25.             <td th:text="${employee.gender}">td>
    26.             <td th:text="${employee.email}">td>
    27.             <td>
    28.                 <a th:href="">删除a>
    29.                 <a th:href="">修改a>
    30.             td>
    31.         tr>
    32.     table>
    33. body>
    34. html>

    结果：

    二、数据分页

    1. /**
    2.  * 获取员工的分页信息
    3.  * @param pageNum
    4.  * @return
    5.  */
    6. PageInfo getEmployeePage(Integer pageNum);
    1. @RequestMapping(value = "/employee/page/{pageNum}",method = RequestMethod.GET)
    2. public String getEmployeePage(@PathVariable("pageNum") Integer pageNum,Model model){
    3.     //获取员工的分页信息
    4.     PageInfo page = employeeService.getEmployeePage(pageNum);
    5.     //将分页数据共享到请求域中
    6.     model.addAttribute("page",page);
    7.     //跳转到employee_list.html
    8.     return "employee_list";
    9. }
    1. public PageInfo getEmployeePage(Integer pageNum) {
    2.     //开启分页功能
    3.     PageHelper.startPage(pageNum,4);
    4.     //查询所有的员工信息
    5.     List list = employeeMapper.getAllEmployee();
    6.     //获取分页相关数据
    7.     PageInfo page = new PageInfo(list,5);
    8.     return page;
    9. }
    1. html>
    2. <html lang="en" xmlns:th="http://www.thymeleaf.org" xmlns:color="http://www.w3.org/1999/xhtml">
    3. <head>
    4.     <meta charset="UTF-8">
    5.     <title>员工列表title>
    6.     <link rel="stylesheet" th:href="@{/static/css/index_work.css}">
    7. head>
    8. <body>
    9.     <table>
    10.         <tr>
    11.             <th colspan="6">员工列表th>
    12.         tr>
    13.         <tr>
    14.             <th>流水号th>
    15.             <th>员工姓名th>
    16.             <th>年龄th>
    17.             <th>性别th>
    18.             <th>邮箱th>
    19.             <th>操作th>
    20.         tr>
    21.         <tr th:each="employee,status : ${page.list}">
    22.             <td th:text="${status.count}">td>
    23.             <td th:text="${employee.empName}">td>
    24.             <td th:text="${employee.age}">td>
    25.             <td th:text="${employee.gender}">td>
    26.             <td th:text="${employee.email}">td>
    27.             <td>
    28.                 <a th:href="">删除a>
    29.                 <a th:href="">修改a>
    30.             td>
    31.         tr>
    32.     table>
    33.     <div style="text-align: center">
    34.         <a th:if="${page.hasPreviousPage}" th:href="@{/employee/page/1}">首页a>
    35.         <a th:if="${page.hasPreviousPage}" th:href="@{'/employee/page' + ${page.prePage}}">上一页a>
    36.  
    37.         <span th:each="num : ${page.navigatepageNums}">
    38.             <a th:if="${page.pageNum == num} style="color: red;" th:href="@{'/employee/page' + ${num}}" th:text="'['+${num}+']'">a>
    39.             <a th:if="${page.pageNum != num} th:href="@{'/employee/page' + ${num}}" th:text="${num}">下一页a>
    40.         span>
    41.         
    42.         <a th:if="${page.hasNextPage}" th:href="@{'/employee/page' + ${page.nextPage}}">下一页a>
    43.         <a th:if="${page.hasNextPage}" th:href="@{'/employee/page' + ${page.pages}}">末页a>
    44.     div>
    45. body>
    46. html>

  • 相关阅读:
    【操作系统-线程池】Pthread 线程池的设计及实现
    算法竞赛入门【码蹄集进阶塔335题】(MT2286-2290）
    贝wa儿歌（安卓）
    http 403
    PHP redis hash
    猿辅导笔试
    第一章初识Maven与Maven安装配置——尚硅谷
    Vue3快速入门
    JavaPTA练习题 7-3 身体质量指数（BMI）测算
    2021 华数杯全国大学生数学建模竞赛C题-基于神经网络预测电动汽车目标客户销售策略(三)（附带赛题解析&获奖论文及MATLAB代码）
  • 原文地址：https://blog.csdn.net/m0_52982868/article/details/126427654