配置文件版MyBatis操作

1.创建entities/Bill

package com.cc.mybatis.entities;

import java.util.Date;

/**
 * 帐单实体类
 * @Title: Provider
 * @Description: com.mengxuegu.springboot.entities
 * @Auther: www.mengxuegu.com
 * @Version: 1.0
 */
public class Bill {

    private Integer bid;
    // 账单编码
    private String billCode;
    // 商品名称
    private String billName;
    // 商品单位
    private String billCom;
    // 商品数量
    private Integer billNum;
    // 总金额
    private Double money;
    // 供应商
    private Provider provider;
    // 是否付款 0 未付款， 1已付款
    private Integer pay;
    // 创建时间
    private Date createDate;
    public Bill() {}

    public Bill(Integer bid, String billCode, String billName, String billCom, Integer billNum, Double money, Provider provider, Integer pay) {
        this.bid = bid;
        this.billCode = billCode;
        this.billName = billName;
        this.billCom = billCom;
        this.billNum = billNum;
        this.money = money;
        this.provider = provider;
        this.pay = pay;
        this.createDate = new Date();
    }

    @Override
    public String toString() {
        return "Bill{" +
                "bid=" + bid +
                ", billCode='" + billCode + '\'' +
                ", billName='" + billName + '\'' +
                ", billCom='" + billCom + '\'' +
                ", billNum=" + billNum +
                ", money=" + money +
                ", provider=" + provider +
                ", pay=" + pay +
                ", createDate=" + createDate +
                '}';
    }

    public Integer getBid() {
        return bid;
    }

    public void setBid(Integer bid) {
        this.bid = bid;
    }

    public String getBillCode() {
        return billCode;
    }

    public void setBillCode(String billCode) {
        this.billCode = billCode;
    }

    public String getBillName() {
        return billName;
    }

    public void setBillName(String billName) {
        this.billName = billName;
    }

    public String getBillCom() {
        return billCom;
    }

    public void setBillCom(String billCom) {
        this.billCom = billCom;
    }

    public Integer getBillNum() {
        return billNum;
    }

    public void setBillNum(Integer billNum) {
        this.billNum = billNum;
    }

    public Double getMoney() {
        return money;
    }

    public void setMoney(Double money) {
        this.money = money;
    }

    public Provider getProvider() {
        return provider;
    }

    public void setProvider(Provider provider) {
        this.provider = provider;
    }

    public Integer getPay() {
        return pay;
    }

    public void setPay(Integer pay) {
        this.pay = pay;
    }

    public Date getCreateDate() {
        return createDate;
    }

    public void setCreateDate(Date createDate) {
        this.createDate = createDate;
    }
}

创建mapper/BillMapper

package com.cc.springboot.mapper;

import com.cc.springboot.entities.Bill;

public interface BillMapper {
    Bill getBillById(Integer bid);

    int addBill(Bill bill);
}

知识点：1. 在mapper/BillMapper添加@mapper或运行文件中@MapperScan("com.cc.springboot.mapper")

              2. interface

2. 在resources中创建核心配置文件和mapper映射文件

BillMapper.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.cc.springboot.mapper.BillMapper">

    <select id="getBillById" resultType="com.cc.springboot.entities.Bill">
          select * from bill where bid=#{bid}
    </select>

    <insert id="addBill">
       insert into bill(bill_code, bill_name) values(#{billCode}, #{billName})
    </insert>
</mapper>

 知识点：id是mapper中的方法名   resultType是实体类的路径

               实体类路径的方式-》右键实体类-》Copy Reference

核心配置文件 mabatis-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>
     <!--核心配置文件-->
    <settings>
        <setting name="mapUnderscoreToCamelCase" value="true"/>
    </settings>
</configuration>

application.properties 进行配置

mybatis.con?g-location= classpath:mybatis/mybatis-con?g.xml
mybatis.mapper-locations= classpath:mybatis/mapper/*.xml

3.创建controller/billController文件

package com.cc.springboot.controller;

import com.cc.springboot.entities.Bill;
import com.cc.springboot.mapper.BillMapper;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.web.bind.annotation.GetMapping;
import org.springframework.web.bind.annotation.PathVariable;
import org.springframework.web.bind.annotation.RestController;

@RestController
public class BillController {
    @Autowired
    BillMapper billMapper;

    @GetMapping("/bill/{bid}")
    public Bill getBillByID(@PathVariable("bid") Integer bid){
        Bill bill = billMapper.getBillById(bid);
        return bill;
    }
    @GetMapping("/bill")
    public Bill addBill(Bill bill){
        billMapper.addBill(bill);
        return bill;
    }


}