📄 trainmessage.jsp
字号:
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<%@ page contentType="text/html; Charset=GB2312" %>
<%@ include file="connection.jsp" %>
<%
ResultSet rsVerify;
String cs_trainno,sqlVerify,trainno,leix,zhanshu,nextcity,daodtime,chuftime,lic,yzprice,rzprice,ywprice,rwprice;
%>
<html>
<head>
<title>查询结果</title>
<link href="css/rege.css" rel="stylesheet" type="text/css">
</head>
<body>
<div id="container">
<div id="banner"><img src="image/top.jpg" width="700" height="93"></div>
<%@ include file="dat/head.txt"%>
<div id="main">
<table width="500" border="1">
<th>车次
<th>类型
<th>站数
<th>下一站
<th>到站时间
<th>出站时间
<th>里程
<th>硬座价
<th>软座价
<th>硬卧价
<th>软卧价
<%
cs_trainno=request.getParameter("cs_trainno");
sqlVerify="select * from cd_train where trainno='"+cs_trainno+"'";
rsVerify=sql.executeQuery(sqlVerify);
while(rsVerify.next())
{
trainno=(String)rsVerify.getString("trainno");
leix=(String)rsVerify.getString("leix");
zhanshu=(String)rsVerify.getString("zhanshu");
nextcity=(String)rsVerify.getString("nextcity");
daodtime=(String)rsVerify.getString("daodtime");
chuftime=(String)rsVerify.getString("chuftime");
lic=(String)rsVerify.getString("lic");
yzprice=(String)rsVerify.getString("yzprice");
rzprice=(String)rsVerify.getString("rzprice");
ywprice=(String)rsVerify.getString("ywprice");
rwprice=(String)rsVerify.getString("rwprice");
%>
<tr>
<td><%=trainno%></td>
<td><%=leix%></td>
<td><%=zhanshu%></td>
<td><%=nextcity%></td>
<td><%=daodtime%></td>
<td><%=chuftime%></td>
<td><%=lic%></td>
<td><%=yzprice%></td>
<td><%=rzprice%></td>
<td><%=ywprice%></td>
<td><%=rwprice%></td>
</tr>
<%}%>
</table>
<%
Conn.close();
%>
</div>
<div id="foot">
版权所有<a href="mailto:xusongsong217x@126.com">作者</a>
</div>
</body>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -