?? search.asp
字號:
<!-- #include file="Include/Chk.asp" -->
<!-- #include file="Conn.asp" -->
<%
dim name,sid
name=Trim(Request.Form("name"))
sid=Trim(Request.Form("sid"))
cate=Request.Form("cate")
if sid="" or name="" or cate="" then
Response.Write "<script language='javascript'>alert('請將信息填寫完整');history.go(-1);</script>"
Response.End()
end if
set rs=server.createobject("Adodb.Recordset")
sql="Select * from Staff where name='"&name&"' and sid='"&sid&"' and cate="&cate
rs.open sql,conn,1,3
if rs.eof then
Response.Write "<script language='javascript'>alert('沒有查詢到指定的證書記錄');history.go(-1);</script>"
Response.End()
else
bid=rs("bid")
name=rs("name")
sid=rs("sid")
cate=rs("cate")
dep=rs("dep")
source=rs("source")
bs=rs("bs")
sj=rs("sj")
cname=rs("cname")
rs.Close
end if
%>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312" />
<title></title>
<link href="Images/default.css" rel="stylesheet" type="text/css" />
</head>
<body>
<form id="form1" name="form1" method="post" action="">
<table width="100%" border="0" cellpadding="0" cellspacing="1" bgcolor="#FFFFFF">
<tr>
<td height="24" colspan="2" class="AddGoods_Left"><div align="center">證書查詢</div></td>
</tr>
<tr>
<td height="5" colspan="2" background="Images/topnav.gif"></td>
</tr>
<tr>
<td height="5" colspan="2"></td>
</tr>
<tr>
<td width="15%" height="25" align="right" valign="middle" bgcolor="#efefef">證書編號：</td>
<td width="85%" height="25" align="left" valign="middle">
<%=bid%> </td>
</tr>
<tr>
<td height="25" align="right" valign="middle" bgcolor="#efefef">學員姓名：</td>
<td height="25" align="left" valign="middle">
<%=name%> </td>
</tr>
<tr>
<td height="25" align="right" valign="middle" bgcolor="#efefef">身份證號：</td>
<td height="25" align="left" valign="middle">
<%=sid%> </td>
</tr>
<tr>
<td height="25" align="right" valign="middle" bgcolor="#efefef">認證專業：</td>
<td height="25" align="left" valign="middle">
<%=dep%></td>
</tr>
<tr>
<td height="25" align="right" valign="middle" bgcolor="#efefef">證書名稱：</td>
<td height="25" align="left" valign="middle">
<%=cname%> </td>
</tr>
<tr>
<td height="25" align="right" valign="middle" bgcolor="#efefef">證書類別：</td>
<td height="25" align="left" valign="middle">
<%
set fs=server.createobject("adodb.recordset")
fs.open "select * from Cate where id="&cate,conn,1,1
if fs.eof then
Response.Write "<option value=''>類別設置錯誤</option>"
else
Response.Write(Trim(fs("Catename")))
end if
fs.Close
Set fs=nothing
%>
</select> </td>
</tr>
<tr>
<td height="25" align="right" valign="middle" bgcolor="#efefef">總 成 績：</td>
<td height="25" align="left" valign="middle">
<%=source%> </td>
</tr>
<tr>
<td height="25" align="right" valign="middle" bgcolor="#efefef">筆試成績：</td>
<td height="25" align="left" valign="middle">
<%=bs%> </td>
</tr>
<tr>
<td height="25" align="right" valign="middle" bgcolor="#efefef">上機成績：</td>
<td height="25" align="left" valign="middle">
<%=sj%> </td>
</tr>
<tr>
<td height="25" align="right" valign="middle" bgcolor="#efefef"> </td>
<td height="25" align="left" valign="middle">
<span class="C_Title">
<input name="button" type="button" onclick="history.back(-1)" value="返 回" />
<input type="button" name="Submit" value="打 印" onclick="javascript:window.print()" />
</span></td>
</tr>
</table>
</form>
</body>
</html>
?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -