楼层表

1.在数据库中创建楼层表及字段

CREATE TABLE hotel_floor(

  -- id 作为主键 

floor_id INT PRIMARY KEY AUTO_INCREMENT,

  -- 楼层号

  floor_number INT(1000), 

 -- 楼层名称

floor_name VARCHAR(50),

-- 创建时间

create_time DATETIME DEFAULT CURRENT_TIMESTAMP

);

2.搭建楼层管理菜单

 新建floor文件夹

 导入楼层表

 复制其中的controller，service，mapper，domain等

　3.前端楼层号限制只能是数字

 楼层名不允许超过50位只能是汉字英文数字的组合

 

 

 4.再添加两个正则表达式

 5.增删改查

package com.rome.hotel.data.service.impl;

import java.util.List;
import com.rome.hotel.common.utils.DateUtils;
import com.rome.hotel.data.domain.HotelUser;
import com.rome.hotel.data.utils.RegexUtils;
import io.jsonwebtoken.lang.Assert;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;
import com.rome.hotel.data.mapper.HotelFloorMapper;
import com.rome.hotel.data.domain.HotelFloor;
import com.rome.hotel.data.service.IHotelFloorService;

/**
 * 楼层Service业务层处理
 * 
 * @author rome
 * @date 2023-12-20
 */
@Service
public class HotelFloorServiceImpl implements IHotelFloorService 
{
    @Autowired
    private HotelFloorMapper hotelFloorMapper;

    /**
     * 查询楼层
     * 
     * @param floorId 楼层主键
     * @return 楼层
     */
    @Override
    public HotelFloor selectHotelFloorByFloorId(Long floorId)
    {
        return hotelFloorMapper.selectHotelFloorByFloorId(floorId);
    }

    /**
     * 查询楼层列表
     * 
     * @param hotelFloor 楼层
     * @return 楼层
     */
    @Override
    public List<HotelFloor> selectHotelFloorList(HotelFloor hotelFloor)
    {
        return hotelFloorMapper.selectHotelFloorList(hotelFloor);
    }

    /**
     * 新增楼层
     * 
     * @param hotelFloor 楼层
     * @return 结果
     */
    @Override
    public int insertHotelFloor(HotelFloor hotelFloor)
    {
//        防御性编程
        Assert.notNull(hotelFloor,"参数位空");
        Assert.state(RegexUtils.testFloorNumber(hotelFloor.getFloorNumber().toString()),"参数只能是数字");
        Assert.notNull(hotelFloor.getFloorName(),"楼层名称不能为空");
        Assert.state(RegexUtils.testFloorName(hotelFloor.getFloorName()),"只能是汉字、数字、字母的组合不能包含其他字符");
        hotelFloor.setCreateTime(DateUtils.getNowDate());
        HotelFloor hotelFloorQuery = hotelFloorMapper.selectHotelFloorByFloorId(hotelFloor.getFloorId());
        Assert.notNull(hotelFloorQuery!=null,"参数异常");
        return hotelFloorMapper.insertHotelFloor(hotelFloor);
    }

    /**
     * 修改楼层
     * 
     * @param hotelFloor 楼层
     * @return 结果
     */
    @Override
    public int updateHotelFloor(HotelFloor hotelFloor)
    {
        //        防御性编程
        Assert.notNull(hotelFloor,"参数位空");
        Assert.state(RegexUtils.testFloorNumber(hotelFloor.getFloorNumber().toString()),"参数只能是数字");
        Assert.notNull(hotelFloor.getFloorName(),"楼层名称不能为空");
        Assert.state(RegexUtils.testFloorName(hotelFloor.getFloorName()),"只能是汉字、数字、字母的组合不能包含其他字符");
        HotelFloor hotelFloorQuery = hotelFloorMapper.selectHotelFloorByFloorId(hotelFloor.getFloorId());
        Assert.notNull(hotelFloorQuery,"参数异常");
        return hotelFloorMapper.updateHotelFloor(hotelFloor);
    }

    /**
     * 批量删除楼层
     * 
     * @param floorIds 需要删除的楼层主键
     * @return 结果
     */
    @Override
    public int deleteHotelFloorByFloorIds(Long[] floorIds)
    {
        for (Long id:floorIds
        ) {

            Assert.notNull(hotelFloorMapper.selectHotelFloorByFloorId(id),"参数异常");
        }
        return hotelFloorMapper.deleteHotelFloorByFloorIds(floorIds);
    }

    /**
     * 删除楼层信息
     * 
     * @param floorId 楼层主键
     * @return 结果
     */
    @Override
    public int deleteHotelFloorByFloorId(Long floorId)
    {

        //        1.防御性编程
        HotelFloor hotelFloor = hotelFloorMapper.selectHotelFloorByFloorId(floorId);
        Assert.notNull(hotelFloor,"参数异常");
        return hotelFloorMapper.deleteHotelFloorByFloorId(floorId);
    }
}