📄 employeequeryc.java
字号:
package com.lovo.servlet.vicky;
import java.io.IOException;
import java.util.Vector;
import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import com.lovo.bo.vicky.EmpBo;
import com.lovo.vo.vicky.EmpVoQ;
import com.lovo.vo.vicky.QueryVo;
public class EmployeeQueryC extends HttpServlet {
/**
*
*/
private static final long serialVersionUID = 1L;
public void doGet(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {
doPost(request, response);
String button = request.getParameter("submit");
String pId = request.getParameter("position");
String dId = request.getParameter("department");
String s = new String(button.getBytes("ISO-8859-1"), "utf-8");
QueryVo vo = new QueryVo();
vo.setPId(pId);
vo.setDId(dId);
if (s.equals("查询")) {
request.getSession().setAttribute("curPos",
request.getParameter("position"));
request.getSession().setAttribute("curDept",
request.getParameter("department"));
request.getSession().setAttribute("pageC", 0);
EmpBo bo = new EmpBo();
Vector<QueryVo> voV = bo.cQuery(vo, 0);
int count = bo.cCount(vo);
System.out.println(count);
request.getSession().setAttribute("query", voV);
request.getSession().setAttribute("countC", count);
response.sendRedirect("../emp/vicky/cemployeequery.jsp");
}
if (s.equals("删除")) {
String[] str = request.getParameterValues("check1");
if (str != null) {
EmpBo bo = new EmpBo();
Vector<QueryVo> queryV = bo.delete(str);
int count = bo.cCount(vo);
request.getSession().setAttribute("countC", count);
request.getSession().setAttribute("query", queryV);
response.sendRedirect("../emp/vicky/cemployeequery.jsp");
} else {
request.getSession().setAttribute("delete", "delete");
response.sendRedirect("../emp/vicky/cemployeequery.jsp");
}
}
// 查询详细信息
if (s.equals("详细查询")) {
String[] str = request.getParameterValues("check1");
System.out.println(str);
if (str == null || str.length > 1) {
request.getSession().setAttribute("delete", "return");
response.sendRedirect("../emp/vicky/cemployeequery.jsp");
} else {
EmpVoQ empVo = new EmpVoQ();
empVo.setId(str[0]);
EmpBo bo = new EmpBo();
empVo = bo.particularSelect(empVo);
request.getSession().setAttribute("selectAll", empVo);
response.sendRedirect("../emp/vicky/queryemployee.jsp");
}
}
if (s.equals("返回")) {
response.sendRedirect("../emp/vicky/employeequery.jsp");
}
if (s.equals("首页")) {
EmpBo bo = new EmpBo();
Vector<QueryVo> queryV = bo.cQuery(vo, 0);
request.getSession().setAttribute("pageC", 0);
request.getSession().setAttribute("query", queryV);
response.sendRedirect("../emp/vicky/cemployeequery.jsp");
}
if (s.equals("上一页")) {
int i = (Integer) request.getSession().getAttribute("pageC");
if (i != 0) {
i = i - 14;
EmpBo bo = new EmpBo();
Vector<QueryVo> queryV = bo.cQuery(vo, i);
request.getSession().setAttribute("query", queryV);
request.getSession().setAttribute("pageC", i);
}
response.sendRedirect("../emp/vicky/cemployeequery.jsp");
}
if (s.equals("下一页")) {
int i = (Integer) request.getSession().getAttribute("pageC");
EmpBo bo = new EmpBo();
// int count = bo.cCount(vo);//
int count = (Integer) request.getSession().getAttribute("countC");
System.out.println(count);
if (i != (count / 14) * 14) {
i = i + 14;
Vector<QueryVo> queryV = bo.cQuery(vo, i);
request.getSession().setAttribute("query", queryV);
request.getSession().setAttribute("pageC", i);
}
response.sendRedirect("../emp/vicky/cemployeequery.jsp");
}
// 显示最后一页的信息
if (s.equals("尾页")) {
EmpBo bo = new EmpBo();
int count = (Integer) request.getSession().getAttribute("countC");
if (count % 14 == 0) {
count = count - 14;
} else {
count = count / 14;
count = count * 14;
}
Vector<QueryVo> queryV = bo.cQuery(vo, count);
request.getSession().setAttribute("query", queryV);
request.getSession().setAttribute("pageC", (count / 14) * 14);
response.sendRedirect("../emp/vicky/cemployeequery.jsp");
}
if(s.equals("新增")){
request.getSession().setAttribute("bool", null);
response.sendRedirect("../emp/employeeRegister.jsp");
}
if(s.equals("修改")){
System.out.println("修改");
String[] str = request.getParameterValues("check1");
System.out.println(str);
if (str == null || str.length > 1) {
request.getSession().setAttribute("delete", "return");
response.sendRedirect("../emp/vicky/cemployeequery.jsp");
} else {
EmpVoQ empVo = new EmpVoQ();
empVo.setId(str[0]);
EmpBo bo = new EmpBo();
empVo = bo.particularSelect(empVo);
request.getSession().setAttribute("edit", empVo);
response.sendRedirect("../emp/basicInfoEdit.jsp");
}
}
}
public void doPost(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {
}
}
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -