SSM小项目（会议管理系统）九 查看会议室（图解超详细）

这是上一篇博客的地址：https://blog.csdn.net/qq_41115379/article/details/114435537
这是下一篇博客的地址：https://blog.csdn.net/qq_41115379/article/details/114583673
查看会议室
先创建一个MeetingRoomController
而且通过查看leftMenu 会发现，他不是admin的操作
再对照数据库，创建meetingroom的实体类

package org.javaboy.meeting.model;

import org.apache.ibatis.annotations.Param;

public class MeetingRoom {
    private Integer roomid;
    private Integer roomnum;
    private String roomname;
    private Integer capacity;
    private Integer status;
    private String description;
    public Integer getRoomid() {
        return roomid;
    }

    public void setRoomid(Integer roomid) {
        this.roomid = roomid;
    }

    public Integer getRoomnum() {
        return roomnum;
    }

    public void setRoomnum(Integer roomnum) {
        this.roomnum = roomnum;
    }

    public String getRoomname() {
        return roomname;
    }

    public void setRoomname(String roomname) {
        this.roomname = roomname;
    }

    public Integer getCapacity() {
        return capacity;
    }

    public void setCapacity(Integer capacity) {
        this.capacity = capacity;
    }

    public Integer getStatus() {
        return status;
    }

    public void setStatus(Integer status) {
        this.status = status;
    }

    public String getDescription() {
        return description;
    }

    public void setDescription(String description) {
        this.description = description;
    }


}

然后依次创建MeetingRoomService，MeetingRoomMapper 和MeetingRoomMapper.xml
MeetingRoomController

package org.javaboy.meeting.controller;

import org.javaboy.meeting.service.MeetingRoomService;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Controller;
import org.springframework.ui.Model;
import org.springframework.web.bind.annotation.GetMapping;

@Controller
public class MeetingRoomController {
    @Autowired
    MeetingRoomService meetingRoomService;
    //不需要admin
    @GetMapping("/meetingrooms")
    public String meetingrooms(Model model){
        model.addAttribute("mrs",meetingRoomService.getAllMrs());
        return "meetingrooms";
    }
}

MeetingRoomService

package org.javaboy.meeting.service;

import org.javaboy.meeting.mapper.MeetingRoomMapper;
import org.javaboy.meeting.model.MeetingRoom;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;

import java.util.List;

@Service
public class MeetingRoomService {
    @Autowired
    MeetingRoomMapper meetingRoomMapper;
    public List<MeetingRoom> getAllMrs() {
       return meetingRoomMapper.getAllMrs();
    }
}

MeetingRoomMapper

package org.javaboy.meeting.mapper;

import org.javaboy.meeting.model.MeetingRoom;

import java.util.List;

public interface MeetingRoomMapper {
    List<MeetingRoom> getAllMrs();
}

MeetingRoomMapper.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="org.javaboy.meeting.mapper.MeetingRoomMapper">

    <select id="getAllMrs" resultType="org.javaboy.meeting.model.MeetingRoom">
        select * from meetingroom;
    </select>
</mapper>

运行成功

再和数据库做对比