📄 index.asp
字号:
<%
function opendb(DBPath,sessionname,dbsort)
dim conn
Set conn=Server.CreateObject("ADODB.Connection")
DBPath1=server.mappath("../../db/#sdoa.asa")
conn.Open "driver={Microsoft Access Driver (*.mdb)};dbq=" & DBPath1
set session(sessionname)=conn
set opendb=session(sessionname)
end function
%>
<%
oabusyname=request.cookies("oabusyname")
oabusyusername=request.cookies("oabusyusername")
oabusyuserdept=request.cookies("oabusyuserdept")
oabusyuserlevel=request.cookies("oabusyuserlevel")
if oabusyusername="" then
response.write("<script language=""javascript"">")
response.write("window.top.location.href='../../default.asp';")
response.write("</script>")
response.end
end if
%>
<!--#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_train")=""
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 pubtrain "
if session("sqlstr_train")<>"" then
sqlstr=sqlstr & session("sqlstr_train")
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_train")=" 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/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.seler.selectedIndex < 0)
{
alert("请选择 seler 选项中的一项。");
theForm.seler.focus();
return (false);
}
var numSelected = 0;
var i;
for (i = 0; i < theForm.seler.length; i++)
{
if (theForm.seler.options[i].selected)
numSelected++;
}
if (numSelected > 12)
{
alert("请选择 seler 选项中的最多 12 项。");
theForm.seler.focus();
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -