Spring+SpringMVC+MyBatis从零到完整项目搭建

浅浅的花香味﹌ 2023-10-08 18:12 16阅读 0赞

## SSM框架搭建流程 ##

> spring+springMVC+MyBatis

> 准备工具：
> 
> idea企业版本+Maven（阿里镜像+环境变量）+Tomcat（本机环境变量）

### 1. idea创建项目 ###

![\[外链图片转存失败,源站可能有防盗链机制,建议将图片保存下来直接上传(img-WzXxwh2i-1677051876703)(C:\\Users\\高\\AppData\\Roaming\\Typora\\typora-user-images\\image-20230221170340083.png)\]][img-WzXxwh2i-1677051876703_C_Users_AppData_Roaming_Typora_typora-user-images_image-20230221170340083.png]

![\[外链图片转存失败,源站可能有防盗链机制,建议将图片保存下来直接上传(img-IPYp2yRf-1677051876708)(笔记图片/image-20230221170427076.png)\]][img-IPYp2yRf-1677051876708_image-20230221170427076.png]

### 2.检查IDEA-Maven配置 ###

![\[外链图片转存失败,源站可能有防盗链机制,建议将图片保存下来直接上传(img-2AKMAfTq-1677051876711)(笔记图片/image-20230221170549218.png)\]][img-2AKMAfTq-1677051876711_image-20230221170549218.png]

### 3. 删除生成的Servlet案例类，改写index.jsp ###

> index.jsp 清空body内容

### 4. 引入依赖Spring+SpringMVC+MyBatis+MySQL+JSON ###

> pom.xml添加依赖

> properties配置内容

<properties>
            <spring-version>5.2.3.RELEASE</spring-version>
            <aspectj-version>1.8.9</aspectj-version>
            <junit-version>4.11</junit-version>
        </properties>

#### 1.Spring的依赖 ####

<dependency>
                <groupId>org.springframework</groupId>
                <artifactId>spring-context</artifactId>
                <version>${spring-version}</version>
            </dependency>

#### 2.SpringMVC依赖 ####

<dependency>
                <groupId>org.springframework</groupId>
                <artifactId>spring-web</artifactId>
                <version>${spring-version}</version>
            </dependency>
            <dependency>
                <groupId>org.springframework</groupId>
                <artifactId>spring-webmvc</artifactId>
                <version>${spring-version}</version>
            </dependency>
            <dependency>
                <groupId>org.springframework</groupId>
                <artifactId>spring-test</artifactId>
                <version>${spring-version}</version>
            </dependency>
            <dependency>
                <groupId>org.springframework</groupId>
                <artifactId>spring-jdbc</artifactId>
                <version>${spring-version}</version>
            </dependency>

#### 3. 代理包 aspectj ####

<dependency>
          <groupId>org.aspectj</groupId>
          <artifactId>aspectjweaver</artifactId>
          <version></version>
        </dependency>

#### 4. junit测试包 ####

<dependency>
          <groupId>junit</groupId>
          <artifactId>junit</artifactId>
          <version>4.11</version>
          <scope>test</scope>
        </dependency>

#### 5.servlet-api相关包 ####

<dependency>
          <groupId>javax.servlet</groupId>
          <artifactId>javax.servlet-api</artifactId>
          <version>3.1.0</version>
        </dependency>
        <dependency>
          <groupId>javax.servlet.jsp</groupId>
          <artifactId>jsp-api</artifactId>
          <version>2.2</version>
        </dependency>
        <dependency>
          <groupId>javax.servlet</groupId>
          <artifactId>jstl</artifactId>
          <version>1.2</version>
        </dependency>

#### 6.Mysql-j包 ####

<dependency>
          <groupId>mysql</groupId>
          <artifactId>mysql-connector-java</artifactId>
          <version>8.0.22</version>
        </dependency>

#### 7. json以及@Responsebody包（jackson） ####

<dependency>
          <groupId>com.fasterxml.jackson.core</groupId>
          <artifactId>jackson-core</artifactId>
          <version>2.12.3</version>
        </dependency>
        <dependency>
          <groupId>com.fasterxml.jackson.core</groupId>
          <artifactId>jackson-databind</artifactId>
          <version>2.12.3</version>
        </dependency>
    
    
        <dependency>
          <groupId>com.alibaba</groupId>
          <artifactId>fastjson</artifactId>
          <version>1.2.78</version>
        </dependency>

#### 8.文件上传和下载 ####

<dependency>
          <groupId>org.apache.commons</groupId>
          <artifactId>commons-lang3</artifactId>
          <version>3.4</version>
        </dependency>
        <dependency>
          <groupId>commons-io</groupId>
          <artifactId>commons-io</artifactId>
          <version>2.4</version>
        </dependency>
    
        <dependency>
          <groupId>commons-fileupload</groupId>
          <artifactId>commons-fileupload</artifactId>
          <version>1.3.1</version>
        </dependency>

#### 9.lombok包 ####

<dependency>
          <groupId>org.projectlombok</groupId>
          <artifactId>lombok</artifactId>
          <version>1.18.22</version>
          <scope>provided</scope>
        </dependency>

#### 10.Mybatis包 ####

<dependency>
          <groupId>org.mybatis</groupId>
          <artifactId>mybatis</artifactId>
          <version>3.5.7</version>
        </dependency>
    
    
        <dependency>
          <groupId>org.mybatis</groupId>
          <artifactId>mybatis-spring</artifactId>
          <version>1.3.0</version>
        </dependency>

#### 11.阿里druid连接池 ####

<dependency>
          <groupId>com.alibaba</groupId>
          <artifactId>druid</artifactId>
          <version>1.2.8</version>
          <scope>compile</scope>
        </dependency>

#### 12. 数据校验包（校验属性必填、邮箱验证） ####

<dependency>
          <groupId>javax.validation</groupId>
          <artifactId>validation-api</artifactId>
          <version>1.1.0.Final</version>
        </dependency>
        <dependency>
          <groupId>org.jboss.logging</groupId>
          <artifactId>jboss-logging</artifactId>
          <version>3.1.0.CR2</version>
        </dependency>
        <dependency>
          <groupId>org.hibernate</groupId>
          <artifactId>hibernate-validator</artifactId>
          <version>5.1.0.Final</version>
        </dependency>

#### 13. 验证码 ####

<dependency>
                <groupId>com.github.whvcse</groupId>
                <artifactId>easy-captcha</artifactId>
                <version>1.6.2</version>
            </dependency>

#### 14.日志包 ####

<dependency>
          <groupId>org.slf4j</groupId>
          <artifactId>slf4j-log4j12</artifactId>
          <version>1.7.21</version>
        </dependency>
    
    <dependency>
          <groupId>log4j</groupId>
          <artifactId>log4j</artifactId>
          <version>1.2.17</version>
        </dependency>
    
        <dependency>
          <groupId>commons-logging</groupId>
          <artifactId>commons-logging</artifactId>
          <version>1.2</version>
        </dependency>

#### 15.mybatis分页-pagerHepler ####

<dependency>
          <groupId>com.github.pagehelper</groupId>
          <artifactId>pagehelper</artifactId>
          <version>4.2.1</version>
        </dependency>

#### 16. API文档生成器-Swagger ####

<dependency>
          <groupId>io.springfox</groupId>
          <artifactId>springfox-swagger2</artifactId>
          <version>2.6.1</version>
        </dependency>
        <dependency>
          <groupId>io.springfox</groupId>
          <artifactId>springfox-swagger-ui</artifactId>
          <version>2.6.1</version>
        </dependency>

### 5. 修改一下tomcat配置 ###

![\[外链图片转存失败,源站可能有防盗链机制,建议将图片保存下来直接上传(img-vdIuw2Vx-1677051876713)(笔记图片/image-20230221172439522.png)\]\[外链图片转存失败,源站可能有防盗链机制,建议将图片保存下来直接上传(img-v9QuKWyM-1677051876714)(笔记图片/image-20230221172451271.png)\]][img-vdIuw2Vx-1677051876713_image-20230221172439522.png_img-v9QuKWyM-1677051876714_image-20230221172451271.png]  
![在这里插入图片描述][2613154e3b204ef5ae4aadefcd2173e6.png]

### 6.创建各种配置文件 ###

#### 1.spring配置文件（包含了mvc功能） ####

![\[外链图片转存失败,源站可能有防盗链机制,建议将图片保存下来直接上传(img-ecUBz4bw-1677051876715)(笔记图片/image-20230221172553053.png)\]][img-ecUBz4bw-1677051876715_image-20230221172553053.png]

> spring配置文件默认内容,文件名spring.xml

<?xml version="1.0" encoding="UTF-8"?>
    <beans xmlns="http://www.springframework.org/schema/beans"
           xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:p="http://www.springframework.org/schema/p"
           xmlns:context="http://www.springframework.org/schema/context"
           xmlns:mvc="http://www.springframework.org/schema/mvc"
           xsi:schemaLocation="http://www.springframework.org/schema/beans
                            http://www.springframework.org/schema/beans/spring-beans-3.1.xsd
                            http://www.springframework.org/schema/context
                            http://www.springframework.org/schema/context/spring-context-3.1.xsd
                            http://www.springframework.org/schema/mvc
                            http://www.springframework.org/schema/mvc/spring-mvc-4.0.xsd">
    
        
    
    </beans>

#### 2.创建mybatis配置文件 ####

> 文件名：Mybatis.xml

#### 3.数据库连接配置文件 ####

> 名字：database.properties

url= jdbc:mysql://localhost:3306/javatest?useUnicode=true&characterEncoding=utf-8&useSSL=false&serverTimezone=Asia/Shanghai
    username=root
    password=cxk666
    driver=com.mysql.cj.jdbc.Driver

### 7.修改web配置文件-web.xml ###

> 设置项目名和加载mybatis配置文件

<display-name>ssm</display-name>
    
        
        <context-param>
            
            <param-name>contextConfigLocation</param-name>
            <param-value>classpath:mybatis.xml</param-value>
        </context-param>
    
    
        <listener>
            <listener-class>org.springframework.web.context.ContextLoaderListener</listener-class>
        </listener>

> 添加springMVC-前端控制器配置

<servlet>
            <servlet-name>dispatcherServlet</servlet-name>
            <servlet-class>org.springframework.web.servlet.DispatcherServlet</servlet-class>
            
            <init-param>
                <param-name>contextConfigLocation</param-name>
                <param-value>classpath:spring.xml</param-value>
            </init-param>
            
            
            <load-on-startup>1</load-on-startup>
        </servlet>
        <servlet-mapping>
            <servlet-name>dispatcherServlet</servlet-name>
            <url-pattern>/</url-pattern>
        </servlet-mapping>

> 字符编码集过滤器

<filter>
            <filter-name>characterEncodingFilter</filter-name>
            <filter-class>org.springframework.web.filter.CharacterEncodingFilter</filter-class>
            
            <init-param>
                <param-name>encoding</param-name>
                <param-value>UTF-8</param-value>
            </init-param>
            
            <init-param>
                <param-name>forceEncoding</param-name>
                <param-value>true</param-value>
            </init-param>
        </filter>
        <filter-mapping>
            <filter-name>characterEncodingFilter</filter-name>
            <url-pattern>/*</url-pattern>
        </filter-mapping>

> 实现RestFul规范的过滤器

<filter>
            <filter-name>hiddenHttpMethodFilter</filter-name>
            <filter-class>org.springframework.web.filter.HiddenHttpMethodFilter</filter-class>
        </filter>
        <filter-mapping>
            <filter-name>hiddenHttpMethodFilter</filter-name>
            <url-pattern>/*</url-pattern>
        </filter-mapping>

### 8.定义项目的包结构路径 ###

> 根包节点定义

![\[外链图片转存失败,源站可能有防盗链机制,建议将图片保存下来直接上传(img-ONwz6pxJ-1677051876716)(笔记图片/image-20230222095840728.png)\]][img-ONwz6pxJ-1677051876716_image-20230222095840728.png]

> 每个业务子节点定义方法

![\[外链图片转存失败,源站可能有防盗链机制,建议将图片保存下来直接上传(img-P6Oau33V-1677051876717)(笔记图片/image-20230222100352571.png)\]][img-P6Oau33V-1677051876717_image-20230222100352571.png]

> 框架核心包结构

![\[外链图片转存失败,源站可能有防盗链机制,建议将图片保存下来直接上传(img-2QLQ2JLa-1677051876718)(笔记图片/image-20230222100617857.png)\]][img-2QLQ2JLa-1677051876718_image-20230222100617857.png]

> webapp目录更改

![\[外链图片转存失败,源站可能有防盗链机制,建议将图片保存下来直接上传(img-LkYndpdC-1677051876718)(笔记图片/image-20230222100931378.png)\]][img-LkYndpdC-1677051876718_image-20230222100931378.png]

### 9.配置Maven的打包 ###

> 源代码目录静态文件要参与打包（如：mybatis映射xml文件）、以及static目录加入打包、resources目录加入打包

> 在pom.xml文件末尾（dependencies标签同级、之后，project标签之中）

<build>
            
            <resources>
                
                <resource>
                    <directory>src/main/resources</directory>
                    <includes>
                        <include>**/*.properties</include>
                        <include>**/*.xml</include>
                        <include>**/*.js</include>
                        <include>**/*.css</include>
                        <include>**/*.html</include>
                    </includes>
                    <filtering>false</filtering>
                </resource>
                
                <resource>
                    <directory>src/main/java</directory>
                    <includes>
                        <include>**/*.properties</include>
                        <include>**/*.xml</include>
                        <include>**/*.js</include>
                        <include>**/*.css</include>
                        <include>**/*.html</include>
                    </includes>
                    <filtering>false</filtering>
                </resource>
            </resources>
            
            <plugins>
                <plugin>
                    <groupId>org.apache.maven.plugins</groupId>
                    <artifactId>maven-war-plugin</artifactId>
                    <version>3.3.2</version>
                </plugin>
            </plugins>
        </build>

### 10.编写SpringMVC配置文件 ###

> 视图解析器

<bean class="org.springframework.web.servlet.view.InternalResourceViewResolver">
            <property name="prefix" value="/WEB-INF/views/"/>
            <property name="suffix" value=".jsp" />
        </bean>

> 自动包扫描注解

<context:component-scan base-package="com.huawei.ssmdemo2023" />

> 数据校验相关注解、依赖注入

<mvc:annotation-driven />

> 文件上传下载配置

<bean id="multipartResolver" class="org.springframework.web.multipart.commons.CommonsMultipartResolver">
            <property name="maxUploadSize" value="5000000000" />
            <property name="defaultEncoding" value="UTF-8" />
        </bean>

> 配置静态资源访问映射

<mvc:resources location="/static/" mapping="/static/**" />

### 11.编写mybatis配置 ###

#### 1. 改写database.properties文件 ####

url= jdbc:mysql://localhost:3306/javatest?useUnicode=true&characterEncoding=utf-8&useSSL=false&serverTimezone=Asia/Shanghai
    username=root
    password=cxk666
    driver=com.mysql.cj.jdbc.Driver
    #定义初始连接数  
    initialSize=2
    #定义最大连接数  
    maxActive=30
    #定义最小空闲  
    minIdle=1
    #定义最长等待时间  
    maxWait=60000

#### 2. 在mybatis配置文件中加载database配置文件项目 ####

<bean class="org.springframework.beans.factory.config.PropertyPlaceholderConfigurer">
            <property name="location" value="classpath:database.properties" />
        </bean>

#### 3. 在mybatis配置文件下配置阿里druid连接池 ####

<bean id="dataSource" class="com.alibaba.druid.pool.DruidDataSource"
            init-method="init" destroy-method="close">
            
            <property name="driverClassName" value="${driver}" />
            <property name="url" value="${url}" />
            <property name="username" value="${username}" />
            <property name="password" value="${password}" />
            
            <property name="initialSize" value="${initialSize}" />
            <property name="minIdle" value="${minIdle}" />
            <property name="maxActive" value="${maxActive}" />
            
            <property name="maxWait" value="${maxWait}" />
    
            
            <property name="timeBetweenEvictionRunsMillis" value="60000" />
    
            
            <property name="minEvictableIdleTimeMillis" value="300000" />
            
            <property name="testWhileIdle" value="true" />
    
            
            <property name="testOnBorrow" value="true" />
            <property name="testOnReturn" value="false" />
    
            
            <property name="poolPreparedStatements" value="true" />
            <property name="maxPoolPreparedStatementPerConnectionSize" value="50" />
    
            
            <property name="defaultAutoCommit" value="true" />
    
            
            <property name="validationQuery" value="select 1 from dual" />
            <property name="filters" value="wall,stat" />
            <property name="proxyFilters">
                <list>
                    <ref bean="logFilter" />
                    <ref bean="stat-filter" />
                </list>
            </property>
        </bean>
    
        
        <bean id="stat-filter" class="com.alibaba.druid.filter.stat.StatFilter">
            
            <property name="slowSqlMillis" value="50"/>
            <property name="logSlowSql" value="true"/>
        </bean>
        
        <bean id="logFilter" class="com.alibaba.druid.filter.logging.Slf4jLogFilter">
            <property name="dataSourceLogEnabled" value="true" />
            <property name="statementExecutableSqlLogEnable" value="true" />
        </bean>

#### 4.在web.xml文件中配置druid连接池数据监控中心 ####

<servlet>
            <servlet-name>DruidStatView</servlet-name>
            <servlet-class>com.alibaba.druid.support.http.StatViewServlet</servlet-class>
        </servlet>
        <servlet-mapping>
            <servlet-name>DruidStatView</servlet-name>
            
            <url-pattern>/druid/*</url-pattern>
        </servlet-mapping>

#### 5.Mybatis配置-实例SQLSessionFactory工厂类 ####

<bean id="sqlSessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean">
            
            <property name="dataSource" ref="dataSource" />
            
            <property name="typeAliasesPackage" value="com.huawei.ssmdemo2023" />
            
            <property name="mapperLocations" value="classpath:com/huawei/ssmdemo2023/mybatis/dao/**/*.xml"></property>
        </bean>

#### 6.Mybatis配置-SQLSession类 ####

<bean class="org.mybatis.spring.mapper.MapperScannerConfigurer">
            
            <property name="basePackage" value="com.huawei.ssmdemo2023.mybatis.dao" />
            
            <property name="sqlSessionFactoryBeanName" value="sqlSessionFactory" />
        </bean>

### 11.MyBatis集成Pagehepler分页工具 ###

#### 1. 引入分页工具依赖 ####

<dependency>
          <groupId>com.github.pagehelper</groupId>
          <artifactId>pagehelper</artifactId>
          <version>4.2.1</version>
        </dependency>

#### 2.在mybatis配置文件中配置分页拦截器 ####

<bean id="pageInterceptor" class="com.github.pagehelper.PageHelper">
            <property name="properties">
                <props>
                    <prop key="helperDialect">mysql</prop>
                    <prop key="reasonable">true</prop>
                    <prop key="supportMethodsArguments">true</prop>
                    <prop key="params">count=countSql</prop>
                </props>
            </property>
        </bean>

#### 3.在SQLSessionFactory配置中添加分页工具配置项目 ####

### 12. 开启@Mapper进行配置 ###

> mybatis配置文件中编写

<context:component-scan base-package="com.huawei.ssmdemo2023.mybatis.dao">
            <context:exclude-filter type="annotation"
                                    expression="org.springframework.stereotype.Controller" />
            <context:exclude-filter type="annotation"
                                    expression="org.springframework.stereotype.Service" />
        </context:component-scan>

### 13.开启日志记录 ###

#### 1.在resources目录下创建一个log4j.properties ####

######################## ????DEBUG????????consoleh?file?????, console?file?????????
    log4j.rootLogger=DEBUG,console,file
    log4j.appender.syslog.encoding=UTF-8
    ########################??????????
    log4j.appender.console = org.apache.log4j.ConsoleAppender
    #??????
    log4j.appender.console.Target = System.out
    #?DEBUG????
    log4j.appender.console.Threshold = DEBUG
    log4j.appender.console.layout = org.apache.log4j.PatternLayout
    #????
    log4j.appender.console.layout.ConversionPattern=[%c]-%m%n
    
    # mybatis日志集成
    log4j.logger.org.mybatis=DEBUG
    log4j.logger.java.sql=DEBUG
    log4j.logger.java.sql.Statement=DEBUG
    log4j.logger.java.sql.ResultSet=DEBUG
    log4j.logger.java.sql.PreparedStatement=DEBUG

## 2. 完整业务流程开发案例 ##

### 1. 案例1-查询一个学生的信息通过学生id ###

> 控制器层

/**
     * 模块名称： 学生信息管理-控制器
     * 模块类型：C-控制器
     * 编码人：高靖博
     * 创建时间：2023/2/22
     * 联系电话：18587388612
     */
    @Controller
    @RequestMapping("/student")
    @Slf4j //提供一个日志log对象注入到当前类
    public class StudentController {
        
    
        // 注入业务层实例
        @Resource(name = "studentServiceImpl")
        private StudentService studentService;
    
        @RequestMapping(value = "/getStudentByID",method = RequestMethod.GET)
        @ResponseBody
        public MyResult getStudentByID(String id){
        
            log.debug("学生信息管理:获取学生信息通过学生id [param:id"+id+"]");
    
            MyResult result = new MyResult();
    
            //调用业务层
            StudentDO studentDO = studentService.getStudentByID(id);
    
            if(studentDO==null){
        
                result.setCode(500);
                result.setMsg("没有查询到任何学生数据！");
            }else{
        
                result.setMsg("学生信息查询成功！");
                result.setData(studentDO);
            }
    
            return result;
        }
    
    }

> 业务接口

public interface StudentService {
        
    
        StudentDO getStudentByID(String id);
    }

> 业务实现层

@Service
    public class StudentServiceImpl implements StudentService {
        
    
        // mybatis接口使用自动注入的方法实现实例注入！！！！！！！！！！！！
        @Autowired
        private StudentMapper studentMapper;
    
        public StudentDO getStudentByID(String id) {
        
    
            StudentDO studentByID = studentMapper.getStudentByID(id);
    
            return studentByID;
        }
    }

> mybatis-dao接口（接口名和xml文件名一致）

@Mapper
    public interface StudentMapper {
        
    
        StudentDO getStudentByID(String id);
    
    }

> mybatis-xml映射文件

<?xml version="1.0" encoding="UTF-8"?>
    <!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" "http://mybatis.org/dtd/mybatis-3-mapper.dtd">
    <mapper namespace="com.huawei.ssmdemo2023.mybatis.dao.student.StudentMapper">
    
        <select id="getStudentByID" resultType="com.huawei.ssmdemo2023.mybatis.domain.student.StudentDO">
            select * from student where id = #{id}
        </select>
    </mapper>

[img-WzXxwh2i-1677051876703_C_Users_AppData_Roaming_Typora_typora-user-images_image-20230221170340083.png]: https://img-blog.csdnimg.cn/90dfb7d7d85c434c952103bb0fdfdbee.png
[img-IPYp2yRf-1677051876708_image-20230221170427076.png]: https://img-blog.csdnimg.cn/a8a57de9dec54e22ba24589d34f74c66.png
[img-2AKMAfTq-1677051876711_image-20230221170549218.png]: https://img-blog.csdnimg.cn/2492a064439a48ceb602c62cb8fa916d.png
[img-vdIuw2Vx-1677051876713_image-20230221172439522.png_img-v9QuKWyM-1677051876714_image-20230221172451271.png]: https://img-blog.csdnimg.cn/2d21e8c12d654766aa57937dd58d3a11.png
[2613154e3b204ef5ae4aadefcd2173e6.png]: https://img-blog.csdnimg.cn/2613154e3b204ef5ae4aadefcd2173e6.png
[img-ecUBz4bw-1677051876715_image-20230221172553053.png]: https://img-blog.csdnimg.cn/a08a2333b05b4d90a71e54fabe1a7021.png
[img-ONwz6pxJ-1677051876716_image-20230222095840728.png]: https://img-blog.csdnimg.cn/d24880a395464b98ad5845413db65861.png
[img-P6Oau33V-1677051876717_image-20230222100352571.png]: https://img-blog.csdnimg.cn/39afbb95826242f8b3fd61f642a7c042.png
[img-2QLQ2JLa-1677051876718_image-20230222100617857.png]: https://img-blog.csdnimg.cn/bd1ca667f37c4b6ba4669d39d71d1c70.png
[img-LkYndpdC-1677051876718_image-20230222100931378.png]: https://img-blog.csdnimg.cn/e800f8f2296f4a64b0221a467727d986.png