在实现查找待审批请假单中出现的问题
通过调试,可以在idea中显示出数据库存在的数据:
相关截图:

但是在浏览器中输入http://localhost/api/leave/list?eid=1
却提示500错误。
相关截图:

对于浏览器中提示出现问题的代码:
相关代码:
package com.imooc.oa.controller;
import com.imooc.oa.entity.LeaveForm;
import com.imooc.oa.service.LeaveFormService;
import com.imooc.oa.utils.ResponseUtils;
import javax.servlet.ServletException;
import javax.servlet.annotation.WebServlet;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import java.io.IOException;
import java.util.Date;
import java.util.List;
import java.util.Map;
@WebServlet("/api/leave/*")
public class LeaveFormServlet extends HttpServlet {
private LeaveFormService leaveFormService = new LeaveFormService();
@Override
protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
this.doPost(request,response);
}
@Override
protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
request.setCharacterEncoding("UTF-8");
response.setContentType("application/json;charset=utf-8");
//http://localhost/api/leave/create
String uri = request.getRequestURI();
String methodName = uri.substring(uri.lastIndexOf("/") + 1);
if (methodName.equals("create")) {
this.create(request, response);
} else if (methodName.equals("list")) {
this.list(request, response);
} else if (methodName.equals("audit")) {
}
}
//创建请假单
private void create(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
String strEmployeeId = request.getParameter("eid");
String formType = request.getParameter("formType");
//从1970年到现在的毫秒数
String startTime = request.getParameter("startTime");
String endTime = request.getParameter("endTime");
String reason = request.getParameter("reason");
LeaveForm form = new LeaveForm();
form.setEmployeeId(Long.parseLong(strEmployeeId));
form.setStartTime(new Date(Long.parseLong(startTime)));
form.setEndTime(new Date(Long.parseLong(endTime)));
form.setFormType(Integer.parseInt(formType));
form.setReason(reason);
form.setCreateTime(new Date());
ResponseUtils resp = null;
try {
leaveFormService.createLeaveForm(form);
resp = new ResponseUtils();
} catch (Exception e) {
e.printStackTrace();
resp = new ResponseUtils(e.getClass().getSimpleName(), e.getMessage());
}
response.getWriter().println(resp.toJsonString());
}
private void list(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException{
String employeeId = request.getParameter("eid");
ResponseUtils resp=null;
try {
List<Map> formList = leaveFormService.getLeaveFormList("process", Long.parseLong(employeeId));
resp=new ResponseUtils().put("list",formList);
} catch (NumberFormatException e) {
e.printStackTrace();
resp=new ResponseUtils(e.getClass().getSimpleName(),e.getMessage());
}
response.getWriter().println(resp.toJsonString());
}
}24
收起
正在回答 回答被采纳积分+1
1回答
2023版Java工程师
- 参与学习 人
- 提交作业 8788 份
- 解答问题 9886 个
综合就业常年第一,编程排行常年霸榜,北上广深月薪过万! 不需要基础,无需脱产即可学习,只要你有梦想,想高薪! 全新升级:技术栈升级(包含VUE3.0,ES6,Git)+项目升级(前后端联调与功能升级)
了解课程

恭喜解决一个难题,获得1积分~
来为老师/同学的回答评分吧
0 星