📄 driverreg.asp
字号:
<!--#include file="..\pub\ChkAdmin.asp"-->
<!--#include file="..\CONN.INC"-->
<html>
<head>
<title>Driver Register</title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<link rel="stylesheet" href="..." type="text/css">
<link rel="stylesheet" href="..." type="text/css">
</head>
<body bgcolor="#FFFFFF" topmargin="8">
<%
Sqlstring="select u.realname,u.Username,d.* from UserInfo u,DriverInfo d where u.UserID=d.UserID"
set rs=Conn.execute(Sqlstring)
Response.write "<table border=1 width=800>"
response.write "<tr>"
response.write "<td>驾驶员姓名</td>"
response.write "<td>出生年月</td>"
response.write "<td>驾照编号</td>"
response.write "<td>驾照生效日期</td>"
response.write "<td>驾照截止日期</td>"
response.write "<td>驾龄</td>"
response.write "<td>准驾类型</td>"
response.write "<td>电话</td>"
response.write "<td>手机</td>"
response.write "<td>地址</td>"
response.write "<td>功能</td>"
response.write "</tr>"
while (not rs.eof)
response.write "<tr>"
response.write "<td>"&rs("DriverName")&"("&rs("RealName")&":"&rs("UserName")&")</td>"
response.write "<td>"&rs("Birthday")&"</td>"
response.write "<td>"&rs("LicenseNO")&"</td>"
response.write "<td>"&rs("LicRelDate")&"</td>"
response.write "<td>"&rs("ExpireDate")&"</td>"
response.write "<td>"&rs("DrivingAge")&"</td>"
response.write "<td>"&rs("DrivingType")&"</td>"
response.write "<td>"&rs("Telphone")&"</td>"
response.write "<td>"&rs("Mobile")&"</td>"
response.write "<td>"&rs("Addr")&"</td>"
response.write "<td><a href=DriverEdit.asp?DriverID="&rs("DriverID")&">编辑</a><a href=DriverDel.asp?DriverID="&rs("DriverID")&"> 删除</a></td>"
response.write "</tr>"
rs.movenext
wend
Sqlstring="select d.* from DriverInfo d where d.UserID is null"
set rs=Conn.execute(Sqlstring)
while (not rs.eof)
response.write "<tr>"
response.write "<td>"&rs("DriverName")&"(未配备用户账号)</td>"
response.write "<td>"&rs("Birthday")&"</td>"
response.write "<td>"&rs("LicenseNO")&"</td>"
response.write "<td>"&rs("LicRelDate")&"</td>"
response.write "<td>"&rs("ExpireDate")&"</td>"
response.write "<td>"&rs("DrivingAge")&"</td>"
response.write "<td>"&rs("DrivingType")&"</td>"
response.write "<td>"&rs("Telphone")&"</td>"
response.write "<td>"&rs("Mobile")&"</td>"
response.write "<td>"&rs("Addr")&"</td>"
response.write "<td><a href=DriverEdit.asp?DriverID="&rs("DriverID")&">编辑</a><a href=DriverDel.asp?DriverID="&rs("DriverID")&"> 删除</a></td>"
response.write "</tr>"
rs.movenext
wend
response.write "</table>"
response.write "<br>"
response.write "<table width=700>"
response.write "<tr><td><center><a href=DriverNew.asp>添加新的司机信息</a></center></td></tr>"
response.write "</table>"
conn.close
set rs=nothing
%>
</body>
</html>⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -