基于Java的教师档案管理系统的设计(3)

if(userType==1) { }

if(userType==2) {

}

return result; 代码3

if(session.getAttribute(\{

out.print(\

请

先

登

录

！

}

');window.open('../index.jsp','_self')\

} 代码4 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 = \

} public

void

jiaoshiUpd(HttpServletRequest

dispatch(targetURL, req, res);

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(\String gongzuo = req.getParameter(\String zhuanye = req.getParameter(\String zhaopian = req.getParameter(\String beizhu = req.getParameter(\ String

sql

=

\

t_jiaoshi

set

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 = \

} public

void

jiaoshiAdd(HttpServletRequest

dispatch(targetURL, req, res);

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(\String zhuanye = req.getParameter(\String zhaopian = req.getParameter(\String beizhu = req.getParameter(\String del = \ String

sql

=

\

into

t_jiaoshi

(gonghao,xingming,xingbie,nianling,shengri,gongzuo,zhuanye,zhaopian,b

eizhu,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

dispatch(targetURL, req, res);

req,HttpServletResponse res) throws ServletException, IOException

{

List jiaoshiList=new ArrayList();

String sql=\Object[] params={}; DB mydb=new DB(); try {

mydb.doPstm(sql, params); ResultSet rs=mydb.getRs(); while(rs.next())

}

{ }

rs.close();

TJiaoshi jiaoshi=new TJiaoshi();

jiaoshi.setId(rs.getInt(\

jiaoshi.setGonghao(rs.getString(\jiaoshi.setXingming(rs.getString(\jiaoshi.setXingbie(rs.getString(\jiaoshi.setNianling(rs.getString(\jiaoshi.setShengri(rs.getString(\jiaoshi.setGongzuo(rs.getString(\jiaoshi.setZhuanye(rs.getString(\jiaoshi.setZhaopian(rs.getString(\jiaoshi.setBeizhu(rs.getString(\

jiaoshiList.add(jiaoshi);

catch(Exception e) { }

mydb.closed();

req.setAttribute(\

e.printStackTrace();

req.getRequestDispatcher(\

(req, res);

}

百度搜索“77cn”或“免费范文网”即可找到本站免费阅读全部范文。收藏本站方便下次阅读，免费范文网，提供经典小说综合文库基于Java的教师档案管理系统的设计(3)在线全文阅读。