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);
}
}
年少轻狂,总以为天下事竭力有为。人事尽时,终感力不能及。