📄 schedule.java
字号:
package com.soft.schedule.control;
import java.io.IOException;
import java.sql.SQLException;
import java.util.List;
import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import com.soft.deptmgr.dao.DeptInfoDAO;
import com.soft.schedule.dao.scheduleDAO;
import com.soft.staff.dao.StaffDAO;
import com.soft.usermgr.dao.UserDAO;
import com.soft.vo.ScheduleInfo;
import com.soft.vo.UserInfo;
public class Schedule extends HttpServlet {
public void doGet(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {
doPost(request,response);
}
public void doPost(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {
String Scheduleid=request.getParameter("Scheduleid");
String ScheduleId=request.getParameter("ScheduleId"); //删除schedule所需参数
int empid =Integer.parseInt(request.getSession().getAttribute("employeeid").toString());
UserDAO ud=new UserDAO();
List li=ud.searchUser(empid);
scheduleDAO sdo=new scheduleDAO();
List perschList=sdo.searchPerSchedule(empid);
request.setAttribute("perschList",perschList);
request.setAttribute("username",li);
request.setAttribute("empid", empid);
System.out.println("employeeid======"+empid+"list:"+perschList.size());
List userlist=ud.searchAllUsers();
request.setAttribute("userlist", userlist);
DeptInfoDAO dep=new DeptInfoDAO();
List depli=dep.getAllDepts();
request.setAttribute("deplist", depli); //用户信息，部门信息参数
String pass=request.getParameter("href");
if(pass!=null)
{
if(Integer.parseInt(pass)==11)
{
request.getRequestDispatcher("add_arrangement.jsp").forward(request, response);
}
/*else if(Integer.parseInt(pass)==22)
{
request.getRequestDispatcher("arrangement_list.jsp").forward(request, response);
}*/
else if(Integer.parseInt(pass)==33)
{
request.getRequestDispatcher("agency_setting.jsp").forward(request, response);
}
}
String postCode=request.getParameter("postCode");
if(postCode!=null)
{
if(postCode.equals("save"))
{
String meetingpeople=request.getParameter("people");
String[] peoples=meetingpeople.split(",");
int peopleid[]=new int[peoples.length];
for(int i=0;i<peoples.length;i++)
{
peopleid[i]=Integer.parseInt(peoples[i]);
System.out.println(peopleid[i]);
}
String theme=request.getParameter("theme");
String content=request.getParameter("content");
String starttime=request.getParameter("starttime");
String endtime=request.getParameter("endtime");
scheduleDAO sch=new scheduleDAO();
try {
int i=sch.insertSchedule(empid,starttime,endtime,content,0,peopleid,theme); //修改
if(i>0)
{
request.getSession().setAttribute("flag","succ");
request.getRequestDispatcher("add_arrangement.jsp").forward(request, response);
}
else
{ request.getSession().setAttribute("flag","fail");
request.getRequestDispatcher("add_arrangement.jsp").forward(request, response);
}
} catch (SQLException e) {
e.printStackTrace();
}
}
else if(postCode.equals("setting"))
{
String meetingpeople=request.getParameter("people");
int peopleid=Integer.parseInt(meetingpeople);
scheduleDAO sch=new scheduleDAO();
try {
int i=sch.insertScheDelegete(empid,peopleid);
if(i>0)
{
request.getSession().setAttribute("flag","succ");
request.getRequestDispatcher("agency_setting.jsp").forward(request, response);
}
else
{
request.getSession().setAttribute("flag","fail");
request.getRequestDispatcher("agency_setting.jsp").forward(request, response);
}
} catch (SQLException e) {
e.printStackTrace();
}
}
else if(postCode.equals("search"))
{
int page=1;
int p=1;
int pagecount=1;
String isfinished=null;
try{pagecount=Integer.parseInt(request.getAttribute("pagecount").toString());
}
catch(Exception e1){}
try{
String strPage=request.getParameter("curpage");
p=Integer.parseInt(strPage);
}catch(Exception e){}
if(p>1)
page=p;
String htdate="wrong";
try{ htdate=request.getParameter("htdate");}catch(Exception es){htdate="wrong";}
String done=request.getParameter("done");
if(done.equals("all"))
isfinished=null;
if(done.equals("done"))
isfinished="1";
if(done.equals("undone"))
isfinished="0";
scheduleDAO sd=new scheduleDAO();
sd.setCurPage(page);
List lt=sd.searchSchedule(empid, isfinished, htdate);
request.setAttribute("htdate",htdate);
request.setAttribute("done",done);
request.setAttribute("rowscount",sd.getPageRowsCount());
request.setAttribute("curpage",page);
request.setAttribute("pagecount",sd.getPageCount());
request.setAttribute("schedulelist",lt);
if(lt.size()>0)
{
request.getRequestDispatcher("arrangement_list.jsp").forward(request, response);
}
else
{
request.getRequestDispatcher("arrangement_list.jsp").forward(request, response);
}
}
// 删除和修改schedule
else if(postCode.equals("update")) //修改日程
{
scheduleDAO udd=new scheduleDAO();
String schid=request.getParameter("Scheduleid");
List updatelist=udd.searchSchedulebyid(Integer.parseInt(schid));
request.setAttribute("updatelist",updatelist);
request.getRequestDispatcher("edit_arrangment.jsp").forward(request, response);
}
else if(postCode.equals("updatefinish")) //修改日程
{
String htdate=request.getParameter("htdate");
String done=request.getParameter("done");
int Schid=Integer.parseInt(request.getParameter("Scheduleid"));
scheduleDAO udd=new scheduleDAO();
int i=udd.updatefinish(Schid);
if(i>0)
{
request.getRequestDispatcher("schedule?postCode=search&done="+done+"&htdate="+htdate).forward(request, response);
}
}
else if(postCode.equals("edit"))
{
scheduleDAO udd=new scheduleDAO();
int id=Integer.parseInt(request.getParameter("schid"));
String theme=request.getParameter("theme");
String fromtime=request.getParameter("fromtime");
String totime=request.getParameter("totime");
String schtext=request.getParameter("schtext");
try {
int i=udd.updatesche(fromtime,totime,schtext,id);
if(i>0)
{
request.getSession().setAttribute("flag","succ");
request.getRequestDispatcher("schedule?postCode=update&Scheduleid="+id).forward(request, response);
}
else
{
request.getSession().setAttribute("flag","fail");
request.getRequestDispatcher("schedule?postCode=update&Scheduleid="+id).forward(request, response);
}
} catch (SQLException e) {
e.printStackTrace();
}
}
else if(postCode.equals("delete")) //删除日程
{
int Schid=Integer.parseInt(request.getParameter("Scheduleid"));
String htdate=request.getParameter("htdate");
String done=request.getParameter("done");
String curpage=request.getParameter("curpage");
try {
scheduleDAO udd=new scheduleDAO();
int i=udd.delschedule(Schid);
if(i>0)
{
request.getSession().setAttribute("flag","succ");
request.getRequestDispatcher("schedule?postCode=search&done="+done+"&htdate="+htdate+"&curpage="+curpage).forward(request, response);
}
else
{
request.getSession().setAttribute("flag","fail");
request.getRequestDispatcher("schedule?postCode=search&done="+done+"&htdate="+htdate+"&curpage="+curpage).forward(request, response);
}
}
catch (NumberFormatException e) {
e.printStackTrace();
}
catch (SQLException e) {
e.printStackTrace();
}
}
}
}
}
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -