实例介绍
【实例简介】
火车购票系统
【实例截图】
【核心代码】
<%@ 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>
相关软件
小贴士
感谢您为本站写下的评论，您的评论对其它用户来说具有重要的参考价值，所以请认真填写。
- 类似“顶”、“沙发”之类没有营养的文字，对勤劳贡献的楼主来说是令人沮丧的反馈信息。
- 相信您也不想看到一排文字/表情墙，所以请不要反馈意义不大的重复字符，也请尽量不要纯表情的回复。
- 提问之前请再仔细看一遍楼主的说明，或许是您遗漏了。
- 请勿到处挖坑绊人、招贴广告。既占空间让人厌烦，又没人会搭理，于人于己都无利。
关于好例子网
本站旨在为广大IT学习爱好者提供一个非营利性互相学习交流分享平台。本站所有资源都可以被免费获取学习研究。本站资源来自网友分享，对搜索内容的合法性不具有预见性、识别性、控制性，仅供学习研究，请务必在下载后24小时内给予删除，不得用于其他任何用途，否则后果自负。基于互联网的特殊性，平台无法对用户传输的作品、信息、内容的权属或合法性、安全性、合规性、真实性、科学性、完整权、有效性等进行实质审查；无论平台是否已进行审查，用户均应自行承担因其传输的作品、信息、内容而可能或已经产生的侵权或权属纠纷等法律责任。本站所有资源不代表本站的观点或立场，基于网友分享，根据中国法律《信息网络传播权保护条例》第二十二与二十三条之规定，若资源存在侵权或相关问题请联系本站客服人员，点此联系我们。关于更多版权及免责申明参见 版权及免责申明
网友评论
我要评论