idea搭建springboot框架并实现查询

环境和开发工具介绍：

        jdk是1.8.3版本，

        maven是3.3.9版本，

        idea是2018.3版本，

        数据库是mysql 5.1.49版本

1  file > new > project

 2 点击next到下面界面，可以修改组路径，我的java环境是: 8，所以java version选择: 8，然后点击next进行下一步

 3 到选择依赖这个界面，如图选择依赖，然后点击next

 4 编辑项目名称和存放路径，点击finish即可生成springboot项目

 5 接着修改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.6.2</version>
        <relativePath/>
    </parent>
    <groupId>com.yrec</groupId>
    <artifactId>yuai</artifactId>
    <version>0.0.1-SNAPSHOT</version>
    <name>yuai</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-jdbc</artifactId>
        </dependency>
        <dependency>
            <groupId>org.springframework.boot</groupId>
            <artifactId>spring-boot-starter-web</artifactId>
        </dependency>

        <!-- mybatis-plus -->
        <dependency>
            <groupId>com.baomidou</groupId>
            <artifactId>mybatis-plus-boot-starter</artifactId>
            <version>3.2.0</version>
        </dependency>
        <dependency>
            <groupId>com.baomidou</groupId>
            <artifactId>mybatis-plus-generator</artifactId>
            <version>3.2.0</version>
        </dependency>
        <!-- freemarker -->
        <dependency>
            <groupId>org.freemarker</groupId>
            <artifactId>freemarker</artifactId>
            <version>2.3.28</version>
        </dependency>

        <dependency>
            <groupId>com.alibaba</groupId>
            <artifactId>fastjson</artifactId>
            <version>1.2.47</version>
        </dependency>
        <!-- mysql -->
        <dependency>
            <groupId>mysql</groupId>
            <artifactId>mysql-connector-java</artifactId>
            <scope>runtime</scope>
        </dependency>
        <!-- 阿里巴巴连接池 -->
        <dependency>
            <groupId>com.alibaba</groupId>
            <artifactId>druid-spring-boot-starter</artifactId>
            <version>1.2.4</version>
        </dependency>
        <!-- lombok -->
        <dependency>
            <groupId>org.projectlombok</groupId>
            <artifactId>lombok</artifactId>
            <version>1.16.10</version>
        </dependency>
    </dependencies>

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

</project>

5 修改配置文件的后缀名为yml，并添加spring配置

server:
  port: 8888
spring:
  application:
    name: xyaiflood-smx
  datasource:
    name: druidDataSource
    driver-class-name: com.mysql.cj.jdbc.Driver
    url: jdbc:mysql://127.0.0.1:3306/demo?serverTimezone=Asia/Shanghai&useUnicode=true&characterEncoding=utf-8&zeroDateTimeBehavior=convertToNull&useSSL=false
    username: root
    password: 123456
    type: com.alibaba.druid.pool.DruidDataSource
    druid:
      filters: stat,wall
      max-active: 100
      initial-size: 1
      max-wait: 60000
      min-idle: 1
      time-between-eviction-runs-millis: 60000
      min-evictable-idle-time-millis: 300000
      validation-query: select 'x'
      test-while-idle: true
      test-on-borrow: false
      test-on-return: false
      pool-prepared-statements: true
      max-open-prepared-statements: 50
      max-pool-prepared-statement-per-connection-size: 20

6 SysUserController

package com.yrec.yuai.controller;

import com.yrec.yuai.model.SysUser;
import com.yrec.yuai.service.SysUserService;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.web.bind.annotation.GetMapping;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.bind.annotation.RestController;

import java.util.List;

/**
 * @program: yuai
 * @description: 用户接口控制器
 * @author: Mr.Chenky
 * @create: 2021-12-22 11:11
 **/
@RestController
@RequestMapping("/sysuser")
public class SysUserController {

    @Autowired
    private SysUserService sysUserService;

    @GetMapping("/getuser")
    public List<SysUser> getUser(){
        return sysUserService.getUser();
    }
}

7 service

package com.yrec.yuai.service;

import com.yrec.yuai.model.SysUser;
import java.util.List;

/**
 * @program: demo
 * @description: 查询接口
 * @author: Mr.Chenky
 * @create: 2021-12-20 16:25
 **/
public interface SysUserService {

    List<SysUser> getUser();
}

8 实现类

package com.yrec.yuai.service.impl;

import com.yrec.yuai.mapper.SysUserMapper;
import com.yrec.yuai.model.SysUser;
import com.yrec.yuai.service.SysUserService;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;
import java.util.List;

/**
 * @program: demo
 * @description: 查询接口实现类
 * @author: Mr.Chenky
 * @create: 2021-12-20 16:57
 **/
@Service
public class SysUserServiceImpl implements SysUserService {

    @Autowired
    private SysUserMapper sysUserMapper;

    @Override
    public List<SysUser> getUser() {
        return sysUserMapper.getUser();
    }
}

9 数据接口

package com.yrec.yuai.mapper;

import com.yrec.yuai.model.SysUser;
import org.apache.ibatis.annotations.Mapper;

import java.util.List;

/**
 * @program: yuai
 * @description: 用户信息查询数据接口
 * @author: Mr.Chenky
 * @create: 2021-12-22 11:28
 **/
@Mapper
public interface SysUserMapper {

    List<SysUser> getUser();
}

10 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.yrec.yuai.mapper.SysUserMapper">
    <resultMap id="BaseResultMap" type="com.yrec.yuai.model.SysUser">
        <id column="ID" jdbcType="INTEGER" property="id"/>
        <result column="ACCOUNT" jdbcType="CHAR" property="account"/>
        <result column="PASSWORD" jdbcType="CHAR" property="password"/>
        <result column="USER_NAME" jdbcType="CHAR" property="userName"/>
        <result column="USER_AGE" jdbcType="INTEGER" property="userAge"/>
    </resultMap>
    <sql id="Base_Column_List">
        ID, ACCOUNT, PASSWORD, USER_NAME, USER_AGE
    </sql>

    <select id="getUser" resultMap="BaseResultMap">
        select * from sys_user
    </select>
</mapper>

11 实体类

package com.yrec.yuai.model;

import com.baomidou.mybatisplus.annotation.TableName;
import com.baomidou.mybatisplus.annotation.TableId;
import com.baomidou.mybatisplus.annotation.TableField;
import lombok.Data;

/**
 * @program: demo
 * @description: 用户表
 * @author: Mr.Chenky
 * @create: 2021-12-20 17:05
 **/
@Data
@TableName("sys_user")
public class SysUser {

    @TableId(value = "ID")
    private Integer id;

    @TableField(value = "ACCOUNT")
    private String account;

    @TableField(value = "PASSWORD")
    private String password;

    @TableField(value = "USER_NAME")
    private String userName;

    @TableField(value = "USER_AGE")
    private Integer userAge;
}

12 项目结构

 13 数据库表结构