宿舍（寝室）管理系统设计与实现 | 附 演示、源码地址

com.cya.controller

com.cya.service

com.cya.service.impl

com.cya.mapper

com.cya.entity

package com.cya.controller;

import java.util.ArrayList;
import java.util.List;
import java.util.Map;

import javax.management.relation.Role;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpSession;

import org.apache.tomcat.util.digester.ArrayStack;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Controller;
import org.springframework.web.bind.annotation.RequestBody;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.bind.annotation.ResponseBody;

import com.cya.entity.Login;
import com.cya.entity.Result;
import com.cya.service.ILoginService;
import com.cya.service.impl.LoginServiceImpl;

@Controller
@ResponseBody
public class LoginController {

    @Autowired
    private ILoginService loginServiceImpl;

    @RequestMapping("login")
    public List login(HttpServletRequest request, @RequestBody Login login) {
        List list=loginServiceImpl.login(login);
        if(list.size()==1) {
            HttpSession session=request.getSession();
            session.setAttribute(login.getRole(), list);
            System.out.println("session="+session.getAttribute(login.getRole()));
        }
        return list;
    }

    @RequestMapping("getSession")
    public List getSession(HttpServletRequest request,@RequestBody Login login){
        System.out.println(login);
        System.out.println(request.getSession().getAttribute(login.getRole()));
        List list=new ArrayList<>();
        list.add(request.getSession().getAttribute(login.getRole()));
        return list;
    }

    @RequestMapping("exitSys")
    public Result exitSys(HttpServletRequest request) {
        String exit="";
        try {
            if(request.getParameter("exit")!=null) {
                exit=request.getParameter("exit");
            }
            request.getSession().removeAttribute(exit);
            return new Result(true, "注销成功");
        } catch (Exception e) {
            // TODO: handle exception
            e.printStackTrace();
            return new Result(false, "注销失败");
        }
    }
}

<!-- ******************** 公告 ******************* -->

  <select id="getNoticeManage" resultType="com.cya.entity.Notice">
    select * from t_notice
    <where>
      <if test="filter=='date' and key !='' ">
        date like concat("%",#{key},"%")
      </if>
    </where>
  </select>

   <insert id="addNoticeManage" parameterType="com.cya.entity.Notice">
    insert into t_notice(noticePerson,date,content) values(#{noticePerson},current_date,#{content})
  </insert>

  <select id="getNoticeMangerById" parameterType="Integer" resultType="com.cya.entity.Notice">
     select * from t_notice where noticeId=#{noticeId}
  </select>

  <update id="updataNoticeManageById" parameterType="com.cya.entity.Notice">
    update t_notice set noticePerson=#{noticePerson},content=#{content} where noticeId=#{noticeId}
  </update>

  <delete id="noticeManagerDeleteById" parameterType="Integer">

     delete from t_notice where noticeId=#{noticeId}
  </delete>

 <!-- ******************** 公告 ******************* -->

@RequestMapping("/getRecordMsg")
    public PageResult getRecordMsg(HttpServletRequest request){
        Integer pageNum=1;
        Integer pageSize=20;
        Integer dormBuildId=0;
        String filter=request.getParameter("filter");
        String key=request.getParameter("key");
        if(request.getParameter("pageNum")!=null && request.getParameter("pageNum")!="") {
            pageNum=Integer.parseInt(request.getParameter("pageNum"));
        }
        if(request.getParameter("pageSize")!=null && request.getParameter("pageSize")!="") {
            pageSize=Integer.parseInt(request.getParameter("pageSize"));
        }
        if(request.getParameter("dormBuildId")!=null && request.getParameter("dormBuildId")!="") {
            dormBuildId=Integer.parseInt(request.getParameter("dormBuildId"));
        }
        System.out.println("pageNum="+pageNum);
        System.out.println("pageSize="+pageSize);
        return dormManageServiceImpl.getRecordMsg(pageNum, pageSize, filter, key, dormBuildId);
    }

    @RequestMapping("getRecordById")
    public Record getRecordById(Integer recordId) {
        return dormManageServiceImpl.getRecordById(recordId);
    }


    @RequestMapping("updataRecordMsg")
    public Result updataRecordMsg(@RequestBody Record record) {
        try {
            dormManageServiceImpl.updataRecordMsg(record);
            return new Result(true, "更新成功");
        } catch (Exception e) {
            // TODO: handle exception
            e.printStackTrace();
            return new Result(false, "更新失败");
        }
    }

    @RequestMapping("addRecordMsg")
    public Result addRecordMsg(@RequestBody Record record) {
        try {
            System.out.println(record);
            dormManageServiceImpl.addRecordMsg(record);
            return new Result(true, "添加成功");
        } catch (Exception e) {
            // TODO: handle exception
            e.printStackTrace();
            return new Result(false, "添加失败");
        }
    }

    @RequestMapping("recordManagerDeleteById1")
    public Result recordManagerDeleteById(HttpServletRequest request) {
        Integer recordId=0;
        if(request.getParameter("recordId")!=null && request.getParameter("recordId")!="") {
            recordId=Integer.parseInt(request.getParameter("recordId"));
        }
        try {
            dormManageServiceImpl.recordManagerDeleteById1(recordId);
            return new Result(true, "删除成功");
        } catch (Exception e) {
            // TODO: handle exception
            e.printStackTrace();
            return new Result(false, "删除失败");
        }
    }