⭐ 欢迎来到虫虫下载站! | 📦 资源下载 📁 资源专辑 ℹ️ 关于我们
⭐ 虫虫下载站

📄 reslut.jsp

📁 JSP+SQL2000做的火车站售票管理系统
💻 JSP
字号:
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<%@ include file="connection.jsp" %>
<%
ResultSet rsVerify;
String cs_city1,cs_city2,cs_trainno,sqlVerify,tujcity,trainno,leix,shif,zhongd,lic,yzshu,rzshu,ywshu,rwshu;
%>
<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_city1=request.getParameter("cs_city1");
   cs_city2=request.getParameter("cs_city2");
   sqlVerify="select * from cs_train where tujcity LIKE '%"+cs_city1+"%"+cs_city2+"%'";
   rsVerify=sql.executeQuery(sqlVerify);
   while(rsVerify.next())
   {
   cs_trainno=(String)rsVerify.getString("trainno");
   leix=(String)rsVerify.getString("leix");
   shif=(String)rsVerify.getString("shif");
   zhongd=(String)rsVerify.getString("zhongd");
   lic=(String)rsVerify.getString("lic");
   yzshu=(String)rsVerify.getString("yzshu");
   rzshu=(String)rsVerify.getString("rzshu");
   ywshu=(String)rsVerify.getString("ywshu");
   rwshu=(String)rsVerify.getString("rwshu");
   
   %>
   <tr>
	 <td><%=cs_trainno%></td>
	 <td><%=leix%></td>
	 <td><%=shif%></td>
	 <td><%=cs_city1%></td>
	 <td><%=cs_city2%></td>
	 <td><%=zhongd%></td>
	 <td><%=lic%></td>
	 <td><%=yzshu%></td>
	 <td><%=rzshu%></td>
	 <td><%=ywshu%></td>
	 <td><%=rwshu%></td> 
   </tr>
   <% }%> 
   </table>
   <% Conn.close(); %>
   <h7><b>查找相关车次的详细信息</b></h7>
   <form action="trainmessage.jsp" method="post" name="search2">
	<p>车次:<input type="text" class="text" name="cs_trainno"></p>
	<p><input type="submit" class="btn" value="确定"> <input name="重置" type="reset" class="btn" value="重置"> 
	</form>
	<p><b>如想网上购票请前往<a href="list.jsp">网上购票</a></b></p>
	</div>
	<div id="foot">
	版权所有<a href="mailto:xusongsong217x@126.com">作者</a>
	</div>
</body>
</html>

⌨️ 快捷键说明

复制代码 Ctrl + C
搜索代码 Ctrl + F
全屏模式 F11
切换主题 Ctrl + Shift + D
显示快捷键 ?
增大字号 Ctrl + =
减小字号 Ctrl + -