• Java框架 SSM整合

    1、ContextLoaderListener

            Spring提供了监听器 ContextLoaderListener，实现ServletContextListener接口，可监听 ServletContext的状态，在web服务器的启动，读取Spring的配置文件，创建Spring的IOC容器。web 应用中必须在web.xml中配置: 
    1. 	<listener>
    2. 		
    3. 		<listener-class>org.springframework.web.context.ContextLoaderListenerlistener-class>
    4. 	listener>
    5. 	<context-param>
    6. 		<param-name>contextConfigLocationparam-name>
    7. 		<param-value>classpath:spring.xmlparam-value>
    8. 	context-param>

    代码示例：

    web.xml：

    1. <servlet>
    2. 		<servlet-name>DispatcherServletservlet-name>
    3. 		<servlet-class>org.springframework.web.servlet.DispatcherServletservlet-class>
    4. 		<init-param>
    5. 			<param-name>contextConfigLocationparam-name>
    6. 			<param-value>classpath:springmvc.xmlparam-value>
    7. 		init-param>
    8. 		<load-on-startup>1load-on-startup>
    9. 	servlet>
    10. 	<servlet-mapping>
    11. 		<servlet-name>DispatcherServletservlet-name>
    12. 		<url-pattern>/url-pattern>
    13. 	servlet-mapping>
    14.  
    15. 	<listener>
    16. 		
    17. 		<listener-class>org.springframework.web.context.ContextLoaderListenerlistener-class>
    18. 	listener>
    19. 	<context-param>
    20. 		<param-name>contextConfigLocationparam-name>
    21. 		<param-value>classpath:spring.xmlparam-value>
    22. 	context-param>

    spring.xml:

    	<context:component-scan base-package="com.chenyixin.ssm.service"/>

    springmvc.xml:

    1. 	
    2. 	<context:component-scan base-package="com.chenyixin.ssm.controller"/>
    3.  
    4. 	
    5. 	<bean id="viewResolver"
    6. 		  class="org.thymeleaf.spring5.view.ThymeleafViewResolver">
    7. 		<property name="order" value="1"/>
    8. 		<property name="characterEncoding" value="UTF-8"/>
    9. 		<property name="templateEngine">
    10. 			<bean class="org.thymeleaf.spring5.SpringTemplateEngine">
    11. 				<property name="templateResolver">
    12. 					<bean class="org.thymeleaf.spring5.templateresolver.SpringResourceTemplateResolver">
    13. 						
    14. 						<property name="prefix" value="/WEB-INF/templates/"/>
    15. 						
    16. 						<property name="suffix" value=".html"/>
    17. 						<property name="templateMode" value="HTML5"/>
    18. 						<property name="characterEncoding" value="UTF-8"/>
    19. 					bean>
    20. 				property>
    21. 			bean>
    22. 		property>
    23. 	bean>
    24.  
    25. 	
    26. 	<mvc:annotation-driven/>
    27.  
    28. 	
    29. 	<mvc:view-controller path="/" view-name="index"/>

    创建 Service 层（除注解外，无代码内容）

     创建 Controller 层

    1. @Controller
    2. public class HelloController {
    3.  
    4.     @Autowired
    5.     private HelloService helloService;
    6. }

    index.html:

    1. <head>
    2.     <meta charset="UTF-8">
    3.     <title>首页title>
    4. head>
    5. <body>
    6. <h1>index.htmlh1>
    7. body>

    结果：运行服务器，正常运行

    若将监听器注释掉，则服务器运行报错:

    1. 	
    2. 	
    3. 	
    4. 	
    5. 	
    6. 	
    7. 	
    8. 	
    9. 	
    10. 	
    11. 	
    12.

    2、准备工作

    ① 创建Maven Module

    略

    ② 导入依赖

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

    ③ 创建表

    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
    9.  
    10. INSERT INTO t_emp VALUES
    11. (1001,'admin',20,'男','admin@qq.com'),
    12. (NULL,'zhangsan',21,'女','zhangsan@qq.com'),
    13. (NULL,'lisi',21,'女','lisi@qq.com'),
    14. (NULL,'wangwu',21,'男','wangwu@qq.com'),
    15. (NULL,'zaoliu',21,'男','zaoliu@qq.com'),
    16. (NULL,'tianqi',22,'女','tianqi@qq.com'),
    17. (NULL,'张三',21,'女','zhangsan@qq.com'),
    18. (NULL,'李四',21,'女','lisi@qq.com'),
    19. (NULL,'王五',21,'男','wangwu@qq.com'),
    20. (NULL,'赵六',21,'男','zaoliu@qq.com'),
    21. (NULL,'田七',22,'女','tianqi@qq.com'),
    22. (NULL,'xioaming',22,'男','xioaming@qq.com'),
    23. (NULL,'xiaohua',22,'男','xiaohua@qq.com'),
    24. (NULL,'xiaozhang',22,'男','xiaozhang@qq.com'),
    25. (NULL,'xiaowang',22,'男','xiaowang@qq.com'),
    26. (NULL,'xiaofang',22,'女','xiaofang@qq.com'),
    27. (NULL,'小明',22,'男','xioaming@qq.com'),
    28. (NULL,'小华',22,'男','xiaohua@qq.com'),
    29. (NULL,'小张',22,'男','xiaozhang@qq.com'),
    30. (NULL,'小王',22,'男','xiaowang@qq.com'),
    31. (NULL,'小芳',22,'女','xiaofang@qq.com')

    ④ 创建实体类Employee 

    1. package com.chenyixin.ssm.pojo;
    2.  
    3. public class Employee {
    4.     private Integer empId;
    5.     private String empName;
    6.     private Integer age;
    7.     private String sex;
    8.     private String email;
    9.  
    10.     public Employee(Integer empId, String empName, Integer age, String sex, String email) {
    11.         this.empId = empId;
    12.         this.empName = empName;
    13.         this.age = age;
    14.         this.sex = sex;
    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 getSex() {
    46.         return sex;
    47.     }
    48.  
    49.     public void setSex(String sex) {
    50.         this.sex = sex;
    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.                 ", sex='" + sex + '\'' +
    68.                 ", email='" + email + '\'' +
    69.                 '}';
    70.     }
    71. }

    3、配置 xml 文件

    3.1、配置 web.xml 文件

    2. 	<filter>
    3. 		<filter-name>CharacterEncodingFilterfilter-name>
    4. 		<filter-class>org.springframework.web.filter.CharacterEncodingFilterfilter-class>
    5. 		<init-param>
    6. 			<param-name>encodingparam-name>
    7. 			<param-value>UTF-8param-value>
    8. 		init-param>
    9. 		<init-param>
    10. 			<param-name>forceEncodingparam-name>
    11. 			<param-value>trueparam-value>
    12. 		init-param>
    13. 	filter>
    14. 	<filter-mapping>
    15. 		<filter-name>CharacterEncodingFilterfilter-name>
    16. 		<url-pattern>/*url-pattern>
    17. 	filter-mapping>
    18.  
    19. 	
    20. 	<filter>
    21. 		<filter-name>HiddenHttpMethodFilterfilter-name>
    22. 		<filter-class>org.springframework.web.filter.HiddenHttpMethodFilterfilter-class>
    23. 	filter>
    24. 	<filter-mapping>
    25. 		<filter-name>HiddenHttpMethodFilterfilter-name>
    26. 		<url-pattern>/*url-pattern>
    27. 	filter-mapping>
    28.  
    29. 	
    30. 	<servlet>
    31. 		<servlet-name>DispatcherServletservlet-name>
    32. 		<servlet-class>org.springframework.web.servlet.DispatcherServletservlet-class>
    33. 		
    34. 		<init-param>
    35. 			<param-name>contextConfigLocationparam-name>
    36. 			<param-value>classpath:springmvc.xmlparam-value>
    37. 		init-param>
    38. 		
    39. 		<load-on-startup>1load-on-startup>
    40. 	servlet>
    41. 	<servlet-mapping>
    42. 		<servlet-name>DispatcherServletservlet-name>
    43. 		<url-pattern>/url-pattern>
    44. 	servlet-mapping>
    45.  
    46. 	
    47. 	<listener>
    48. 		<listener-class>org.springframework.web.context.ContextLoaderListenerlistener-class>
    49. 	listener>
    50.  
    51. 	
    52. 	<context-param>
    53. 		<param-name>contextConfigLocationparam-name>
    54. 		<param-value>classpath:spring.xmlparam-value>
    55. 	context-param>

    3.2、创建SpringMVC的配置文件并配置

    1.     
    2. 	<context:component-scan base-package="com.chenyixin.ssm.controller"/>
    3.  
    4. 	
    5. 	<bean id="viewResolver"
    6. 		  class="org.thymeleaf.spring5.view.ThymeleafViewResolver">
    7. 		<property name="order" value="1"/>
    8. 		<property name="characterEncoding" value="UTF-8"/>
    9. 		<property name="templateEngine">
    10. 			<bean class="org.thymeleaf.spring5.SpringTemplateEngine">
    11. 				<property name="templateResolver">
    12. 					<bean class="org.thymeleaf.spring5.templateresolver.SpringResourceTemplateResolver">
    13. 						
    14. 						<property name="prefix" value="/WEB-INF/templates/"/>
    15. 						
    16. 						<property name="suffix" value=".html"/>
    17. 						<property name="templateMode" value="HTML5"/>
    18. 						<property name="characterEncoding" value="UTF-8"/>
    19. 					bean>
    20. 				property>
    21. 			bean>
    22. 		property>
    23. 	bean>
    24. 	
    25. 	<mvc:default-servlet-handler/>
    26.  
    27. 	
    28. 	<mvc:annotation-driven/>
    29.  
    30. 	
    31. 	<mvc:view-controller path="/" view-name="index"/>

    3.3、创建Spring的配置文件并配置

    1. 	
    2. 	<context:component-scan base-package="com.chenyixin.ssm">
    3. 		<context:exclude-filter type="annotation" expression="org.springframework.stereotype.Controller"/>
    4. 	context:component-scan>
    5.  
    6. 	
    7. 	<context:property-placeholder location="classpath:jdbc.properties"/>
    8.  
    9. 	
    10. 	<bean id="dataSource" class="com.alibaba.druid.pool.DruidDataSource">
    11. 		<property name="driverClassName" value="${jdbc.driver}"/>
    12. 		<property name="url" value="${jdbc.url}"/>
    13. 		<property name="username" value="${jdbc.username}"/>
    14. 		<property name="password" value="${jdbc.password}"/>
    15. 	bean>
    16.  
    17. 	
    18. 	<bean id="transactionManager" class="org.springframework.jdbc.datasource.DataSourceTransactionManager">
    19. 		<property name="dataSource" ref="dataSource"/>
    20. 	bean>
    21.  
    22. 	
    23. 	<tx:annotation-driven transaction-manager="transactionManager"/>

    4、搭建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=root

    ② 在 Spring 的配置文件中添加 MyBatis 的配置

    1. 	
    2. 	<bean class="org.mybatis.spring.SqlSessionFactoryBean">
    3. 		
    4. 		<property name="configLocation" value="classpath:mybatis-config.xml"/>
    5. 		
    6. 		<property name="dataSource" ref="dataSource"/>
    7. 		
    8. 		<property name="typeAliasesPackage" value="com.chenyixin.ssm.pojo"/>
    9. 		
    10. 		
    11. 	bean>
    12.  
    13. 	
    14. 	<bean class="org.mybatis.spring.mapper.MapperScannerConfigurer">
    15. 		<property name="basePackage" value="com.chenyixin.ssm.mapper"/>
    16. 	bean>

    ③ 创建MyBatis的核心配置文件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. 	
    9. 	<settings>
    10. 		<setting name="mapUnderscoreToCamelCase" value="true"/>
    11. 	settings>
    12.  
    13. 	<plugins>
    14. 		
    15. 		<plugin interceptor="com.github.pagehelper.PageInterceptor">plugin>
    16. 	plugins>
    17.  
    18. configuration>

    ④ 创建Mapper接口和映射文件

    EmployeeMapper 接口：

    1. public interface EmployeeMapper {
    2. }

    EmployeeMapper.xml 映射文件：

    1. "1.0" encoding="UTF-8" ?>
    2. mapper
    3. 		PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN"
    4. 		"http://mybatis.org/dtd/mybatis-3-mapper.dtd">
    5.  
    6. <mapper namespace="com.chenyixin.ssm.mapper.EmployeeMapper">
    7.  
    8. mapper>

    ⑤ 创建日志文件log4j.xml

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

    5、功能实现

    5.1、功能清单

     

    5.2、访问首页

    创建 index.html:

    1. html>
    2. <html lang="en" xmlns:th="http://www.thymeleaf.org">
    3. <head>
    4.     <meta charset="UTF-8">
    5.     <title>首页title>
    6. head>
    7. <body>
    8. <h1>index.htmlh1>
    9. <a th:href="@{/employee}">员工信息列表a>
    10. body>
    11. html>

    5.3、查询全部数据(含分页功能)

    ① Java 代码

    EmployeeController :

    1. @Controller
    2. public class EmployeeController {
    3.  
    4.     @Autowired
    5.     private EmployeeService employeeService;
    6.  
    7.     @GetMapping("/employee/page/{pageNum}")
    8.     public String getAllEmployee(Model model,@PathVariable("pageNum") Integer pageNum) {
    9.         PageInfo page = employeeService.getAllEmployee(pageNum);
    10.         model.addAttribute("page", page);
    11.         return "employee_list";
    12.     }
    13. }

    EmployeeService :

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

    EmployeeServiceImpl 

    1. @Service
    2. @Transactional
    3. public class EmployeeServiceImpl implements EmployeeService {
    4.  
    5.     @Autowired
    6.     private EmployeeMapper employeeMapper;
    7.  
    8.     @Override
    9.     public PageInfo getAllEmployee(Integer pageNum) {
    10.         // 开启分页功能，并传入 当前页面，和每页显示的条数
    11.         PageHelper.startPage(pageNum,4);
    12.         List list = employeeMapper.selectAllEmployee();
    13.         // 创建 PageInfo ,传入 list 和 导航分页的页码数
    14.         return new PageInfo<>(list, 5);
    15.     }
    16. }

    EmployeeMapper 

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

    ② Mybaits 代码

    1. <mapper namespace="com.chenyixin.ssm.mapper.EmployeeMapper">
    2. 	
    3. 	<select id="selectAllEmployee" resultType="employee">
    4. 		select * from t_emp
    5. 	select>
    6. mapper>

    ③ employee_list.html

    1. html>
    2. <html lang="en" xmlns:th="http://www.thymeleaf.org">
    3. <link rel="stylesheet" th:href="@{/static/css/index_work.css}">
    4. <head>
    5.     <meta charset="UTF-8">
    6.     <title>员工信息表title>
    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.sex}">td>
    26.         <td th:text="${employee.email}">td>
    27.         <td>
    28.             <a>删除a>
    29.             <a>修改a>
    30.         td>
    31.     tr>
    32.     <tr>
    33.         <td colspan="6">
    34.             <span th:if="${page.hasPreviousPage}">
    35.                 <a th:href="@{/employee/page/1}">首页a>
    36.                 <a th:href="@{'/employee/page/'+${page.prePage}}">上一页a>
    37.             span>
    38.             <span th:each="num : ${page.navigatepageNums}">
    39.                 <a th:if="${page.pageNum == num}" style="color: orangered" th:href="@{'/employee/page/'+${num}}" th:text="'【'+${num}+'】'">a>
    40.                 <a th:if="${page.pageNum != num}" th:href="@{'/employee/page/'+${num}}" th:text="${num}">a>
    41.             span>
    42.  
    43.             <span th:if="${page.hasNextPage }">
    44.                 <a th:href="@{'/employee/page/'+${page.nextPage}}">下一页a>
    45.                 <a th:href="@{'/employee/page/'+${page.pages}}">末页a>
    46.             span>
    47.         td>
    48.     tr>
    49. table>
    50. body>
    51. html>

    5.4 删除功能

    ① 修改employee_list.html，并添加事件

    1. html>
    2. <html lang="en" xmlns:th="http://www.thymeleaf.org">
    3. <link rel="stylesheet" th:href="@{/static/css/index_work.css}">
    4. <head>
    5.     <meta charset="UTF-8">
    6.     <title>员工信息表title>
    7. head>
    8. <body>
    9. <table id="dataTable">
    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.sex}">td>
    26.         <td th:text="${employee.email}">td>
    27.         <td>
    28.             <a @click="deleteEmployee" th:href="@{'/employee/'+${employee.empId}}">删除a>
    29.             <a>修改a>
    30.         td>
    31.     tr>
    32.     <tr>
    33.         <td colspan="6">
    34.             <span th:if="${page.hasPreviousPage}">
    35.                 <a th:href="@{/employee/page/1}">首页a>
    36.                 <a th:href="@{'/employee/page/'+${page.prePage}}">上一页a>
    37.             span>
    38.             <span th:each="num : ${page.navigatepageNums}">
    39.                 <a th:if="${page.pageNum == num}" style="color: orangered" th:href="@{'/employee/page/'+${num}}"
    40.                    th:text="'['+${num}+'] '">a>
    41.                 <a th:if="${page.pageNum != num}" th:href="@{'/employee/page/'+${num}}" th:text="${num+' '}">a>
    42.             span>
    43.  
    44.             <span th:if="${page.hasNextPage }">
    45.                 <a th:href="@{'/employee/page/'+${page.nextPage}}">下一页a>
    46.                 <a th:href="@{'/employee/page/'+${page.pages}}">末页a>
    47.             span>
    48.         td>
    49.         <td>
    50.             
    51.             <form id="delete_form" method="post">
    52.                 
    53.                 <input type="hidden" name="_method" value="delete"/>
    54.             form>
    55.         td>
    56.     tr>
    57. table>
    58.  
    60. <script type="text/javascript" th:src="@{/static/js/vue.js}">script>
    61. <script type="text/javascript">
    62.     var vue = new Vue({
    63.         el: "#dataTable",
    64.         methods: {
    65.             // event 表示当前事件
    66.             deleteEmployee: function (event) {
    67.                 // 通过 id 获取表单标签
    68.                 var delete_form = document.getElementById("delete_form");
    69.                 // 将触发事件的超链接的 href 属性为表单的 action 属性赋值
    70.                 delete_form.action = event.target.href;
    71.                 // 提交表单
    72.                 delete_form.submit();
    73.                 // 阻止超链接的默认跳转行为
    74.                 event.preventDefault();
    75.             }
    76.         }
    77.     });
    78. script>
    79. body>
    80. html>

    ② 控制器方法

    1.     @DeleteMapping("/employee/{id}")
    2.     public String deleteEmployeeById(@PathVariable Integer id, @RequestHeader("Referer") String referer) {
    3.         employeeService.deleteEmployeeById(id);
    4.         return "redirect:" + referer;
    5.     }

    5.5 添加员工信息功能

    ① 修改employee_list.html

    作用：跳转到添加数据页面

     

    ② 创建employee_add.html

    1. html>
    2. <html lang="en" xmlns:th="http://www.thymeleaf.org">
    3. <link rel="stylesheet" th:href="@{/static/css/index_work.css}">
    4. <head>
    5.     <meta charset="UTF-8">
    6.     <title>添加员工信息title>
    7. head>
    8. <body>
    9. <form th:action="@{/employee}" method="post">
    10.     <table id="dataTable">
    11.         <tr>
    12.             <th colspan="2">添加员工信息th>
    13.         tr>
    14.         <tr>
    15.             <td>姓名td>
    16.             <td>
    17.                 <input type="text" name="empName"/>
    18.             td>
    19.         tr>
    20.         <tr>
    21.             <td>年龄td>
    22.             <td>
    23.                 <input type="text" name="age" />
    24.             td>
    25.         tr>
    26.         <tr>
    27.             <td>性别td>
    28.             <td>
    29.                 <input type="text" name="sex">
    30.             td>
    31.         tr>
    32.         <tr>
    33.             <td>邮箱td>
    34.             <td>
    35.                 <input type="text" name="email" >
    36.             td>
    37.         tr>
    38.         <tr>
    39.             <th colspan="2">
    40.                 <input type="submit" value="添加">
    41.                         
    42.                 <input type="reset" value="重置">
    43.             th>
    44.         tr>
    45.     table>
    46. form>
    47. body>
    48. html>

    ③ 控制器方法

    1.     @RequestMapping("/employee/to/add")
    2.     public String toADD(@RequestHeader("Referer") String referer) {
    3.         this.referer = referer;
    4.         return "employee_add";
    5.     }
    6.     @PostMapping("/employee")
    7.     public String addEmployee(Employee employee) {
    8.         employeeService.addEmployee(employee);
    9.         return "redirect:"+referer;
    10.     }

    ④ 添加方法

    EmployeeService 接口：

    1.     /**
    2.      * 添加用户信息
    3.      * @param employee
    4.      */
    5.     void addEmployee(Employee employee);

    EmployeeServiceImpl 实现类：

    1.     @Override
    2.     public void addEmployee(Employee employee) {
    3.         employeeMapper.insertEmployee(employee);
    4.     }

    EmployeeMapper 接口：

    1.     /**
    2.      * 添加用户信息
    3.      * @param employee
    4.      */
    5.     void insertEmployee(Employee employee);

    EmployeeMapper.xml 配置文件：

    1. 	
    2. 	<insert id="insertEmployee">
    3. 		insert into t_emp values(null,#{empName},#{age},#{sex},#{email})
    4. 	insert>

    5.6 更新员工数据功能

    ① 修改超链接

     

    ② 创建employee_update.html

    1. html>
    2. <html lang="en" xmlns:th="http://www.thymeleaf.org">
    3. <link rel="stylesheet" th:href="@{/static/css/index_work.css}">
    4. <head>
    5.     <meta charset="UTF-8">
    6.     <title>修改员工信息title>
    7. head>
    8. <body>
    9. <form th:action="@{/employee}" method="post">
    10.     <input type="hidden" name="_method" value="put">
    11.     <input type="hidden" name="empId" th:value="${employee.empId}">
    12.     <table id="dataTable">
    13.         <tr>
    14.             <th colspan="2">修改员工信息th>
    15.         tr>
    16.         <tr>
    17.             <td>姓名td>
    18.             <td>
    19.                 <input type="text" name="empName" th:value="${employee.empName}"/>
    20.             td>
    21.         tr>
    22.         <tr>
    23.             <td>年龄td>
    24.             <td>
    25.                 <input type="text" name="age" th:value="${employee.age}"/>
    26.             td>
    27.         tr>
    28.         <tr>
    29.             <td>性别td>
    30.             <td>
    31.                 <input type="radio" name="sex" value="男" th:field="${employee.sex}">男
    32.                 <input type="radio" name="sex" value="女" th:field="${employee.sex}">女
    33.             td>
    34.         tr>
    35.         <tr>
    36.             <td>邮箱td>
    37.             <td>
    38.                 <input type="text" name="email" th:value="${employee.email}">
    39.             td>
    40.         tr>
    41.         <tr>
    42.             <th colspan="2">
    43.                 <input type="submit" value="修改">
    44.                         
    45.                 <input type="reset" value="重置">
    46.             th>
    47.         tr>
    48.     table>
    49. form>
    50. body>
    51. html>

    ③ 控制器方法

    1.     @GetMapping("/employee/{id}")
    2.     public String toUpdate(@RequestHeader("Referer") String referer, @PathVariable Integer id, Model model) {
    3.         Employee employee = employeeService.getEmployeeById(id);
    4.         model.addAttribute("employee", employee);
    5.         this.referer = referer;
    6.         return "employee_update";
    7.     }
    8.  
    9.     @PutMapping("/employee")
    10.     public String UpdateEmployee(Employee employee) {
    11.         employeeService.updateEmployee(employee);
    12.         return "redirect:" + referer;
    13.     }

    ④ 修改方法

    EmployeeService 接口：

    1.     /**
    2.      * 根据 id 查询员工信息
    3.      * @param id
    4.      */
    5.     Employee getEmployeeById(Integer id);
    6.  
    7.     /**
    8.      * 修改用户信息
    9.      * @param employee
    10.      */
    11.     void updateEmployee(Employee employee);

    EmployeeServiceImpl 实现类：

    1.     @Override
    2.     public Employee getEmployeeById(Integer id) {
    3.         return employeeMapper.selectEmployeeById(id);
    4.     }
    5.  
    6.     @Override
    7.     public void updateEmployee(Employee employee) {
    8.         employeeMapper.updateEmployee(employee);
    9.     }

    EmployeeMapper 接口：

    1.     /**
    2.      * 根据 id 查询员工信息
    3.      * @param id
    4.      */
    5.     Employee selectEmployeeById(Integer id);
    6.  
    7.     /**
    8.      * 修改用户信息
    9.      * @param employee
    10.      */
    11.     void updateEmployee(Employee employee);

    EmployeeMapper.xml 配置文件：

    1. 	
    2. 	<select id="selectEmployeeById" resultType="employee">
    3. 		select *
    4. 		from t_emp
    5. 		where emp_id = #{id}
    6. 	select>
    7.  
    8. 	
    9. 	<update id="updateEmployee">
    10. 		update t_emp
    11. 		set emp_name = #{empName},
    12. 			age      = #{age},
    13. 			sex      = #{sex},
    14. 			email    = #{email}
    15. 		where emp_id = #{empId}
    16. 	update>

  • 相关阅读:
    每周一算法：最短路计数
    【Javascript】运算符（赋值，算术，自增，自减）
    java使用了未经检查或不安全的操作。的解决方法
    35岁危机，有哪10种解法？
    【Elixr】 introduce
    Windows 11 22621.1 , 10.0.22622.290 文件资源管理器中启用多标签,全新导航栏
    Java垃圾回收_1
    jar包应用的简单启停脚本
    Notepad++使用技巧
    SBF vs. 火柴大王
  • 原文地址：https://blog.csdn.net/weixin_65637841/article/details/126494322