• SSM_整合篇

    一、整合步骤

    1.1 数据表的介绍

    team表：

     player表：

    1.2 创建maven项目

    1.3 pom.xml引入jar依赖

    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.lxygroupId>
    8.     <artifactId>myssm_testartifactId>
    9.     <version>1.0-SNAPSHOTversion>
    10.  
    11.     <packaging>warpackaging>
    12.  
    13.     
    14.     
    15.     <properties>
    16.         <spring.version>5.2.13.RELEASEspring.version>
    17.         <mybatis.version>3.5.6mybatis.version>
    18.         <mybatis.spring.version>1.3.3mybatis.spring.version>
    19.         <pagehelper.version>5.1.10pagehelper.version>
    20.         <mysql.version>8.0.23mysql.version>
    21.         <druid.version>1.2.3druid.version>
    22.         <servlet-api.version>4.0.1servlet-api.version>
    23.         <jackson.version>2.9.6jackson.version>
    24.         <log4j.version>1.2.17log4j.version>
    25.         <junit.version>4.12junit.version>
    26.         <maven.compiler.source>11maven.compiler.source>
    27.         <maven.compiler.target>11maven.compiler.target>
    28.     properties>
    29.     <dependencies>
    30.         
    31.         <dependency>
    32.             <groupId>org.springframeworkgroupId>
    33.             <artifactId>spring-webmvcartifactId>
    34.             <version>${spring.version}version>
    35.         dependency>
    36.         <dependency>
    37.             <groupId>org.springframeworkgroupId>
    38.             <artifactId>spring-txartifactId>
    39.             <version>${spring.version}version>
    40.         dependency>
    41.         <dependency>
    42.             <groupId>org.springframeworkgroupId>
    43.             <artifactId>spring-jdbcartifactId>
    44.             <version>${spring.version}version>
    45.         dependency>
    46.         <dependency>
    47.             <groupId>org.springframeworkgroupId>
    48.             <artifactId>spring-aspectsartifactId>
    49.             <version>${spring.version}version>
    50.         dependency>
    51.         
    52.         <dependency>
    53.             <groupId>commons-fileuploadgroupId>
    54.             <artifactId>commons-fileuploadartifactId>
    55.             <version>1.3.1version>
    56.         dependency>
    57.         
    58.         <dependency>
    59.             <groupId>org.mybatisgroupId>
    60.             <artifactId>mybatisartifactId>
    61.             <version>${mybatis.version}version>
    62.         dependency>
    63.         
    64.         <dependency>
    65.             <groupId>org.mybatisgroupId>
    66.             <artifactId>mybatis-springartifactId>
    67.             <version>${mybatis.spring.version}version>
    68.         dependency>
    69.         
    70.         <dependency>
    71.             <groupId>com.github.pagehelpergroupId>
    72.             <artifactId>pagehelperartifactId>
    73.             <version>${pagehelper.version}version>
    74.         dependency>
    75.         
    76.         <dependency>
    77.             <groupId>mysqlgroupId>
    78.             <artifactId>mysql-connector-javaartifactId>
    79.             <version>${mysql.version}version>
    80.         dependency>
    81.         
    82.         <dependency>
    83.             <groupId>com.alibabagroupId>
    84.             <artifactId>druidartifactId>
    85.             <version>${druid.version}version>
    86.         dependency>
    87.         
    88.         <dependency>
    89.             <groupId>javax.servletgroupId>
    90.             <artifactId>javax.servlet-apiartifactId>
    91.             <version>${servlet-api.version}version>
    92.             <scope>providedscope>
    93.         dependency>
    94.         
    95.         <dependency>
    96.             <groupId>com.fasterxml.jackson.coregroupId>
    97.             <artifactId>jackson-databindartifactId>
    98.             <version>${jackson.version}version>
    99.         dependency>
    100.         
    101.         <dependency>
    102.             <groupId>log4jgroupId>
    103.             <artifactId>log4jartifactId>
    104.             <version>${log4j.version}version>
    105.         dependency>
    106.         
    107.         <dependency>
    108.             <groupId>junitgroupId>
    109.             <artifactId>junitartifactId>
    110.             <version>${junit.version}version>
    111.             <scope>testscope>
    112.         dependency>
    113.         <dependency>
    114.             <groupId>org.springframeworkgroupId>
    115.             <artifactId>spring-testartifactId>
    116.             <version>${spring.version}version>
    117.         dependency>
    118.         
    119.         <dependency>
    120.             <groupId>javax.annotationgroupId>
    121.             <artifactId>javax.annotation-apiartifactId>
    122.             <version>1.3.2version>
    123.         dependency>
    124.     dependencies>
    125.     
    126.     <build>
    127.         <resources>
    128.             <resource>
    129.                 <directory>src/main/javadirectory>
    130.                 <includes>
    131.                     <include>**/*.propertiesinclude>
    132.                     <include>**/*.xmlinclude>
    133.                 includes>
    134.                 <filtering>falsefiltering>
    135.             resource>
    136.         resources>
    137.         <plugins>
    138.             
    139.             <plugin>
    140.                 <groupId>org.apache.maven.pluginsgroupId>
    141.                 <artifactId>maven-compiler-pluginartifactId>
    142.                 <configuration>
    143.                     <source>1.8source>
    144.                     <target>1.8target>
    145.                     <encoding>UTF-8encoding>
    146.                 configuration>
    147.             plugin>
    148.             
    149.             <plugin>
    150.                 <groupId>org.apache.tomcat.mavengroupId>
    151.                 <artifactId>tomcat7-maven-pluginartifactId>
    152.                 <version>2.2version>
    153.                 <configuration>
    154.                     
    155.                     <port>80port>
    156.                     
    157.                     <path>/path>
    158.                     <uriEncoding>UTF-8uriEncoding>
    159.                 configuration>
    160.             plugin>
    161.             
    162.             <plugin>
    163.                 <groupId>org.mybatis.generatorgroupId>
    164.                 <artifactId>mybatis-generator-maven-pluginartifactId>
    165.                 <version>1.3.5version>
    166.                 <configuration>
    167.                     
    168.                     <configurationFile>src/main/resources/generatorConfig.xmlconfigurationFile>
    169.                     <overwrite>trueoverwrite>
    170.                 configuration>
    171.                 <dependencies>
    172.                     <dependency>
    173.                         <groupId>org.mybatis.generatorgroupId>
    174.                         <artifactId>mybatis-generator-coreartifactId>
    175.                         <version>1.3.5version>
    176.                     dependency>
    177.                 dependencies>
    178.             plugin>
    179.         plugins>
    180.     build>
    181. project>

    1.4 编写Mybatis的配置文件

    Mybatis的配置文件mybatis.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.     <settings>
    7.         <setting name="logImpl" value="LOG4J" />
    8.     settings>
    9.     
    10. configuration>

    日志配置文件文件log4j.properties：

    1. # Global logging configuration info warning error
    2. log4j.rootLogger=DEBUG,stdout
    3. # Console output...
    4. log4j.appender.stdout=org.apache.log4j.ConsoleAppender
    5. log4j.appender.stdout.layout=org.apache.log4j.PatternLayout
    6. log4j.appender.stdout.layout.ConversionPattern=%5p [%t] - %m%n

    1.5 编写Spring的配置文件spring.xml 

     连接数据库的参数配置文件jdbc.properties

    1. jdbc.driver=com.mysql.cj.jdbc.Driver
    2. jdbc.url=jdbc:mysql://localhost:3306/myssm_kkb?useUnicode=true&characterEncoding=utf-8&useSSL=false&serverTimezone=GMT
    3. jdbc.username=root
    4. jdbc.password=linda198721

    这里数据库的版本是Mysql8

    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:tx="http://www.springframework.org/schema/tx"
    6.        xsi:schemaLocation="http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans.xsd
    7.         http://www.springframework.org/schema/context http://www.springframework.org/schema/context/spring-context.xsd
    8.         http://www.springframework.org/schema/tx http://www.springframework.org/schema/tx/spring-tx.xsd">
    9.  
    10.     
    11.     <context:component-scan base-package="com.lxy.mapper,com.lxy.service"/>
    12.  
    13.     
    14.     <context:property-placeholder location="classpath*:jdbc.properties"/>
    15.     <bean id="dataSource" class="com.alibaba.druid.pool.DruidDataSource">
    16.         
    17.         <property name="driverClassName" value="${jdbc.driver}"/>
    18.         <property name="url" value="${jdbc.url}"/>
    19.         <property name="username" value="${jdbc.username}"/>
    20.         <property name="password" value="${jdbc.password}"/>
    21.     bean>
    22.     <bean id="sqlSessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean">
    23.         
    24.         <property name="configLocation" value="classpath:mybatis.xml"/>
    25.         <property name="dataSource" ref="dataSource"/>
    26.         
    27.         <property name="typeAliasesPackage" value="com.lxy.pojo"/>
    28.         
    29.         
    30.         
    31.         <property name="plugins">
    32.             <array>
    33.                 
    34.                 <bean class="com.github.pagehelper.PageInterceptor">
    35.                     <property name="properties">
    36.                         <value>
    37.                             reasonable=true
    38.                         value>
    39.                     property>
    40.                 bean>
    41.             array>
    42.         property>
    43.     bean>
    44.     <bean class="org.mybatis.spring.mapper.MapperScannerConfigurer">
    45.         <property name="basePackage" value="com.lxy.mapper"/>
    46.         <property name="sqlSessionFactoryBeanName" value="sqlSessionFactory"/>
    47.     bean>
    48.  
    49.     
    50.     <tx:annotation-driven transaction-manager="transactionManager"/>
    51.     <bean id="transactionManager" class="org.springframework.jdbc.datasource.DataSourceTransactionManager">
    52.         <property name="dataSource" ref="dataSource"/>
    53.     bean>
    54. beans>

     1.6 编写SpringMVC的配置文件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 http://www.springframework.org/schema/beans/spring-beans.xsd
    7.        http://www.springframework.org/schema/context http://www.springframework.org/schema/context/spring-context.xsd
    8.        http://www.springframework.org/schema/mvc http://www.springframework.org/schema/mvc/spring-mvc.xsd">
    9.  
    10.     
    11.     <context:component-scan base-package="com.lxy.controller"/>
    12.     <mvc:annotation-driven/>
    13.     
    14.     <bean id="internalResourceViewResolver" class="org.springframework.web.servlet.view.InternalResourceViewResolver">
    15.         <property name="prefix" value="/pages/"/>
    16.         <property name="suffix" value=".html"/>
    17.     bean>
    18.     
    19.     <mvc:resources mapping="/img/**" location="/img/"/>
    20.     <mvc:resources mapping="/js/**" location="/js/"/>
    21.     <mvc:resources mapping="/css/**" location="/css/"/>
    22.     <mvc:resources mapping="/fonts/**" location="/fonts/"/>
    23.     <mvc:resources mapping="/static/**" location="/static/"/>
    24.     <mvc:resources mapping="/pages/**" location="/pages/"/>
    25.     
    26.     <bean id="multipartResolver" class="org.springframework.web.multipart.commons.CommonsMultipartResolver">
    27.     bean>
    28. beans>

     1.7 导入静态页面

    如果您也想要这个项目的话，可以在下发评论，我私信发送给您

    1.8 编写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.     <welcome-file-list>
    7.         <welcome-file>/pages/index.htmlwelcome-file>
    8.     welcome-file-list>
    9.  
    10.     
    11.     <context-param>
    12.         
    13.         <param-name>contextConfigLocationparam-name>
    14.         <param-value>classpath*:spring.xmlparam-value>
    15.     context-param>
    16.     <listener>
    17.         <listener-class>org.springframework.web.context.ContextLoaderListenerlistener-class>
    18.     listener>
    19.     
    20.     <servlet>
    21.         <servlet-name>dispatcherServletservlet-name>
    22.         <servlet-class>org.springframework.web.servlet.DispatcherServletservlet-class>
    23.         
    24.         <init-param>
    25.             <param-name>contextConfigLocationparam-name>
    26.             <param-value>classpath*:springmvc.xmlparam-value>
    27.         init-param>
    28.         
    29.         <load-on-startup>1load-on-startup>
    30.     servlet>
    31.     
    32.     <servlet-mapping>
    33.         <servlet-name>dispatcherServletservlet-name>
    34.         <url-pattern>/url-pattern>
    35.     servlet-mapping>
    36.  
    37.     
    38.     <filter>
    39.         <filter-name>httpMethodFilterfilter-name>
    40.         <filter-class>
    41.             org.springframework.web.filter.HiddenHttpMethodFilter
    42.         filter-class>
    43.     filter>
    44.     <filter-mapping>
    45.         <filter-name>httpMethodFilterfilter-name>
    46.         <url-pattern>/*url-pattern>
    47.     filter-mapping>
    48.  
    49.     
    50.     <filter>
    51.         <filter-name>characterEncodingFilterfilter-name>
    52.         <filter-class>org.springframework.web.filter.CharacterEncodingFilterfilter-class>
    53.         
    54.         <init-param>
    55.             <param-name>encodingparam-name>
    56.             <param-value>UTF-8param-value>
    57.         init-param>
    58.         
    59.         <init-param>
    60.             <param-name>forceRequestEncodingparam-name>
    61.             <param-value>trueparam-value>
    62.         init-param>
    63.         
    64.         <init-param>
    65.             <param-name>forceResponseEncodingparam-name>
    66.             <param-value>trueparam-value>
    67.         init-param>
    68.     filter>
    69.     <filter-mapping>
    70.         <filter-name>characterEncodingFilterfilter-name>
    71.         <url-pattern>/*url-pattern>
    72.     filter-mapping>
    73. web-app>

     1.8 测试

    启动项目，浏览器访问http://localhost:8088/。看到如图所示页面表示项目整合成功。

    二、使用mybatis反向生成实体类、dao和映射文件

    2.1 反向生成配置文件generatorConfig.xml

    1. "1.0" encoding="UTF-8"?>
    2. generatorConfiguration
    3.         PUBLIC "-//mybatis.org//DTD MyBatis Generator Configuration 1.0//EN"
    4.         "http://mybatis.org/dtd/mybatis-generator-config_1_0.dtd">
    6. <generatorConfiguration>
    7.     
    8.     <classPathEntry
    9.             location="D:\repository\mysql\mysql-connector-java\8.0.23\mysql-connector-java-8.0.23.jar" />
    10.     <context id="MyBatis" targetRuntime="MyBatis3">
    11.         
    12.         <commentGenerator>
    13.             <property name="suppressAllComments" value="true" />
    14.         commentGenerator>
    15.         
    16.         <jdbcConnection driverClass="com.mysql.cj.jdbc.Driver"
    17.                         connectionURL="jdbc:mysql://localhost:3306/myssm_kkb?useUnicode=true&characterEncoding=utf8&useSSL=false&serverTimezone=GMT"
    18.                         userId="a"
    19.                         passwor="a">
    20.         jdbcConnection>
    21.         
    22.         <javaTypeResolver>
    23.             <property name="forceBigDecimals" value="false" />
    24.         javaTypeResolver>
    25.         
    26.         <javaModelGenerator targetPackage="com.lxy.pojo"
    27.                             targetProject="src\main\java">
    28.             <property name="trimStrings" value="true" />
    29.         javaModelGenerator>
    30.         
    31.         <sqlMapGenerator targetPackage="com.lxy.mapper"
    32.                          targetProject="src\main\resources">
    33.         sqlMapGenerator>
    34.         
    35.         <javaClientGenerator type="XMLMAPPER"
    36.                              targetPackage="com.lxy.mapper"
    37.                              targetProject="src\main\java">
    38.         javaClientGenerator>
    39.         
    40.         
    41.  
    42.         <table tableName="Team">
    43.             <property name="useActualColumnNames" value="true"/>
    44.         table>
    45.         <table tableName="Player">
    46.             <property name="useActualColumnNames" value="true"/>
    47.         table>
    48.         <table tableName="game">
    49.             <property name="useActualColumnNames" value="true"/>
    50.         table>
    51.         <table tableName="GameType">
    52.             <property name="useActualColumnNames" value="true"/>
    53.         table>
    54.         <table tableName="Admins">
    55.             <property name="useActualColumnNames" value="true"/>
    56.         table>
    57.         <table tableName="AdminRole">
    58.             <property name="useActualColumnNames" value="true"/>
    59.         table>
    60.     context>
    61. generatorConfiguration>

    2.2运行插件

    注意只能运行一次,运行完毕显示BUILD SUCCESS即为成功。

     2.3 测试

    1. package com.lxy.test;
    2.  
    3. import com.lxy.mapper.TeamMapper;
    4. import com.lxy.pojo.Team;
    5. import org.junit.Test;
    6. import org.junit.runner.RunWith;
    7. import org.springframework.test.context.ContextConfiguration;
    8. import org.springframework.test.context.junit4.SpringJUnit4ClassRunner;
    9.  
    10. import javax.annotation.Resource;
    11.  
    12. @RunWith(SpringJUnit4ClassRunner.class)
    13. @ContextConfiguration(locations = {"classpath:spring.xml"})
    14. public class TestMapper {
    15.  
    16.     @Resource
    17.     private TeamMapper teamMapper;
    18.     @Test
    19.     public void test01(){
    20.         Team team = teamMapper.selectByPrimaryKey(1001);
    21.         System.out.println(team);
    22.     }
    23. }

    三、案例--使用多条件分页查询

    3.1 业务逻辑层

    编写一个QueryVO类，存储查询条件

    1. package com.lxy.vo;
    2.  
    3. import org.springframework.format.annotation.DateTimeFormat;
    4.  
    5. import java.util.Date;
    6.  
    7. public class QueryVO {
    8.     private String teamName;
    9.     private String chineseName;
    10.     private String coach;
    11.     //@DateTimeFormat(pattern = "yyyy-MM-dd")
    12.     private Date beginDate;
    13.     //@DateTimeFormat(pattern = "yyyy-MM-dd")
    14.     private Date endDate;
    15.     private Integer area;
    16.  
    17.     @Override
    18.     public String toString() {
    19.         return "QueryVO{" +
    20.                 "teamName='" + teamName + '\'' +
    21.                 ", chineseName='" + chineseName + '\'' +
    22.                 ", coach='" + coach + '\'' +
    23.                 ", beginDate=" + beginDate +
    24.                 ", endDate=" + endDate +
    25.                 ", area=" + area +
    26.                 '}';
    27.     }
    28.  
    29.     public String getTeamName() {
    30.         return teamName;
    31.     }
    32.  
    33.     public void setTeamName(String teamName) {
    34.         this.teamName = teamName;
    35.     }
    36.  
    37.     public String getChineseName() {
    38.         return chineseName;
    39.     }
    40.  
    41.     public void setChineseName(String chineseName) {
    42.         this.chineseName = chineseName;
    43.     }
    44.  
    45.     public String getCoach() {
    46.         return coach;
    47.     }
    48.  
    49.     public void setCoach(String coach) {
    50.         this.coach = coach;
    51.     }
    52.  
    53.     public Date getBeginDate() {
    54.         return beginDate;
    55.     }
    56.  
    57.     public void setBeginDate(Date beginDate) {
    58.         this.beginDate = beginDate;
    59.     }
    60.  
    61.     public Date getEndDate() {
    62.         return endDate;
    63.     }
    64.  
    65.     public void setEndDate(Date endDate) {
    66.         this.endDate = endDate;
    67.     }
    68.  
    69.     public Integer getArea() {
    70.         return area;
    71.     }
    72.  
    73.     public void setArea(Integer area) {
    74.         this.area = area;
    75.     }
    76. }

    编写service层代码，用来条件分页查询

    1. package com.lxy.service;
    2.  
    3. import com.github.pagehelper.PageHelper;
    4. import com.github.pagehelper.PageInfo;
    5. import com.lxy.mapper.TeamMapper;
    6. import com.lxy.pojo.Team;
    7. import com.lxy.pojo.TeamExample;
    8. import com.lxy.vo.QueryVO;
    9. import org.springframework.stereotype.Service;
    10.  
    11. import javax.annotation.Resource;
    12. import java.util.List;
    13.  
    14. @Service
    15. public class TeamService {
    16.     @Resource
    17.     private TeamMapper teamMapper;
    18.  
    19.     public PageInfo queryByPage(Integer pageNum, Integer pageSize, QueryVO vo){
    20.         TeamExample example = new TeamExample();
    21.         //创建条件的容器
    22.         TeamExample.Criteria criteria = example.createCriteria();
    23.         if (vo!=null){
    24.             if (vo.getTeamName()!=null&&!"".equals(vo.getTeamName().trim())){
    25.                 criteria.andTeamNameLike("%"+vo.getTeamName().trim()+"%");
    26.             }
    27.             if(vo.getChineseName()!=null && !"".equals(vo.getChineseName().trim()) ){
    28.                 criteria.andChineseNameLike("%"+vo.getChineseName().trim()+"%");
    29.             }
    30.             if(vo.getCoach()!=null && !"".equals(vo.getCoach().trim())){
    31.                 criteria.andCoachLike("%"+vo.getCoach().trim()+"%");
    32.             }
    33.             if(vo.getBeginDate()!=null){
    34.                 criteria.andCreateTimeGreaterThanOrEqualTo(vo.getBeginDate());
    35.             }
    36.             if(vo.getEndDate()!=null){
    37.                 criteria.andCreateTimeLessThanOrEqualTo(vo.getEndDate());
    38.             }
    39.             if(vo.getArea()!=null && vo.getArea()!=-1){
    40.                 criteria.andAreaEqualTo(vo.getArea());
    41.             }
    42.         }
    43.         //分页
    44.         PageHelper.startPage(pageNum,pageSize);
    45.         List list = teamMapper.selectByExample(example);
    46.         return new PageInfo<>(list);
    47.     }
    48. }

     编写测试类：

    1. package com.lxy.test;
    2.  
    3. import com.github.pagehelper.PageInfo;
    4. import com.lxy.mapper.TeamMapper;
    5. import com.lxy.pojo.Team;
    6. import com.lxy.service.TeamService;
    7. import org.junit.Test;
    8. import org.junit.runner.RunWith;
    9. import org.springframework.test.context.ContextConfiguration;
    10. import org.springframework.test.context.junit4.SpringJUnit4ClassRunner;
    11.  
    12. import javax.annotation.Resource;
    13.  
    14. @RunWith(SpringJUnit4ClassRunner.class)
    15. @ContextConfiguration(locations = {"classpath:spring.xml"})
    16. public class TestMapper {
    17.  
    18.     @Resource
    19.     private TeamMapper teamMapper;
    20.  
    21.     @Resource
    22.     private TeamService teamService;
    23.  
    24.     @Test
    25.     public void test02(){
    26.         PageInfo teamPageInfo = teamService.queryByPage(1, 5, null);
    27.         System.out.println(teamPageInfo);
    28.     }
    29.     @Test
    30.     public void test01(){
    31.         Team team = teamMapper.selectByPrimaryKey(1001);
    32.         System.out.println(team);
    33.     }
    34. }

    测试结果：

    3.2 控制器层

    3.2.1 返回值的初始写法 

    编写controller代码：

    1. package com.lxy.controller;
    2.  
    3. import com.github.pagehelper.PageInfo;
    4. import com.lxy.pojo.Team;
    5. import com.lxy.service.TeamService;
    6. import com.lxy.vo.QueryVO;
    7. import org.springframework.stereotype.Controller;
    8. import org.springframework.web.bind.annotation.RequestMapping;
    9. import org.springframework.web.bind.annotation.ResponseBody;
    10.  
    11. import javax.annotation.Resource;
    12.  
    13. @Controller
    14. @RequestMapping("team")
    15. @ResponseBody
    16. public class TeamController {
    17.  
    18.     @Resource
    19.     private TeamService teamService;
    20.  
    21.     @RequestMapping("list")
    22.     public PageInfo queryByPage(Integer pageNum, Integer pageSize, QueryVO vo){
    23.         if (pageNum==null || pageNum<=0){
    24.             pageNum=1;
    25.         }
    26.         if (pageSize==null || pageSize<=0){
    27.             pageSize=5;
    28.         }
    29.         PageInfo teamPageInfo = teamService.queryByPage(pageNum, pageSize, vo);
    30.         return teamPageInfo;
    31.     }
    32. }

    这样返回给前端是返回的json格式的，包括时间，如果我们要返回正常的时间，需要在Team实体类中的时间字段上添加

    @JsonFormat(pattern = "yyyy-MM-dd",timezone = "GMT+8")这样显示的时间正常。

    启动程序来测试一下：

    这样可以看到返回的json数据正常

    3.2.2 返回值的高级写法

    将返回值封装为ResultVO，既能返回一个pageInfo，还能返回一个对象，一个集合，以及一条消息。

    更改controller代码：

    1. package com.lxy.controller;
    2.  
    3. import com.github.pagehelper.PageInfo;
    4. import com.lxy.pojo.Team;
    5. import com.lxy.service.TeamService;
    6. import com.lxy.vo.QueryVO;
    7. import com.lxy.vo.ResultVO;
    8. import org.springframework.stereotype.Controller;
    9. import org.springframework.web.bind.annotation.RequestMapping;
    10. import org.springframework.web.bind.annotation.ResponseBody;
    11.  
    12. import javax.annotation.Resource;
    13.  
    14. @Controller
    15. @RequestMapping("team")
    16. @ResponseBody
    17. public class TeamController {
    18.  
    19.     @Resource
    20.     private TeamService teamService;
    21.  
    22.     @RequestMapping("list")
    23.     public ResultVO queryByPage(Integer pageNum, Integer pageSize, QueryVO vo){
    24.         if (pageNum==null || pageNum<=0){
    25.             pageNum=1;
    26.         }
    27.         if (pageSize==null || pageSize<=0){
    28.             pageSize=5;
    29.         }
    30.         PageInfo teamPageInfo = teamService.queryByPage(pageNum, pageSize, vo);
    31.         return new ResultVO<>(teamPageInfo);
    32.     }
    33. }

    启动程序测试：

    3.2.3 日期类型解决方案

    如果此时想访问localhost的主页面来获取数据，很抱歉目前还获取不到。

    因为如果通过主页面来获取条件，初始时时间数据为空，那么程序会想把空指转换为日期类型，所以我们必须要在QueryVO中日期属性上加上日期格式化的注解  如下--

    //如果实体类中的日期类型需要从页面获取数据,避免NULL转换为Date类型出现问题
//解决方案2:@InitBinder
//解决方案1:实体类的日期类型属性上添加注解

     方案一： 

     日期格式化：

    1. package com.lxy.vo;
    2.  
    3. import org.springframework.format.annotation.DateTimeFormat;
    4.  
    5. import java.util.Date;
    6.  
    7. public class QueryVO {
    8.     private String teamName;
    9.     private String chineseName;
    10.     private String coach;
    11.     @DateTimeFormat(pattern = "yyyy-MM-dd")
    12.     private Date beginDate;
    13.     @DateTimeFormat(pattern = "yyyy-MM-dd")
    14.     private Date endDate;
    15.     private Integer area;
    16.  
    17.     @Override
    18.     public String toString() {
    19.         return "QueryVO{" +
    20.                 "teamName='" + teamName + '\'' +
    21.                 ", chineseName='" + chineseName + '\'' +
    22.                 ", coach='" + coach + '\'' +
    23.                 ", beginDate=" + beginDate +
    24.                 ", endDate=" + endDate +
    25.                 ", area=" + area +
    26.                 '}';
    27.     }
    28.  
    29.     public String getTeamName() {
    30.         return teamName;
    31.     }
    32.  
    33.     public void setTeamName(String teamName) {
    34.         this.teamName = teamName;
    35.     }
    36.  
    37.     public String getChineseName() {
    38.         return chineseName;
    39.     }
    40.  
    41.     public void setChineseName(String chineseName) {
    42.         this.chineseName = chineseName;
    43.     }
    44.  
    45.     public String getCoach() {
    46.         return coach;
    47.     }
    48.  
    49.     public void setCoach(String coach) {
    50.         this.coach = coach;
    51.     }
    52.  
    53.     public Date getBeginDate() {
    54.         return beginDate;
    55.     }
    56.  
    57.     public void setBeginDate(Date beginDate) {
    58.         this.beginDate = beginDate;
    59.     }
    60.  
    61.     public Date getEndDate() {
    62.         return endDate;
    63.     }
    64.  
    65.     public void setEndDate(Date endDate) {
    66.         this.endDate = endDate;
    67.     }
    68.  
    69.     public Integer getArea() {
    70.         return area;
    71.     }
    72.  
    73.     public void setArea(Integer area) {
    74.         this.area = area;
    75.     }
    76. }

     这样就可以访问到主页面了:

     方案二：

     在controller中添加注解方法：

    1.     @InitBinder
    2.     protected void initDateFormatBinder(WebDataBinder binder){
    3.         SimpleDateFormat dateFormat = new SimpleDateFormat("yyyy-MM-dd");
    4.         binder.registerCustomEditor(Date.class,new CustomDateEditor(dateFormat,true));
    5.     }

    添加这个方法后，实体类中可不添加注解 

    四、添加操作 

    teamService添加代码：

    1. package com.lxy.service;
    2.  
    3. import com.github.pagehelper.PageHelper;
    4. import com.github.pagehelper.PageInfo;
    5. import com.lxy.mapper.TeamMapper;
    6. import com.lxy.pojo.Team;
    7. import com.lxy.pojo.TeamExample;
    8. import com.lxy.vo.QueryVO;
    9. import org.springframework.stereotype.Service;
    10. import org.springframework.transaction.annotation.Propagation;
    11. import org.springframework.transaction.annotation.Transactional;
    12.  
    13. import javax.annotation.Resource;
    14. import java.util.List;
    15.  
    16. @Service
    17. public class TeamService {
    18.     @Resource
    19.     private TeamMapper teamMapper;
    20.  
    21.     @Transactional(propagation = Propagation.REQUIRED,readOnly = true)
    22.     public PageInfo queryByPage(Integer pageNum, Integer pageSize, QueryVO vo){
    23.         TeamExample example = new TeamExample();
    24.         //创建条件的容器
    25.         TeamExample.Criteria criteria = example.createCriteria();
    26.         if (vo!=null){
    27.             if (vo.getTeamName()!=null&&!"".equals(vo.getTeamName().trim())){
    28.                 criteria.andTeamNameLike("%"+vo.getTeamName().trim()+"%");
    29.             }
    30.             if(vo.getChineseName()!=null && !"".equals(vo.getChineseName().trim()) ){
    31.                 criteria.andChineseNameLike("%"+vo.getChineseName().trim()+"%");
    32.             }
    33.             if(vo.getCoach()!=null && !"".equals(vo.getCoach().trim())){
    34.                 criteria.andCoachLike("%"+vo.getCoach().trim()+"%");
    35.             }
    36.             if(vo.getBeginDate()!=null){
    37.                 criteria.andCreateTimeGreaterThanOrEqualTo(vo.getBeginDate());
    38.             }
    39.             if(vo.getEndDate()!=null){
    40.                 criteria.andCreateTimeLessThanOrEqualTo(vo.getEndDate());
    41.             }
    42.             if(vo.getArea()!=null && vo.getArea()!=-1){
    43.                 criteria.andAreaEqualTo(vo.getArea());
    44.             }
    45.         }
    46.         //分页
    47.         PageHelper.startPage(pageNum,pageSize);
    48.         List list = teamMapper.selectByExample(example);
    49.         return new PageInfo<>(list);
    50.     }
    51.  
    52.     //添加操作，再添加一个事务用来回滚
    53.     @Transactional(propagation = Propagation.REQUIRED,rollbackFor = {Exception.class})
    54.     public int addTeam(Team team){
    55.         return teamMapper.insertSelective(team);
    56.     }
    57. }

    teamController添加代码：

    1. package com.lxy.controller;
    2.  
    3. import com.github.pagehelper.PageInfo;
    4. import com.lxy.pojo.Team;
    5. import com.lxy.service.TeamService;
    6. import com.lxy.vo.QueryVO;
    7. import com.lxy.vo.ResultVO;
    8. import org.springframework.stereotype.Controller;
    9. import org.springframework.web.bind.annotation.RequestMapping;
    10. import org.springframework.web.bind.annotation.RequestMethod;
    11. import org.springframework.web.bind.annotation.ResponseBody;
    12.  
    13. import javax.annotation.Resource;
    14.  
    15. @Controller
    16. @RequestMapping("team")
    17. @ResponseBody
    18. public class TeamController {
    19.  
    20.     @Resource
    21.     private TeamService teamService;
    22.  
    23.     @RequestMapping(value = "list",method = RequestMethod.GET)
    24.     public ResultVO queryByPage(Integer pageNum, Integer pageSize, QueryVO vo){
    25.         if(pageNum==null || pageNum<=0){
    26.             pageNum=1;
    27.         }
    28.         if(pageSize==null || pageSize<=0){
    29.             pageSize=5;
    30.         }
    31.         PageInfo teamPageInfo = teamService.queryByPage(pageNum, pageSize, vo);
    32.         return new ResultVO<>(teamPageInfo);
    33.     }
    34.  
    35.     //添加操作
    36.     @RequestMapping(value = "",method = RequestMethod.POST)
    37.     public ResultVO addTeam(Team team){
    38.         int i = teamService.addTeam(team);
    39.         if (i==1){
    40.             return new ResultVO<>();
    41.         }
    42.         return new ResultVO<>(500,"服务器内部异常，请稍后再试！");
    43.     }
    44. }

    五、更新操作

    5.1 更新步骤

    第一步：点击更新按钮时，首先应该根据此条数据的id来返回整条数据，让数据达到一种回显的效果

    第二步：等所有数据都修改之后，再次点击提交时才是真正的更新

    5.1.1 第一步：

    teamService添加代码：

    1.     /**
    2.      * 根据主键查询
    3.      * @param teamId
    4.      * @return
    5.      */
    6.     @Transactional(propagation = Propagation.REQUIRED,readOnly = true)
    7.     public Team queryById(Integer teamId){
    8.         return teamMapper.selectByPrimaryKey(teamId);
    9.     }

    teamController添加代码：

    1.     //根据主键查询
    2.     @RequestMapping(value = "{id}",method =RequestMethod.GET)
    3.     public ResultVO update(@PathVariable("id") Integer teamId){
    4.         Team team = teamService.queryById(teamId);
    5.         return new ResultVO<>(team);
    6.     }

    5.1.2 第二步：

     teamService添加代码：

    1.     /**
    2.      * 更新 根据主键更新
    3.      * @param team
    4.      * @return
    5.      */
    6.     @Transactional(propagation = Propagation.REQUIRED,rollbackFor = {Exception.class})
    7.     public int updateTeam(Team team){
    8.         return teamMapper.updateByPrimaryKeySelective(team);
    9.     }

    teamController添加代码：

    1.     @RequestMapping(value = "{id}",method = RequestMethod.PUT)
    2.     public ResultVO updateTeam(@PathVariable("id") Integer teamId,Team team){
    3.         team.setTeamId(teamId);
    4.         int i = teamService.updateTeam(team);
    5.         if(i==1){
    6.             return new ResultVO();
    7.         }
    8.         return new ResultVO<>(500,"服务器内部异常，请稍后再试！");
    9.     }

     六、删除操作

     此删除功能也应该为逻辑删除，即删除时不是数据直接消失，而是数据在显示状态但不能操作。

     teamService添加代码：

    1.     /**
    2.      * 根据主键删除 逻辑删除
    3.      * @param teamId
    4.      * @return
    5.      */
    6.     @Transactional(propagation = Propagation.REQUIRED,rollbackFor = {Exception.class})
    7.     public int deleteTeam(Integer teamId){
    8.         Team team = teamMapper.selectByPrimaryKey(teamId);
    9.         team.setIsDel(1);
    10.         return teamMapper.updateByPrimaryKeySelective(team);
    11.     }

    teamController添加代码：

    1.     @RequestMapping(value = "{id}",method = RequestMethod.DELETE)
    2.     public ResultVO delete(@PathVariable("id") Integer teamId){
    3.         int delete = teamService.deleteTeam(teamId);
    4.         if (delete==1){
    5.             return new ResultVO<>();
    6.         }
    7.         return new ResultVO<>(500,"服务器内部异常，请稍后再试！");
    8.     }

     七、文件上传

     teamController添加代码:

    1.     @RequestMapping(value = "{id}",method = RequestMethod.POST)
    2.     public ResultVO uploadLogo(@RequestParam("logo") MultipartFile myFile, HttpServletRequest request,
    3.                                      @PathVariable("id") Integer teamId){
    4.         //文件上传到指定位置
    5.         String path = request.getServletContext().getRealPath("/img/uploadFile");
    6.         //获取原始文件的名称
    7.         String originalFilename = myFile.getOriginalFilename();
    8.         //定义文件的新名称:随机名称+原有的后缀名
    9.         String randomName= UUID.randomUUID().toString().replace("-","");
    10.         int index = originalFilename.lastIndexOf(".");
    11.         String hz = originalFilename.substring(index);
    12.         String logoName=randomName+hz;
    13.         int num=0;
    14.         try {
    15.             myFile.transferTo(new File(path+"/"+logoName));
    16.             System.out.println("上传成功！"+path+"/"+logoName);
    17.             Team team = new Team();
    18.             team.setTeamId(teamId);
    19.             team.setTeamLogo(logoName);
    20.             num = teamService.updateTeam(team);
    21.             if(num==1){
    22.                 return new ResultVO();
    23.             }else {
    24.                 return new ResultVO<>(500,"服务器内部异常，请稍后再试！");
    25.             }
    26.  
    27.         } catch (IOException e) {
    28.             e.printStackTrace();
    29.             return new ResultVO<>(500,"图片上传出现问题！"+e.getMessage());
    30.         }
    31.     }

    至此SSM整合完毕，如果你想要此项目来练习一下，请给我一个三连并在下发评论，我会及时联系你给你发前端素材和后端源码，感谢观看！！！

  • 相关阅读:
    16、学习MySQL 正则表达式
    讲一讲VS Code配置GoLang语言开发环境
    Ubuntu下 FTP的搭建配置
    面试官：熟悉Redis？请讲讲Redis缓存穿透、缓存击穿、缓存雪崩有什么区别
    如何使用Python进行机器学习？
    算法书学习笔记
    mysql8.0版本的 utf8mb4 格式数据不能移植到 mysql1.0版本上
    基于ssm操作系统课程网站
    腾讯开源 tRPC：多语言、高性能 RPC 开发框架
    SQL Server事务及隔离级别
  • 原文地址：https://blog.csdn.net/m0_57209427/article/details/128036423