中北大学2014届毕业设计说明书
3.流程图如下图4.4所示：
通过 登陆系统 管理员录入教职工信息 系统验证教职工信息 未通过 录入成功 结 束
图4.4 教职工录入流程图
4.3.2教职工管理
1.描述：管理员点击左侧的菜单“教职工管理”，页面跳转到做教职工界面，调用后台的servlet类查询所有教职工的信息。 2.程序效果图如下图4.5所示
第21页 共42页
中北大学2014届毕业设计说明书
图4.5 教职工管理界面
教职工管理关键代码：
public void jihuayuanAdd(HttpServletRequest req,HttpServletResponse res) public void jiaoshiDel(HttpServletRequest req,HttpServletResponse res)
{
int id = Integer.parseInt(req.getParameter(\String del = \
String sql = \
Object[] params={del,id}; DB mydb=new DB(); mydb.doPstm(sql, params); mydb.closed();
req.setAttribute(\教师信息删除成功!\req.setAttribute(\
String targetURL = \
}
dispatch(targetURL, req, res);
public void jiaoshiUpd(HttpServletRequest req,HttpServletResponse res) {
int id = Integer.parseInt(req.getParameter(\String gonghao = req.getParameter(\String xingming = req.getParameter(\String xingbie = req.getParameter(\String nianling = req.getParameter(\String shengri = req.getParameter(\
第22页 共42页
中北大学2014届毕业设计说明书
String gongzuo = req.getParameter(\String zhuanye = req.getParameter(\String zhaopian = req.getParameter(\String beizhu = req.getParameter(\
String sql = \
gonghao=?,xingming=?,xingbie=?,nianling=?,shengri=?,gongzuo=?,zhuanye=?,zhaopian=?,beizhu=? where id=?\
Object[]
params={gonghao,xingming,xingbie,nianling,shengri,gongzuo,zhuanye,zhaopian,beizhu,id};
DB mydb=new DB(); mydb.doPstm(sql, params); mydb.closed();
req.setAttribute(\教师信息修改成功!\req.setAttribute(\
String targetURL = \
}
dispatch(targetURL, req, res);
public void jiaoshiAdd(HttpServletRequest req,HttpServletResponse res) {
String gonghao = req.getParameter(\String xingming = req.getParameter(\String xingbie = req.getParameter(\String nianling = req.getParameter(\String shengri = req.getParameter(\String gongzuo = req.getParameter(\
第23页 共42页
中北大学2014届毕业设计说明书
String zhuanye = req.getParameter(\String zhaopian = req.getParameter(\String beizhu = req.getParameter(\String del = \
String sql = \
(gonghao,xingming,xingbie,nianling,shengri,gongzuo,zhuanye,zhaopian,beizhu,del)\
Object[]
\
params={gonghao,xingming,xingbie,nianling,shengri,gongzuo,zhuanye,zhaopian,beizhu,del};
DB mydb=new DB(); mydb.doPstm(sql, params); mydb.closed();
req.setAttribute(\教师信息添加成功!\req.setAttribute(\
String targetURL = \
}
public void jiaoshiMana(HttpServletRequest req,HttpServletResponse res) throws
dispatch(targetURL, req, res);
ServletException, IOException
{
List jiaoshiList=new ArrayList();
String sql=\Object[] params={}; DB mydb=new DB();
第24页 共42页
