SSM酒店管理系统项目Day11

15.楼层管理

15.1 添加楼层管理页面15.2 楼层管理的增删改查

15.2.1 实体类15.2.2 数据层15.2.3 业务层15.2.4 控制层
建议配合视频学习食用（8-1~8-4）：
https://www.bilibili.com/video/BV1rr4y1F7Y2?p=1

1.floorManager.jsp

<%@ page contentType="text/html;charset=UTF-8" language="java" %>



    
    
    
    
    
    
    
    
    
    
    



    


        
        

            
搜索信息
            

                

                    

                        

                            楼层名称
                            

                                
                            
                        
                        

                            搜索
                            
                            重置
                            
                        
                    
                
            
        

        
        

        
        

        
        

        
        

            

                

                    楼层名称
                    

                        
                        
                        
                    
                
                

                    楼层备注
                    

                        
                    
                
                

                    

                        提交
                        
                        重置
                        
                    
                
            
        

    

2.PageController.java

   
    @RequestMapping("/toFloorManager")
    public String toFloorManager(){
        return "floor/floorManager";
    }

3.数据库

Floor,java

package com.manong.entity;

import lombok.Data;

@Data
public class Floor {
    private Integer id;
    private String floorName;
    private String remark;
}

FloorVo.java

package com.manong.vo;

import com.manong.entity.Floor;
import lombok.Data;

@Data
public class FloorVo extends Floor {

    private Integer page;//当前页码
    private Integer limit;//每页显示数量

}

FloorMapper.java

package com.manong.dao;

import com.manong.entity.Floor;
import com.manong.vo.FloorVo;
import org.apache.ibatis.annotations.Delete;

import java.util.List;

public interface FloorMapper {

    
    List findFloorList(FloorVo floorVo);

    
    int insert(Floor floor);

    
    int updateFloor(Floor floor);

    
    @Delete("delete from t_floor where id = #{id}")
    int deleteById(Integer id);
}

FloorMapper.xml

    
        
        
        
    

    
        insert into t_floor (floorName, remark) values (#{floorName,jdbcType=VARCHAR}, #{remark,jdbcType=VARCHAR} )
    

    
        update t_floor
        
            
                floorName = #{floorName,jdbcType=VARCHAR},
            
            
                remark = #{remark,jdbcType=VARCHAR},
            
        
        where id = #{id,jdbcType=INTEGER}
    

    
        select * from t_floor
        
            
                and floorName like  concat('%',#{floorName},'%')
            
        
        order by id
    

FloorService.java

package com.manong.service;

import com.manong.entity.Floor;
import com.manong.vo.FloorVo;

import java.util.List;

public interface FloorService {

    
    List findFloorList(FloorVo floorVo);

    
    int insert(Floor floor);

    
    int updateFloor(Floor floor);

    
    int deleteById(Integer id);

}

FloorServiceImpl.java

package com.manong.service.impl;

import com.alibaba.fastjson.JSON;
import com.manong.dao.FloorMapper;
import com.manong.entity.Floor;
import com.manong.service.FloorService;
import com.manong.utils.JedisPoolUtils;
import com.manong.utils.RedisKey;
import com.manong.vo.FloorVo;
import org.springframework.stereotype.Service;
import org.springframework.transaction.annotation.Transactional;
import org.springframework.util.StringUtils;
import redis.clients.jedis.Jedis;

import javax.annotation.Resource;
import java.util.List;


@Service
@Transactional
public class FloorServiceImpl implements FloorService {

    @Resource
    private FloorMapper floorMapper;

    
    public List findFloorList(FloorVo floorVo) {
        return floorMapper.findFloorList(floorVo);
    }

    public int insert(Floor floor) {
        return floorMapper.insert(floor);
    }

    public int updateFloor(Floor floor) {
        return floorMapper.updateFloor(floor);
    }

    @Override
    public int deleteById(Integer id) {
        return floorMapper.deleteById(id);
    }
}

FloorController.java

package com.manong.controller;

import com.alibaba.fastjson.JSON;
import com.github.pagehelper.PageHelper;
import com.github.pagehelper.PageInfo;
import com.manong.entity.Floor;
import com.manong.service.FloorService;
import com.manong.utils.DataGridViewResult;
import com.manong.utils.SystemConstants;
import com.manong.vo.FloorVo;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.bind.annotation.ResponseBody;
import org.springframework.web.bind.annotation.RestController;

import javax.annotation.Resource;
import java.util.HashMap;
import java.util.List;
import java.util.Map;

@RestController
@RequestMapping("/admin/floor")
public class FloorController {

    @Resource
    private FloorService floorService;


    
    @RequestMapping("/list")
    public DataGridViewResult list(FloorVo floorVo){
        //设置分页信息
        PageHelper.startPage(floorVo.getPage(),floorVo.getLimit());
        //调用查询楼层列表方法
        List floorList = floorService.findFloorList(floorVo);
        //创建分页对象
        PageInfo pageInfo = new PageInfo(floorList);
        //返回数据
        return new DataGridViewResult(pageInfo.getTotal(),pageInfo.getList());
    }


    
    @RequestMapping("/addFloor")
    public String addFloor(Floor floor){
        Map map = new HashMap();
        if(floorService.insert(floor)>0){
            map.put(SystemConstants.SUCCESS,true);
            map.put(SystemConstants.MESSAGE,"添加成功");
        }else{
            map.put(SystemConstants.SUCCESS,false);
            map.put(SystemConstants.MESSAGE,"添加失败");
        }
        return JSON.toJSONString(map);
    }

    
    @RequestMapping("/updateFloor")
    public String updateFloor(Floor floor){
        Map map = new HashMap();
        if(floorService.updateFloor(floor)>0){
            map.put(SystemConstants.SUCCESS,true);
            map.put(SystemConstants.MESSAGE,"修改成功");
        }else{
            map.put(SystemConstants.SUCCESS,false);
            map.put(SystemConstants.MESSAGE,"修改失败");
        }
        return JSON.toJSONString(map);
    }

    
    @ResponseBody
    @RequestMapping("/deleteById")
    public String deleteById(Integer id){
        Map map = new HashMap();
        if(floorService.deleteById(id)>0){
            map.put(SystemConstants.SUCCESS,true);
            map.put(SystemConstants.MESSAGE,"删除成功");
        }else{
            map.put(SystemConstants.SUCCESS,false);
            map.put(SystemConstants.MESSAGE,"删除失败");
        }
        return JSON.toJSONString(map);
    }
}