Roma
世界已黑白,此人已成仙。

年少轻狂,总以为天下事竭力有为。人事尽时,终感力不能及。

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);
}
}

  

posted on 2023-12-20 22:41  罗|马  阅读(38)  评论(0编辑  收藏  举报

Live2D