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

代码5

public void gongziAdd(HttpServletRequest req,HttpServletResponse res)

{

int jsid = Integer.parseInt(req.getParameter(\String riqi = req.getParameter(\String gongzi = req.getParameter(\String jiangjin = req.getParameter(\

String sql = \into t_gongzi (jsid,riqi,gongzi,jiangjin)

values (?,?,?,?)\

Object[] params={jsid,riqi,gongzi,jiangjin}; DB mydb=new DB(); mydb.doPstm(sql, params); mydb.closed();

req.setAttribute(\教师工资添加成功\req.setAttribute(\

String targetURL = \

}

public void jsList(HttpServletRequest req,HttpServletResponse

dispatch(targetURL, req, res);

res) throws ServletException, IOException

{

List jiaoshiList=new ArrayList();

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

catch(Exception e) {

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);

}

e.printStackTrace();

mydb.closed();

req.setAttribute(\

req.getRequestDispatcher(\

res);

}

public void toAddGz(HttpServletRequest req,HttpServletResponse

res) throws ServletException, IOException

{

TJiaoshi jiaoshi=new TJiaoshi();

int jsid = Integer.parseInt(req.getParameter(\String sql=\Object[] params={jsid}; DB mydb=new DB(); try {

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

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

rs.close();

catch(Exception e) { }

mydb.closed();

GregorianCalendar gc = new GregorianCalendar();

String strDate = DateUtils.formatDate2Str(gc.getTime(),

e.printStackTrace();

\

req.getRequestDispatcher(\

req.setAttribute(\req.setAttribute(\

res);

}

public void gongziMana(HttpServletRequest

req,HttpServletResponse res) throws ServletException, IOException

{

List gongziList = new ArrayList(); String

riqi

=

req.getParameter(\

String sql = \tb.xingming,ta.* from t_gongzi

ta,t_jiaoshi tb where ta.jsid=tb.id\

if(!(\ }

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

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

TGongzi gongzi=new TGongzi();

gongzi.setId(rs.getInt(\

gongzi.setJsxm(rs.getString(\gongzi.setRiqi(rs.getString(\gongzi.setGongzi(rs.getString(\gongzi.setJiangjin(rs.getString(\

gongziList.add(gongzi);

sql += \

}

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