基于javaweb的毕业设计会议管理系统源码+数据库.zip

package service.dao.sql; public class Sql { //employee //注册 //注册验证 public static String select_Register_inspection="select e.EMPLOEENAME,e.USERNAME,e.PASSWORD,e.PHONE,e.EMAIL,d.departmentname from employee e,department d\n" + "where d.departmentid=e.departmentid \n" + "and EMPLOEENAME=? and USERNAME=? and PASSWORD=? and PHONE=? and EMAIL=? and d.departmentname=? \n" + " \n" + " \n" + " "; //插入头像 public static String insert_HeadPortrait_all="insert into employee (employeeid,pic) values(EMPLOYEES_SEQ.nextval,?)"; //找到部门编号 public static String select_DepartmentName_DepartmentId="select departmentid from department where departmentname=?"; //补充其余注册信息 public static String update_EmploeeMessageByPic="update employee set status=0,role=2,departmentid=?,EMPLOEENAME=?,USERNAME=?,PASSWORD=?,PHONE=?,EMAIL=?where pic=?"; //注册检验 public static String select_EmployeeMessageByPic_AccordingDepartmentEmployee="select EMPLOEENAME,USERNAME,PASSWORD,pic,PHONE,EMAIL,departmentname from(select e.EMPLOEENAME,e.USERNAME,e.PASSWORD,e.pic,e.PHONE,e.EMAIL,d.departmentname from employee e,department d\n" + "where d.departmentid=e.departmentid)where pic =?"; //Employee //登录检验 public static String select_Employee_login="select * from employee where username=?and password=?"; //登录身份检验 public static String select_Employee_identify="select role from employee where username=? and password=?"; //审批检验 public static String select_Employee_Examine="select emploeename,username,phone,email from employee where status=0 and role=2"; //审批通过/不通过 public static String update_Employee_Approve="update employee set status=? where emploeename=?"; //是否是审批通过的 public static String select_Employee_user_pass="select status from employee where username=? and password=? "; //department //部门管理 //查询所有部门 public static String select_Department_manga="select departmentid,departmentname from department"; //插入部门信息 public static String insert_Department_manga="insert into department values(DEPARTMENT_ID_SEQ.nextval,?,'1')"; //删除部门信息 public static String delete_Department_manga="delete department where departmentname=?"; //visit //访问次数 //获取上次访问的次数 public static String select_Visit_Count="select * from visit"; //数据库记录访问的次数 public static String update_Visit_Count="update visit set count = ?"; //清空记录 public static String update_Visit_clear="update visit set count=''"; //搜索 //Employee //模糊查询 public static String selectSearchEmployee="select emploeename,username,phone,email from employee where 1=1 "; //分页查询 //总记录 public static String selectCount="select count(*) from employee"; //每页多少条记录 public static String selectPage="SELECT emploeename,username,phone,email FROM (SELECT rownum r,e.emploeename,e.username,e.phone,e.email from employee e)where r>=? and r<=?"; //meetingroom //会议室 //所有会议室信息 public static String selectMeeting="select roomnum,roomname,capacity,status from meetingroom"; //插入会议室信息 public static String insertMeeting="insert into meetingroom(roomid,roomnum,roomname,capacity,status)values(MEETINGROOM_ID_SEQ.nextval,?,?,?,?)"; //修改会议室信息根据id public static String updateMeeting="update meetingroom set roomnum=?,roomname=?,capacity=?,status=? where roomnum=?"; //meetingvo //会议 public static String selectVo="select m.MEETINGNAME mname,r.roomname rname,m.STARTTIME stime,m.ENDTIME etime,m.RESERVETIME rtime,e.emploeename ename, e.employeeid eid from meeting m,meetingroom r,meetingparticipants p,employee e where m.roomid=r.roomid and m.reservationisld=p.employeeid and p.employeeid=e.employeeid"; public static String selectPojo="select m.MEETINGNAME mname,r.roomname rname,m.STARTTIME stime,m.ENDTIME etime,m.RESERVETIME rtime,e.emploeename ename,e.employeeid eid from meeting m,meetingroom r,meetingparticipants p,employee e where m.roomid=r.roomid and m.reservationisld=p.employeeid and p.employeeid=e.employeeid and e.employeeid=?"; public static String updatePojo="update meeting set status='1',DESCRIBE=? where RESERVATIONISLD=? "; public static String selectBo="select m.MEETINGNAME mname,r.roomname rname,m.STARTTIME stime,m.ENDTIME etime,m.RESERVETIME rtime,e.emploeename ename, e.employeeid eid,m.status mstatus from meeting m,meetingroom r,meetingparticipants p,employee e where m.roomid=r.roomid and m.reservationisld=p.employeeid and p.employeeid=e.employeeid and m.status='0'"; public static String selectPo="select m.MEETINGNAME mname,r.roomname rname,m.STARTTIME stime,m.ENDTIME etime,m.RESERVETIME rtime,e.emploeename ename, e.employeeid eid,m.status mstatus,m.describe mdescribe from meeting m,meetingroom r,meetingparticipants p,employee e where m.roomid=r.roomid and m.reservationisld=p.employeeid and p.employeeid=e.employeeid and m.status='1'"; public static String selectqo="select m.MEETINGNAME mname,r.roomname rname,m.STARTTIME stime,m.ENDTIME etime,m.RESERVETIME rtime,e.emploeename ename from meeting m,meetingroom r,meetingparticipants p,employee e where m.roomid=r.roomid and m.reservationisld=p.employeeid and p.employeeid=e.employeeid and 1=1 "; //分页查询 public static String qoCount= "select count(*) from meeting"; public static String qoPage="select mname,rname,stime,etime,rtime,ename from(select rownum r,m.MEETINGNAME mname,r.roomname rname,m.STARTTIME stime,m.ENDTIME etime,m.RESERVETIME rtime,e.emploeename ename from meeting m,meetingroom r,meetingparticipants p,employee e where m.roomid=r.roomid and m.reservationisld=p.employeeid and p.employeeid=e.employeeid and 1=1)where r>=? and r<=?"; public static String selectTo="select m.MEETINGNAME mname,r.roomname rname,m.STARTTIME stime,m.ENDTIME etime,m.RESERVETIME rtime,e.emploeename ename from meeting m,meetingroom r,meetingparticipants p,employee e where m.roomid=r.roomid and m.reservationisld=p.employeeid and p.employeeid=e.employeeid"; // public static String selectToto="select m.MEETINGNAME mname,r.roomname rname,m.STARTTIME stime,m.ENDTIME etime,m.RESERVETIME rtime,e.emploeename ename from meeting m,meetingroom r,meetingparticipants p,employee e where m.roomid=r.roomid and m.reservationisld=p.employeeid and p.employeeid=e.employeeid where"; //会议室名称 //部门人员 //预定 //预定信息查询 public static String selectDto= "select m.meetingname mname,m.numberofparticipants partic,m.starttime stime,m.endtime etime,r.roomname rname,m.describe describe,e.emploeename ename from meeting m,employee e,department d,meetingroom r where m.reservationisld=e.employeeid and e.departmentid=d.departmentid and r.roomid=m.roomid"; // 插入会议室信息 public static String insertDto=" insert into meeting(meetingid,meetingname,numberofparticipants,starttime,endtime,describe)values(MEETINGID_PA_SEQ.nextval,?,?,?,?,?)"; //预定修改，根据会议名称修改人员 // 先知道人员id public static String selectByName="select employeeid from employee e where emploeename=?"; public static String updateByRname="update meeting set reservationisld=? where meetingid=? "; //预定修改，根据会议名称修改 //先知道会议室id public static String selectByRname="select roomid from meetingroom where roomname=?"; public static String updateByRid="update meeting set ROOMID=? where meetingid=?"; // 根据部门名称得到部门有哪些人 public static String getEnameByDeptName="select emploeename from departm