前言

一直以来都是用springmvc+mybatis进行后端接口开发工作，最近闲来无事，根据现有功能需求，用springboot+mybatis部署一套简单的web项目。

所用工具

IntelliJ IDEA 2018.1.4
JDK 1.8
apache-tomcat-8.0.50

所解决的问题

1、如何用idea创建springboot项目
2、如何进行 服务器、数据库、mybatis、视图解析器的配置
3、如何使用mybatis generator 自动生成代码
4、如何使用multipart进行文件上传
5、如何运用springboot的事务
6、如何打包进行tomcat部署

运用idea创建springboot项目

1、打开IDEA，File -> New -> Project，选择Spring Initializr，然后next。

image.png

2、修改Ariifact，下面的Name、package会自动修改；Packaging有两种模式，一种是Jar，一种是War；因为springboot中自带了tomcat，因此可以将项目打成jar，直接运行；而我现有项目是部署到tomcat上，因此我需要打成war包；然后next。

image.png

image.png

image.png

4、进入项目

image.png

pom.xml

<?xml version="1.0" encoding="UTF-8"?>
<project xmlns="http://maven.apache.org/POM/4.0.0" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
         xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 http://maven.apache.org/xsd/maven-4.0.0.xsd">
    <modelVersion>4.0.0</modelVersion>

    <groupId>com.example</groupId>
    <artifactId>springbootdemo</artifactId>
    <version>0.0.1-SNAPSHOT</version>
    <packaging>war</packaging>

    <name>springbootdemo</name>
    <description>Demo project for Spring Boot</description>

    <parent>
        <groupId>org.springframework.boot</groupId>
        <artifactId>spring-boot-starter-parent</artifactId>
        <version>2.0.2.RELEASE</version>
        <relativePath/> <!-- lookup parent from repository -->
    </parent>

    <properties>
        <project.build.sourceEncoding>UTF-8</project.build.sourceEncoding>
        <project.reporting.outputEncoding>UTF-8</project.reporting.outputEncoding>
        <java.version>1.8</java.version>
    </properties>

    <dependencies>
        <dependency>
            <groupId>org.springframework.boot</groupId>
            <artifactId>spring-boot-starter-jdbc</artifactId>
        </dependency>
        <dependency>
            <groupId>org.springframework.boot</groupId>
            <artifactId>spring-boot-starter-web</artifactId>
        </dependency>
        <dependency>
            <groupId>org.mybatis.spring.boot</groupId>
            <artifactId>mybatis-spring-boot-starter</artifactId>
            <version>1.3.2</version>
        </dependency>

        <dependency>
            <groupId>org.springframework.boot</groupId>
            <artifactId>spring-boot-devtools</artifactId>
            <scope>runtime</scope>
        </dependency>
        <dependency>
            <groupId>com.microsoft.sqlserver</groupId>
            <artifactId>mssql-jdbc</artifactId>
            <scope>runtime</scope>
        </dependency>
        <dependency>
            <groupId>org.springframework.boot</groupId>
            <artifactId>spring-boot-starter-tomcat</artifactId>
            <scope>provided</scope>
        </dependency>
        <dependency>
            <groupId>org.springframework.boot</groupId>
            <artifactId>spring-boot-starter-test</artifactId>
            <scope>test</scope>
        </dependency>
    </dependencies>

    <build>
        <plugins>
            <plugin>
                <groupId>org.springframework.boot</groupId>
                <artifactId>spring-boot-maven-plugin</artifactId>
            </plugin>
        </plugins>
    </build>
</project>

无配置文件的springmvc

通过两个例子：1、http请求访问并渲染页面 2、http请求返回json字符串
-配置数据源、视图渲染
-添加视图渲染pom依赖
-创建WelcomeController、welcome.jsp

新增之后的项目结构

image.png

application.yml 配置数据源 和 视图渲染

# 数据源、视图配置
spring:
  datasource:
      url: jdbc:sqlserver://xx:1433;DatabaseName=xx
      username: xx
      password: xx
      driver-class-name: com.microsoft.sqlserver.jdbc.SQLServerDriver
  mvc:
    view:
      prefix: /WEB-INF/views/
      suffix: .jsp

pom.xml新增视图渲染依赖

<!-- 使用 jsp 必要依赖 -->
        <dependency>
            <groupId>org.apache.tomcat.embed</groupId>
            <artifactId>tomcat-embed-jasper</artifactId>
            <scope>provided</scope>
        </dependency>
        <dependency>
            <groupId>javax.servlet</groupId>
            <artifactId>jstl</artifactId>
        </dependency>

创建WelcomeController

package com.example.springbootdemo.web;

import com.example.springbootdemo.entity.Welcome;
import com.example.springbootdemo.response.Response;
import com.example.springbootdemo.response.ResponseCode;
import org.springframework.stereotype.Controller;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.bind.annotation.ResponseBody;
import org.springframework.web.servlet.ModelAndView;
import java.util.ArrayList;
import java.util.List;

@Controller
@RequestMapping("/welcome")
public class WelcomeController {
    /**
     * 访问welcome.jsp页面
     * @return
     */
    @RequestMapping("welcomeIndex")
    public ModelAndView welcomeIndex(){
        ModelAndView mv = new ModelAndView();
        mv.setViewName("welcome");
        mv.addObject("name","xx");
        return mv;
    }

    /**
     * 返回json字符串
     * @return
     */
    @RequestMapping("getWelcomeInfo")
    @ResponseBody
    public Response getWelcomeInfo(){
        /**
         * 测试数据
         */
        List<Welcome> welcomes = new ArrayList<>();
        Welcome w1 = new Welcome();
        w1.setId("1");
        w1.setName("xx1");
        w1.setAge(11);
        w1.setGender("女");

        Welcome w2 = new Welcome();
        w2.setId("2");
        w2.setName("xx2");
        w2.setAge(22);
        w2.setGender("男");
        welcomes.add(w1);
        welcomes.add(w2);

        Response response = new Response();
        response.setData(welcomes);
        response.setRetcode(ResponseCode.SUCCESS);
        response.setRetdesc("Success");
        return response;
    }
}

创建welcome.jsp

<%@ page contentType="text/html;charset=UTF-8" language="java" %>
<html>
<head>
    <title>视图渲染</title>
</head>
<body>
    您好，${name}
</body>
</html>

启动项目，并访问
http://localhost:8080/welcome/getWelcomeInfo
http://localhost:8080/welcome/welcomeIndex

使用mybatis generator自动生成代码

用于为表创建 *Mapper.xml、model、dao文件

在pom.xml 添加mybatis generator 自动生成代码插件

<build>
        <plugins>
            <plugin>
                <groupId>org.springframework.boot</groupId>
                <artifactId>spring-boot-maven-plugin</artifactId>
            </plugin>
            <!-- mybatis generator 自动生成代码插件 -->
            <plugin>
                <groupId>org.mybatis.generator</groupId>
                <artifactId>mybatis-generator-maven-plugin</artifactId>
                <version>1.3.2</version>
                <configuration>
                    <configurationFile>${basedir}/src/main/resources/generator/generatorConfig.xml</configurationFile>
                    <overwrite>true</overwrite>
                    <verbose>true</verbose>
                </configuration>
            </plugin>
        </plugins>
    </build>

在上面pom.xml配置的pugin路径resources/generator 文件夹下添加generatorConfig.xml

<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE generatorConfiguration
        PUBLIC "-//mybatis.org//DTD MyBatis Generator Configuration 1.0//EN"
        "http://mybatis.org/dtd/mybatis-generator-config_1_0.dtd">
<generatorConfiguration>
    <!-- 数据库驱动:选择你的本地硬盘上面的数据库驱动包-->
    <classPathEntry  location="C:\Users\.m2\repository\com\microsoft\sqlserver\mssql-jdbc\6.2.2.jre8\mssql-jdbc-6.2.2.jre8.jar"/>
    <context id="DB2Tables"  targetRuntime="MyBatis3">
        <commentGenerator>
            <property name="suppressDate" value="true"/>
            <!-- 是否去除自动生成的注释 true：是 ： false:否 -->
            <property name="suppressAllComments" value="true"/>
        </commentGenerator>
        <!--数据库链接URL，用户名、密码 -->
        <jdbcConnection driverClass="com.microsoft.sqlserver.jdbc.SQLServerDriver" connectionURL="jdbc:sqlserver://xx:1433;DatabaseName=xx" userId="xx" password="xx">
        </jdbcConnection>
        <javaTypeResolver>
            <property name="forceBigDecimals" value="false"/>
        </javaTypeResolver>
        <!-- 生成模型的包名和位置-->
        <javaModelGenerator targetPackage="com.example.springbootdemo.entity" targetProject="src/main/java">
            <property name="enableSubPackages" value="true"/>
            <property name="trimStrings" value="true"/>
        </javaModelGenerator>
        <!-- 生成映射文件的包名和位置-->
        <sqlMapGenerator targetPackage="mybatis" targetProject="src/main/resources">
            <property name="enableSubPackages" value="true"/>
        </sqlMapGenerator>
        <!-- 生成DAO的包名和位置-->
        <javaClientGenerator type="XMLMAPPER" targetPackage="com.example.springbootdemo.mapper" targetProject="src/main/java">
            <property name="enableSubPackages" value="true"/>
        </javaClientGenerator>
        <!-- 要生成的表 tableName是数据库中的表名或视图名 domainObjectName是实体类名-->
        <table tableName="xx" domainObjectName="StudentBinding" enableCountByExample="false" enableUpdateByExample="false" enableDeleteByExample="false" enableSelectByExample="false" selectByExampleQueryId="false"></table>
    </context>
</generatorConfiguration>

使用maven中的mybatis-generator:generate根据数据库里面表生产相关的类
Edit Configurations -> 添加 -> Maven

image.png

image.png

image.png

image.png

image.png

配置mybatis

在application.yml 中添加mybatis的配置

# mybatis配置
mybatis:
  mapper-locations: classpath*:mybatis/*Mapper.xml
  type-aliases-package: com.example.springbootdemo.entity

在StudentBindingMapper.java中添加 @Repository("studentBindingMapper")注解才能使用@MapperScan扫描到

@Repository("studentBindingMapper")
public interface StudentBindingMapper {}

在SpringbootdemoApplication.java添加@MapperScan

package com.example.springbootdemo;
import org.mybatis.spring.annotation.MapperScan;
import org.springframework.boot.SpringApplication;
import org.springframework.boot.autoconfigure.SpringBootApplication;

@SpringBootApplication
@MapperScan("com.example.springbootdemo.mapper")
public class SpringbootdemoApplication {

    public static void main(String[] args) {
        SpringApplication.run(SpringbootdemoApplication.class, args);
    }
}

添加service、controller层

项目层级

image.png

添加StudentBindingService

package com.example.springbootdemo.service;
import com.example.springbootdemo.entity.StudentBinding;
import java.util.List;

public interface StudentBindingService {
    int deleteByPrimaryKey(Long id);
    int insert(StudentBinding record);
    int insertSelective(StudentBinding record);
    StudentBinding selectByPrimaryKey(Long id);
    int updateByPrimaryKeySelective(StudentBinding record);
    int updateByPrimaryKey(StudentBinding record);
    void validTransaction(Long id);
    List<StudentBinding> getStudentBindByQuery(StudentBinding record);
}

添加StudentBindingServiceImpl

package com.example.springbootdemo.service.impl;

import com.example.springbootdemo.entity.StudentBinding;
import com.example.springbootdemo.mapper.StudentBindingMapper;
import com.example.springbootdemo.service.StudentBindingService;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;
import org.springframework.transaction.annotation.Transactional;
import java.util.List;

@Service(value = "studentBindingService")
public class StudentBindingServiceImpl implements StudentBindingService {
    @Autowired
    private StudentBindingMapper studentBindingMapper;

    @Override
    public int deleteByPrimaryKey(Long id) {
        return studentBindingMapper.deleteByPrimaryKey(id);
    }

    @Override
    public int insert(StudentBinding record) {
        return studentBindingMapper.insert(record);
    }

    @Override
    public int insertSelective(StudentBinding record) {
        return studentBindingMapper.insertSelective(record);
    }

    @Override
    public StudentBinding selectByPrimaryKey(Long id) {
        return studentBindingMapper.selectByPrimaryKey(id);
    }

    @Override
    public int updateByPrimaryKeySelective(StudentBinding record) {
        return studentBindingMapper.updateByPrimaryKeySelective(record);
    }

    @Override
    public int updateByPrimaryKey(StudentBinding record) {
        return studentBindingMapper.updateByPrimaryKey(record);
    }

    @Override
    @Transactional
    public void validTransaction(Long id){
        // 删除之后，插入该id的数据
        studentBindingMapper.deleteByPrimaryKey(id);

        StudentBinding record = new StudentBinding();
        record.setId(id);
        studentBindingMapper.insertSelective(record);
    }

    @Override
    public List<StudentBinding> getStudentBindByQuery(StudentBinding record) {
        return studentBindingMapper.getStudentBindByQuery(record);
    }
}

新增StudentBindingController

package com.example.springbootdemo.web;

import com.example.springbootdemo.entity.StudentBinding;
import com.example.springbootdemo.response.Response;
import com.example.springbootdemo.response.ResponseCode;
import com.example.springbootdemo.service.StudentBindingService;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Controller;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.bind.annotation.RequestParam;
import org.springframework.web.bind.annotation.ResponseBody;
import org.springframework.web.multipart.MultipartFile;
import org.springframework.web.servlet.ModelAndView;
import java.io.File;
import java.io.IOException;
import java.util.List;

@Controller
@RequestMapping(value = "/studentBind")
public class StudentBindingController {
    @Autowired
    private StudentBindingService studentBindingService;

    /**
     * 根据请求参数，删除绑定学生信息
     * @param id
     * @return
     */
    @RequestMapping("deleteByPrimaryKey")
    @ResponseBody
    public Response deleteByPrimaryKey(Long id){
        Response response = new Response();
        if(id==null){
            response.setRetcode(ResponseCode.PARAMARTER_ERROR);
            response.setRetdesc("参数错误");
            return response;
        }

        try{
            studentBindingService.deleteByPrimaryKey(id);
            response.setRetcode(ResponseCode.SUCCESS);
            response.setRetdesc("删除成功");
        }catch (Exception e){
            e.printStackTrace();
            response.setRetcode(ResponseCode.FAILED);
            response.setRetdesc("删除异常");
        }
        return response;
    }

    /**
     * 根据请求参数，添加绑定学生信息
     * @param record
     * @return
     */
    @RequestMapping("insertSelective")
    @ResponseBody
    public Response insertSelective(StudentBinding record){
        Response response = new Response();
        if(record==null){
            response.setRetcode(ResponseCode.PARAMARTER_ERROR);
            response.setRetdesc("参数错误");
            return response;
        }

        try{
            studentBindingService.insertSelective(record);
            response.setRetcode(ResponseCode.SUCCESS);
            response.setRetdesc("添加成功");
        }catch (Exception e){
            e.printStackTrace();
            response.setRetcode(ResponseCode.FAILED);
            response.setRetdesc("添加异常");
        }
        return response;
    }

    /**
     * 根据请求参数，查询绑定学生信息
     * @param id
     * @return
     */
    @RequestMapping("selectByPrimaryKey")
    @ResponseBody
    public Response selectByPrimaryKey(Long id){
        Response response = new Response();
        if(id==null){
            response.setRetcode(ResponseCode.PARAMARTER_ERROR);
            response.setRetdesc("参数错误");
            return response;
        }

        try{
            StudentBinding studentBinding = studentBindingService.selectByPrimaryKey(id);
            response.setData(studentBinding);
            response.setRetcode(ResponseCode.SUCCESS);
            response.setRetdesc("查询成功");
        }catch (Exception e){
            e.printStackTrace();
            response.setRetcode(ResponseCode.FAILED);
            response.setRetdesc("查询异常");
        }
        return response;
    }

    /**
     * 验证@Transaction注解是否好用
     * @param id
     * @return
     */
    @RequestMapping("validTransaction")
    @ResponseBody
    public Response validTransaction(Long id){
        Response response = new Response();
        if(id==null){
            response.setRetcode(ResponseCode.PARAMARTER_ERROR);
            response.setRetdesc("参数错误");
            return response;
        }

        try{
            studentBindingService.validTransaction(id);
            response.setRetcode(ResponseCode.SUCCESS);
        }catch (Exception e){
            e.printStackTrace();
            response.setRetcode(ResponseCode.FAILED);
        }
        return response;
    }

    /**
     * 渲染jsp页面
     * @return
     */
    @RequestMapping("welcomeIndex")
    public ModelAndView welcomeIndex(){
        List<StudentBinding> studentBindings = studentBindingService.getStudentBindByQuery(new StudentBinding());
//        model.addAttribute("studentBindings",studentBindings);
        ModelAndView mv = new ModelAndView();
        mv.setViewName("welcome");
        mv.addObject("studentBindings",studentBindings);
        return mv;
    }

    /**
     * 跳转到上传文件页面
     * @return
     */
    @RequestMapping("multipartIndex")
    public String multipartIndex(){
        return "multipart-index";
    }

    /**
     * 上传文件到指定目录
     * @param file
     * @return
     */
    @RequestMapping("/upload")
    @ResponseBody
    public Response upload(@RequestParam("file") MultipartFile file){
        Response response = new Response();
        if (file.isEmpty()){
            response.setRetcode(ResponseCode.PARAMARTER_ERROR);
            response.setRetdesc("参数错误");
            return response;
        }

        try {
            String filePath = "D:\\ceshi\\upload\\";
            File dir = new File(filePath);
            if(!dir.isDirectory()){
                dir.mkdir();
            }

            String fileOriginalName = file.getOriginalFilename();
            File writeFile = new File(filePath + fileOriginalName);
            //文件写入磁盘
            file.transferTo(writeFile);

            response.setRetcode(ResponseCode.SUCCESS);
            response.setRetdesc("上传成功");
        } catch (IOException e) {
            e.printStackTrace();
            response.setRetcode(ResponseCode.FAILED);
            response.setRetdesc("上传失败");
        }

        return response;
    }
}

重启项目之后，就可以访问各个接口

springboot配置事务

springboot配置事务有两种方式
1、在SpringbootdemoApplication.java项目入口，添加@EnableTransactionManagement的注解用来开启事务
2、在service实现类上添加@Transactional注解，那么该类的所有方法都进行事务管理；也可以直接在service实现类的方法上直接添加@Transactional注解，那么只对该方法进行事务管理，上面代码中有对方法添加事务的例子

springboot打包进行tomcat部署

Edit Configuration -> Maven -> 添加 ->启动 -> 复制war包 -> tomcat webapp ->修改war包的名字 -> tomcat bin -> startup.bat

image.png

image.png

image.png

image.png

image.png

tomcat启动之后，访问http://localhost:8080/springbootdemo/welcome/welcomeIndex进行验证

image.png