springboot + mybatis环境搭建

第一: 先看目录结构

第二: 各个文件内容

com/springstudy/demo/controller/IndexController.java 内容如下:

package com.springstudy.demo.controller;

import com.springstudy.demo.entity.AppInfo;
import com.springstudy.demo.service.AppInfoService;
import org.springframework.stereotype.Controller;
import org.springframework.ui.Model;
import org.springframework.web.bind.annotation.RequestMapping;

import javax.annotation.Resource;
import java.util.List;

@Controller
@RequestMapping(value = "/index")
public class IndexController {
    @Resource
    private AppInfoService appInfoService;

    @RequestMapping(value = "/index")
    public String index() {
        return "index/index";
    }

    @RequestMapping(value = "/demo")
    public String demo(Model model) {
        model.addAttribute("currentValue", "测试...333666");
        try {
            List<AppInfo> appInfoList = appInfoService.getAllAppInfo();
            model.addAttribute("appInfoList", appInfoList);
        } catch (Exception e) {
            model.addAttribute("appInfoList", "无数据!!!");
            e.printStackTrace();
        }
        return "index/index";
    }
}

com/springstudy/demo/entity/AppInfo.java 代码如下:

package com.springstudy.demo.entity;

import java.io.Serializable;
import java.util.Date;

/**
 * 对应数据库的app_info表
 */
public class AppInfo implements Serializable {
    private String id;
    private String host_name;
    private String app_id;
    private Date create_time;
    private String app_name;
    private Double cpu_per;
    private Double mem_per;
    private String app_type;
    private String state;

    public AppInfo() {
    }

    public AppInfo(String id, String host_name, String app_id, Date create_time, String app_name, Double cpu_per, Double mem_per, String app_type, String state) {
        this.id = id;
        this.host_name = host_name;
        this.app_id = app_id;
        this.create_time = create_time;
        this.app_name = app_name;
        this.cpu_per = cpu_per;
        this.mem_per = mem_per;
        this.app_type = app_type;
        this.state = state;
    }

    public String getId() {
        return id;
    }

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

    public String getHost_name() {
        return host_name;
    }

    public void setHost_name(String host_name) {
        this.host_name = host_name;
    }

    public String getApp_id() {
        return app_id;
    }

    public void setApp_id(String app_id) {
        this.app_id = app_id;
    }

    public Date getCreate_time() {
        return create_time;
    }

    public void setCreate_time(Date create_time) {
        this.create_time = create_time;
    }

    public String getApp_name() {
        return app_name;
    }

    public void setApp_name(String app_name) {
        this.app_name = app_name;
    }

    public Double getCpu_per() {
        return cpu_per;
    }

    public void setCpu_per(Double cpu_per) {
        this.cpu_per = cpu_per;
    }

    public Double getMem_per() {
        return mem_per;
    }

    public void setMem_per(Double mem_per) {
        this.mem_per = mem_per;
    }

    public String getApp_type() {
        return app_type;
    }

    public void setApp_type(String app_type) {
        this.app_type = app_type;
    }

    public String getState() {
        return state;
    }

    public void setState(String state) {
        this.state = state;
    }
}

com/springstudy/demo/mapper/AppInfoMapper.java 内容如下:

package com.springstudy.demo.mapper;

import com.springstudy.demo.entity.AppInfo;
import org.springframework.stereotype.Repository;

import java.util.List;

/**
 * 操作数据库的方法
 */
@Repository
public interface AppInfoMapper {
    //查询所有数据
    public List<AppInfo> getAllAppInfo() throws Exception;
}

com/springstudy/demo/service/AppInfoService.java 的内容如下:

package com.springstudy.demo.service;

import com.springstudy.demo.entity.AppInfo;
import com.springstudy.demo.mapper.AppInfoMapper;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;

import java.util.List;

@Service
public class AppInfoService {
    @Autowired
    private AppInfoMapper appInfoMapper;

    public List<AppInfo> getAllAppInfo() throws Exception {
        return appInfoMapper.getAllAppInfo();
    }
}

启动文件 com/springstudy/demo/DemoApplication.java 内容如下:

package com.springstudy.demo;

import org.mybatis.spring.annotation.MapperScan;
import org.springframework.boot.SpringApplication;
import org.springframework.boot.autoconfigure.SpringBootApplication;

@SpringBootApplication
@MapperScan("com.springstudy.demo.mapper")
public class DemoApplication {

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

}

mybatis/mapper/AppInfoMapper.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.springstudy.demo.mapper.AppInfoMapper">

    <!--java Bean属性和数据表字段的映射-->
    <resultMap id="resultMap" type="com.springstudy.demo.entity.AppInfo">
        <id column="ID" property="id" jdbcType="CHAR" />
        <result column="HOST_NAME" property="host_name" jdbcType="CHAR" />
        <result column="APP_PID" property="app_pid" jdbcType="CHAR" />
        <result column="APP_TYPE" property="app_type" jdbcType="CHAR" />
        <result column="APP_NAME" property="app_name" jdbcType="CHAR" />
        <result column="CPU_PER" property="cpu_per" jdbcType="DOUBLE" />
        <result column="MEM_PER" property="mem_per" jdbcType="DOUBLE" />
        <result column="STATE" property="state" jdbcType="CHAR" />
        <result column="CREATE_TIME" property="create_time" jdbcType="TIMESTAMP" />
    </resultMap>

    <select id="getAllAppInfo" resultType="com.springstudy.demo.entity.AppInfo">
        select * from APP_INFO
    </select>

</mapper>

mybatis/mybatis-config.xml 内容如下:

<?xml version="1.0" encoding="UTF-8" ?>
<!DOCTYPE configuration PUBLIC "-//mybatis.org//DTD Config 3.0//EN" "http://mybatis.org/dtd/mybatis-3-config.dtd">
<configuration>

    <mappers>

    </mappers>


</configuration>

templates/index/index.html 内容如下:

<!DOCTYPE html>
<html lang="en" xmlns:th="http://www.thymeleaf.org">
<head>
    <meta charset="UTF-8">
    <title>Title</title>
</head>
<body>

<h3>首页</h3>
[[${currentValue}]]

[[${appInfoList}]]

</body>
</html>

application.properties 内容如下:

#应用名称
spring.application.name=springboot-study
#访问端口
server.port=8080
#数据库配置
spring.datasource.driver-class-name=com.mysql.jdbc.Driver
spring.datasource.url=jdbc:mysql://localhost:3306/test5
spring.datasource.username=root
spring.datasource.password=root
#关闭thymeleaf模板缓存
spring.thymeleaf.cache=false
#配置mybatis
mybatis.mapper-locations=classpath:mybatis/mapper/*.xml
mybatis.config-location=classpath:mybatis/mybatis-config.xml

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 https://maven.apache.org/xsd/maven-4.0.0.xsd">
    <modelVersion>4.0.0</modelVersion>
    <parent>
        <groupId>org.springframework.boot</groupId>
        <artifactId>spring-boot-starter-parent</artifactId>
        <version>2.5.5</version>
        <relativePath/> <!-- lookup parent from repository -->
    </parent>
    <groupId>com.springstudy</groupId>
    <artifactId>demo</artifactId>
    <version>0.0.1-SNAPSHOT</version>
    <name>demo</name>
    <description>Demo project for Spring Boot</description>
    <properties>
        <java.version>1.8</java.version>
    </properties>
    <dependencies>
        <dependency>
            <groupId>org.springframework.boot</groupId>
            <artifactId>spring-boot-starter-thymeleaf</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>2.2.0</version>
        </dependency>

        <dependency>
            <groupId>org.springframework.boot</groupId>
            <artifactId>spring-boot-starter-test</artifactId>
            <scope>test</scope>
        </dependency>

        <!--jdbc    start-->
        <dependency>
            <groupId>org.springframework.boot</groupId>
            <artifactId>spring-boot-starter-jdbc</artifactId>
            <version>2.5.5</version>
        </dependency>

        <dependency>
            <groupId>mysql</groupId>
            <artifactId>mysql-connector-java</artifactId>
            <version>5.1.46</version>
        </dependency>
        <!--jdbc    end-->

        <!--热部署 start-->
        <dependency>
            <groupId>org.springframework.boot</groupId>
            <artifactId>spring-boot-devtools</artifactId>
            <!-- 启用热部署 -->
            <optional>true</optional>
        </dependency>
        <!--热部署 end-->
        
    </dependencies>

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

</project>

浏览器访问,效果如图

 

采坑注意:

1. 注解千万不要忘记写, 如@Resource , @AutoWired, @Service, @Repository
2. 启动入口文件不要忘记写注解 @MapperScan("com.springstudy.demo.mapper")
3. mybatis/mapper/AppInfoMapper.xml文件中字段映射千万要细心
4. application.properties文件(不要忘记配置这两项)

   #配置mybatis
   mybatis.mapper-locations=classpath:mybatis/mapper/*.xml
   mybatis.config-location=classpath:mybatis/mybatis-config.xml 

5. pom.xml文件的这两项

   <!--jdbc    start-->
   <dependency>
       <groupId>org.springframework.boot</groupId>
       <artifactId>spring-boot-starter-jdbc</artifactId>
       <version>2.5.5</version>
   </dependency>
   
   <dependency>
       <groupId>mysql</groupId>
       <artifactId>mysql-connector-java</artifactId>
       <version>5.1.46</version>
   </dependency>
   <!--jdbc    end-->
   
   <!--idea热部署 start-->
   <dependency>
       <groupId>org.springframework.boot</groupId>
       <artifactId>spring-boot-devtools</artifactId>
       <!-- 启用热部署 -->
       <optional>true</optional>
   </dependency>
   <!--idea热部署 end-->