基本信息
源码名称：火车订票系统（源码+数据库+课设报告）
源码大小：42.07M
文件格式：.zip
开发语言：Java
更新时间：2021-08-03
   友情提示：（无需注册或充值，赞助后即可获取资源下载链接）

     嘿，亲！知识可是无价之宝呢，但咱这精心整理的资料也耗费了不少心血呀。小小地破费一下，绝对物超所值哦！如有下载和支付问题，请联系我们QQ(微信同号)：813200300

本次赞助数额为： 2 元　
   源码介绍

火车购票系统





<%@ page language="java" contentType="text/html; charset=UTF-8"
    pageEncoding="UTF-8"%>
<!DOCTYPE html>
<html>
<head>
<meta charset="UTF-8">
<title>Insert title here</title>
</head>
<body style="background:url(page/zz2.png)">
<div align="center">
<h1>火车订票系统</h1>
没有账号？<a href="register.jsp">点我注册</a>
<form action="login_check.jsp" method="post" >
账号:<input type="text" name='user'/><br><br>
密码:<input type="password" name='pwd'/><br><br>
<input type="submit" value='登录'/>
</form>

</div>
</body>
</html>

<%@ page language="java" contentType="text/html; charset=UTF-8"
    pageEncoding="UTF-8"%>
    
<!DOCTYPE html>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<title>登录结果</title>
</head>
<jsp:useBean id="db" class='hello.DB'></jsp:useBean>
<body style="background:url(page/zz2.png)">
<%@ page import="java.sql.*" %>
<%
db.init();
String sql="select * from users where'" request.getParameter("user") "'=username and '" request.getParameter("pwd") "'=password";
ResultSet rs=db.executeQuery(sql);
if(rs.next()){
session.setAttribute("user",request.getParameter("user"));//保存用户名到session
%><!-- 成功 -->

<h1 align="center">欢迎您！<a href="用户信息.jsp"><%out.print(request.getParameter("user"));%></a></h1>
<div align="center"><form action="ticket.jsp" >
<input checked="true" name="gender"type="radio" value="今天"/>今天
<input name="gender"type="radio" value="明天"/>明天
<input name="gender"type="radio" value="后天"/>后天<br>
出发站：<input type="text" name='begin' value="福州"/><br>
终点站：<input type="text" name='end' value="莆田"/><br>
<input type="submit" value='查询车票'/>
</form></div>



<br><br> 
<h2 >我的订单</h2><!-- 显示我的所有订单 -->
<%
sql="select * from orders where username='" request.getParameter("user") "'";
rs=db.executeQuery(sql);
%><div ><table border="1">
<tr><td>订单号</td><td>列车号</td><td>出发-终点</td><td>座位类型</td><td>乘客</td>
<td>出发日期</td><td>购买时间</td><td>操作</td>
<%
while(rs.next()){
if(rs.getString("status").equals("已退票")){
%>
<tr>
<td><%out.print(rs.getString("ordernum")); %></td>
<td><%out.print(rs.getString("trainnum")); %></td>
<td><%out.print(rs.getString("Originating") "-" rs.getString("arriving")); %></td>
<td><%out.print(rs.getString("seattype")); %></td>
<td><%out.print(rs.getString("passenger")); %></td>
<td><%out.print(rs.getString("time")); %></td>
<td><%out.print(rs.getString("pur_time")); %></td>
<td>已退</td>
</tr>
<%
}
else {
%>
<tr>
<td><%out.print(rs.getString("ordernum")); %></td>
<td><%out.print(rs.getString("trainnum")); %></td>
<td><%out.print(rs.getString("Originating") "-" rs.getString("arriving")); %></td>
<td><%out.print(rs.getString("seattype")); %></td>
<td><%out.print(rs.getString("passenger")); %></td>
<td><%out.print(rs.getString("time")); %></td>
<td><%out.print(rs.getString("pur_time")); %></td>
<td><a  href="我的订单.jsp?ordernum=<%=rs.getString("ordernum")%>">退票</a></td>
</tr>
<%
}

}
%></table></div><%
}
else{
%><!-- 失败 -->
<h1 align="center">用户名密码不匹配</h1>

<%}
db.close();
%>
</body>
</html>

<%@ page language="java" contentType="text/html; charset=UTF-8"
    pageEncoding="UTF-8"%>
<!DOCTYPE html>
<html>
<head>
<meta charset="UTF-8">
<title>Insert title here</title>
</head>
<body style="background:url(page/zz2.png)">
<h1 align="center">注册页面</h1>
<br><br>
<div align="center">
<form action="register_end.jsp" method="post">
用户名：<input type="text" name='username'/><br><br>
身份证：<input type="text" name='idnum'/><br><br>
性别：<input type="text" name="sex"/><br><br>
省份：<input type="text" name="province"/><br><br>
电话：<input type="text" name="telnum"/><br><br>
紧急联系电话：<input type="text" name="tel"/><br><br>
密码：<input type="password" name="pass"/><br><br>
<input type="submit" value='提交'/>
</form>
</div>
</body>
</html>

<%@ page language="java" contentType="text/html; charset=UTF-8"
    pageEncoding="UTF-8"%>
<!DOCTYPE html>
<html>
<head>
<meta charset="UTF-8">
<title>Insert title here</title>
</head>
<jsp:useBean id="db" class='hello.DB'></jsp:useBean>
<body style="background:url(page/zz2.png)">
<%@ page import="java.sql.*" %>
<%
db.init();
//执行储存过程，判断用户是否存在
String sql="exec user_exist '" request.getParameter("username")
"','" request.getParameter("idnum")
"','" request.getParameter("sex")
"','" request.getParameter("province")
"','" request.getParameter("telnum")
"','" request.getParameter("tel")
"','" request.getParameter("pass")
"'";sql="select * from users where username='" request.getParameter("username") "'";
ResultSet rs=db.executeQuery(sql);
if(rs.next()){
%><h1 align="center">用户名已存在</h1><%
}
else{
sql="insert into users values ('" request.getParameter("username")
"','" request.getParameter("idnum")
"','" request.getParameter("sex")
"','" request.getParameter("province")
"','" request.getParameter("telnum")
"','" request.getParameter("tel")
"','" request.getParameter("pass")
"')";
rs=db.executeQuery(sql);
%>
<h1 align="center">注册成功</h1>
<%
}
db.close();
%>

</body>
</html>

<%@ page language="java" contentType="text/html; charset=UTF-8"
    pageEncoding="UTF-8"%>
<!DOCTYPE html>
<html>
<head>
<meta charset="UTF-8">
<title>Insert title here</title>
</head>
<jsp:useBean id="db" class='hello.DB'></jsp:useBean>
<body style="background:url(page/zz2.png)">
hello：<%out.print(session.getAttribute("user"));%><br><br>

<%@ page import="java.sql.*" %>

<%
db.init();
String price;
String time=(String)session.getAttribute("day");
if(request.getParameter("seattype").equals("一等座"))
price=(String)session.getAttribute("price2");
else price=(String)session.getAttribute("price");

String s="exec order_exist '" session.getAttribute("user") "','"
session.getAttribute("trainnum")
"','" request.getParameter("passenger") "','" time "'";
ResultSet rs=db.executeQuery(s);
if(rs.next()){
%>
<h1 align="center">请勿重复提交！</h1><br>
<%
}
else{
%>
<h1 align="center">支付成功！请返回</h1><br>
<%
String sql="exec order_insert '" session.getAttribute("user")
"','" request.getParameter("seattype")
"','" session.getAttribute("trainnum")
"','" session.getAttribute("begin")
"','" session.getAttribute("end") "','购票','成功' ,'"
request.getParameter("passenger") "','"
request.getParameter("idnum") "','"
request.getParameter("xt") "','" time "'";
db.executeQuery(sql);

//座位减少//乘客
sql="exec seat_opearing '" session.getAttribute("trainnum")
"','" session.getAttribute("begin")
"','" session.getAttribute("end") "','" request.getParameter("seattype")
"','" time "',' '";
db.executeQuery(sql);
}

db.close();

//request.getParameter("idnum");身份证号
//request.getParameter("xt");协童
%>
</body>
</html>

<%@ page language="java" contentType="text/html; charset=UTF-8"
    pageEncoding="UTF-8"%>
<!DOCTYPE html>
<html>
<head>
<meta charset="UTF-8">
<title>购票</title>
</head>
<jsp:useBean id="db" class='hello.DB'></jsp:useBean>
<body style="background:url(page/zz2.png)">
hello：<%out.print(session.getAttribute("user"));%>
<br><h1 align="center">购票页面</h1>
<%@ page import="java.sql.*" %>
<% String begin=request.getParameter("begin");//获取出发地和终点
session.setAttribute("begin",begin);
String end=request.getParameter("end");
session.setAttribute("end",end);

String day="day0";
if(request.getParameter("gender").equals("明天"))day="day1";
else if(request.getParameter("gender").equals("后天"))day="day2";
session.setAttribute("day",day);
db.init();
//查询车票
String sql=
"select s1.trainnum,s1.staname staname1,s2.staname staname2,s1.begintime,s2.arrivetime,"
"datediff(mi,s1.begintime,s2.arrivetime) usetime," day "_1 s1," day "_2 s2," day "_v sv "
"from station s1 ,station s2,seat s "
"where s1.staname='" begin "' and s2.staname='" end "' "
"and s1.trainnum=s2.trainnum and s1.trainnum=s.trainnum "
"and s1.stanum<s2.stanum "
"and s2.stanum=s.stanum";
ResultSet rs=db.executeQuery(sql);


System.out.print(sql);
if(rs.next()){
%><h3>您选择的日期是:<%out.print(request.getParameter("gender")); %></h3>
<table border="1" >
<tr>
<td>车次</td>
<td>始-终</td>
<td>出发时间</td>
<td>到达时间</td>
<td>历时(分钟)</td>
<td>二等座余票</td>
<td>一等座余票</td>
<td>无座余票</td>

<td>操作</td>
</tr>
<tr>
<td><%out.print(rs.getString("trainnum")); %></td>
<td><%out.print(rs.getString("staname1") "-" rs.getString("staname2")); %></td>
<td><%out.print(rs.getString("begintime").substring(0,5)); %></td>
<td><%out.print(rs.getString("arrivetime").substring(0,5)); %></td>
<td><%out.print(rs.getString("usetime")); %></td>
<td><%out.print(rs.getString("s2")); %></td>
<td><%out.print(rs.getString("s1")); %></td>
<td><%out.print(rs.getString("sv")); %></td>

<td><a  href="ticket_pur.jsp?trainnum=<%=rs.getString("trainnum")%>">购买</a></td>
</tr>

<% while(rs.next()){
String sta1=rs.getString("staname1");
%>
<tr>
<td><%out.print(rs.getString("trainnum")); %></td>
<td><%out.print(rs.getString("staname1") "-" rs.getString("staname2")); %></td>
<td><%out.print(rs.getString("begintime").substring(0,5)); %></td>
<td><%out.print(rs.getString("arrivetime").substring(0,5)); %></td>
<td><%out.print(rs.getString("usetime")); %></td>
<td><%out.print(rs.getString("s2")); %></td>
<td><%out.print(rs.getString("s1")); %></td>
<td><%out.print(rs.getString("sv")); %></td>

<td><a  href="ticket_pur.jsp?trainnum=<%=rs.getString("trainnum")%> ">购买</a></td>
</tr>
</table>
<% }
}
else out.print("无票");
db.close();
%>
</body>
</html>

<%@ page language="java" contentType="text/html; charset=UTF-8"
    pageEncoding="UTF-8"%>
<!DOCTYPE html>
<html>
<head>
<meta charset="UTF-8">
<title>车票明细</title>
</head>
<jsp:useBean id="db" class='hello.DB'></jsp:useBean>
<body style="background:url(page/zz2.png)">
hello：<%out.print(session.getAttribute("user"));%>
<br><h1 align="center">请确定您的订单</h1>
<%@ page import="java.sql.*" %>
<% String trainnum=request.getParameter("trainnum");
session.setAttribute("trainnum",trainnum);
String begin=(String)session.getAttribute("begin");
String end=(String)session.getAttribute("end");
String day=(String)session.getAttribute("day");
%>
<%
db.init();
String sql="declare @price float "
"exec getprice '" trainnum "','" begin "','" end "',@price out "
"select @price p,@price*1.6 p1";
ResultSet rs=db.executeQuery(sql);
String price="",price2="";
if(rs.next()){
price=rs.getString("p");//2等
price2=rs.getString("p1");//1等
session.setAttribute("price2",price2);
session.setAttribute("price",price);
}
if(price.length()>5)price=price.substring(0,4);
if(price2.length()>5){
price2=price2.substring(0,4);
}
%>
<table border="1">
<tr><td>车次</td><td>出发</td><td>终点</td><td>一等座</td><td>二等座</td><td>无座</td></tr>
<tr><td width="10%"><%out.print(trainnum); %></td>
<td width="8%"><%out.print(begin); %></td>
<td width="8%"><%out.print(end); %></td>
<td width="8%"><%out.print(price2 "元"); %></td>
<td width="8%"><%out.print(price "元"); %></td>
<td width="8%"><%out.print(price "元"); %></td></tr>
</table>
<form action="success.jsp">
乘客名：<input name="passenger" type ="text" /><br>
身份证号：<input name="idnum" type ="text" /><br>
是否携童：
<input  name="xt"type="radio" value="是"/>yes
<input checked="true"  name="xt"type="radio" value="否"/>no
<br>
<input  name="seattype"type="radio" value="一等座"/>一等座
<input checked="true"  name="seattype"type="radio" value="二等座"/>二等座
<input name="seattype"type="radio" value="无座"/>无座<br>
<input type="submit" value='确认购买'/>
</form>
<%db.close(); %>
</body>
</html>

<%@ page language="java" contentType="text/html; charset=UTF-8"
    pageEncoding="UTF-8"%>
<!DOCTYPE html>
<html>
<head>
<meta charset="UTF-8">
<title>Insert title here</title>
</head>
<jsp:useBean id="db" class='hello.DB'></jsp:useBean>
<body style="background:url(page/zz2.png)">
<h1 align="center">我的订单</h1>
<br><br>
<%@ page import="java.sql.*" %>
订单<%out.print(request.getParameter("ordernum")); %>成功退票
<%
db.init();
String s="select * from orders where ordernum='" request.getParameter("ordernum") "'";
ResultSet rs=db.executeQuery(s);
rs.next();
String passenger =rs.getString("passenger");
String trainnum=rs.getString("trainnum");
String begin=rs.getString("Originating");
String end=rs.getString("arriving");
String seattype=rs.getString("seattype");
String time=rs.getString("time");
//座位增加
String sql="exec seat_opearing '" trainnum
"','" begin
"','" end "','" seattype
"','" time "','-'";
db.executeQuery(sql);
//乘客减少  触发器实现
sql="exec order_update '" request.getParameter("ordernum") "'";
//订单信息修改

sql="update orders set status='已退票'  where ordernum='" request.getParameter("ordernum") "'";
db.executeQuery(sql);
db.close();
%>
</body>
</html>

<%@ page language="java" contentType="text/html; charset=UTF-8"
    pageEncoding="UTF-8"%>
<!DOCTYPE html>
<html>
<head>
<meta charset="UTF-8">
<title>Insert title here</title>
</head>
<body>
<h1><a>我的信息</a></h1>
</body>
</html>