📄 resultquery1.jsp

📁 基于JSP的公交查询系统,很好用的,适于学习,操作语句全在jsp页面里
💻 JSP
字号:
<%@ page contentType="text/html; charset=gb2312" language="java" import="java.sql.*" errorPage="" %>
<%@ page import="java.util.*" %>

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">

<STYLE type=text/css>BODY {
	FONT-SIZE: 13px; FONT-FAMILY: 宋体; TEXT-ALIGN: center
}
TR {
	FONT-SIZE: 13px; FONT-FAMILY: 宋体; TEXT-ALIGN: center
}
TD {
	FONT-SIZE: 13px; FONT-FAMILY: 宋体; TEXT-ALIGN: center
}
</STYLE>

<META content="MSHTML 6.00.2900.2995" name=GENERATOR><title>车次查询结果</title></HEAD>
<BODY>
<% Connection con;
    String statement="";
	ResultSet result;
	String BusID=new String(request.getParameter("query1").getBytes("ISO8859_1"),"GBK");
     String a_startime="";
	 String a_endtime="";
	 String w_startime="";
	 String w_endtime="";
     int t_value=0;
    
	String stations[]=new String[100];
	int count=0;
     
     
  	try{ Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
	     }
		catch(ClassNotFoundException e){}
		 
	try{ 
	      con=DriverManager.getConnection("jdbc:odbc:nbos","","");
	      Statement sql=con.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_READ_ONLY); 
		  statement="select * from bus where BusID='"+BusID+"'";
		  result=sql.executeQuery(statement);
		  if(!result.next())
		  { response.sendRedirect("errorquery1.jsp");
		  }
		  else{ result.previous();
		  //显示站点的详细信息
          while(result.next()){
           String busid=result.getString("BusID");
	       String Detail=result.getString("Detail");
           a_startime=result.getString("A_STime");
	       a_endtime=result.getString("A_ETime");
	       w_startime=result.getString("W_STime");
	       w_endtime=result.getString("W_ETime");
           t_value=result.getInt("T_Value");

		   StringTokenizer str1=new StringTokenizer(Detail,"->");
		  while(str1.hasMoreTokens())
		      { stations[count]=str1.nextToken();
			 count++;
			  }//endwhile
			 
	          }//endelse
		      }//endtry
			  
		
			  
		result.close();
   }catch(SQLException e1){}
	
	 
%>
<TABLE cellSpacing=1 cellPadding=3 width=650 align=center bgColor=#003399 
border=0>
  <TBODY>
  <TR>
    <TD background=Picture/topbg.gif height=20></TD>
  </TR>
  <TR bgColor=#7da4ec>
    <TD><STRONG><FONT color=#ffffff>
      
      车次查询结果</FONT></STRONG></TD>
  </TR>
  <TR bgColor=#e8f3ff>
    <TD><!--查询结果显示开始-->
      <TABLE cellSpacing=1 cellPadding=3 width=500 bgColor=#003399 border=0>
        <TBODY>
        <TR bgColor=#fddd90>
          <TD width=150 rowspan="2">车次: <font color="#FF0000"><%=BusID%></font>
          车</TD>
          <TD width="91" rowspan="2">票价:<font color="#FF0000"><%=t_value%></font>元</TD>
          <TD width="237">夏季时间：<%=a_startime%>--<%=a_endtime%></TD>
        </TR>
        <TR bgColor=#fddd90>
          <TD>冬季时间：<%=w_startime%>--<%=w_endtime%></TD>
        </TR>
        <TR bgColor=#fddd90>
          <TD width=150>经过站次</TD>
          <TD colspan="2">经过站点</TD>
        </TR>
       <% for(int i=0;i<count;i++) {  %>
		<TR onmouseover="this.style.backgroundColor = '#FFF9EE'" 
        onmouseout="this.style.backgroundColor = ''" bgColor=#e8f3ff>
        
		  <TD><%=i+1%></TD>
          <TD colspan="2"><a href="resultquery2.jsp?query2=<%=stations[i]%>" target="_blank"><%=stations[i]%></a></TD>
		</TR>
		<% }  %>
		</TBODY></TABLE>
      <!--查询结果显示结束--><BR>        <IMG 
      src="Picture/close_window.gif" width="78" height="21" border=0 
      style="CURSOR: hand" onclick=window.close()> </TD>
  </TR>
  
  <TR>
    <TD background=Picture/bottombg.gif 
height=20></TD>
  </TR></TBODY></TABLE> 
</BODY></HTML>
⌨️ 快捷键说明

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