📄 index.asp
字号:
<script>
//
// 力天2002网络办公系统
// Copyright (c) 深圳市力天软件开发有限公司
// http://www.ebexpert.net
//
// 文件名 : index.asp
// 描述 : 航班时刻列表
// 版本 :
// 作者 : zyh
// 备注 :
</script>
<!--#include file="check.asp"-->
<!--#include file="const.inc"-->
<html>
<head>
<title>scroll menu</title>
<link rel="stylesheet" href="../css/eintrdemo.css">
</head>
<script>
function js_openpage(url) {
var
newwin=window.open(url,"NewWin","toolbar=no,resizable=yes,location=no,directories=no,status=no,menubar=no,scrollbars=yes,top=220,left=220,width=500,height=400");
// newwin.focus();
return false;
}
function del(url)
{
if (confirm("是否要删除此航班信息"))
{
window.open(url,"NewWin","toolbar=no,resizable=yes,location=no,directories=no,status=no,menubar=no,scrollbars=yes,top=220,left=220,width=450,height=200");
}
}
</Script>
<% if request.querystring("sele")="all" then
session("sqlstr_flight")=""
end if
if not isempty(request.querystring("page")) then
currpage=cint(request.querystring("page"))
end if
Set conn=Server.CreateObject("ADODB.Connection")
DBPath1=server.mappath("../access.mdb")
conn.Open "driver={Microsoft Access Driver (*.mdb)};dbq=" & DBPath1
set rs=server.CreateObject ("adodb.recordset")
sqlstr="select * from pubplane "
if session("sqlstr_flight")<>"" then
sqlstr=sqlstr & session("sqlstr_flight")
else
if not isempty(request.form("seler")) then
sqlstr=sqlstr & " where "
select case request.form("seler")
case "leavestation"
sqlstr_add=" leavestation like '%"&request.form("selecttext")&"%' "
case "returnstation"
sqlstr_add=" returnstation like '%"&request.form("selecttext")&"%' "
end select
session("sqlstr_flight")=" where " &sqlstr_add
sqlstr=sqlstr & sqlstr_add
end if
end if
rs.open sqlstr,conn,1,1
alls=rs.Recordcount
if Request.QueryString("allnum")<>"" OR Request.QueryString("allnum")<>null then
session("maxpage")=Cint(Request.QueryString("allnum"))
else
session("maxpage")=18
end if
maxpage=session("maxpage")
'判断共有几页
if (alls mod maxpage)=0 then
pagesum=alls\maxpage
else
pagesum=alls\maxpage+1
end if
'判断当前页
if Request.QueryString("page")<>"" or Request.QueryString("page")<>null then
session("currpage")=Cint(Request.QueryString("page"))
else
session("currpage")=1
end if
currpage= session("currpage")
'把光标移到当前页的第一条记录
if Not rs.Eof then
rs.Move (currpage-1)*maxpage
end if %>
<body bgcolor="#FFFFFF" topmargin="0" leftmargin="0"
onLoad="MM_preloadImages('/images/add_on.gif','images/modify_on.gif','images/delete_on.gif','images/add_on.gif','images/search_on.gif','images/showall_on.gif')">
<table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td class="heading" bgcolor="#4e5960" colspan="2" height="3"></td>
</tr>
<tr>
<td class="heading" bgcolor="#4e5960" colspan="2"> <font color="#FFFFFF"><b>航班时刻表</b></font></td>
</tr>
<tr>
<!--webbot BOT="GeneratedScript" PREVIEW=" " startspan --><script Language="JavaScript"><!--
function FrontPage_Form1_Validator(theForm)
{
if (theForm.selecttext.value == "")
{
alert("请在 selecttext 域中输入值。");
theForm.selecttext.focus();
return (false);
}
if (theForm.selecttext.value.length > 12)
{
alert("在 selecttext 域中，请最多输入 12 个字符。");
theForm.selecttext.focus();
return (false);
}
return (true);
}
//--></script><!--webbot BOT="GeneratedScript" endspan --><form method="post" action="index.asp" name="FrontPage_Form1" onsubmit="return FrontPage_Form1_Validator(this)">
<td valign="top" height="332">
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -