基于javaweb+mysql的jsp+servlet校园学生兼职系统(学生、企业、管理员)(java+servlet+dwr+jsp+javascript+mysql)
私信源码获取及调试交流
运行环境
Java≥8、MySQL≥5.7、Tomcat≥8
开发工具
eclipse/idea/myeclipse/sts等均可配置运行
适用
课程设计,大作业,毕业设计,项目练习,学习演示等
功能说明
基于javaweb+mysql的JSP+Servlet校园学生兼职系统(学生、企业、管理员)(java+servlet+dwr+jsp+javascript+mysql)
/dwr
管理员:
admin 123456
企业:
company1 123456
company2 123456
用户:
user1 123456
user2 123456
String qylianxiren=req.getParameter("qylianxiren");
String qydianhua=req.getParameter("qydianhua");
String qyhangye=req.getParameter("qyhangye");
String qyguimo=req.getParameter("qyguimo");
String qyjieshao=req.getParameter("qyjieshao");
//用户修改的sql语句
String sql="update qiye set qydengluName=?,qymingcheng=?,qydizhi=?,qylianxiren=?,qydianhua=?,qyhangye=?,qyguimo=?,qyjieshao=? where qyid=?";
Object[] params={qydengluName,qymingcheng,qydizhi,qylianxiren,qydianhua,qyhangye,qyguimo,qyjieshao,qiyeID};
DB mydb=new DB();
mydb.doPstm(sql, params);
mydb.closed();
DB mydb1=new DB();
sql="select * from qiye where qyid=?";
Object[] params1={qiyeID};
mydb1.doPstm(sql, params1);
try
{
ResultSet rs=mydb1.getRs();
boolean mark=(rs==null||!rs.next()?false:true);
if(mark==false)
{
}
else
{
Tqiye qiye=new Tqiye();
qiye.setqyid(rs.getInt("qyid"));
qiye.setqydengluName(rs.getString("qydengluName"));
qiye.setqymingcheng(rs.getString("qymingcheng"));
qiye.setqydizhi(rs.getString("qydizhi"));
qiye.setqydianhua(rs.getString("qydianhua"));
qiye.setqylianxiren(rs.getString("qylianxiren"));
qiye.setqyhangye(rs.getString("qyhangye"));
qiye.setqyguimo(rs.getString("qyguimo"));
qiye.setqyjieshao(rs.getString("qyjieshao"));
WebContext ctx = WebContextFactory.get();
session.setAttribute("qiye", qiye);
}
rs.close();
}
catch (SQLException e)
{
e.printStackTrace();
}
finally
{
mydb.closed();
mydb1.closed();
}
req.setAttribute("message", "修改成功");
req.setAttribute("path", "qiye?type=qiyeXinxi");
{
super.init(config);
}
public void destroy()
{
}
}
public class indexList
{
public static List zhiweiNew()
{
List zhiweiList=new ArrayList();
String sql="select a.*,b.quyuName from zhiwei a left join quyu b on a.quyuID=b.quyuID where a.zwzhuangtai='已通过' order by zwfaburiqi desc limit 0,8 ";
Object[] params={};
DB mydb=new DB();
try
{
mydb.doPstm(sql, params);
ResultSet rs=mydb.getRs();
while(rs.next())
{
xuesheng.setyhweixin(rs.getString("yhweixin"));
xuesheng.setyhjieshao(rs.getString("yhjieshao"));
WebContext ctx = WebContextFactory.get();
session.setAttribute("xuesheng", xuesheng);
}
rs.close();
}
catch (SQLException e)
{
e.printStackTrace();
}
finally
{
mydb.closed();
mydb1.closed();
}
req.setAttribute("message", "修改成功");
req.setAttribute("path", "xuesheng?type=xueshengXinxi");
String targetURL = "/common/success.jsp";
dispatch(targetURL, req, res);
}
public void xueshengDel(HttpServletRequest req,HttpServletResponse res)
{
String id=req.getParameter("id");
String sql="delete from yonghu where yhid=?";
Object[] params={id};
DB mydb=new DB();
mydb.doPstm(sql, params);
mydb.closed();
req.setAttribute("message", "删除成功");
req.setAttribute("path", "xuesheng?type=xueshengMana");
String targetURL = "/common/success.jsp";
dispatch(targetURL, req, res);
}
public void Logout(HttpServletRequest req,HttpServletResponse res)
{
req.getSession().setAttribute("xuesheng", null);
req.getSession().setAttribute("qiye", null);
req.getSession().setAttribute("userType", null);
String targetURL = "/default.jsp";
}
public void zhiweiDel(HttpServletRequest req,HttpServletResponse res)
{
String id=req.getParameter("id");
String sql="delete from zhiwei where zwid=?";
Object[] params={id};
DB mydb=new DB();
mydb.doPstm(sql, params);
mydb.closed();
req.setAttribute("message", "删除成功");
req.setAttribute("path", "zhiwei?type=zhiweiMana");
String targetURL = "/common/success.jsp";
dispatch(targetURL, req, res);
}
public void zhiweiInfo(HttpServletRequest req,HttpServletResponse res) throws ServletException, IOException
{
Tzhiwei zhiwei=new Tzhiwei();
int quyuID=0;
List quyuList = getquyuList();
int id = Integer.parseInt(req.getParameter("id"));
String sql="select a.*,b.quyuName from zhiwei a left join quyu b on a.quyuID=b.quyuID where a.zwid=?"; //查询语句
Object[] params={id};
DB mydb=new DB();
try
{
mydb.doPstm(sql, params);
ResultSet rs=mydb.getRs();
while(rs.next())
{
zhiwei.setzwid(rs.getInt("zwid"));
zhiwei.setzwmingcheng(rs.getString("zwmingcheng"));
zhiwei.setzwleixing(rs.getString("zwleixing"));
zhiwei.setQuyuID(rs.getInt("quyuID"));
zhiwei.setQuyuName(rs.getString("quyuName"));
zhiwei.setzwxinzi(rs.getString("zwxinzi"));
zhiwei.setzwzhize(rs.getString("zwzhize"));
zhiwei.setzwyaoqiu(rs.getString("zwyaoqiu"));
zhiwei.setzwdizhi(rs.getString("zwdizhi"));
zhiwei.setzwrenshu(rs.getString("zwrenshu"));
zhiwei.setzwfaburiqi(rs.getString("zwfaburiqi"));
zhiwei.setzwzhuangtai(rs.getString("zwzhuangtai"));
mydb.doPstm(sql, params);
ResultSet rs=mydb.getRs();
while(rs.next())
{
Tquyu quyu=new Tquyu();
quyu.setquyuID(rs.getInt("quyuid"));
quyu.setQuyuName(rs.getString("quyuname"));
quyuList.add(quyu);
}
rs.close();
}
catch(Exception e)
{
e.printStackTrace();
}
mydb.closed();
return quyuList;
}
}
public class quyu_servlet extends HttpServlet
{
public void service(HttpServletRequest req,HttpServletResponse res)throws ServletException, IOException
{
String type=req.getParameter("type");
if(type.endsWith("quyuMana"))
{
quyuMana(req, res);
}
if(type.endsWith("quyuAdd"))
{
quyuAdd(req, res);
DB mydb=new DB();
mydb.doPstm(sql, params);
mydb.closed();
req.setAttribute("message", "添加成功");
req.setAttribute("path", "zhiwei?type=zhiweiMana");
String targetURL = "/common/success.jsp";
dispatch(targetURL, req, res);
}
public void zhiweiUpdate(HttpServletRequest req,HttpServletResponse res)
{
String id=req.getParameter("id");
String zwmingcheng=req.getParameter("zwmingcheng");
String zwleixing=req.getParameter("zwleixing");
String quyuID=req.getParameter("quyuID");
String zwxinzi=req.getParameter("zwxinzi");
String zwrenshu=req.getParameter("zwrenshu");
String zwdizhi=req.getParameter("zwdizhi");
String zwzhize=req.getParameter("zwzhize");
String zwyaoqiu=req.getParameter("zwyaoqiu");
String sql="update zhiwei set zwmingcheng=?,zwleixing=?,quyuID=?,zwxinzi=?,zwrenshu=?,zwdizhi=?,zwzhize=?,zwyaoqiu=? where zwid=?";
Object[] params={zwmingcheng,zwleixing,quyuID,zwxinzi,zwrenshu,zwdizhi,zwzhize,zwyaoqiu,id};
DB mydb=new DB();
mydb.doPstm(sql, params);
mydb.closed();
req.setAttribute("message", "修改成功");
req.setAttribute("path", "zhiwei?type=zhiweiMana");
String targetURL = "/common/success.jsp";
dispatch(targetURL, req, res);
}
public void zhiweiDel(HttpServletRequest req,HttpServletResponse res)
{
String id=req.getParameter("id");
String sql="delete from zhiwei where zwid=?";
Object[] params={id};
DB mydb=new DB();
mydb.doPstm(sql, params);
mydb.closed();
req.setAttribute("message", "删除成功");
req.setAttribute("path", "zhiwei?type=zhiweiMana");
String targetURL = "/common/success.jsp";
dispatch(targetURL, req, res);
}
public void zhiweiInfo(HttpServletRequest req,HttpServletResponse res) throws ServletException, IOException
{
Tzhiwei zhiwei=new Tzhiwei();
int quyuID=0;
List quyuList = getquyuList();
int id = Integer.parseInt(req.getParameter("id"));
String sql="select a.*,b.quyuName from zhiwei a left join quyu b on a.quyuID=b.quyuID where a.zwid=?"; //查询语句
req.setAttribute("zhiwei", zhiwei);
req.getRequestDispatcher("zhiweiInfo.jsp").forward(req, res);
}
public void dispatch(String targetURI,HttpServletRequest request,HttpServletResponse response)
{
RequestDispatcher dispatch = getServletContext().getRequestDispatcher(targetURI);
try
{
dispatch.forward(request, response);
return;
}
catch (ServletException e)
{
e.printStackTrace();
}
catch (IOException e)
{
e.printStackTrace();
}
}
public void init(ServletConfig config) throws ServletException
{
super.init(config);
}
public void destroy()
{
}
}
// TODO Auto-generated catch block
e.printStackTrace();
}
WebContext ctx = WebContextFactory.get();
HttpSession session=ctx.getSession();
Tqiye qiye=(Tqiye)session.getAttribute("qiye");
String sql="update qiye set qydengluPass=? where qyid=?";
Object[] params={userPwNew,qiye.getqyid()};
DB mydb=new DB();
mydb.doPstm(sql, params);
return "yes";
}
public String adminPwEdit(String userPwNew)
{
System.out.println("DDDD");
try
{
Thread.sleep(700);
}
catch (InterruptedException e)
{
// TODO Auto-generated catch block
e.printStackTrace();
}
WebContext ctx = WebContextFactory.get();
HttpSession session=ctx.getSession();
TAdmin admin=(TAdmin)session.getAttribute("admin");
String sql="update admin set dengluPass=? where id=?";
Object[] params={userPwNew,admin.getId()};
DB mydb=new DB();
mydb.doPstm(sql, params);
return "yes";
}
public List quyuAll()
{
List quyuList=new ArrayList();
String sql="select * from quyu";
Object[] params={};
DB mydb=new DB();
try
{
mydb.doPstm(sql, params);
ResultSet rs=mydb.getRs();
while(rs.next())
{
public class qiye_servlet extends HttpServlet
{
public void service(HttpServletRequest req,HttpServletResponse res)throws ServletException, IOException
{
String type=req.getParameter("type");
if(type.endsWith("qiyeAdd"))
{
qiyeAdd(req, res);
}
if(type.endsWith("qiyeUpdate"))
{
qiyeUpdate(req, res);
}
if(type.endsWith("qiyeMana"))
{
qiyeMana(req, res);
}
if(type.endsWith("qiyeDel"))
{
qiyeDel(req, res);
}
if(type.endsWith("qiyeXinxi"))
{
qiyeXinxi(req, res);
}
}
public void qiyeAdd(HttpServletRequest req,HttpServletResponse res)
{
String qydengluName=req.getParameter("qydengluName");
qiye.setqymingcheng(rs.getString("qymingcheng"));
qiye.setqydizhi(rs.getString("qydizhi"));
qiye.setqydianhua(rs.getString("qydianhua"));
qiye.setqylianxiren(rs.getString("qylianxiren"));
qiye.setqyhangye(rs.getString("qyhangye"));
qiye.setqyguimo(rs.getString("qyguimo"));
qiye.setqyjieshao(rs.getString("qyjieshao"));
qiyeList.add(qiye);
}
rs.close();
}
catch(Exception e)
{
e.printStackTrace();
}
mydb.closed();
req.setAttribute("qiyeList", qiyeList);
req.getRequestDispatcher("qiye/qiyeUpdate.jsp").forward(req, res);
}
public void dispatch(String targetURI,HttpServletRequest request,HttpServletResponse response)
{
RequestDispatcher dispatch = getServletContext().getRequestDispatcher(targetURI);
try
{
dispatch.forward(request, response);
return;
}
catch (ServletException e)
{
e.printStackTrace();
}
catch (IOException e)
{
e.printStackTrace();
}
}
public void init(ServletConfig config) throws ServletException
{
super.init(config);
}
public void destroy()
{
qiye.setqyid(rs.getInt("qyid"));
qiye.setqydengluName(rs.getString("qydengluName"));
qiye.setqydengluPass(rs.getString("qydengluPass"));
qiye.setqymingcheng(rs.getString("qymingcheng"));
qiye.setqydizhi(rs.getString("qydizhi"));
qiye.setqydianhua(rs.getString("qydianhua"));
qiye.setqylianxiren(rs.getString("qylianxiren"));
qiye.setqyjieshao(rs.getString("qyjieshao"));
qiye.setqyguimo(rs.getString("qyguimo"));
qiye.setqyhangye(rs.getString("qyhangye"));
WebContext ctx = WebContextFactory.get();
HttpSession session=ctx.getSession();
session.setAttribute("userType", 1);
session.setAttribute("qiye", qiye);
}
rs.close();
}
catch (SQLException e)
{
System.out.println("登录失败");
e.printStackTrace();
}
finally
{
mydb.closed();
}
}
if(userType==2)
{
String sql="select * from yonghu where yhdengluName=? and yhdengluPass=?";
Object[] params={userName,userPw};
DB mydb=new DB();
mydb.doPstm(sql, params);
try
{
ResultSet rs=mydb.getRs();
boolean mark=(rs==null||!rs.next()?false:true);
if(mark==false)
{
result="no";
}
else
{
result="yes";
Tyonghu xuesheng=new Tyonghu();
xuesheng.setyhid(rs.getInt("yhid"));
xuesheng.setyhdengluName(rs.getString("yhdengluName"));
xuesheng.setyhdengluPass(rs.getString("yhdengluPass"));
xuesheng.setyhxingming(rs.getString("yhxingming"));
xuesheng.setyhxingbie(rs.getString("yhxingbie"));
xuesheng.setyhnianling(rs.getString("yhnianling"));
xuesheng.setyhxuexiao(rs.getString("yhxuexiao"));
HttpSession session=ctx.getSession();
session.setAttribute("userType", 2);
session.setAttribute("xuesheng", xuesheng);
}
rs.close();
}
catch (SQLException e)
{
System.out.println("登录失败");
e.printStackTrace();
}
finally
{
mydb.closed();
}
}
return result;
}
public String xueshengPwEdit(String userPwNew)
{
System.out.println("DDDD");
try
{
Thread.sleep(700);
}
catch (InterruptedException e)
{
// TODO Auto-generated catch block
e.printStackTrace();
}
WebContext ctx = WebContextFactory.get();
HttpSession session=ctx.getSession();
Tyonghu xuesheng=(Tyonghu)session.getAttribute("xuesheng");
String sql="update xuesheng set yhdengluPass=? where yhid=?";
Object[] params={userPwNew,xuesheng.getyhid()};
DB mydb=new DB();
mydb.doPstm(sql, params);
return "yes";
}
public String qiyePwEdit(String userPwNew)
{
System.out.println("DDDD");
try
{
Thread.sleep(700);
}
catch (InterruptedException e)
{
// TODO Auto-generated catch block
zhiwei.setzwid(rs.getInt("zwid"));
zhiwei.setzwmingcheng(rs.getString("zwmingcheng"));
zhiwei.setzwleixing(rs.getString("zwleixing"));
zhiwei.setQuyuID(rs.getInt("quyuID"));
zhiwei.setQuyuName(rs.getString("quyuName"));
zhiwei.setzwxinzi(rs.getString("zwxinzi"));
zhiwei.setzwzhize(rs.getString("zwzhize"));
zhiwei.setzwyaoqiu(rs.getString("zwyaoqiu"));
zhiwei.setzwdizhi(rs.getString("zwdizhi"));
zhiwei.setzwrenshu(rs.getString("zwrenshu"));
zhiwei.setzwfaburiqi(rs.getString("zwfaburiqi"));
zhiwei.setzwzhuangtai(rs.getString("zwzhuangtai"));
zhiweiList.add(zhiwei);
}
rs.close();
}
catch(Exception e)
{
e.printStackTrace();
}
mydb.closed();
req.setAttribute("zhiweiList", zhiweiList);
req.getRequestDispatcher("qiye/zhiweiguanli.jsp").forward(req, res);
}
public void shenhe1(HttpServletRequest req,HttpServletResponse res)
{
String id=req.getParameter("id");
String sql="Update zhiwei set zwzhuangtai='已通过' where zwid=?";
Object[] params={id};
DB mydb=new DB();
mydb.doPstm(sql, params);
mydb.closed();
req.setAttribute("message", "审核完成");
req.setAttribute("path", "zhiwei?type=zhiweihoutaiMana");
String targetURL = "/common/success.jsp";
dispatch(targetURL, req, res);
}
public void shenhe2(HttpServletRequest req,HttpServletResponse res)
{
String id=req.getParameter("id");
String sql="Update zhiwei set zwzhuangtai='未通过' where zwid=?";
Object[] params={id};
DB mydb=new DB();
mydb.doPstm(sql, params);
mydb.closed();
{
String id=req.getParameter("id");
String sql="Update shenqing set sqzhuangtai='拒绝' where sqid=?";
Object[] params={id};
DB mydb=new DB();
mydb.doPstm(sql, params);
mydb.closed();
req.setAttribute("message", "审核完成");
req.setAttribute("path", "shenqing?type=shenqingList");
String targetURL = "/common/success.jsp";
dispatch(targetURL, req, res);
}
public void shenqingQuery(HttpServletRequest req,HttpServletResponse res) throws ServletException, IOException
{
List shenqingList=new ArrayList();
HttpSession session=req.getSession();
Tqiye qiye=(Tqiye)session.getAttribute("qiye");
int qiyeID=qiye.getqyid();
String sql="select a.*,b.zwmingcheng,c.yhxingming,c.yhxingbie,c.yhnianling,c.yhxuexiao,c.yhzhuanye,c.yhdianhua,c.yhweixin,c.yhjieshao from shenqing a left join zhiwei b on a.zhiweiID=b.zwid left join yonghu c on a.xueshengID=c.yhid where a.zhiweiID in(select zwid from zhiwei where qiyeID=?)"; //查询语句
String zwmingcheng=req.getParameter("zwmingcheng");
if(!zwmingcheng.equals(""))
{
sql+=" and b.zwmingcheng='"+zwmingcheng+"'";
}
Object[] params={qiyeID};
DB mydb=new DB();
try
{
mydb.doPstm(sql, params);
ResultSet rs=mydb.getRs();
while(rs.next())
{
Tshenqing shenqing=new Tshenqing();
shenqing.setsqid(rs.getInt("sqid"));
shenqing.setzwmingcheng(rs.getString("zwmingcheng"));
shenqing.setyhxingming(rs.getString("yhxingming"));
shenqing.setyhxingbie(rs.getString("yhxingbie"));
}
if(userType==1)//企业登录
{
String sql="select * from qiye where qydengluName=? and qydengluPass=?";
Object[] params={userName,userPw};
DB mydb=new DB();
mydb.doPstm(sql, params);
try
{
ResultSet rs=mydb.getRs();
boolean mark=(rs==null||!rs.next()?false:true);
if(mark==false)
{
result="no";
}
else
{
result="yes";
Tqiye qiye=new Tqiye();
qiye.setqyid(rs.getInt("qyid"));
qiye.setqydengluName(rs.getString("qydengluName"));
qiye.setqydengluPass(rs.getString("qydengluPass"));
qiye.setqymingcheng(rs.getString("qymingcheng"));
qiye.setqydizhi(rs.getString("qydizhi"));
qiye.setqydianhua(rs.getString("qydianhua"));
qiye.setqylianxiren(rs.getString("qylianxiren"));
qiye.setqyjieshao(rs.getString("qyjieshao"));
qiye.setqyguimo(rs.getString("qyguimo"));
qiye.setqyhangye(rs.getString("qyhangye"));
WebContext ctx = WebContextFactory.get();
HttpSession session=ctx.getSession();
session.setAttribute("userType", 1);
session.setAttribute("qiye", qiye);
}
rs.close();
}
catch (SQLException e)
{
System.out.println("登录失败");
e.printStackTrace();
shenqing.setsqzhuangtai(rs.getString("sqzhuangtai"));
shenqing.setsqshijian(rs.getString("sqshijian"));
shenqingList.add(shenqing);
}
rs.close();
}
catch(Exception e)
{
e.printStackTrace();
}
mydb.closed();
req.setAttribute("shenqingList", shenqingList);
req.getRequestDispatcher("qiye/shenqingguanli.jsp").forward(req, res);
}
public void dispatch(String targetURI,HttpServletRequest request,HttpServletResponse response)
{
RequestDispatcher dispatch = getServletContext().getRequestDispatcher(targetURI);
try
{
dispatch.forward(request, response);
return;
}
catch (ServletException e)
{
e.printStackTrace();
}
catch (IOException e)
{
e.printStackTrace();
}
}
public void init(ServletConfig config) throws ServletException
{
super.init(config);
}
public void destroy()
{
}
public void xueshengUpdate(HttpServletRequest req,HttpServletResponse res)
{
HttpSession session=req.getSession();
Tyonghu xuesheng1=(Tyonghu)session.getAttribute("xuesheng");
int xueshengID=xuesheng1.getyhid();
String yhdengluName=req.getParameter("yhdengluName");
String yhxingming=req.getParameter("yhxingming");
String yhxingbie=req.getParameter("yhxingbie");
String yhnianling=req.getParameter("yhnianling");
String yhxuexiao=req.getParameter("yhxuexiao");
String yhzhuanye=req.getParameter("yhzhuanye");
String yhdianhua=req.getParameter("yhdianhua");
String yhweixin=req.getParameter("yhweixin");
String yhjieshao=req.getParameter("yhjieshao");
//用户修改的sql语句
String sql="update yonghu set yhdengluName=?,yhxingming=?,yhxingbie=?,yhnianling=?,yhxuexiao=?,yhzhuanye=?,yhdianhua=?,yhweixin=?,yhjieshao=? where yhid=?";
Object[] params={yhdengluName,yhxingming,yhxingbie,yhnianling,yhxuexiao,yhzhuanye,yhdianhua,yhweixin,yhjieshao,xueshengID};
DB mydb=new DB();
mydb.doPstm(sql, params);
DB mydb1=new DB();
sql="select * from yonghu where yhid=?";
Object[] params1={xueshengID};
mydb1.doPstm(sql, params1);
try
{
ResultSet rs=mydb1.getRs();
boolean mark=(rs==null||!rs.next()?false:true);
if(mark==false)
{
}
else
{
Tyonghu xuesheng=new Tyonghu();
xuesheng.setyhid(rs.getInt("yhid"));
xuesheng.setyhdengluName(rs.getString("yhdengluName"));
xuesheng.setyhdengluPass(rs.getString("yhdengluPass"));
xuesheng.setyhxingming(rs.getString("yhxingming"));
xuesheng.setyhxingbie(rs.getString("yhxingbie"));
xuesheng.setyhnianling(rs.getString("yhnianling"));
xuesheng.setyhxuexiao(rs.getString("yhxuexiao"));
xuesheng.setyhzhuanye(rs.getString("yhzhuanye"));
xuesheng.setyhdianhua(rs.getString("yhdianhua"));
xuesheng.setyhweixin(rs.getString("yhweixin"));
xuesheng.setyhjieshao(rs.getString("yhjieshao"));
zhiwei.setQuyuID(rs.getInt("quyuID"));
zhiwei.setQuyuName(rs.getString("quyuName"));
zhiwei.setzwxinzi(rs.getString("zwxinzi"));
zhiwei.setzwzhize(rs.getString("zwzhize"));
zhiwei.setzwyaoqiu(rs.getString("zwyaoqiu"));
zhiwei.setzwdizhi(rs.getString("zwdizhi"));
zhiwei.setzwrenshu(rs.getString("zwrenshu"));
zhiwei.setzwfaburiqi(rs.getString("zwfaburiqi"));
zhiwei.setzwzhuangtai(rs.getString("zwzhuangtai"));
zhiweiList.add(zhiwei);
}
rs.close();
}
catch(Exception e)
{
e.printStackTrace();
}
mydb.closed();
req.setAttribute("zhiweiList", zhiweiList);
req.getRequestDispatcher("zhiweiList.jsp").forward(req, res);
}
public void zhiweiList(HttpServletRequest req,HttpServletResponse res) throws ServletException, IOException
{
List zhiweiList=new ArrayList();
String sql="select a.*,b.quyuName,c.qymingcheng from zhiwei a left join qiye c on a.qiyeID=c.qyid left join quyu b on a.quyuID=b.quyuID where a.zwzhuangtai='已通过' order by zwfaburiqi desc"; //查询语句
Object[] params={};
DB mydb=new DB();
try
{
mydb.doPstm(sql, params);
ResultSet rs=mydb.getRs();
while(rs.next())
{
Tzhiwei zhiwei=new Tzhiwei();
zhiwei.setzwid(rs.getInt("zwid"));
zhiwei.setzwmingcheng(rs.getString("zwmingcheng"));
zhiwei.setqymingcheng(rs.getString("qymingcheng"));
zhiwei.setzwleixing(rs.getString("zwleixing"));
zhiwei.setQuyuID(rs.getInt("quyuID"));