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）
最后，别忘了一键三连哦
706
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
