?? index.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="../user/index.jsp">首頁</a>
<a href="../user/inf_edit.jsp">控制面板</a> <a href="../common/exit.jsp">退出</a> </td>
</tr>
</TBODY>
</table>
<form name="search" method="post" action="../user/do_search.jsp">
<table width="600" border="0" align="center" cellpadding="0" cellspacing="0">
<tr>
<td width="700" bgcolor="#ebebeb"><span class="style2">搜索車次：</span>
關鍵字:<input type="text" name="keywords">
<input type="submit" value="Search">
</table>
</form>
<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>
<td width="600" align="center" bgcolor="#cccccc">
查看
</td>
</tr>
</table>
<%
ResultSet rs=search.getResultSetBySql("select * from traininf");
if(rs!=null&&rs.next())
{
%>
<table cellSpacing=0 cellPadding=0 width=600 align="center" align="center">
<%
do
{
%>
<tr>
<td width="600" align="center" bgcolor="#EBEBEB">
<%=rs.getString(1)%>
</td>
<td width="600" align="center" bgcolor="#EBEBEB">
<%=rs.getString(2)%>
</td>
<td width="600" align="center" bgcolor="#EBEBEB">
<%=rs.getString(3)%>
</td>
<td width="600" align="center" bgcolor="#EBEBEB">
<%=rs.getString(4)%>
</td>
<td width="600" align="center" bgcolor="#EBEBEB">
<%=rs.getInt(6)%>
</td>
<td width="600" align="center" bgcolor="#EBEBEB" height="25">
<a href="../train/look_by_user.jsp?train_serial=<%=rs.getString(1)%>">查看</a>
</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>
<td width="600" align="center" bgcolor="#cccccc" height="3">
</td>
</tr>
<%
}
while(rs.next());
%>
</table>
<%
}
else
{
%>
<table cellSpacing=0 cellPadding=0 width=600 align="center" align="center">
<tr>
<td width="600" align="center" bgcolor="#EBEBEB">
該系統沒有添加任何列車線路
</td>
</tr>
</table>
<%
}
%>
</body>
</html>
?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -