Idea创建Spring Boot项目创建（SpringBoot+Mybaties+jsp）

0.SpringBoot项目的一些基本配置

启动横幅

在resources下创建一个名为banner.txt的文件
在文件里面定义，比如

  __                      .__               
_/  |_  ____  __ _____  __|__|____    ____  
\   __\/  _ \|  |  \  \/  /  \__  \  /    \ 
 |  | (  <_> )  |  />    <|  |/ __ \|   |  \
 |__|  \____/|____//__/\_ \__(____  /___|  /
                         \/       \/     \/ 

即可

定义log

将一个ico图片拷贝到resources下重命名为favicon即可

1.创建springboot项目

导入依赖

在pom中导入如下依赖

 <dependency>
            <groupId>com.alibaba</groupId>
            <artifactId>druid-spring-boot-starter</artifactId>
            <version>1.1.10</version>
        </dependency>
        <dependency>
            <groupId>mysql</groupId>
            <artifactId>mysql-connector-java</artifactId>
            <scope>runtime</scope>
            <version>5.1.21</version>
        </dependency>

在application里面配置数据库基本信息

spring.datasource.username=root
spring.datasource.password=root
spring.datasource.url=jdbc:mysql://127.0.0.1:3306/apidemo?useUnicode=true&characterEncoding=UTF-8&serverTimezone=UTC
spring.datasource.type=com.alibaba.druid.pool.DruidDataSource

配置包扫描

直接在生成的application文件里更改

更改内容如下

@SpringBootApplication
@MapperScan(basePackages ="touxian_ssm.ssm.Service.**")
public class SsmApplication {

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

创建Mapper接口

创建数据库表

创建Book_type类

public class Book_type {

    private  Integer id;
    private  String typename;
    private Integer sort;
    private String remark;

    public Integer getId() {
        return id;
    }

    public void setId(Integer id) {
        this.id = id;
    }

    public String getTypename() {
        return typename;
    }

    public void setTypename(String typename) {
        this.typename = typename;
    }

    public Integer getSort() {
        return sort;
    }

    public void setSort(Integer sort) {
        this.sort = sort;
    }

    public String getRemark() {
        return remark;
    }

    public void setRemark(String remark) {
        this.remark = remark;
    }
}

package touxian_ssm.ssm.Service.Book;

import touxian_ssm.ssm.vo.Book_type;

import java.util.List;

/**
 * @author 偷闲
 * @date 2019/4/28 15:25
 */
public interface Book_typeMapper {

    List<Book_type> getalltype();
}

定义xml文件

在application.properties里面添加mybaties扫描添加如下

mybatis.mapper-locations=classpath*:/mybaties/*/*.xml

在resources下创建mybaties文件，并创建xml文件

2.整合jsp

导入依赖

因为springboot没有jsp依赖，所以需要自己导入,pom文件导入如下5个依赖

<dependency>
            <groupId>javax.servlet</groupId>
            <artifactId>javax.servlet-api</artifactId>
        </dependency>
        <dependency>
            <groupId>javax.servlet.jsp</groupId>
            <artifactId>javax.servlet.jsp-api</artifactId>
            <version>2.3.1</version>
        </dependency>
        <dependency>
            <groupId>org.springframework.boot</groupId>
            <artifactId>spring-boot-starter-tomcat</artifactId>
        </dependency>
        <dependency>
            <groupId>org.apache.tomcat.embed</groupId>
            <artifactId>tomcat-embed-jasper</artifactId>
        </dependency>
        <dependency>
            <groupId>jstl</groupId>
            <artifactId>jstl</artifactId>
            <version>1.2</version>
        </dependency>

设置webapp

在main下新建webapp/jsp文件夹

给项目指定jsp所在位置

配置jsp视图解析器

新建WebMvcConfig

使用ctrl+o重写父类中的方法
代码如下

@Configuration
public class WebMvcConfig implements WebMvcConfigurer {
    @Override
    public void configureViewResolvers(ViewResolverRegistry registry) {

        registry.jsp("/jsp/",".jsp");
    }

}

新建jsp与controller

Controller里面的代码是

@Controller
public class TypeController {
    @Autowired
    Book_typeMapper book_typeservice;
    @RequestMapping("type")
    public String hello(Model mod){
        List<Book_type> alltype= book_typeservice.getalltype();
        mod.addAttribute("alltype",alltype);
        return "type_list";
    }

}

jsp里面的代码是

<%@ page language="java" contentType="text/html; charset=UTF-8"
         pageEncoding="UTF-8"%>
<%@ taglib prefix="c" uri="http://java.sun.com/jsp/jstl/core"%>
<%@ taglib prefix="fmt" uri="http://java.sun.com/jsp/jstl/fmt"%>

<html>
<head>
    <title>Title</title>
</head>
<body>
<table style="margin-top:5px;">
    <thead>
    <tr>
        <th class="center">序号</th>
        <th class="center">名称</th>
        <th class="center">备注</th>
    </tr>
    </thead>
    <tbody>
    <!-- 开始循环 -->
    <c:forEach items="${alltype}" var="var" varStatus="vs">
        <tr>
            <td class='center' style="width: 30px;">${var.sort}</td>
            <td class='center'>${var.type_name}</td>
            <td class='center'>${var.remark}</td>
        </tr>
    </c:forEach>
    </tbody>
</table>


</body>
</html>

前台访问

http://localhost:8080/type