📄 add.asp
字号:
<script>
//
// 力天2002网络办公系统
// Copyright (c) 深圳市力天软件开发有限公司
// http://www.ebexpert.net
//
// 文件名 : add.asp
// 描述 : 航班时刻数据添加与提交
// 版本 :
// 作者 : zyh
// 备注 :
</script>
<!--#include file="const.inc"-->
<%
planecode=trim(request("planecode"))
if planecode<>"" then
planetype=trim(request("planetype"))
leavestation=trim(request("leavestation"))
returnstation=trim(request("returnstation"))
passstation=trim(request("passstation"))
leavetime=trim(request("leavetime"))
returntime=trim(request("returntime"))
price=trim(request("price"))
remark=trim(request("remark"))
Set conn=Server.CreateObject("ADODB.Connection")
DBPath1=server.mappath("../access.mdb")
conn.Open "driver={Microsoft Access Driver (*.mdb)};dbq=" & DBPath1
sql="insert into pubplane(planecode,planetype,leavestation,returnstation,passstation,leavetime,returntime,price,remark) values ('" & planecode & "','" & planetype & "','" & leavestation & "','" & returnstation & "','" & passstation & "','" & leavetime & "','" & returntime & "','" & price & "','" & remark & "')"
conn.Execute sql
set conn=nothing
%>
<script language=javascript>
window.close();
window.opener.parent.frames("main").document.location ="index.asp?add=judge";
</Script>
<% else %>
<html>
<head>
<title>添加航班时刻表</title>
<meta http-equiv="Content-Type" content="text/html; cha rsadet=gb2312">
<link rel="stylesheet" href="../css/eintrdemo.css">
</head>
<body bgcolor="#efefef" leftmargin="0" topmargin="0" marginwidth="0" marginheight="0" onLoad="MM_preloadImages('images/add_on.gif')">
<form method="post" action="add.asp" name="form">
<table width="100%" border="0" cellspacing="1" cellpadding="2">
<tr bgcolor="#4E5960">
<td class="heading">
<p align="left"><b><font color="#FFFFFF">航班添加</font></b></p>
</td>
</tr>
</table>
<table width="100%" border="1" cellspacing="0" cellpadding="1" bordercolordark="#FFFFFF" bordercolor="#000000">
<tr>
<td width="12%" bgcolor="bfbfbf" valign="top">航班：</td>
<td width="88%">
<p align="left"><input size=30 maxlength=50 name="planecode"><input type="hidden" value="<%=request("channelid")%>" name="channelid">
</p>
</td>
</tr>
<tr>
<td width="12%" bgcolor="bfbfbf" valign="top">机型：</td>
<td width="88%">
<input size=30 maxlength=50 name="planetype">
</td>
</tr>
<tr>
<td width="12%" bgcolor="bfbfbf" valign="top">起点：</td>
<td width="88%">
<input size=20 maxlength=20 name="leavestation">
</td>
</tr>
<tr>
<td width="12%" bgcolor="bfbfbf" valign="top">终点：</td>
<td width="88%">
<input size=20 maxlength=20 name="returnstation">
</td>
</tr>
<tr>
<td width="12%" bgcolor="bfbfbf" valign="top">中途停降：</td>
<td width="88%">
<input size=40 maxlength=200 name="passstation">
</td>
</tr>
<tr>
<td width="12%" bgcolor="bfbfbf" valign="top">始发时间：</td>
<td width="88%">
<input size=20 maxlength=20 name="leavetime">
</td>
</tr>
<tr>
<td width="12%" bgcolor="bfbfbf" valign="top">终点时间：</td>
<td width="88%">
<input size=20 maxlength=20 name="returntime">
</td>
</tr>
<tr>
<td width="12%" bgcolor="bfbfbf" valign="top">票价：</td>
<td width="88%">
<input size=20 maxlength=50 name="price">
</td>
</tr>
<tr>
<td width="12%" bgcolor="bfbfbf" valign="top">备注：</td>
<td width="88%">
<textarea name="remark" cols="40" rows="4"></textarea>
</td>
</tr>
</table>
<div align="center"> <br> <a href="javascript:document.form.submit();" onMouseOut="MM_swapImgRestore()" onMouseOver="MM_swapImage('Image1','','images/sendarticle_on.gif',1)"><img name="Image1" border="0" src="images/sendarticle_off.gif" width="60" height="19" hspace="5"></a><a href="javascript:document.form.reset();" onMouseOut="MM_swapImgRestore()" onMouseOver="MM_swapImage('Image2','','images/rewrite_on.gif',1)"><img name="Image2" border="0" src="images/rewrite_off.gif" width="60" height="19" hspace="5"></a><a href="Javascript:window.close();" onMouseOut="MM_swapImgRestore()" onMouseOver="MM_swapImage('Image3','','images/close_2.gif',1)"><img name="Image3" border="0" src="images/close_1.gif" width="85" height="19" hspace="5"></a>
</div>
</form>
<% end if %>
</body>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -