0
0

学生宿舍管理系统

1.项目介绍：

学生宿舍管理系统，管理员可以对宿舍、宿舍楼、学生进行增删改查操作

2.项目技术：

前端：jsp、css、JavaScript、Jquery

后端：Servlet、mvc

3.开发环境：

JAVA版本：JDK1.8

类型：IDEA

Tomcat版本：Tomcat 7-10

数据库：MySql

硬件类型：Win、Mac

4.功能介绍：

4.1.模块登录：

4.2.其他模块：

4.2.1.宿舍楼管理：

4.2.2.宿舍管理：

4.2.3.学生管理：

5. 代码目录：

6.代码模块：

dto：

  1. package com.roadjava.studentroom.bean.dto;
  3. /**
  4.  * 封装删除语句参数的类
  5.  */
  6. public class DeleteParam {
  7.     private StringBuilder sql;
  8.     private Long[] ids;
  10.     public StringBuilder getSql() {
  11.         return sql;
  12.     }
  14.     public void setSql(StringBuilder sql) {
  15.         this.sql = sql;
  16.     }
  18.     public Long[] getIds() {
  19.         return ids;
  20.     }
  22.     public void setIds(Long[] ids) {
  23.         this.ids = ids;
  24.     }
  26. }

entity：

  1. //
  2. // Source code recreated from a .class file by IntelliJ IDEA
  3. // (powered by Fernflower decompiler)
  4. //
  6. package com.roadjava.studentroom.bean.entity;
  8. public class BuildingDO {
  9.     private Long id;
  10.     private String no;
  11.     private String completedDate;
  12.     private String type;
  13.     private String uniqueNo;
  15.     public BuildingDO() {
  16.     }
  18.     public Long getId() {
  19.         return this.id;
  20.     }
  22.     public void setId(Long id) {
  23.         this.id = id;
  24.     }
  26.     public String getNo() {
  27.         return this.no;
  28.     }
  30.     public void setNo(String no) {
  31.         this.no = no;
  32.     }
  34.     public String getCompletedDate() {
  35.         return this.completedDate;
  36.     }
  38.     public void setCompletedDate(String completedDate) {
  39.         this.completedDate = completedDate;
  40.     }
  42.     public String getType() {
  43.         return this.type;
  44.     }
  46.     public void setType(String type) {
  47.         this.type = type;
  48.     }
  50.     public String getUniqueNo() {
  51.         return format(this.type, this.no);
  52.     }
  54.     public static String format(String type, String no) {
  55.         if ("M".equals(type)) {
  56.             type = "男";
  57.         } else {
  58.             type = "女";
  59.         }
  61.         return type + "-" + no;
  62.     }
  63. }
  1. //
  2. // Source code recreated from a .class file by IntelliJ IDEA
  3. // (powered by Fernflower decompiler)
  4. //
  6. package com.roadjava.studentroom.bean.entity;
  8. public class DormitoryDO {
  9.     private Long id;
  10.     private String no;
  11.     private Long dormitoryBuildingId;
  12.     private String buildingUniqueNo;
  14.     public DormitoryDO() {
  15.     }
  17.     public Long getId() {
  18.         return this.id;
  19.     }
  21.     public void setId(Long id) {
  22.         this.id = id;
  23.     }
  25.     public String getNo() {
  26.         return this.no;
  27.     }
  29.     public void setNo(String no) {
  30.         this.no = no;
  31.     }
  33.     public Long getDormitoryBuildingId() {
  34.         return this.dormitoryBuildingId;
  35.     }
  37.     public void setDormitoryBuildingId(Long dormitoryBuildingId) {
  38.         this.dormitoryBuildingId = dormitoryBuildingId;
  39.     }
  41.     public String getBuildingUniqueNo() {
  42.         return this.buildingUniqueNo;
  43.     }
  45.     public void setBuildingUniqueNo(String buildingUniqueNo) {
  46.         this.buildingUniqueNo = buildingUniqueNo;
  47.     }
  48. }
  1. //
  2. // Source code recreated from a .class file by IntelliJ IDEA
  3. // (powered by Fernflower decompiler)
  4. //
  6. package com.roadjava.studentroom.bean.entity;
  8. public class ManagerDO {
  9.     private Long id;
  10.     private String userName;
  11.     private String pwd;
  13.     public ManagerDO() {
  14.     }
  16.     public Long getId() {
  17.         return this.id;
  18.     }
  20.     public void setId(Long id) {
  21.         this.id = id;
  22.     }
  24.     public String getUserName() {
  25.         return this.userName;
  26.     }
  28.     public void setUserName(String userName) {
  29.         this.userName = userName;
  30.     }
  32.     public String getPwd() {
  33.         return this.pwd;
  34.     }
  36.     public void setPwd(String pwd) {
  37.         this.pwd = pwd;
  38.     }
  39. }
  1. //
  2. // Source code recreated from a .class file by IntelliJ IDEA
  3. // (powered by Fernflower decompiler)
  4. //
  6. package com.roadjava.studentroom.bean.entity;
  8. public class StudentDO {
  9.     private Long id;
  10.     private String name;
  11.     private String gender;
  12.     private String no;
  13.     private String dept;
  14.     private String grade;
  15.     private Long dormitoryId;
  16.     private Long buildingId;
  17.     private String dormitoryNo;
  18.     private String buildingUniqueNo;
  20.     public StudentDO() {
  21.     }
  23.     public String getDormitoryNo() {
  24.         return this.dormitoryNo;
  25.     }
  27.     public void setDormitoryNo(String dormitoryNo) {
  28.         this.dormitoryNo = dormitoryNo;
  29.     }
  31.     public Long getId() {
  32.         return this.id;
  33.     }
  35.     public void setId(Long id) {
  36.         this.id = id;
  37.     }
  39.     public String getName() {
  40.         return this.name;
  41.     }
  43.     public void setName(String name) {
  44.         this.name = name;
  45.     }
  47.     public String getNo() {
  48.         return this.no;
  49.     }
  51.     public void setNo(String no) {
  52.         this.no = no;
  53.     }
  55.     public Long getDormitoryId() {
  56.         return this.dormitoryId;
  57.     }
  59.     public void setDormitoryId(Long dormitoryId) {
  60.         this.dormitoryId = dormitoryId;
  61.     }
  63.     public String getDept() {
  64.         return this.dept;
  65.     }
  67.     public void setDept(String dept) {
  68.         this.dept = dept;
  69.     }
  71.     public String getGrade() {
  72.         return this.grade;
  73.     }
  75.     public void setGrade(String grade) {
  76.         this.grade = grade;
  77.     }
  79.     public Long getBuildingId() {
  80.         return this.buildingId;
  81.     }
  83.     public void setBuildingId(Long buildingId) {
  84.         this.buildingId = buildingId;
  85.     }
  87.     public String getBuildingUniqueNo() {
  88.         return this.buildingUniqueNo;
  89.     }
  91.     public void setBuildingUniqueNo(String buildingUniqueNo) {
  92.         this.buildingUniqueNo = buildingUniqueNo;
  93.     }
  95.     public String getGender() {
  96.         return this.gender;
  97.     }
  99.     public void setGender(String gender) {
  100.         this.gender = gender;
  101.     }
  102. }

filter：

  1. //
  2. // Source code recreated from a .class file by IntelliJ IDEA
  3. // (powered by Fernflower decompiler)
  4. //
  6. package com.roadjava.studentroom.filter;
  8. import java.io.IOException;
  9. import javax.servlet.Filter;
  10. import javax.servlet.FilterChain;
  11. import javax.servlet.FilterConfig;
  12. import javax.servlet.ServletException;
  13. import javax.servlet.ServletRequest;
  14. import javax.servlet.ServletResponse;
  15. import javax.servlet.annotation.WebFilter;
  16. import javax.servlet.annotation.WebInitParam;
  17. import javax.servlet.http.HttpServletRequest;
  18. import javax.servlet.http.HttpServletResponse;
  20. @WebFilter(
  21.     filterName = "characterEncodingFilter",
  22.     urlPatterns = {"/*"},
  23.     initParams = {@WebInitParam(
  24.     name = "encoding",
  25.     value = "UTF-8"
  26. )}
  27. )
  28. public class CharacterEncodingFilter implements Filter {
  29.     private String encoding = null;
  31.     public CharacterEncodingFilter() {
  32.     }
  34.     public void destroy() {
  35.     }
  37.     public void doFilter(ServletRequest req, ServletResponse resp, FilterChain chain) throws ServletException, IOException {
  38.         HttpServletRequest httpServletRequest = (HttpServletRequest)req;
  39.         HttpServletResponse httpServletResponse = (HttpServletResponse)resp;
  40.         httpServletRequest.setCharacterEncoding(this.encoding);
  41.         httpServletResponse.setCharacterEncoding(this.encoding);
  42.         chain.doFilter(req, resp);
  43.     }
  45.     public void init(FilterConfig config) throws ServletException {
  46.         this.encoding = config.getInitParameter("encoding");
  47.     }
  48. }
  1. //
  2. // Source code recreated from a .class file by IntelliJ IDEA
  3. // (powered by Fernflower decompiler)
  4. //
  6. package com.roadjava.studentroom.filter;
  8. import com.roadjava.studentroom.bean.entity.ManagerDO;
  9. import java.io.IOException;
  10. import javax.servlet.Filter;
  11. import javax.servlet.FilterChain;
  12. import javax.servlet.FilterConfig;
  13. import javax.servlet.ServletException;
  14. import javax.servlet.ServletRequest;
  15. import javax.servlet.ServletResponse;
  16. import javax.servlet.annotation.WebFilter;
  17. import javax.servlet.http.HttpServletRequest;
  18. import javax.servlet.http.HttpServletResponse;
  20. @WebFilter(
  21.     filterName = "characterEncodingFilter",
  22.     urlPatterns = {"/building", "/dormitory", "/student", "/manager"}
  23. )
  24. public class XAuthFilter implements Filter {
  25.     public XAuthFilter() {
  26.     }
  28.     public void destroy() {
  29.     }
  31.     public void doFilter(ServletRequest req, ServletResponse resp, FilterChain chain) throws ServletException, IOException {
  32.         HttpServletRequest httpServletRequest = (HttpServletRequest)req;
  33.         HttpServletResponse httpServletResponse = (HttpServletResponse)resp;
  34.         ManagerDO manager = (ManagerDO)httpServletRequest.getSession().getAttribute("manager");
  35.         if (manager == null) {
  36.             httpServletResponse.sendRedirect(httpServletRequest.getContextPath() + "/index.jsp");
  37.         } else {
  38.             chain.doFilter(req, resp);
  39.         }
  40.     }
  42.     public void init(FilterConfig config) throws ServletException {
  43.     }
  44. }

req：

  1. //
  2. // Source code recreated from a .class file by IntelliJ IDEA
  3. // (powered by Fernflower decompiler)
  4. //
  6. package com.roadjava.studentroom.req;
  8. import com.roadjava.studentroom.util.Constants;
  10. public class BaseRequest {
  11.     private int pageSize;
  12.     private int pageNow;
  14.     public BaseRequest() {
  15.         this.pageSize = Constants.PAGE_SIZE;
  16.     }
  18.     public int getStart() {
  19.         return (this.pageNow - 1) * this.pageSize;
  20.     }
  22.     public int getPageSize() {
  23.         return this.pageSize;
  24.     }
  26.     public void setPageSize(int pageSize) {
  27.         this.pageSize = pageSize;
  28.     }
  30.     public void setPageNow(int pageNow) {
  31.         this.pageNow = pageNow;
  32.     }
  34.     public int getpageNow() {
  35.         return this.pageNow;
  36.     }
  37. }
  1. //
  2. // Source code recreated from a .class file by IntelliJ IDEA
  3. // (powered by Fernflower decompiler)
  4. //
  6. package com.roadjava.studentroom.req;
  8. public class DormitoryBuildingRequest extends BaseRequest {
  9.     private String no;
  11.     public DormitoryBuildingRequest() {
  12.     }
  14.     public String getNo() {
  15.         return this.no;
  16.     }
  18.     public void setNo(String no) {
  19.         this.no = no;
  20.     }
  22.     public boolean selectAll() {
  23.         return this.getPageSize() == -1;
  24.     }
  25. }
  1. //
  2. // Source code recreated from a .class file by IntelliJ IDEA
  3. // (powered by Fernflower decompiler)
  4. //
  6. package com.roadjava.studentroom.req;
  8. public class DormitoryRequest extends BaseRequest {
  9.     private String no;
  10.     private Long dormitoryBuildingId;
  12.     public DormitoryRequest() {
  13.     }
  15.     public String getNo() {
  16.         return this.no;
  17.     }
  19.     public void setNo(String no) {
  20.         this.no = no;
  21.     }
  23.     public Long getDormitoryBuildingId() {
  24.         return this.dormitoryBuildingId;
  25.     }
  27.     public void setDormitoryBuildingId(Long dormitoryBuildingId) {
  28.         this.dormitoryBuildingId = dormitoryBuildingId;
  29.     }
  31.     public boolean selectAll() {
  32.         return this.getPageSize() == -1;
  33.     }
  34. }
  1. //
  2. // Source code recreated from a .class file by IntelliJ IDEA
  3. // (powered by Fernflower decompiler)
  4. //
  6. package com.roadjava.studentroom.req;
  8. public class StudentRequest extends BaseRequest {
  9.     private String studentNo;
  11.     public StudentRequest() {
  12.     }
  14.     public String getStudentNo() {
  15.         return this.studentNo;
  16.     }
  18.     public void setStudentNo(String studentNo) {
  19.         this.studentNo = studentNo;
  20.     }
  21. }

res：

  2.   // IntelliJ API Decompiler stub source generated from a class file
  3.   // Implementation of methods is not available
  5. package com.roadjava.studentroom.res;
  7. public class ResultDTO <T> {
  8.     private java.lang.String errCode;
  9.     private java.lang.String errMsg;
  10.     private java.lang.Boolean success;
  11.     private T data;
  12.     private java.lang.Long total;
  13.     private java.util.Map<java.lang.String,java.lang.Object> attributes;
  15.     private ResultDTO() { /* compiled code */ }
  17.     public void addAttr(java.lang.String key, java.lang.Object value) { /* compiled code */ }
  19.     public static <T> com.roadjava.studentroom.res.ResultDTO<T> buildSuccess(T t, java.lang.Number total) { /* compiled code */ }
  21.     public static <T> com.roadjava.studentroom.res.ResultDTO<T> buildEmptySuccess() { /* compiled code */ }
  23.     public static <T> com.roadjava.studentroom.res.ResultDTO<T> buildSuccess(T t) { /* compiled code */ }
  25.     public static <T> com.roadjava.studentroom.res.ResultDTO<T> buildFailure(java.lang.String code, java.lang.String errMsg) { /* compiled code */ }
  27.     public static <T> com.roadjava.studentroom.res.ResultDTO<T> buildFailure(java.lang.String errMsg) { /* compiled code */ }
  29.     public java.lang.String getErrCode() { /* compiled code */ }
  31.     public void setErrCode(java.lang.String errCode) { /* compiled code */ }
  33.     public java.lang.String getErrMsg() { /* compiled code */ }
  35.     public void setErrMsg(java.lang.String errMsg) { /* compiled code */ }
  37.     public java.lang.Boolean getSuccess() { /* compiled code */ }
  39.     public void setSuccess(java.lang.Boolean success) { /* compiled code */ }
  41.     public T getData() { /* compiled code */ }
  43.     public void setData(T data) { /* compiled code */ }
  45.     public java.lang.Long getTotal() { /* compiled code */ }
  47.     public void setTotal(java.lang.Long total) { /* compiled code */ }
  49.     public java.util.Map<java.lang.String,java.lang.Object> getAttributes() { /* compiled code */ }
  51.     public void setAttributes(java.util.Map<java.lang.String,java.lang.Object> attributes) { /* compiled code */ }
  52. }
  1. //
  2. // Source code recreated from a .class file by IntelliJ IDEA
  3. // (powered by Fernflower decompiler)
  4. //
  6. package com.roadjava.studentroom.res;
  8. import com.roadjava.studentroom.util.Constants;
  9. import java.util.Vector;
  11. public class TableDataDTO {
  12.     private Vector<Vector<Object>> data;
  13.     private int pageNow;
  14.     private int totalCount;
  15.     private String searchWord;
  17.     public TableDataDTO() {
  18.     }
  20.     public Vector<Vector<Object>> getData() {
  21.         return this.data;
  22.     }
  24.     public void setData(Vector<Vector<Object>> data) {
  25.         this.data = data;
  26.     }
  28.     public int getTotalCount() {
  29.         return this.totalCount;
  30.     }
  32.     public void setTotalCount(int totalCount) {
  33.         this.totalCount = totalCount;
  34.     }
  36.     public int getPageNow() {
  37.         return this.pageNow;
  38.     }
  40.     public void setPageNow(int pageNow) {
  41.         this.pageNow = pageNow;
  42.     }
  44.     public String getSearchWord() {
  45.         return this.searchWord;
  46.     }
  48.     public void setSearchWord(String searchWord) {
  49.         this.searchWord = searchWord;
  50.     }
  52.     public int getPageCount() {
  53.         int pageCount = false;
  54.         int pageCount;
  55.         if (this.totalCount % Constants.PAGE_SIZE == 0) {
  56.             pageCount = this.totalCount / Constants.PAGE_SIZE;
  57.         } else {
  58.             pageCount = this.totalCount / Constants.PAGE_SIZE + 1;
  59.         }
  61.         return pageCount;
  62.     }
  63. }
  1. //
  2. // Source code recreated from a .class file by IntelliJ IDEA
  3. // (powered by Fernflower decompiler)
  4. //
  6. package com.roadjava.studentroom.res;
  8. import com.roadjava.studentroom.util.Constants;
  9. import java.util.Vector;
  11. public class TableResult<T> {
  12.     private Vector<T> data;
  13.     private int totalCount;
  14.     private int pageNow;
  15.     private String searchWord;
  17.     public TableResult() {
  18.     }
  20.     public Vector<T> getData() {
  21.         return this.data;
  22.     }
  24.     public void setData(Vector<T> data) {
  25.         this.data = data;
  26.     }
  28.     public int getTotalCount() {
  29.         return this.totalCount;
  30.     }
  32.     public void setTotalCount(int totalCount) {
  33.         this.totalCount = totalCount;
  34.     }
  36.     public int getPageNow() {
  37.         return this.pageNow;
  38.     }
  40.     public void setPageNow(int pageNow) {
  41.         this.pageNow = pageNow;
  42.     }
  44.     public String getSearchWord() {
  45.         return this.searchWord;
  46.     }
  48.     public void setSearchWord(String searchWord) {
  49.         this.searchWord = searchWord;
  50.     }
  52.     public int getPageCount() {
  53.         int pageCount = false;
  54.         int pageCount;
  55.         if (this.totalCount % Constants.PAGE_SIZE == 0) {
  56.             pageCount = this.totalCount / Constants.PAGE_SIZE;
  57.         } else {
  58.             pageCount = this.totalCount / Constants.PAGE_SIZE + 1;
  59.         }
  61.         return pageCount;
  62.     }
  63. }

service-->impl：

  1. //
  2. // Source code recreated from a .class file by IntelliJ IDEA
  3. // (powered by Fernflower decompiler)
  4. //
  6. package com.roadjava.studentroom.service.impl;
  8. import com.roadjava.studentroom.bean.dto.DeleteParam;
  9. import com.roadjava.studentroom.bean.entity.BuildingDO;
  10. import com.roadjava.studentroom.bean.entity.DormitoryDO;
  11. import com.roadjava.studentroom.req.DormitoryBuildingRequest;
  12. import com.roadjava.studentroom.req.DormitoryRequest;
  13. import com.roadjava.studentroom.res.TableResult;
  14. import com.roadjava.studentroom.service.BaseServiceSupport;
  15. import com.roadjava.studentroom.service.BuildingService;
  16. import com.roadjava.studentroom.service.DormitoryService;
  17. import com.roadjava.studentroom.util.DBUtil;
  18. import java.sql.Connection;
  19. import java.sql.PreparedStatement;
  20. import java.sql.ResultSet;
  21. import java.sql.SQLException;
  22. import java.util.ArrayList;
  23. import java.util.List;
  24. import java.util.Vector;
  25. import java.util.function.Function;
  26. import java.util.stream.Collectors;
  28. public class BuildingServiceImpl extends BaseServiceSupport implements BuildingService {
  29.     public BuildingServiceImpl() {
  30.     }
  32.     public boolean add(BuildingDO buildingDO) {
  33.         String sql = "insert into dormitory_building(no,completed_date,type) values(?,?,?)";
  34.         return this.doAdd(sql, new Object[]{buildingDO.getNo(), buildingDO.getCompletedDate(), buildingDO.getType()});
  35.     }
  37.     public boolean delete(Long[] ids) {
  38.         List<DeleteParam> conditionList = new ArrayList();
  39.         List<Long> dormitoryIds = new ArrayList();
  40.         DormitoryService dormitoryService = new DormitoryServiceImpl();
  41.         Long[] var8 = ids;
  42.         int var7 = ids.length;
  44.         for(int var6 = 0; var6 < var7; ++var6) {
  45.             Long buildingId = var8[var6];
  46.             DormitoryRequest dormitoryRequest = new DormitoryRequest();
  47.             dormitoryRequest.setPageSize(-1);
  48.             dormitoryRequest.setDormitoryBuildingId(buildingId);
  49.             Vector<DormitoryDO> vector = dormitoryService.getVector(dormitoryRequest);
  50.             List<Long> list = (List)vector.stream().map(DormitoryDO::getId).collect(Collectors.toList());
  51.             dormitoryIds.addAll(list);
  52.         }
  54.         StringBuilder dormitoryDelsql;
  55.         DeleteParam dormitoryDeleteParam;
  56.         if (!dormitoryIds.isEmpty()) {
  57.             dormitoryDelsql = new StringBuilder("delete from student where dormitory_id in (");
  58.             dormitoryDeleteParam = new DeleteParam();
  59.             dormitoryDeleteParam.setSql(dormitoryDelsql);
  60.             dormitoryDeleteParam.setIds((Long[])dormitoryIds.toArray(new Long[dormitoryIds.size()]));
  61.             conditionList.add(dormitoryDeleteParam);
  62.         }
  64.         dormitoryDelsql = new StringBuilder("delete from dormitory where dormitory_building_id in ( ");
  65.         dormitoryDeleteParam = new DeleteParam();
  66.         dormitoryDeleteParam.setSql(dormitoryDelsql);
  67.         dormitoryDeleteParam.setIds(ids);
  68.         conditionList.add(dormitoryDeleteParam);
  69.         StringBuilder buildingDelSql = new StringBuilder("delete from dormitory_building where id in ( ");
  70.         DeleteParam buildingDeleteParam = new DeleteParam();
  71.         buildingDeleteParam.setSql(buildingDelSql);
  72.         buildingDeleteParam.setIds(ids);
  73.         conditionList.add(buildingDeleteParam);
  74.         return this.doDelete(conditionList);
  75.     }
  77.     public boolean update(BuildingDO buildingDO) {
  78.         String sql = "update dormitory_building set no = ?,completed_date = ?   ,type = ? where id = ? ";
  79.         return this.doUpdate(sql, new Object[]{buildingDO.getNo(), buildingDO.getCompletedDate(), buildingDO.getType(), buildingDO.getId()});
  80.     }
  82.     public TableResult<BuildingDO> retrieveList(DormitoryBuildingRequest req) {
  83.         TableResult<BuildingDO> retDTO = new TableResult();
  84.         StringBuilder sql = new StringBuilder("select id,no,date_format(completed_date,'%Y-%m-%d') as completed_date,type  from dormitory_building where 1=1 ");
  85.         if (req.getNo() != null && !"".equals(req.getNo().trim())) {
  86.             sql.append("and no like '%");
  87.             sql.append(req.getNo());
  88.             sql.append("%'");
  89.         }
  91.         sql.append(" order by id desc  ");
  92.         if (!req.selectAll()) {
  93.             sql.append(" limit ");
  94.             sql.append(req.getStart()).append(",").append(req.getPageSize());
  95.         }
  97.         Connection conn = DBUtil.getConn();
  98.         PreparedStatement ps = null;
  99.         ResultSet resultSet = null;
  101.         try {
  102.             if (conn == null) {
  103.                 return null;
  104.             }
  106.             ps = conn.prepareStatement(sql.toString());
  107.             resultSet = ps.executeQuery();
  108.             Vector data = new Vector();
  110.             while(resultSet.next()) {
  111.                 long id = resultSet.getLong("id");
  112.                 String no = resultSet.getString("no");
  113.                 String completed_date = resultSet.getString("completed_date");
  114.                 String type = resultSet.getString("type");
  115.                 BuildingDO oneVector = new BuildingDO();
  116.                 oneVector.setId(id);
  117.                 oneVector.setNo(no);
  118.                 oneVector.setCompletedDate(completed_date);
  119.                 oneVector.setType(type);
  120.                 data.addElement(oneVector);
  121.             }
  123.             sql.setLength(0);
  124.             sql.append("select count(*) from dormitory_building where 1=1 ");
  125.             if (req.getNo() != null && !"".equals(req.getNo().trim())) {
  126.                 sql.append("and no like '%");
  127.                 sql.append(req.getNo());
  128.                 sql.append("%'");
  129.             }
  131.             ps = conn.prepareStatement(sql.toString());
  132.             resultSet = ps.executeQuery();
  134.             while(resultSet.next()) {
  135.                 int totalCount = resultSet.getInt(1);
  136.                 retDTO.setTotalCount(totalCount);
  137.             }
  139.             retDTO.setData(data);
  140.             retDTO.setPageNow(req.getpageNow());
  141.             TableResult var15 = retDTO;
  142.             return var15;
  143.         } catch (SQLException var18) {
  144.             var18.printStackTrace();
  145.         } finally {
  146.             DBUtil.closeResultSet(resultSet);
  147.             DBUtil.closePs(ps);
  148.             DBUtil.closeConn(conn);
  149.         }
  151.         return null;
  152.     }
  154.     public BuildingDO retrieveOneById(Long id) {
  155.         StringBuilder sql = new StringBuilder("select id,no, date_format(completed_date,'%Y-%m-%d') as completed_date,  type  from dormitory_building where id =? ");
  156.         Connection conn = DBUtil.getConn();
  157.         PreparedStatement ps = null;
  158.         ResultSet resultSet = null;
  160.         try {
  161.             if (conn == null) {
  162.                 return null;
  163.             } else {
  164.                 ps = conn.prepareStatement(sql.toString());
  165.                 ps.setLong(1, id);
  166.                 resultSet = ps.executeQuery();
  167.                 BuildingDO resultDO = new BuildingDO();
  169.                 while(resultSet.next()) {
  170.                     String no = resultSet.getString("no");
  171.                     String completed_date = resultSet.getString("completed_date");
  172.                     String type = resultSet.getString("type");
  173.                     resultDO.setId(id);
  174.                     resultDO.setNo(no);
  175.                     resultDO.setCompletedDate(completed_date);
  176.                     resultDO.setType(type);
  177.                 }
  179.                 BuildingDO var11 = resultDO;
  180.                 return var11;
  181.             }
  182.         } catch (SQLException var14) {
  183.             var14.printStackTrace();
  184.             return null;
  185.         } finally {
  186.             DBUtil.closeResultSet(resultSet);
  187.             DBUtil.closePs(ps);
  188.             DBUtil.closeConn(conn);
  189.         }
  190.     }
  192.     public Vector<BuildingDO> getVector(DormitoryBuildingRequest req) {
  193.         TableResult<BuildingDO> result = this.retrieveList(req);
  194.         return result.getData();
  195.     }
  196. }
  1. //
  2. // Source code recreated from a .class file by IntelliJ IDEA
  3. // (powered by Fernflower decompiler)
  4. //
  6. package com.roadjava.studentroom.service.impl;
  8. import com.roadjava.studentroom.bean.dto.DeleteParam;
  9. import com.roadjava.studentroom.bean.entity.BuildingDO;
  10. import com.roadjava.studentroom.bean.entity.DormitoryDO;
  11. import com.roadjava.studentroom.req.DormitoryRequest;
  12. import com.roadjava.studentroom.res.TableResult;
  13. import com.roadjava.studentroom.service.BaseServiceSupport;
  14. import com.roadjava.studentroom.service.DormitoryService;
  15. import com.roadjava.studentroom.util.DBUtil;
  16. import java.sql.Connection;
  17. import java.sql.PreparedStatement;
  18. import java.sql.ResultSet;
  19. import java.sql.SQLException;
  20. import java.util.ArrayList;
  21. import java.util.List;
  22. import java.util.Vector;
  24. public class DormitoryServiceImpl extends BaseServiceSupport implements DormitoryService {
  25.     public DormitoryServiceImpl() {
  26.     }
  28.     public boolean add(DormitoryDO dormitoryDO) {
  29.         String sql = "insert into dormitory(no,dormitory_building_id) values(?,?)";
  30.         return this.doAdd(sql, new Object[]{dormitoryDO.getNo(), dormitoryDO.getDormitoryBuildingId()});
  31.     }
  33.     public boolean delete(Long[] ids) {
  34.         List<DeleteParam> conditionList = new ArrayList();
  35.         StringBuilder studentDeleteSql = new StringBuilder("delete from student where dormitory_id in (");
  36.         DeleteParam studentDeleteParam = new DeleteParam();
  37.         studentDeleteParam.setSql(studentDeleteSql);
  38.         studentDeleteParam.setIds(ids);
  39.         conditionList.add(studentDeleteParam);
  40.         StringBuilder sql = new StringBuilder("delete from dormitory where id in ( ");
  41.         DeleteParam deleteParam = new DeleteParam();
  42.         deleteParam.setSql(sql);
  43.         deleteParam.setIds(ids);
  44.         conditionList.add(deleteParam);
  45.         return this.doDelete(conditionList);
  46.     }
  48.     public boolean update(DormitoryDO dormitoryDO) {
  49.         String sql = "update dormitory set no = ?,dormitory_building_id=?   where id = ? ";
  50.         return this.doUpdate(sql, new Object[]{dormitoryDO.getNo(), dormitoryDO.getDormitoryBuildingId(), dormitoryDO.getId()});
  51.     }
  53.     public TableResult<DormitoryDO> retrieveList(DormitoryRequest req) {
  54.         TableResult<DormitoryDO> retDTO = new TableResult();
  55.         StringBuilder sql = new StringBuilder();
  56.         sql.append("select a.id,a.no,b.no as build_no,b.type from dormitory a ");
  57.         sql.append(" left join dormitory_building b  on a.dormitory_building_id = b.id ");
  58.         sql.append(" where 1=1 ");
  59.         if (req.getNo() != null && !"".equals(req.getNo().trim())) {
  60.             sql.append(" and a.no like '%");
  61.             sql.append(req.getNo());
  62.             sql.append("%'");
  63.         }
  65.         if (req.getDormitoryBuildingId() != null) {
  66.             sql.append(" and a.dormitory_building_id = " + req.getDormitoryBuildingId());
  67.         }
  69.         sql.append(" order by a.id desc  ");
  70.         if (!req.selectAll()) {
  71.             sql.append(" limit ");
  72.             sql.append(req.getStart()).append(",").append(req.getPageSize());
  73.         }
  75.         Connection conn = DBUtil.getConn();
  76.         PreparedStatement ps = null;
  77.         ResultSet resultSet = null;
  79.         try {
  80.             if (conn != null) {
  81.                 ps = conn.prepareStatement(sql.toString());
  82.                 resultSet = ps.executeQuery();
  83.                 Vector data = new Vector();
  85.                 while(resultSet.next()) {
  86.                     long id = resultSet.getLong("id");
  87.                     String no = resultSet.getString("no");
  88.                     String buildingNo = resultSet.getString("build_no");
  89.                     String type = resultSet.getString("type");
  90.                     DormitoryDO oneVector = new DormitoryDO();
  91.                     oneVector.setId(id);
  92.                     oneVector.setNo(no);
  93.                     oneVector.setBuildingUniqueNo(BuildingDO.format(type, buildingNo));
  94.                     data.addElement(oneVector);
  95.                 }
  97.                 sql.setLength(0);
  98.                 sql.append("select count(*) from dormitory where 1=1 ");
  99.                 if (req.getNo() != null && !"".equals(req.getNo().trim())) {
  100.                     sql.append("and no like '%");
  101.                     sql.append(req.getNo());
  102.                     sql.append("%'");
  103.                 }
  105.                 ps = conn.prepareStatement(sql.toString());
  106.                 resultSet = ps.executeQuery();
  108.                 while(resultSet.next()) {
  109.                     int totalCount = resultSet.getInt(1);
  110.                     retDTO.setTotalCount(totalCount);
  111.                 }
  113.                 retDTO.setData(data);
  114.                 retDTO.setPageNow(req.getpageNow());
  115.                 TableResult var15 = retDTO;
  116.                 return var15;
  117.             }
  118.         } catch (SQLException var18) {
  119.             var18.printStackTrace();
  120.             return null;
  121.         } finally {
  122.             DBUtil.closeResultSet(resultSet);
  123.             DBUtil.closePs(ps);
  124.             DBUtil.closeConn(conn);
  125.         }
  127.         return null;
  128.     }
  130.     public DormitoryDO retrieveOneById(Long id) {
  131.         StringBuilder sql = new StringBuilder();
  132.         sql.append("select id,no,dormitory_building_id from dormitory where id =? ");
  133.         Connection conn = DBUtil.getConn();
  134.         PreparedStatement ps = null;
  135.         ResultSet resultSet = null;
  137.         try {
  138.             if (conn == null) {
  139.                 return null;
  140.             }
  142.             ps = conn.prepareStatement(sql.toString());
  143.             ps.setLong(1, id);
  144.             resultSet = ps.executeQuery();
  145.             DormitoryDO resultDO = new DormitoryDO();
  147.             while(resultSet.next()) {
  148.                 String no = resultSet.getString(2);
  149.                 resultDO.setId(id);
  150.                 resultDO.setNo(no);
  151.                 resultDO.setDormitoryBuildingId(resultSet.getLong(3));
  152.             }
  154.             DormitoryDO var9 = resultDO;
  155.             return var9;
  156.         } catch (SQLException var12) {
  157.             var12.printStackTrace();
  158.         } finally {
  159.             DBUtil.closeResultSet(resultSet);
  160.             DBUtil.closePs(ps);
  161.             DBUtil.closeConn(conn);
  162.         }
  164.         return null;
  165.     }
  167.     public Vector<DormitoryDO> getVector(DormitoryRequest req) {
  168.         TableResult<DormitoryDO> result = this.retrieveList(req);
  169.         return result.getData();
  170.     }
  171. }
  1. //
  2. // Source code recreated from a .class file by IntelliJ IDEA
  3. // (powered by Fernflower decompiler)
  4. //
  6. package com.roadjava.studentroom.service.impl;
  8. import com.roadjava.studentroom.bean.entity.ManagerDO;
  9. import com.roadjava.studentroom.service.ManagerService;
  10. import com.roadjava.studentroom.util.DBUtil;
  11. import java.sql.Connection;
  12. import java.sql.PreparedStatement;
  13. import java.sql.ResultSet;
  14. import java.sql.SQLException;
  16. public class ManagerServiceImpl implements ManagerService {
  17.     public ManagerServiceImpl() {
  18.     }
  20.     public boolean validateManagerInfo(ManagerDO managerDO) {
  21.         String sql = "select pwd from manager where user_name = ? ";
  22.         Connection conn = DBUtil.getConn();
  23.         PreparedStatement ps = null;
  24.         ResultSet resultSet = null;
  26.         try {
  27.             if (conn == null) {
  28.                 return false;
  29.             }
  31.             ps = conn.prepareStatement(sql);
  32.             ps.setString(1, managerDO.getUserName());
  33.             resultSet = ps.executeQuery();
  34.             boolean validateOk = false;
  36.             while(resultSet.next()) {
  37.                 String pwd = resultSet.getString(1);
  38.                 if (managerDO.getPwd().equals(pwd)) {
  39.                     validateOk = true;
  40.                 }
  41.             }
  43.             boolean var9 = validateOk;
  44.             return var9;
  45.         } catch (SQLException var12) {
  46.             var12.printStackTrace();
  47.         } finally {
  48.             DBUtil.closeResultSet(resultSet);
  49.             DBUtil.closePs(ps);
  50.             DBUtil.closeConn(conn);
  51.         }
  53.         return false;
  54.     }
  55. }
  1. //
  2. // Source code recreated from a .class file by IntelliJ IDEA
  3. // (powered by Fernflower decompiler)
  4. //
  6. package com.roadjava.studentroom.service.impl;
  8. import com.roadjava.studentroom.bean.dto.DeleteParam;
  9. import com.roadjava.studentroom.bean.entity.BuildingDO;
  10. import com.roadjava.studentroom.bean.entity.StudentDO;
  11. import com.roadjava.studentroom.req.StudentRequest;
  12. import com.roadjava.studentroom.res.TableResult;
  13. import com.roadjava.studentroom.service.BaseServiceSupport;
  14. import com.roadjava.studentroom.service.StudentService;
  15. import com.roadjava.studentroom.util.DBUtil;
  16. import java.sql.Connection;
  17. import java.sql.PreparedStatement;
  18. import java.sql.ResultSet;
  19. import java.sql.SQLException;
  20. import java.util.ArrayList;
  21. import java.util.List;
  22. import java.util.Vector;
  24. public class StudentServiceImpl extends BaseServiceSupport implements StudentService {
  25.     public StudentServiceImpl() {
  26.     }
  28.     public boolean add(StudentDO studentDO) {
  29.         if (this.checkHasExist(studentDO.getNo())) {
  30.             throw new RuntimeException("学号已存在");
  31.         } else {
  32.             String sql = "insert into student(name,gender,no,dept,grade,dormitory_id) values(?,?,?,?,?,?)";
  33.             return this.doAdd(sql, new Object[]{studentDO.getName(), studentDO.getGender(), studentDO.getNo(), studentDO.getDept(), studentDO.getGrade(), studentDO.getDormitoryId()});
  34.         }
  35.     }
  37.     private boolean checkHasExist(String no) {
  38.         String sql = "select count(1) from student where no = ? ";
  39.         Connection conn = DBUtil.getConn();
  40.         PreparedStatement ps = null;
  41.         ResultSet resultSet = null;
  43.         try {
  44.             if (conn != null) {
  45.                 ps = conn.prepareStatement(sql);
  46.                 ps.setString(1, no);
  47.                 resultSet = ps.executeQuery();
  48.                 boolean hasExist = false;
  50.                 boolean var9;
  51.                 while(resultSet.next()) {
  52.                     int count = resultSet.getInt(1);
  53.                     if (count != 0) {
  54.                         hasExist = true;
  55.                         var9 = hasExist;
  56.                         return var9;
  57.                     }
  58.                 }
  60.                 var9 = hasExist;
  61.                 return var9;
  62.             }
  64.             return false;
  65.         } catch (SQLException var12) {
  66.             var12.printStackTrace();
  67.         } finally {
  68.             DBUtil.closeResultSet(resultSet);
  69.             DBUtil.closePs(ps);
  70.             DBUtil.closeConn(conn);
  71.         }
  73.         return false;
  74.     }
  76.     public boolean delete(Long[] ids) {
  77.         StringBuilder sqlBuilder = new StringBuilder("delete from student where id in (");
  78.         DeleteParam deleteParam = new DeleteParam();
  79.         deleteParam.setSql(sqlBuilder);
  80.         deleteParam.setIds(ids);
  81.         List<DeleteParam> list = new ArrayList();
  82.         list.add(deleteParam);
  83.         return this.doDelete(list);
  84.     }
  86.     public boolean update(StudentDO studentDO) {
  87.         String sql = "update student set name = ?,no = ?,dept = ?,grade = ?, gender = ?, dormitory_id = ?  where id = ?";
  88.         return this.doUpdate(sql, new Object[]{studentDO.getName(), studentDO.getNo(), studentDO.getDept(), studentDO.getGrade(), studentDO.getGender(), studentDO.getDormitoryId(), studentDO.getId()});
  89.     }
  91.     public TableResult<StudentDO> retrieveList(StudentRequest studentRequest) {
  92.         TableResult<StudentDO> retDTO = new TableResult();
  93.         StringBuilder sql = new StringBuilder();
  94.         sql.append(" select s.id,s.name,s.gender,s.no,s.dept,s.grade, d.no as dormitoryNo,b.no as buildingNo,b.type ");
  95.         this.appendFrom(sql);
  96.         this.appendWhere(studentRequest, sql);
  97.         sql.append(" order by s.id desc limit ");
  98.         sql.append(studentRequest.getStart()).append(",").append(studentRequest.getPageSize());
  99.         Connection conn = DBUtil.getConn();
  100.         PreparedStatement ps = null;
  101.         ResultSet resultSet = null;
  103.         try {
  104.             if (conn != null) {
  105.                 ps = conn.prepareStatement(sql.toString());
  106.                 resultSet = ps.executeQuery();
  107.                 Vector data = new Vector();
  109.                 while(resultSet.next()) {
  110.                     long id = resultSet.getLong("id");
  111.                     String name = resultSet.getString("name");
  112.                     String gender = resultSet.getString("gender");
  113.                     String no = resultSet.getString("no");
  114.                     String dept = resultSet.getString("dept");
  115.                     String grade = resultSet.getString("grade");
  116.                     String dormitoryNo = resultSet.getString("dormitoryNo");
  117.                     String type = resultSet.getString("type");
  118.                     String buildingNo = resultSet.getString("buildingNo");
  119.                     StudentDO studentDO = new StudentDO();
  120.                     studentDO.setId(id);
  121.                     studentDO.setName(name);
  122.                     studentDO.setGender(gender);
  123.                     studentDO.setNo(no);
  124.                     studentDO.setDept(dept);
  125.                     studentDO.setGrade(grade);
  126.                     studentDO.setDormitoryNo(dormitoryNo);
  127.                     studentDO.setBuildingUniqueNo(BuildingDO.format(type, buildingNo));
  128.                     data.addElement(studentDO);
  129.                 }
  131.                 sql.setLength(0);
  132.                 sql.append("select count(*) ");
  133.                 this.appendFrom(sql);
  134.                 this.appendWhere(studentRequest, sql);
  135.                 ps = conn.prepareStatement(sql.toString());
  136.                 resultSet = ps.executeQuery();
  138.                 while(resultSet.next()) {
  139.                     int totalCount = resultSet.getInt(1);
  140.                     retDTO.setTotalCount(totalCount);
  141.                 }
  143.                 retDTO.setData(data);
  144.                 retDTO.setPageNow(studentRequest.getpageNow());
  145.                 TableResult var20 = retDTO;
  146.                 return var20;
  147.             }
  149.             return null;
  150.         } catch (SQLException var23) {
  151.             var23.printStackTrace();
  152.         } finally {
  153.             DBUtil.closeResultSet(resultSet);
  154.             DBUtil.closePs(ps);
  155.             DBUtil.closeConn(conn);
  156.         }
  158.         return null;
  159.     }
  161.     public StudentDO retrieveOneById(Long id) {
  162.         StringBuilder sql = new StringBuilder();
  163.         sql.append(" select s.id,s.name,s.gender,s.no,s.dept,s.grade,s.dormitory_id, d.dormitory_building_id  ");
  164.         this.appendFrom(sql);
  165.         sql.append(" where s.id =? ");
  166.         Connection conn = DBUtil.getConn();
  167.         PreparedStatement ps = null;
  168.         ResultSet resultSet = null;
  170.         try {
  171.             if (conn != null) {
  172.                 ps = conn.prepareStatement(sql.toString());
  173.                 ps.setLong(1, id);
  174.                 resultSet = ps.executeQuery();
  175.                 StudentDO studentDO = new StudentDO();
  177.                 while(resultSet.next()) {
  178.                     String no = resultSet.getString("no");
  179.                     String name = resultSet.getString("name");
  180.                     String gender = resultSet.getString("gender");
  181.                     String dept = resultSet.getString("dept");
  182.                     String grade = resultSet.getString("grade");
  183.                     long dormitoryId = resultSet.getLong("dormitory_id");
  184.                     long dormitoryBuildingId = resultSet.getLong("dormitory_building_id");
  185.                     studentDO.setId(id);
  186.                     studentDO.setName(name);
  187.                     studentDO.setGender(gender);
  188.                     studentDO.setNo(no);
  189.                     studentDO.setDept(dept);
  190.                     studentDO.setGrade(grade);
  191.                     studentDO.setDormitoryId(dormitoryId);
  192.                     studentDO.setBuildingId(dormitoryBuildingId);
  193.                 }
  195.                 StudentDO var17 = studentDO;
  196.                 return var17;
  197.             }
  198.         } catch (SQLException var20) {
  199.             var20.printStackTrace();
  200.             return null;
  201.         } finally {
  202.             DBUtil.closeResultSet(resultSet);
  203.             DBUtil.closePs(ps);
  204.             DBUtil.closeConn(conn);
  205.         }
  207.         return null;
  208.     }
  210.     private void appendFrom(StringBuilder sql) {
  211.         sql.append(" from student s  ");
  212.         sql.append(" left join dormitory d on s.dormitory_id = d.id  ");
  213.         sql.append(" left join dormitory_building b on d.dormitory_building_id = b.id  ");
  214.     }
  216.     private void appendWhere(StudentRequest studentRequest, StringBuilder sql) {
  217.         sql.append(" where 1=1 ");
  218.         if (studentRequest.getStudentNo() != null && !"".equals(studentRequest.getStudentNo().trim())) {
  219.             sql.append(" and s.no like '%");
  220.             sql.append(studentRequest.getStudentNo());
  221.             sql.append("%'");
  222.         }
  224.     }
  225. }

service：

  1. //
  2. // Source code recreated from a .class file by IntelliJ IDEA
  3. // (powered by Fernflower decompiler)
  4. //
  6. package com.roadjava.studentroom.service;
  8. import com.roadjava.studentroom.bean.dto.DeleteParam;
  9. import com.roadjava.studentroom.util.DBUtil;
  10. import java.sql.Connection;
  11. import java.sql.PreparedStatement;
  12. import java.sql.SQLException;
  13. import java.util.Iterator;
  14. import java.util.List;
  16. public class BaseServiceSupport {
  17.     public BaseServiceSupport() {
  18.     }
  20.     protected boolean doAdd(String sql, Object... args) {
  21.         Connection conn = DBUtil.getConn();
  22.         PreparedStatement ps = null;
  24.         try {
  25.             if (conn == null) {
  26.                 return false;
  27.             }
  29.             ps = conn.prepareStatement(sql);
  30.             this.populatePs(ps, args);
  31.             boolean var7 = ps.executeUpdate() == 1;
  32.             return var7;
  33.         } catch (SQLException var10) {
  34.             var10.printStackTrace();
  35.         } finally {
  36.             DBUtil.closePs(ps);
  37.             DBUtil.closeConn(conn);
  38.         }
  40.         return false;
  41.     }
  43.     private void populatePs(PreparedStatement ps, Object... args) throws SQLException {
  44.         if (args != null && args.length > 0) {
  45.             for(int i = 0; i < args.length; ++i) {
  46.                 ps.setObject(i + 1, args[i]);
  47.             }
  48.         }
  50.     }
  52.     protected boolean doDelete(List<DeleteParam> deleteParams) {
  53.         Connection conn = DBUtil.getConn();
  54.         boolean result = true;
  56.         try {
  57.             conn.setAutoCommit(false);
  58.             Iterator var5 = deleteParams.iterator();
  60.             while(var5.hasNext()) {
  61.                 DeleteParam deleteParam = (DeleteParam)var5.next();
  62.                 StringBuilder sql = deleteParam.getSql();
  63.                 Long[] ids = deleteParam.getIds();
  64.                 int length = ids.length;
  66.                 for(int i = 0; i < length; ++i) {
  67.                     if (i == length - 1) {
  68.                         sql.append(" ?) ");
  69.                     } else {
  70.                         sql.append("?,");
  71.                     }
  72.                 }
  74.                 PreparedStatement ps = null;
  76.                 try {
  77.                     ps = conn.prepareStatement(sql.toString());
  79.                     for(int i = 0; i < length; ++i) {
  80.                         ps.setLong(i + 1, ids[i]);
  81.                     }
  83.                     System.out.println("ps:" + ps.toString());
  84.                     ps.executeUpdate();
  85.                 } catch (SQLException var24) {
  86.                     var24.printStackTrace();
  87.                     conn.rollback();
  88.                     result = false;
  89.                     break;
  90.                 } finally {
  91.                     DBUtil.closePs(ps);
  92.                 }
  93.             }
  95.             if (result) {
  96.                 conn.commit();
  97.             }
  98.         } catch (Exception var26) {
  99.             result = false;
  100.             var26.printStackTrace();
  102.             try {
  103.                 conn.rollback();
  104.             } catch (SQLException var23) {
  105.                 var23.printStackTrace();
  106.                 result = false;
  107.             }
  108.         } finally {
  109.             DBUtil.closeConn(conn);
  110.         }
  112.         return result;
  113.     }
  115.     protected boolean doUpdate(String sql, Object... args) {
  116.         Connection conn = DBUtil.getConn();
  117.         PreparedStatement ps = null;
  119.         try {
  120.             if (conn != null) {
  121.                 ps = conn.prepareStatement(sql);
  122.                 this.populatePs(ps, args);
  123.                 boolean var7 = ps.executeUpdate() == 1;
  124.                 return var7;
  125.             }
  126.         } catch (SQLException var10) {
  127.             var10.printStackTrace();
  128.             return false;
  129.         } finally {
  130.             DBUtil.closePs(ps);
  131.             DBUtil.closeConn(conn);
  132.         }
  134.         return false;
  135.     }
  136. }
  1. //
  2. // Source code recreated from a .class file by IntelliJ IDEA
  3. // (powered by Fernflower decompiler)
  4. //
  6. package com.roadjava.studentroom.service;
  8. import com.roadjava.studentroom.bean.entity.BuildingDO;
  9. import com.roadjava.studentroom.req.DormitoryBuildingRequest;
  10. import com.roadjava.studentroom.res.TableResult;
  11. import java.util.Vector;
  13. public interface BuildingService {
  14.     boolean add(BuildingDO var1);
  16.     boolean delete(Long[] var1);
  18.     boolean update(BuildingDO var1);
  20.     TableResult<BuildingDO> retrieveList(DormitoryBuildingRequest var1);
  22.     BuildingDO retrieveOneById(Long var1);
  24.     Vector<BuildingDO> getVector(DormitoryBuildingRequest var1);
  25. }
  1. //
  2. // Source code recreated from a .class file by IntelliJ IDEA
  3. // (powered by Fernflower decompiler)
  4. //
  6. package com.roadjava.studentroom.service;
  8. import com.roadjava.studentroom.bean.entity.DormitoryDO;
  9. import com.roadjava.studentroom.req.DormitoryRequest;
  10. import com.roadjava.studentroom.res.TableResult;
  11. import java.util.Vector;
  13. public interface DormitoryService {
  14.     boolean add(DormitoryDO var1);
  16.     boolean delete(Long[] var1);
  18.     boolean update(DormitoryDO var1);
  20.     TableResult<DormitoryDO> retrieveList(DormitoryRequest var1);
  22.     DormitoryDO retrieveOneById(Long var1);
  24.     Vector<DormitoryDO> getVector(DormitoryRequest var1);
  25. }
  1. //
  2. // Source code recreated from a .class file by IntelliJ IDEA
  3. // (powered by Fernflower decompiler)
  4. //
  6. package com.roadjava.studentroom.service;
  8. import com.roadjava.studentroom.bean.entity.ManagerDO;
  10. public interface ManagerService {
  11.     boolean validateManagerInfo(ManagerDO var1);
  12. }
  1. //
  2. // Source code recreated from a .class file by IntelliJ IDEA
  3. // (powered by Fernflower decompiler)
  4. //
  6. package com.roadjava.studentroom.service;
  8. import com.roadjava.studentroom.bean.entity.StudentDO;
  9. import com.roadjava.studentroom.req.StudentRequest;
  10. import com.roadjava.studentroom.res.TableResult;
  12. public interface StudentService {
  13.     boolean add(StudentDO var1);
  15.     boolean delete(Long[] var1);
  17.     boolean update(StudentDO var1);
  19.     TableResult<StudentDO> retrieveList(StudentRequest var1);
  21.     StudentDO retrieveOneById(Long var1);
  22. }

servlet：

  1. //
  2. // Source code recreated from a .class file by IntelliJ IDEA
  3. // (powered by Fernflower decompiler)
  4. //
  6. package com.roadjava.studentroom.servlet;
  8. import com.roadjava.studentroom.bean.entity.BuildingDO;
  9. import com.roadjava.studentroom.req.DormitoryBuildingRequest;
  10. import com.roadjava.studentroom.res.TableResult;
  11. import com.roadjava.studentroom.service.BuildingService;
  12. import com.roadjava.studentroom.service.impl.BuildingServiceImpl;
  13. import java.io.IOException;
  14. import javax.servlet.ServletException;
  15. import javax.servlet.annotation.WebServlet;
  16. import javax.servlet.http.HttpServlet;
  17. import javax.servlet.http.HttpServletRequest;
  18. import javax.servlet.http.HttpServletResponse;
  20. @WebServlet(
  21.     name = "buildingServlet",
  22.     urlPatterns = {"/building"}
  23. )
  24. public class BuildingServlet extends HttpServlet {
  25.     BuildingService service = new BuildingServiceImpl();
  27.     public BuildingServlet() {
  28.     }
  30.     protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
  31.         this.doGet(request, response);
  32.     }
  34.     protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
  35.         request.setAttribute("buildingActive", "active");
  36.         String type = request.getParameter("type");
  37.         String buildingId;
  38.         String no;
  39.         if ("toManage".equals(type)) {
  40.             buildingId = request.getParameter("no");
  41.             no = request.getParameter("pageNow");
  42.             DormitoryBuildingRequest searchRequest = new DormitoryBuildingRequest();
  43.             int pageNow = 1;
  44.             if (no != null && !"".equals(no.trim())) {
  45.                 pageNow = Integer.parseInt(no);
  46.             }
  48.             searchRequest.setPageNow(pageNow);
  49.             searchRequest.setNo(buildingId);
  50.             TableResult<BuildingDO> tableResult = this.service.retrieveList(searchRequest);
  51.             tableResult.setPageNow(pageNow);
  52.             tableResult.setSearchWord(buildingId == null ? "" : buildingId);
  53.             request.setAttribute("tableResult", tableResult);
  54.             request.getRequestDispatcher("/WEB-INF/building/manage.jsp").forward(request, response);
  55.         } else if ("toAdd".equals(type)) {
  56.             request.getRequestDispatcher("/WEB-INF/building/add.jsp").forward(request, response);
  57.         } else {
  58.             String completedDate;
  59.             if ("add".equals(type)) {
  60.                 buildingId = request.getParameter("no");
  61.                 no = request.getParameter("completedDate");
  62.                 completedDate = request.getParameter("buildingType");
  63.                 BuildingDO buildingDO = new BuildingDO();
  64.                 buildingDO.setNo(buildingId);
  65.                 buildingDO.setType(completedDate);
  66.                 buildingDO.setCompletedDate(no);
  67.                 this.service.add(buildingDO);
  68.                 response.sendRedirect(request.getContextPath() + "/building?type=toManage");
  69.             } else if ("toUpdate".equals(type)) {
  70.                 buildingId = request.getParameter("id");
  71.                 no = request.getParameter("pageNow");
  72.                 BuildingDO buildingDO = this.service.retrieveOneById(Long.parseLong(buildingId));
  73.                 request.setAttribute("oneDO", buildingDO);
  74.                 request.setAttribute("pageNow", Integer.parseInt(no));
  75.                 request.getRequestDispatcher("/WEB-INF/building/update.jsp").forward(request, response);
  76.             } else if ("update".equals(type)) {
  77.                 buildingId = request.getParameter("id");
  78.                 no = request.getParameter("no");
  79.                 completedDate = request.getParameter("completedDate");
  80.                 String buildingType = request.getParameter("buildingType");
  81.                 String pageNow = request.getParameter("pageNow");
  82.                 BuildingDO buildingDO = new BuildingDO();
  83.                 buildingDO.setId(Long.parseLong(buildingId));
  84.                 buildingDO.setNo(no);
  85.                 buildingDO.setType(buildingType);
  86.                 buildingDO.setCompletedDate(completedDate);
  87.                 this.service.update(buildingDO);
  88.                 response.sendRedirect(request.getContextPath() + "/building?type=toManage&pageNow=" + pageNow);
  89.             } else if ("delete".equals(type)) {
  90.                 buildingId = request.getParameter("id");
  91.                 this.service.delete(new Long[]{Long.parseLong(buildingId)});
  92.                 response.sendRedirect(request.getContextPath() + "/building?type=toManage");
  93.             }
  94.         }
  96.     }
  97. }
  1. //
  2. // Source code recreated from a .class file by IntelliJ IDEA
  3. // (powered by Fernflower decompiler)
  4. //
  6. package com.roadjava.studentroom.servlet;
  8. import com.roadjava.studentroom.bean.entity.BuildingDO;
  9. import com.roadjava.studentroom.bean.entity.DormitoryDO;
  10. import com.roadjava.studentroom.req.DormitoryBuildingRequest;
  11. import com.roadjava.studentroom.req.DormitoryRequest;
  12. import com.roadjava.studentroom.res.ResultDTO;
  13. import com.roadjava.studentroom.res.TableResult;
  14. import com.roadjava.studentroom.service.BuildingService;
  15. import com.roadjava.studentroom.service.DormitoryService;
  16. import com.roadjava.studentroom.service.impl.BuildingServiceImpl;
  17. import com.roadjava.studentroom.service.impl.DormitoryServiceImpl;
  18. import com.roadjava.studentroom.util.ResponseUtil;
  19. import java.io.IOException;
  20. import java.util.Vector;
  21. import javax.servlet.ServletException;
  22. import javax.servlet.annotation.WebServlet;
  23. import javax.servlet.http.HttpServlet;
  24. import javax.servlet.http.HttpServletRequest;
  25. import javax.servlet.http.HttpServletResponse;
  27. @WebServlet(
  28.     name = "dormitoryServlet",
  29.     urlPatterns = {"/dormitory"}
  30. )
  31. public class DormitoryServlet extends HttpServlet {
  32.     private DormitoryService service = new DormitoryServiceImpl();
  33.     private BuildingService buildingService = new BuildingServiceImpl();
  35.     public DormitoryServlet() {
  36.     }
  38.     protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
  39.         this.doGet(request, response);
  40.     }
  42.     protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
  43.         request.setAttribute("dormitoryActive", "active");
  44.         String type = request.getParameter("type");
  45.         String buildingId;
  46.         String no;
  47.         if ("toManage".equals(type)) {
  48.             buildingId = request.getParameter("no");
  49.             no = request.getParameter("pageNow");
  50.             DormitoryRequest searchRequest = new DormitoryRequest();
  51.             int pageNow = 1;
  52.             if (no != null && !"".equals(no.trim())) {
  53.                 pageNow = Integer.parseInt(no);
  54.             }
  56.             searchRequest.setPageNow(pageNow);
  57.             searchRequest.setNo(buildingId);
  58.             TableResult<DormitoryDO> tableResult = this.service.retrieveList(searchRequest);
  59.             tableResult.setPageNow(pageNow);
  60.             tableResult.setSearchWord(buildingId == null ? "" : buildingId);
  61.             request.setAttribute("tableResult", tableResult);
  62.             request.getRequestDispatcher("/WEB-INF/dormitory/manage.jsp").forward(request, response);
  63.         } else if ("toAdd".equals(type)) {
  64.             DormitoryBuildingRequest dormitoryBuildingRequest = new DormitoryBuildingRequest();
  65.             dormitoryBuildingRequest.setPageSize(-1);
  66.             Vector<BuildingDO> vector = this.buildingService.getVector(dormitoryBuildingRequest);
  67.             request.setAttribute("buildings", vector);
  68.             request.getRequestDispatcher("/WEB-INF/dormitory/add.jsp").forward(request, response);
  69.         } else {
  70.             DormitoryDO dormitoryDO;
  71.             if ("add".equals(type)) {
  72.                 buildingId = request.getParameter("no");
  73.                 no = request.getParameter("buildingId");
  74.                 dormitoryDO = new DormitoryDO();
  75.                 dormitoryDO.setNo(buildingId);
  76.                 dormitoryDO.setDormitoryBuildingId(Long.parseLong(no));
  77.                 this.service.add(dormitoryDO);
  78.                 response.sendRedirect(request.getContextPath() + "/dormitory?type=toManage");
  79.             } else if ("toUpdate".equals(type)) {
  80.                 buildingId = request.getParameter("id");
  81.                 no = request.getParameter("pageNow");
  82.                 dormitoryDO = this.service.retrieveOneById(Long.parseLong(buildingId));
  83.                 request.setAttribute("oneDO", dormitoryDO);
  84.                 request.setAttribute("pageNow", Integer.parseInt(no));
  85.                 DormitoryBuildingRequest dormitoryBuildingRequest = new DormitoryBuildingRequest();
  86.                 dormitoryBuildingRequest.setPageSize(-1);
  87.                 Vector<BuildingDO> vector = this.buildingService.getVector(dormitoryBuildingRequest);
  88.                 request.setAttribute("buildings", vector);
  89.                 request.getRequestDispatcher("/WEB-INF/dormitory/update.jsp").forward(request, response);
  90.             } else if ("update".equals(type)) {
  91.                 buildingId = request.getParameter("id");
  92.                 no = request.getParameter("no");
  93.                 String buildingId = request.getParameter("buildingId");
  94.                 String pageNow = request.getParameter("pageNow");
  95.                 DormitoryDO dormitoryDO = new DormitoryDO();
  96.                 dormitoryDO.setId(Long.parseLong(buildingId));
  97.                 dormitoryDO.setNo(no);
  98.                 dormitoryDO.setDormitoryBuildingId(Long.parseLong(buildingId));
  99.                 this.service.update(dormitoryDO);
  100.                 response.sendRedirect(request.getContextPath() + "/dormitory?type=toManage&pageNow=" + pageNow);
  101.             } else if ("delete".equals(type)) {
  102.                 buildingId = request.getParameter("id");
  103.                 this.service.delete(new Long[]{Long.parseLong(buildingId)});
  104.                 response.sendRedirect(request.getContextPath() + "/dormitory?type=toManage");
  105.             } else if ("getDormitoriesByBuildingId".equals(type)) {
  106.                 buildingId = request.getParameter("buildingId");
  107.                 DormitoryRequest dormitoryRequest = new DormitoryRequest();
  108.                 dormitoryRequest.setPageSize(-1);
  109.                 dormitoryRequest.setDormitoryBuildingId(Long.parseLong(buildingId));
  110.                 Vector<DormitoryDO> dormitoryDOS = this.service.getVector(dormitoryRequest);
  111.                 ResponseUtil.respAppJson(response, ResultDTO.buildSuccess(dormitoryDOS));
  112.             }
  113.         }
  115.     }
  116. }
  1. //
  2. // Source code recreated from a .class file by IntelliJ IDEA
  3. // (powered by Fernflower decompiler)
  4. //
  6. package com.roadjava.studentroom.servlet;
  8. import com.roadjava.studentroom.bean.entity.ManagerDO;
  9. import com.roadjava.studentroom.res.ResultDTO;
  10. import com.roadjava.studentroom.service.ManagerService;
  11. import com.roadjava.studentroom.service.impl.ManagerServiceImpl;
  12. import com.roadjava.studentroom.util.ResponseUtil;
  13. import java.io.IOException;
  14. import javax.servlet.ServletException;
  15. import javax.servlet.annotation.WebServlet;
  16. import javax.servlet.http.HttpServlet;
  17. import javax.servlet.http.HttpServletRequest;
  18. import javax.servlet.http.HttpServletResponse;
  20. @WebServlet(
  21.     name = "loginServlet",
  22.     urlPatterns = {"/loginServlet"}
  23. )
  24. public class LoginServlet extends HttpServlet {
  25.     ManagerService managerService = new ManagerServiceImpl();
  27.     public LoginServlet() {
  28.     }
  30.     protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
  31.         this.doGet(request, response);
  32.     }
  34.     protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
  35.         String type = request.getParameter("type");
  36.         if ("trueLogin".equals(type)) {
  37.             String uname = request.getParameter("uname");
  38.             String pwd = request.getParameter("pwd");
  39.             if (uname == null || "".equals(uname.trim()) || pwd == null || "".equals(pwd.trim())) {
  40.                 ResultDTO<Object> dto = ResultDTO.buildFailure("用户名或密码不能为空");
  41.                 ResponseUtil.respAppJson(response, dto);
  42.                 return;
  43.             }
  45.             ManagerDO managerDO = new ManagerDO();
  46.             managerDO.setUserName(uname);
  47.             managerDO.setPwd(pwd);
  48.             boolean b = this.managerService.validateManagerInfo(managerDO);
  49.             if (b) {
  50.                 request.getSession().setAttribute("manager", managerDO);
  51.                 ResponseUtil.respAppJson(response, ResultDTO.buildEmptySuccess());
  52.             } else {
  53.                 ResponseUtil.respAppJson(response, ResultDTO.buildFailure("用户名或密码不正确"));
  54.             }
  55.         } else {
  56.             request.getRequestDispatcher("/WEB-INF/login.jsp").forward(request, response);
  57.         }
  59.     }
  60. }
  1. //
  2. // Source code recreated from a .class file by IntelliJ IDEA
  3. // (powered by Fernflower decompiler)
  4. //
  6. package com.roadjava.studentroom.servlet;
  8. import com.roadjava.studentroom.service.ManagerService;
  9. import com.roadjava.studentroom.service.impl.ManagerServiceImpl;
  10. import java.io.IOException;
  11. import javax.servlet.ServletException;
  12. import javax.servlet.annotation.WebServlet;
  13. import javax.servlet.http.HttpServlet;
  14. import javax.servlet.http.HttpServletRequest;
  15. import javax.servlet.http.HttpServletResponse;
  17. @WebServlet(
  18.     name = "managerServlet",
  19.     urlPatterns = {"/manager"}
  20. )
  21. public class ManagerServlet extends HttpServlet {
  22.     ManagerService managerService = new ManagerServiceImpl();
  24.     public ManagerServlet() {
  25.     }
  27.     protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
  28.         this.doGet(request, response);
  29.     }
  31.     protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
  32.         request.setAttribute("managerActive", "active");
  33.         String type = request.getParameter("type");
  34.         if ("logout".equals(type)) {
  35.             request.getSession().invalidate();
  36.             response.sendRedirect(request.getContextPath() + "/index.jsp");
  37.         }
  39.     }
  40. }
  1. //
  2. // Source code recreated from a .class file by IntelliJ IDEA
  3. // (powered by Fernflower decompiler)
  4. //
  6. package com.roadjava.studentroom.servlet;
  8. import com.roadjava.studentroom.bean.entity.BuildingDO;
  9. import com.roadjava.studentroom.bean.entity.StudentDO;
  10. import com.roadjava.studentroom.req.DormitoryBuildingRequest;
  11. import com.roadjava.studentroom.req.StudentRequest;
  12. import com.roadjava.studentroom.res.ResultDTO;
  13. import com.roadjava.studentroom.res.TableResult;
  14. import com.roadjava.studentroom.service.BuildingService;
  15. import com.roadjava.studentroom.service.DormitoryService;
  16. import com.roadjava.studentroom.service.StudentService;
  17. import com.roadjava.studentroom.service.impl.BuildingServiceImpl;
  18. import com.roadjava.studentroom.service.impl.DormitoryServiceImpl;
  19. import com.roadjava.studentroom.service.impl.StudentServiceImpl;
  20. import com.roadjava.studentroom.util.ResponseUtil;
  21. import java.io.IOException;
  22. import java.util.Vector;
  23. import javax.servlet.ServletException;
  24. import javax.servlet.annotation.WebServlet;
  25. import javax.servlet.http.HttpServlet;
  26. import javax.servlet.http.HttpServletRequest;
  27. import javax.servlet.http.HttpServletResponse;
  29. @WebServlet(
  30.     name = "studentServlet",
  31.     urlPatterns = {"/student"}
  32. )
  33. public class StudentServlet extends HttpServlet {
  34.     private StudentService service = new StudentServiceImpl();
  35.     private DormitoryService dormitoryService = new DormitoryServiceImpl();
  36.     private BuildingService buildingService = new BuildingServiceImpl();
  38.     public StudentServlet() {
  39.     }
  41.     protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
  42.         this.doGet(request, response);
  43.     }
  45.     protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
  46.         request.setAttribute("studentActive", "active");
  47.         String type = request.getParameter("type");
  48.         String id;
  49.         String pageNow;
  50.         if ("toManage".equals(type)) {
  51.             id = request.getParameter("no");
  52.             pageNow = request.getParameter("pageNow");
  53.             StudentRequest searchRequest = new StudentRequest();
  54.             int pageNow = 1;
  55.             if (pageNow != null && !"".equals(pageNow.trim())) {
  56.                 pageNow = Integer.parseInt(pageNow);
  57.             }
  59.             searchRequest.setPageNow(pageNow);
  60.             searchRequest.setStudentNo(id);
  61.             TableResult<StudentDO> tableResult = this.service.retrieveList(searchRequest);
  62.             tableResult.setPageNow(pageNow);
  63.             tableResult.setSearchWord(id == null ? "" : id);
  64.             request.setAttribute("tableResult", tableResult);
  65.             request.getRequestDispatcher("/WEB-INF/student/manage.jsp").forward(request, response);
  66.         } else if ("toAdd".equals(type)) {
  67.             DormitoryBuildingRequest dormitoryBuildingRequest = new DormitoryBuildingRequest();
  68.             dormitoryBuildingRequest.setPageSize(-1);
  69.             Vector<BuildingDO> vector = this.buildingService.getVector(dormitoryBuildingRequest);
  70.             request.setAttribute("buildings", vector);
  71.             request.getRequestDispatcher("/WEB-INF/student/add.jsp").forward(request, response);
  72.         } else if ("add".equals(type)) {
  73.             try {
  74.                 StudentDO studentDO = this.buildBasicStudent(request);
  75.                 boolean b = this.service.add(studentDO);
  76.                 if (b) {
  77.                     ResponseUtil.respAppJson(response, ResultDTO.buildSuccess("添加成功"));
  78.                 } else {
  79.                     ResponseUtil.respAppJson(response, ResultDTO.buildFailure("添加失败"));
  80.                 }
  81.             } catch (Exception var10) {
  82.                 var10.printStackTrace();
  83.                 ResponseUtil.respAppJson(response, ResultDTO.buildFailure(var10.getMessage()));
  84.             }
  85.         } else if ("toUpdate".equals(type)) {
  86.             id = request.getParameter("id");
  87.             pageNow = request.getParameter("pageNow");
  88.             StudentDO dormitoryDO = this.service.retrieveOneById(Long.parseLong(id));
  89.             request.setAttribute("oneDO", dormitoryDO);
  90.             request.setAttribute("pageNow", Integer.parseInt(pageNow));
  91.             DormitoryBuildingRequest dormitoryBuildingRequest = new DormitoryBuildingRequest();
  92.             dormitoryBuildingRequest.setPageSize(-1);
  93.             Vector<BuildingDO> vector = this.buildingService.getVector(dormitoryBuildingRequest);
  94.             request.setAttribute("buildings", vector);
  95.             request.getRequestDispatcher("/WEB-INF/student/update.jsp").forward(request, response);
  96.         } else if ("update".equals(type)) {
  97.             try {
  98.                 id = request.getParameter("id");
  99.                 StudentDO studentDO = this.buildBasicStudent(request);
  100.                 studentDO.setId(Long.parseLong(id));
  101.                 boolean b = this.service.update(studentDO);
  102.                 if (b) {
  103.                     ResponseUtil.respAppJson(response, ResultDTO.buildSuccess("更新成功"));
  104.                 } else {
  105.                     ResponseUtil.respAppJson(response, ResultDTO.buildFailure("更新失败"));
  106.                 }
  107.             } catch (Exception var9) {
  108.                 var9.printStackTrace();
  109.                 ResponseUtil.respAppJson(response, ResultDTO.buildFailure(var9.getMessage()));
  110.             }
  111.         } else if ("delete".equals(type)) {
  112.             id = request.getParameter("id");
  113.             this.service.delete(new Long[]{Long.parseLong(id)});
  114.             response.sendRedirect(request.getContextPath() + "/student?type=toManage");
  115.         }
  117.     }
  119.     private StudentDO buildBasicStudent(HttpServletRequest request) {
  120.         String no = request.getParameter("no");
  121.         String name = request.getParameter("name");
  122.         String gender = request.getParameter("gender");
  123.         String dept = request.getParameter("dept");
  124.         String grade = request.getParameter("grade");
  125.         String dormitoryId = request.getParameter("dormitoryId");
  126.         StudentDO studentDO = new StudentDO();
  127.         studentDO.setNo(no);
  128.         studentDO.setName(name);
  129.         studentDO.setGender(gender);
  130.         studentDO.setDept(dept);
  131.         studentDO.setGrade(grade);
  132.         studentDO.setDormitoryId(Long.parseLong(dormitoryId));
  133.         return studentDO;
  134.     }
  135. }

util：

  1. //
  2. // Source code recreated from a .class file by IntelliJ IDEA
  3. // (powered by Fernflower decompiler)
  4. //
  6. package com.roadjava.studentroom.util;
  8. import java.util.Date;
  10. public class Constants {
  11.     public static final Integer PAGE_SIZE = 10;
  12.     public static final String MIDDLE_LINE = "-";
  14.     public Constants() {
  15.     }
  17.     public static void main(String[] args) {
  18.         Date date = new Date();
  19.         System.out.println(date);
  20.         System.out.println(date.getTime());
  21.         System.out.println(System.currentTimeMillis());
  22.     }
  23. }
  2.   // IntelliJ API Decompiler stub source generated from a class file
  3.   // Implementation of methods is not available
  5. package com.roadjava.studentroom.util;
  7. public class DBUtil {
  8.     private static final java.lang.String URL = "jdbc:mysql://localhost:3306/dormitory?serverTimezone=GMT%2B8&useUnicode=true&characterEncoding=utf-8&useSSL=false";
  9.     private static final java.lang.String DRIVER = "com.mysql.jdbc.Driver";
  10.     private static final java.lang.String USER_NAME = "输入自己的数据库名";
  11.     private static final java.lang.String PWD = "输入自己的数据库密码";
  13.     public DBUtil() { /* compiled code */ }
  15.     public static java.sql.Connection getConn() { /* compiled code */ }
  17.     public static void closeResultSet(java.sql.ResultSet resultSet) { /* compiled code */ }
  19.     public static void closePs(java.sql.PreparedStatement ps) { /* compiled code */ }
  21.     public static void closeConn(java.sql.Connection conn) { /* compiled code */ }
  22. }
  1. //
  2. // Source code recreated from a .class file by IntelliJ IDEA
  3. // (powered by Fernflower decompiler)
  4. //
  6. package com.roadjava.studentroom.util;
  8. import com.alibaba.fastjson.JSON;
  9. import java.io.IOException;
  10. import java.io.PrintWriter;
  11. import javax.servlet.http.HttpServletResponse;
  13. public class ResponseUtil {
  14.     public ResponseUtil() {
  15.     }
  17.     public static void respTxtHtml(HttpServletResponse resp, String result) {
  18.         resp.setCharacterEncoding("utf-8");
  19.         resp.setContentType("text/html;charset=utf-8");
  20.         write(resp, result);
  21.     }
  23.     private static void write(HttpServletResponse resp, String result) {
  24.         try {
  25.             Throwable var2 = null;
  26.             Object var3 = null;
  28.             try {
  29.                 PrintWriter writer = resp.getWriter();
  31.                 try {
  32.                     writer.print(result);
  33.                     writer.flush();
  34.                 } finally {
  35.                     if (writer != null) {
  36.                         writer.close();
  37.                     }
  39.                 }
  40.             } catch (Throwable var12) {
  41.                 if (var2 == null) {
  42.                     var2 = var12;
  43.                 } else if (var2 != var12) {
  44.                     var2.addSuppressed(var12);
  45.                 }
  47.                 throw var2;
  48.             }
  49.         } catch (IOException var13) {
  50.             var13.printStackTrace();
  51.         }
  53.     }
  55.     public static void respTxtPlain(HttpServletResponse resp, String result) {
  56.         resp.setCharacterEncoding("utf-8");
  57.         resp.setContentType("text/plain;charset=utf-8");
  58.         write(resp, result);
  59.     }
  61.     public static void respAppJson(HttpServletResponse resp, Object obj) {
  62.         resp.setCharacterEncoding("utf-8");
  63.         resp.setContentType("application/json;charset=utf-8");
  64.         write(resp, JSON.toJSONString(obj));
  65.     }
  66. }

7.Mysql模块：

7.1 dormitory：

7.2 dormitory_building:

7.3 manager:

7.4 student:

7.5 MySql代码：

  1. DROP TABLE IF EXISTS `dormitory`;
  2. CREATE TABLE `dormitory` (
  3.   `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
  4.   `no` varchar(50) NOT NULL COMMENT '宿舍编号',
  5.   `dormitory_building_id` bigint(20) NOT NULL COMMENT '外键,宿舍所在楼id',
  6.   PRIMARY KEY (`id`)
  7. ) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8;
  9. -- ----------------------------
  10. -- Records of dormitory
  11. -- ----------------------------
  12. INSERT INTO `dormitory` VALUES ('1', '11', '3');
  13. INSERT INTO `dormitory` VALUES ('2', '12', '3');
  14. INSERT INTO `dormitory` VALUES ('3', '13', '3');
  15. INSERT INTO `dormitory` VALUES ('4', '14', '3');
  16. INSERT INTO `dormitory` VALUES ('5', '14', '2');
  18. -- ----------------------------
  19. -- Table structure for dormitory_building
  20. -- ----------------------------
  21. DROP TABLE IF EXISTS `dormitory_building`;
  22. CREATE TABLE `dormitory_building` (
  23.   `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
  24.   `no` varchar(50) NOT NULL COMMENT '宿舍楼编号',
  25.   `completed_date` date NOT NULL COMMENT '宿舍楼建成时间',
  26.   `type` char(1) NOT NULL COMMENT '宿舍楼类型:M:男生宿舍,F:女生宿舍',
  27.   PRIMARY KEY (`id`)
  28. ) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8;
  30. -- ----------------------------
  31. -- Records of dormitory_building
  32. -- ----------------------------
  33. INSERT INTO `dormitory_building` VALUES ('1', '1', '2022-07-16', 'M');
  34. INSERT INTO `dormitory_building` VALUES ('2', '2', '2022-07-07', 'M');
  35. INSERT INTO `dormitory_building` VALUES ('3', '3', '2022-07-14', 'F');
  37. -- ----------------------------
  38. -- Table structure for manager
  39. -- ----------------------------
  40. DROP TABLE IF EXISTS `manager`;
  41. CREATE TABLE `manager` (
  42.   `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
  43.   `user_name` varchar(50) NOT NULL COMMENT '登录用户名',
  44.   `pwd` varchar(50) NOT NULL COMMENT '密码',
  45.   PRIMARY KEY (`id`)
  46. ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COMMENT='管理员表';
  48. -- ----------------------------
  49. -- Records of manager
  50. -- ----------------------------
  51. INSERT INTO `manager` VALUES ('1', 'admin', 'admin');
  53. -- ----------------------------
  54. -- Table structure for student
  55. -- ----------------------------
  56. DROP TABLE IF EXISTS `student`;
  57. CREATE TABLE `student` (
  58.   `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
  59.   `no` varchar(50) NOT NULL COMMENT '学号',
  60.   `name` varchar(50) NOT NULL COMMENT '学生姓名',
  61.   `gender` char(1) NOT NULL COMMENT '性别:M:男,F:女',
  62.   `dept` varchar(100) NOT NULL COMMENT '院系',
  63.   `grade` varchar(100) NOT NULL COMMENT '班级',
  64.   `dormitory_id` bigint(20) NOT NULL COMMENT '外键,宿舍id',
  65.   PRIMARY KEY (`id`),
  66.   UNIQUE KEY `idx_no` (`no`)
  67. ) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8;
  69. -- ----------------------------
  70. -- Records of student
  71. -- ----------------------------
  72. INSERT INTO `student` VALUES ('1', '1001', '冰墩墩', 'M', 'jisuanji', '1', '5');
  73. INSERT INTO `student` VALUES ('2', '1003', 'wangmeili', 'F', '化学系', '111', '4');
  74. INSERT INTO `student` VALUES ('3', '1002', '王大锤', 'M', '化学系', '111', '5');

注：项目根据王不二实战项目

标签： java maven tomcat
本文转载自: https://blog.csdn.net/weixin_61684487/article/details/127494395
版权归原作者 狐狸先森。 所有， 如有侵权，请联系我们删除。
登录后发布评论

“学生宿舍管理系统”的评论:

还没有评论
关于作者
...
overfit同步小助手
文章同步
相关阅读

网络安全法-网络运行安全

使用selenium/drissionpage时如何阻止chrome自动跳转http到https

docker desktop 里部署的Open WebUI 管理员密码忘记了的处理方法

在ubuntu20.04中搭建onsite比赛运行环境

利用开源的低代码表单设计器FcDesigner高效管理和渲染复杂表单结构

Kafka学习笔记

【前端】浏览器输入url到页面呈现发生了什么？