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