jsp+mysql开发的火车票网上购票系统源码.rar

package dp.admin.svlt; import java.io.IOException; import java.io.PrintWriter; import java.sql.ResultSet; import java.util.ArrayList; import java.util.Iterator; import java.util.List; import javax.servlet.ServletException; import javax.servlet.http.HttpServlet; import javax.servlet.http.HttpServletRequest; import javax.servlet.http.HttpServletResponse; import javax.servlet.http.HttpSession; import dp.been.Cusinfo; import dp.been.Dpiao; import dp.been.Piao; import dp.been.Traininfo; import dp.been.Userinfo; import dp.been.Xianlu; import dp.been.Zhandian; import dp.utils.DbConn; import dp.utils.FindService; import dp.utils.HandleProperties; public class Init extends HttpServlet { /** * Constructor of the object. */ public Init() { super(); } /** * Destruction of the servlet. <br> */ public void destroy() { super.destroy(); // Just puts "destroy" string in log // Put your code here } /** * The doGet method of the servlet. <br> * * This method is called when a form has its tag value method equals to get. * * @param request the request send by the client to the server * @param response the response send by the server to the client * @throws ServletException if an error occurred * @throws IOException if an error occurred */ public void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException { this.doPost(request, response); } /** * The doPost method of the servlet. <br> * * This method is called when a form has its tag value method equals to post. * * @param request the request send by the client to the server * @param response the response send by the server to the client * @throws ServletException if an error occurred * @throws IOException if an error occurred */ public void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException { //设置传输数据编码方式 request.setCharacterEncoding("utf-8"); response.setCharacterEncoding("utf-8"); response.setContentType("text/html"); HttpSession session=request.getSession(); //获取当前登录用户信息 Object utype=session.getAttribute("utype"); Object userid=session.getAttribute("userid"); if(utype==null||userid==null){ return; } //获取前台数据 String flgs=request.getParameter("flgs"); String tname=request.getParameter("tname"); //定义sql语句变量 String sql=""; //创建配置文件操作对象 HandleProperties hp=new HandleProperties(session,utype+""+userid); //创建数据库操作对象 DbConn db=new DbConn(); //管理员信息管理初始化 if("admin".equals(tname)){ if("1".equals(flgs)){ sql="select * from userinfo"; hp.setValue("sql", sql); }else{ sql=hp.readValue("sql"); } ResultSet rs=db.query(sql); List<Userinfo> alist=FindService.getUserinfo(rs); request.setAttribute("alist", alist); request.getRequestDispatcher("/admin/mgadmin.jsp").forward(request, response); return; } //顾客信息管理初始化 if("cusinfo".equals(tname)){ if("1".equals(flgs)){ sql="select * from cusinfo"; hp.setValue("sql", sql); }else{ sql=hp.readValue("sql"); } ResultSet rs=db.query(sql); List<Cusinfo> alist=FindService.getCusinfo(rs); request.setAttribute("alist", alist); request.getRequestDispatcher("/admin/mgcusinfo.jsp").forward(request, response); return; } //火车信息管理初始化 if("traininfo".equals(tname)){ if("1".equals(flgs)){ sql="select * from traininfo"; hp.setValue("sql", sql); }else{ sql=hp.readValue("sql"); } ResultSet rs=db.query(sql); List<Traininfo> alist=FindService.getTraininfo(rs); request.setAttribute("alist", alist); request.getRequestDispatcher("/admin/mgtraininfo.jsp").forward(request, response); return; } //站点信息管理初始化 if("zhandian".equals(tname)){ if("1".equals(flgs)){ sql="select * from zhandian"; hp.setValue("sql", sql); }else{ sql=hp.readValue("sql"); } ResultSet rs=db.query(sql); List<Zhandian> alist=FindService.getZhandian(rs); request.setAttribute("alist", alist); request.getRequestDispatcher("/admin/mgzhandian.jsp").forward(request, response); return; } //线路信息初始化 if("initxl".equals(tname)){ if("1".equals(flgs)){ sql="select * from traininfo"; hp.setValue("sql", sql); }else{ sql=hp.readValue("sql"); } List<Xianlu> xllist=new ArrayList(); DbConn db2=new DbConn(); ResultSet rs=db.query(sql); List<Traininfo> tlist=FindService.getTraininfo(rs); Iterator<Traininfo> it=tlist.iterator(); while(it.hasNext()){ Traininfo t=it.next(); Xianlu xl=new Xianlu(); xl.setTid(t.getId()); xl.setTname(t.getTname()); ResultSet rs2=db2.query("select zhandian.*,xh from xianlu,zhandian where xianlu.zdid=zhandian.id and xianlu.tid="+t.getId()+" order by xh"); List<Zhandian> zdlist=FindService.getZhandian(rs2); xl.setZdlist(zdlist); xllist.add(xl); } request.setAttribute("alist", xllist); request.getRequestDispatcher("/admin/initxianlu.jsp").forward(request, response); return; } //线路信息管理初始化 if("xianlu".equals(tname)){ String ids=request.getParameter("tid"); if("1".equals(flgs)){ sql="select zhandian.*,xh from zhandian,xianlu where zhandian.id=xianlu.zdid and xianlu.tid="+ids+" order by xh"; hp.setValue("sql", sql); }else{ sql=hp.readValue("sql"); } ResultSet rs=db.query(sql); List<Zhandian> zlist=FindService.getZhandians(rs); request.setAttribute("alist", zlist); DbConn db2=new DbConn(); ResultSet rs2=db2.query("select * from zhandian where id not in(select zdid from xianlu where tid="+ids+")"); List<Zhandian> zdlist=FindService.getZhandian(rs2); request.setAttribute("zdlist", zdlist); DbConn db3=new DbConn(); Object tn=db3.getOnlyOne("select tname from traininfo where id="+ids); Traininfo t=new Traininfo(); t.setId(Integer.parseInt(ids)); t.setTname(tn+""); request.setAttribute("t", t); request.getRequestDispatcher("/admin/mgxianlu.jsp").forward(request, response); return; } //车票信息管理初始化 if("piao".equals(tname)){ String ids=request.getParameter("tid"); if("1".equals(flgs)){ sql="select tmp.*,zdname as eaddr,tname,traintype from (select piao.*,zdname as saddr from piao,zhandian where piao.szdid=zhandian.id and yxsj='1975-01-01' and zdname like '%0%') tmp,zhandian,traininfo where tmp.tid=traininfo.id and tmp.ezdid=zhandian.id and zdname like '%0%' and 1=0"; hp.setValue("sql", sql); }else{ sql=hp.readValue("sql"); } ResultSet rs2=db.query(sql); List<Piao> plist=FindService.getPiao(rs2); request.setAttribute("alist", plist); DbConn db2=new DbConn(); ResultSet rs=db2.query("select * from traininfo"); List<Traininfo> tlist=FindService.getTraininfo(rs); request.setAttribute("tlist", tlist); request.getRequestDispatcher("/admin/mgpiao.jsp").forward(request, response); return; } //订票信息管理初始化 if("dpiao".equals(tname)){ ResultSet rs=db.query("select dpiao.*,cxzh,ezdid,ezdname,ptype,pval,stime,szdid,szdname,tid,tname,traintype,yxsj from(select tmp.*,zdname as ezdname from(select piao.*,zdname as szdname,tname,traintype from piao,zhandian,traininfo where piao.tid=traininfo.id and piao.szdid=zhandian.id)tmp,zhandian where tmp.ezdid=zhandian.id)tm,dpiao,cusinfo where tm.id=dpiao.pid and dpiao.cidcard=cusinfo.cidcard"); List<Dpiao> dplist=FindService.getDpiao(rs); request.setAttribute("alist", dplist); request.getRequestDispatcher("/admin/mdpiao.jsp").forward(request, response); return; }