博客目录

JSP火车票预定查询系统

本系统是一套模拟12306网站的火车票一站式操作系统，普通用户可以查询、添加、改签火车票等，管理员可以管理线路、站点、车票等。

实现功能截图

详细功能点：

1、管理员/普通用户登录（注册）

2、修改密码

3、普通用户：查询火车票、订票、我的订单（付款、改签、退票）

4、管理员：管理员信息管理、会员信息管理、火车信息管理、站点信息管理、线路信息管理、车票信息管理、订票信息管理等

注册：

普通用户首页：

火车票查询：

订票：

我的订单：

管理员登录：

管理员首页：

管理员火车信息管理：

站点信息管理：

线路信息管理：

车票信息管理：

订票信息管理：

技术点总结

jsp、Servlet

jdk版本：1.7

tomcat: 7.0

数据库：mysql

开发工具：eclipse

项目包结构分类清晰：

（红色叉号为误报，emmm）

代码

model类“：

Piao.java:

package dp.been;public class Piao {private int id;private int tid;private String tname;private String traintype;private int szdid;private String szdname;private int ezdid;private String ezdname;private String stime;private String pval;private String cxzh;private String ptype;private String yxsj;public int getId() {return id;}public void setId(int id) {this.id = id;}public int getTid() {return tid;}public void setTid(int tid) {this.tid = tid;}public String getTname() {return tname;}public void setTname(String tname) {this.tname = tname;}public String getTraintype() {return traintype;}public void setTraintype(String traintype) {this.traintype = traintype;}public int getSzdid() {return szdid;}public void setSzdid(int szdid) {this.szdid = szdid;}public String getSzdname() {return szdname;}public void setSzdname(String szdname) {this.szdname = szdname;}public int getEzdid() {return ezdid;}public void setEzdid(int ezdid) {this.ezdid = ezdid;}public String getEzdname() {return ezdname;}public void setEzdname(String ezdname) {this.ezdname = ezdname;}public String getStime() {return stime;}public void setStime(String stime) {this.stime = stime;}public String getPval() {return pval;}public void setPval(String pval) {this.pval = pval;}public String getCxzh() {return cxzh;}public void setCxzh(String cxzh) {this.cxzh = cxzh;}public String getPtype() {return ptype;}public void setPtype(String ptype) {this.ptype = ptype;}public String getYxsj() {return yxsj;}public void setYxsj(String yxsj) {this.yxsj = yxsj;}}

Traininfo.java:

package dp.been;public class Traininfo {private int id;private String tname;private String cz;private String znums;private String xcnums;private String traintype;public int getId() {return id;}public void setId(int id) {this.id = id;}public String getTname() {return tname;}public void setTname(String tname) {this.tname = tname;}public String getCz() {return cz;}public void setCz(String cz) {this.cz = cz;}public String getZnums() {return znums;}public void setZnums(String znums) {this.znums = znums;}public String getXcnums() {return xcnums;}public void setXcnums(String xcnums) {this.xcnums = xcnums;}public String getTraintype() {return traintype;}public void setTraintype(String traintype) {this.traintype = traintype;}}

用户端servlet类：

HandlePiaoSvlt.java:

package dp.svlt;import java.io.IOException;import java.io.PrintWriter;import javax.servlet.ServletException;import javax.servlet.http.HttpServlet;import javax.servlet.http.HttpServletRequest;import javax.servlet.http.HttpServletResponse;import dp.utils.DbConn;import net.sf.json.JSONObject;public class HandlePiaoSvlt extends HttpServlet {/*** Constructor of the object.*/public HandlePiaoSvlt() {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");String id=request.getParameter("idi");String flgs=request.getParameter("flgs");JSONObject json=new JSONObject();DbConn db=new DbConn();if("fk".equals(flgs)){int bls=db.deleteOrUpdate("update dpiao set lyflag='已付款' where id="+id);if(bls>0){json.put("dt", 1);json.put("msg", "付款成功。");}else{json.put("dt", 0);json.put("msg", "fkerror:01");}}else if("gq".equals(flgs)){//改签int bls=db.deleteOrUpdate("delete from dpiao where id="+id);if(bls>0){json.put("dt", 2);json.put("msg", "改签成功，请重新选票订票。");}else{json.put("dt", 0);json.put("msg", "fkerror:01");}}else if("lp".equals(flgs)){int bls=db.deleteOrUpdate("update dpiao set lyflag='已领票' where id="+id);if(bls>0){json.put("dt", 1);json.put("msg", "领票成功。");}else{json.put("dt", 0);json.put("msg", "lperror:01");}}else if("tp".equals(flgs)){int bls=db.deleteOrUpdate("delete from dpiao where id="+id);if(bls>0){json.put("dt", 1);json.put("msg", "退票成功。");}else{json.put("dt", 0);json.put("msg", "tperror:01");}}else if("del".equals(flgs)){int bls=db.deleteOrUpdate("delete from dpiao where id="+id);if(bls>0){json.put("dt", 1);json.put("msg", "删除成功。");}else{json.put("dt", 0);json.put("msg", "tperror:01");}}else{json.put("dt", 0);}PrintWriter out = response.getWriter();out.print(json.toString());out.flush();out.close();}/*** Initialization of the servlet. <br>** @throws ServletException if an error occurs*/public void init() throws ServletException {// Put your code here}}

DpSvlt.java:

package dp.svlt;import java.io.IOException;import java.io.PrintWriter;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.utils.DbConn;import net.sf.json.JSONObject;public class DpSvlt extends HttpServlet {/*** Constructor of the object.*/public DpSvlt() {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 userid =session.getAttribute("userid");JSONObject json=new JSONObject();if(userid==null){json.put("msg", "请登录.");}else{String pid=request.getParameter("pid");if("".equals(pid)||pid==null){json.put("msg", "error:01");}else {DbConn db=new DbConn();Object cidcard=db.getOnlyOne("select cidcard from cusinfo where id="+userid);boolean bl=db.insort("insert into dpiao(cidcard,pid,lyflag) values('"+cidcard+"',"+pid+",'待付款')");if(!bl){json.put("msg", 1);}else{json.put("msg", "error:02");}}}PrintWriter out = response.getWriter();out.print(json.toString());out.flush();out.close();}/*** Initialization of the servlet. <br>** @throws ServletException if an error occurs*/public void init() throws ServletException {// Put your code here}}

管理员端servlet:

CkSvlt.java:

package dp.admin.svlt;import java.io.IOException;import java.io.PrintWriter;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.utils.HandleProperties;import net.sf.json.JSONObject;public class CkSvlt extends HttpServlet {/*** Constructor of the object.*/public CkSvlt() {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 userid=session.getAttribute("userid");Object utype=session.getAttribute("utype");//创建json对象JSONObject json=new JSONObject();String sql=request.getParameter("sql");if(userid==null||utype==null){json.put("msg", "请重新登陆");}else{HandleProperties hp=new HandleProperties(session,utype+""+userid);hp.setValue("sql", sql);json.put("msg", 1);}PrintWriter out=response.getWriter();out.print(json.toString());out.flush();out.close();}/*** Initialization of the servlet. <br>** @throws ServletException if an error occurs*/public void init() throws ServletException {// Put your code here}}

写在最后

码代码不容易，需要的同学可以参考学习，全部代码不能都贴出，如果需要可以+博主V交流获取（Code2Life2）

最后，别忘了一键三连哦

Java Jsp+Servlet+mysql实现的火车票查询预定系统（管理员/普通用户 功能：火车票查询 订票付款退票改签 火车票信息管理 线路管理 站点管理等）