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