2021-05-20

创建application.yml文件

spring:
  datasource:
    url: jdbc:mysql://127.0.0.1:3306/restaurant?serverTimezone=Asia/Shanghai&useSSL=false&characterEncoding=utf-8
    username: root
    password: ********
    driver-class-name: com.mysql.cj.jdbc.Driver

mybatis:
  configuration:
    map-underscore-to-camel-case: true
    log-impl: org.apache.ibatis.logging.stdout.StdOutImpl

创建一个新类，添加属性和getter,setter方法

package com.sdcet.entity;


import java.util.Date;

public class User {
    /**
     * 主键
     * bigint --> Long
     */
    private Long id;
    /**
     * 名字
     *VARCHER --> String
     */
    private String name;
    /**
     * 密码
     */
    private String password;
    /**
     * 性别
     */
    private String sex;
    /**
     * 手机号
     */
    private String phoneNum;
    /**
     * 创建时间
     * DATETIME --> java.util.Date
     */
    private Date createTime;
    /**
     * 修改时间
     */
    private Date updateTime;

    public Long getId() {
        return id;
    }

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

    public String getName() {
        return name;
    }

    public void setName(String name) {
        this.name = name;
    }

    public String getPassword() {
        return password;
    }

    public void setPassword(String password) {
        this.password = password;
    }

    public String getSex() {
        return sex;
    }

    public void setSex(String sex) {
        this.sex = sex;
    }

    public String getPhoneNum() {
        return phoneNum;
    }

    public void setPhoneNum(String phoneNum) {
        this.phoneNum = phoneNum;
    }

    public Date getCreateTime() {
        return createTime;
    }

    public void setCreateTime(Date createTime) {
        this.createTime = createTime;
    }

    public Date getUpdateTime() {
        return updateTime;
    }

    public void setUpdateTime(Date updateTime) {
        this.updateTime = updateTime;
    }
}

在UserMapper接口中添加

@Select("SELECT * FROM user WHERE id = #{id}")
User selectUserById(Long id);

@Select("SELECT * FROM user WHERE name = #{name}")
User selectUserByName(String name);
在UserController中添加
@RequestMapping("/user")
public User user(Long id){
    return userMapper.selectUserById(id);
}

@RequestMapping("/userName")
public User userName(String name){
    return userMapper.selectUserByName(name);
}

在浏览器中输入local host:8080/user(/userName)添加id/name值可以查看数据库中的数据