项目编号：KS023
运行环境：
开发工具：IDEA 或 Eclipse
JAVA: JDK1.8
应用服务器：tomcat8.5.31
Maven: 3.3.9
开发技术：
后台：SSM框架+Shiro权限管理框架
前台：bootstrap+jquery
为客户开发的会议室预约系统，基于SSM框架，权限管理使用Shiro框架。用户权限分为普通用户和管理员。普通用户可以申请会议室使用，也可以取消申请。管理员可以管理会议室(包括会议室信息的增删改查)和处理普通用户的会议室申请，也可以管理用户信息等。
下面展示一下系统的部分功能：
管理员账户登陆
会议室管理
预约审核管理
预约记录查询
用户注册管理
普通用户登陆
查询会议室列表
预约记录查询
预约会议室
取消预约申请
以上是会议室预约管理系统的部分展示功能，本系统功能完整，页面简洁，适合于毕业设计或课程设计使用。
项目实现代码：
package .em.service;
import .em.domain.PagingVO;
import .em.domain.Reservation;
import .em.domain.ReservationCustom;
import .em.domain.ReservationVo;
import java.util.List;
/**
* Created by znz
*/
public interface ReservationService {
/**
* 查询15天内待审核的预约总数
* @return
*/
public Integer reservationCount() throws Exception;
/**
* 查询15天内的所有待审核预约记录
* @return
*/
public List<ReservationVo> findByPaging(Integer toPageNo) throws Exception;
/**
* 根据借用人查询其所有预约记录
* @param name
* @return
*/
public List<Reservation> findByName(String name);
/**
* 查询15天内的审核通过的预约总数
* @return
*/
public Integer reservationPassCount();
/**
* 查询15天内的所有审核通过预约记录
* @param toPageNo
* @return
* @throws Exception
*/
public List<ReservationVo> findRecord(Integer toPageNo) throws Exception;
/**
* 审核预约会议室
* @param id
* @throws Exception
*/
public void reviewReservation(Integer id) throws Exception;
/**
* 查询15天内所有预约记录
* @return
*/
public Integer reserveCount() throws Exception;
/**
* 查询当前日期起,15天内的所有已被预约的会议室记录
* @return
*/
public List<ReservationVo> findAllByPaging(Integer toPageNo) throws Exception;
/**
* 添加会议室预约
* @param reservationCustom
*/
public void addReservation(ReservationCustom reservationCustom) throws Exception;
/**
* 根据借用人查询所有会议室预约信息
* @param name
* @return
* @throws Exception
*/
public List<ReservationVo> queryByUser(String name) throws Exception;
/**
* 查询指定借用人预约会议室信息
* @param name
* @return
* @throws Exception
*/
public List<ReservationCustom> findByUser(String name) throws Exception;
/**
* 根据id取消会议室申请
* @param id
* @throws Exception
*/
public void cancelApplication(Integer id) throws Exception;
}
package .em.service.impl;
import .em.dao.ReservationMapper;
import .em.domain.PagingVO;
import .em.domain.Reservation;
import .em.domain.ReservationCustom;
import .em.domain.ReservationVo;
import .em.service.ReservationService;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;
import java.util.List;
/**
* Created by znz
*/
@Service
public class ReservationServiceImpl implements ReservationService {
@Autowired
private ReservationMapper reservationMapper;
@Override
public Integer reservationCount() {
return reservationMapper.reservationCount();
}
@Override
public List<ReservationVo> findByPaging(Integer toPageNo) {
PagingVO pagingVO = new PagingVO();
pagingVO.setToPageNo(toPageNo);
List<ReservationVo> list = reservationMapper.findByPaging(pagingVO);
return list;
}
@Override
public List<Reservation> findByName(String name) {
return reservationMapper.findByName(name);
}
@Override
public Integer reservationPassCount() {
return reservationMapper.reservationPassCount();
}
@Override
public List<ReservationVo> findRecord(Integer toPageNo) throws Exception {
PagingVO pagingVO = new PagingVO();
pagingVO.setToPageNo(toPageNo);
List<ReservationVo> list = reservationMapper.findRecord(pagingVO);
return list;
}
@Override
public void reviewReservation(Integer id) throws Exception {
reservationMapper.reviewReservation(id);
}
@Override
public Integer reserveCount() throws Exception {
return reservationMapper.reserveCount();
}
@Override
public List<ReservationVo> findAllByPaging(Integer toPageNo) throws Exception {
PagingVO pagingVO = new PagingVO();
pagingVO.setToPageNo(toPageNo);
List<ReservationVo> list = reservationMapper.findAllByPaging(pagingVO);
return list;
}
@Override
public void addReservation(ReservationCustom reservationCustom) throws Exception {
reservationMapper.addReservation(reservationCustom);
}
@Override
public List<ReservationVo> queryByUser(String name) throws Exception {
return reservationMapper.queryByUser(name);
}
@Override
public List<ReservationCustom> findByUser(String name) throws Exception {
return reservationMapper.findByUser(name);
}
@Override
public void cancelApplication(Integer id) throws Exception {
reservationMapper.cancelApplication(id);
}
}
package .em.service;
import .em.domain.Room;
import java.util.List;
/**
* Created by znz
*/
public interface RoomService {
/**
* 获取会议室总数
* @return
*/
public Integer roomCount();
/**
* 获取分页查询会议室信息
* @param toPageNo
* @return
* @throws Exception
*/
List<Room> findByPaging(Integer toPageNo) throws Exception;
/**
* 添加会议室信息
* @param room
* @throws Exception
*/
public void add(Room room) throws Exception;
/**
* 根据id查询会议室信息
* @param id
* @return
* @throws Exception
*/
public Room findById(Integer id) throws Exception;
/**
* 根据id更新会议室信息
* @param room 输入Room对象(包含id,name,message属性)
* @throws Exception
*/
public void updateById(Room room) throws Exception;
/**
* 根据id删除会议室信息
* @param id
* @throws Exception
*/
public void removeById(Integer id) throws Exception;
/**
* 根据名字模糊查询会议室信息
* @param name
* @return
* @throws Exception
*/
public List<Room> findByName(String name) throws Exception;
/**
* 获取所有会议室的名称
* @return
* @throws Exception
*/
public List<Room> nameList() throws Exception;
}
package .em.service.impl;
import .em.dao.RoomMapper;
import .em.domain.PagingVO;
import .em.domain.Room;
import .em.service.RoomService;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;
import java.util.List;
/**
* Created by znz
*/
@Service
public class RoomServiceImpl implements RoomService {
@Autowired
private RoomMapper roomMapper;
@Override
public Integer roomCount() {
return roomMapper.roomCount();
}
@Override
public List<Room> findByPaging(Integer toPageNo) throws Exception {
PagingVO pagingVO = new PagingVO();
pagingVO.setToPageNo(toPageNo);
List<Room> list = roomMapper.findByPaging(pagingVO);
return list;
}
@Override
public void add(Room room) throws Exception {
roomMapper.add(room);
}
@Override
public Room findById(Integer id) throws Exception {
return roomMapper.findById(id);
}
@Override
public void updateById(Room room) throws Exception {
roomMapper.updateById(room);
}
@Override
public void removeById(Integer id) throws Exception {
roomMapper.removeById(id);
}
@Override
public List<Room> findByName(String name) throws Exception {
return roomMapper.findByName(name);
}
@Override
public List<Room> nameList() throws Exception {
return roomMapper.nameList();
}
}
