springboot+mybatis 实现根据条件查询数据库 将结果集合循环遍历显示在页面上

1、model层  bean类

package com.example.demo.model;
public class Lamp {
    private int id;
    //支付账单的openid
    private String openid;
    //发起人
   private String sname;
   //祝福人
   private String gname;
   //灯的位置
    private String address;
    //点灯的时间如7天
    private int cycle;
    //灯的类型
    private String kinds;
    //祝福语
    private String content;
    //付费的金额
    private String money;
    //付费的时间
    private String time;

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

    public int getId() {
        return id;
    }

    public String getOpenid() {
        return openid;
    }

    public String getSname() {
        return sname;
    }

    public String getGname() {
        return gname;
    }

    public String getAddress() {
        return address;
    }

    public int getCycle() {
        return cycle;
    }

    public String getKinds() {
        return kinds;
    }

    public String getContent() {
        return content;
    }

    public String getMoney() {
        return money;
    }

    public String getTime() {
        return time;
    }

    public void setOpenid(String openid) {
        this.openid = openid;
    }

    public void setSname(String sname) {
        this.sname = sname;
    }

    public void setGname(String gname) {
        this.gname = gname;
    }

    public void setAddress(String address) {
        this.address = address;
    }

    public void setCycle(int cycle) {
        this.cycle = cycle;
    }

    public void setKinds(String kinds) {
        this.kinds = kinds;
    }

    public void setContent(String content) {
        this.content = content;
    }

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

    public void setTime(String time) {
        this.time = time;
    }
}

<