?? do_search.jsp
字號:
<%@ page language="java" contentType="text/html;charset=gb2312"%>
<%@ page import="java.sql.*"%>
<jsp:useBean id="search" class="com.db.Common"/>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<title>搜索結果</title>
<meta http-equiv="content-type" content="text/html; charset=gb2312">
<link rel="stylesheet" href="../css/mm_lodging1.css" type="text/css">
</head>
<%
request.setCharacterEncoding("gb2312");
if(session.getAttribute("isLogin")==null)
{
%>
<jsp:forward page="../login/login.html"/>
<%
}
%>
<body text=#003300 vLink=#002200 leftMargin=0 topMargin=0>
<table width="600" border="0" align="center" cellpadding="0" cellspacing="0">
<tr width="600">
<td><img src="../image/16.gif"></td>
</tr>
</table>
<table cellSpacing=0 cellPadding=0 width=600 align="center" bgcolor="#033D7C">
<TBODY>
<tr width="600" bgcolor="#a4c2c2">
<td height="36" colspan="3" id="navigation" class="navText" align="center"> <a href="../system_admin/index.jsp">首頁</a>
<a href="../user/admin_by_s_admin.jsp">用戶管理</a> <a href="../admin/admin_by_s_admin.jsp">管理員管理</a>
<a href="../admin/add_by_s.jsp">添加管理員</a> <a href="../system_admin/inf_edit.jsp">控制面板</a>
<a href="../train/1stProcess_add_by_s.jsp">添加列車路線</a> <a href="../common/exit.jsp">退出</a> </td>
</tr>
</TBODY>
</table>
<br>
<%
String search_type=request.getParameter("search_type");
String keywords=request.getParameter("keywords");
String sql="";
ResultSet rst=null;
if(search_type.equals("車次"))
{
sql="select * from traininf where train_serial='"+keywords+"'";
rst=search.getResultSetBySql(sql);
int stations_num=0;
int h_s_num=0;
int s_s_num=0;
int h_r_num=0;
int s_r_num=0;
if(rst.next())
{
%>
<table cellSpacing=0 cellPadding=0 width=600 align="center" align="center">
<tr>
<td width="600" align="center" bgcolor="#cccccc">
硬座票量
</td>
<td width="600" align="center" bgcolor="#cccccc">
軟座票量
</td>
<td width="600" align="center" bgcolor="#cccccc">
硬臥票量
</td>
<td width="600" align="center" bgcolor="#cccccc">
軟臥票量
</td>
</tr>
</table>
<table cellSpacing=0 cellPadding=0 width=600 align="center" align="center">
<%
//ResultSet rs=search.getResultSetBySql("select * from traininf where train_serial='"+keywords+"'");
%>
<tr>
<%
stations_num=rst.getInt(5);
h_s_num=rst.getInt(7);
s_s_num=rst.getInt(8);
h_r_num=rst.getInt(9);
s_r_num=rst.getInt(10);
%>
<td width="600" align="center" bgcolor="#EBEBEB">
<%=h_s_num%>
</td>
<td width="600" align="center" bgcolor="#EBEBEB">
<%=s_s_num%>
</td>
<td width="600" align="center" bgcolor="#EBEBEB">
<%=h_r_num%>
</td>
<td width="600" align="center" bgcolor="#EBEBEB">
<%=s_r_num%>
</td>
</tr>
<%
%>
</table>
<%
ResultSet rs_stations=search.getResultSetByTable(""+keywords+"_stations_inf");
ResultSet rs_start_time=search.getResultSetByTable(""+keywords+"_start_time");
ResultSet rs_to_time=search.getResultSetByTable(""+keywords+"_to_time");
ResultSet rs_hs_price=search.getResultSetByTable(""+keywords+"_hard_seat_price");
ResultSet rs_ss_price=search.getResultSetByTable(""+keywords+"_soft_seat_price");
ResultSet rs_hr_price=search.getResultSetByTable(""+keywords+"_hard_recumbency_price");
ResultSet rs_sr_price=search.getResultSetByTable(""+keywords+"_soft_recumbency_price");
String[] stations=new String[stations_num];
String[] start_time=new String[stations_num-1];
String[] to_time=new String[stations_num-1];
float[] hs_price=new float[stations_num-1];
float[] ss_price=new float[stations_num-1];
float[] hr_price=new float[stations_num-1];
float[] sr_price=new float[stations_num-1];
if(rs_stations!=null&&rs_stations.next())
{
for(int i=1;i<=stations_num;i++)
{
stations[i-1]=rs_stations.getString(i+1);
}
}
if(rs_start_time!=null&&rs_start_time.next())
{
for(int i=1;i<stations_num;i++)
{
start_time[i-1]=rs_start_time.getString(i+1);
}
}
if(rs_to_time!=null&&rs_to_time.next())
{
for(int i=1;i<stations_num;i++)
{
to_time[i-1]=rs_to_time.getString(i+1);
}
}
if(rs_hs_price!=null&&rs_hs_price.next())
{
for(int i=1;i<stations_num;i++)
{
hs_price[i-1]=rs_hs_price.getFloat(i+1);
}
}
if(rs_ss_price!=null&&rs_ss_price.next())
{
for(int i=1;i<stations_num;i++)
{
ss_price[i-1]=rs_ss_price.getFloat(i+1);
}
}
if(rs_hr_price!=null&&rs_hr_price.next())
{
for(int i=1;i<stations_num;i++)
{
hr_price[i-1]=rs_hr_price.getFloat(i+1);
}
}
if(rs_sr_price!=null&&rs_sr_price.next())
{
for(int i=1;i<stations_num;i++)
{
sr_price[i-1]=rs_sr_price.getFloat(i+1);
}
}
%>
<br>
<table cellSpacing=0 cellPadding=0 width=600 align="center" align="center">
<tr>
<td width="600" align="center" bgcolor="#cccccc">
站點
</td>
<td width="600" align="center" bgcolor="#cccccc">
發車時間
</td>
<td width="600" align="center" bgcolor="#cccccc">
到達時間
</td>
</tr>
<tr>
<td width="600" align="center" bgcolor="#cccccc" height="3">
</td>
<td width="600" align="center" bgcolor="#cccccc" height="3">
</td>
<td width="600" align="center" bgcolor="#cccccc" height="3">
</td>
</tr>
<tr>
<td width="600" align="center" bgcolor="#EBEBEB">
<%=stations[0]%>
</td>
<td width="600" align="center" bgcolor="#EBEBEB">
<%=start_time[0]%>
</td>
<td width="600" align="center" bgcolor="#EBEBEB">
---
</td>
</tr>
<tr>
<td width="600" align="center" bgcolor="#cccccc" height="3">
</td>
<td width="600" align="center" bgcolor="#cccccc" height="3">
</td>
<td width="600" align="center" bgcolor="#cccccc" height="3">
</td>
</tr>
<%
for(int i=1;i<=stations_num-2;i++)
{
%>
<tr>
<td width="600" align="center" bgcolor="#EBEBEB">
<%=stations[i]%>
</td>
<td width="600" align="center" bgcolor="#EBEBEB">
<%=start_time[i]%>
</td>
<td width="600" align="center" bgcolor="#EBEBEB">
<%=to_time[i-1]%>
</td>
</tr>
<tr>
<td width="600" align="center" bgcolor="#cccccc" height="3">
</td>
<td width="600" align="center" bgcolor="#cccccc" height="3">
</td>
<td width="600" align="center" bgcolor="#cccccc" height="3">
</td>
</tr>
<%
}
%>
<tr>
<td width="600" align="center" bgcolor="#EBEBEB">
<%=stations[stations_num-1]%>
</td>
<td width="600" align="center" bgcolor="#EBEBEB">
---
</td>
<td width="600" align="center" bgcolor="#EBEBEB">
<%=to_time[stations_num-2]%>
</td>
</tr>
</table>
<br>
<table cellSpacing=0 cellPadding=0 width=600 align="center" align="center">
<tr>
<td width="600" align="center" bgcolor="#cccccc">
相鄰站點
</td>
<td width="600" align="center" bgcolor="#cccccc">
硬座價格
</td>
<td width="600" align="center" bgcolor="#cccccc">
軟座價格
</td>
<td width="600" align="center" bgcolor="#cccccc">
硬臥價格
</td>
<td width="600" align="center" bgcolor="#cccccc">
軟臥價格
</td>
</tr>
<%
for(int i=1;i<stations_num;i++)
{
%>
<tr>
<td width="600" align="center" bgcolor="#EBEBEB">
<%=stations[i-1]%>--<%=stations[i]%>
</td>
<td width="600" align="center" bgcolor="#EBEBEB">
<%=hs_price[i-1]%>
</td>
<td width="600" align="center" bgcolor="#EBEBEB">
<%=ss_price[i-1]%>
</td>
<td width="600" align="center" bgcolor="#EBEBEB">
<%=hr_price[i-1]%>
</td>
<td width="600" align="center" bgcolor="#EBEBEB">
<%=sr_price[i-1]%>
</td>
</tr>
<tr>
<td width="600" align="center" bgcolor="#cccccc" height="3">
</td>
<td width="600" align="center" bgcolor="#cccccc" height="3">
</td>
<td width="600" align="center" bgcolor="#cccccc" height="3">
</td>
<td width="600" align="center" bgcolor="#cccccc" height="3">
</td>
<td width="600" align="center" bgcolor="#cccccc" height="3">
</td>
</tr>
<%
}
%>
</table>
<%
}
else
{
%>
<table cellSpacing=0 cellPadding=0 width=600 align="center" align="center">
<tr>
<td width="600" align="center" bgcolor="#cccccc">
沒有您要找的信息
</td>
</tr>
</table>
<%
}
}
else
{
sql="select * from userinf where username='"+keywords+"'";
rst=search.getResultSetBySql(sql);
if(rst!=null&&rst.next())
{
%>
<table cellSpacing=0 cellPadding=0 width=600 align="center" align="center">
<tr>
<td width="600" align="center" bgcolor="#cccccc">
<%=keywords%>詳細信息列表
</td>
</tr>
</table>
<table cellSpacing=0 cellPadding=0 width=600 align="center" align="center">
<tr>
<td width="600" align="center" bgcolor="#EBEBEB">
真實姓名：
</td>
<td width="600" align="center" bgcolor="#EBEBEB">
<%=rst.getString(3)%>
</td>
</tr>
<tr>
<td width="600" align="center" bgcolor="#cccccc" height="3">
</td>
<td width="600" align="center" bgcolor="#cccccc" height="3">
</td>
</tr>
<tr>
<td width="600" align="center" bgcolor="#EBEBEB">
性別：
</td>
<td width="600" align="center" bgcolor="#EBEBEB">
<%=rst.getString(4)%>
</td>
</tr>
<tr>
<td width="600" align="center" bgcolor="#cccccc" height="3">
</td>
<td width="600" align="center" bgcolor="#cccccc" height="3">
</td>
</tr>
<tr>
<td width="600" align="center" bgcolor="#EBEBEB">
年齡：
</td>
<td width="600" align="center" bgcolor="#EBEBEB">
<%=rst.getInt(5)%>
</td>
</tr>
<tr>
<td width="600" align="center" bgcolor="#cccccc" height="3">
</td>
<td width="600" align="center" bgcolor="#cccccc" height="3">
</td>
</tr>
<tr>
<td width="600" align="center" bgcolor="#EBEBEB">
身份證號：
</td>
<td width="600" align="center" bgcolor="#EBEBEB">
<%=rst.getString(6)%>
</td>
</tr>
<tr>
<td width="600" align="center" bgcolor="#cccccc" height="3">
</td>
<td width="600" align="center" bgcolor="#cccccc" height="3">
</td>
</tr>
<tr>
<td width="600" align="center" bgcolor="#EBEBEB">
通信地址：
</td>
<td width="600" align="center" bgcolor="#EBEBEB">
<%=rst.getString(7)%>
</td>
</tr>
<tr>
<td width="600" align="center" bgcolor="#cccccc" height="3">
</td>
<td width="600" align="center" bgcolor="#cccccc" height="3">
</td>
</tr>
<tr>
<td width="600" align="center" bgcolor="#EBEBEB">
電子郵箱：
</td>
<td width="600" align="center" bgcolor="#EBEBEB">
<%=rst.getString(8)%>
</td>
</tr>
<tr>
<td width="600" align="center" bgcolor="#cccccc" height="3">
</td>
<td width="600" align="center" bgcolor="#cccccc" height="3">
</td>
</tr>
<tr>
<td width="600" align="center" bgcolor="#EBEBEB">
電話：
</td>
<td width="600" align="center" bgcolor="#EBEBEB">
<%=rst.getString(9)%>
</td>
</tr>
</table>
<%
}
else
{
%>
<table cellSpacing=0 cellPadding=0 width=600 align="center" align="center">
<tr>
<td width="600" align="center" bgcolor="#cccccc">
沒有您要找的信息
</td>
</tr>
</table>
<%
}
}
%>
</body>
</html>
?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -