教师档案管理系统毕业设计论文

中北大学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页