?? default.asp
字號(hào):
<!--#include file="../Session.asp"-->
<%
function judge(a,b)
dim res
if instr(a,b)>0 then
res ="checked"
end if
judge = res
end function
%>
<%
function judges(a,b)
dim ress
if (a=b) then
ress ="selected"
end if
judges = ress
end function
%>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<link href="../../css/site.css" rel="stylesheet" type="text/css">
</head>
<body>
<table width="100%" border="0" align="center" cellpadding="1" cellspacing="0">
<tr align="center">
<td height="50" colspan="6" class="tdstyle"><font color="#000000" size="3"><strong>精品圖片</strong></font></td>
</tr>
<tr align="center">
<td width="8%" height="25" class="tdstyle"><strong>編 號(hào)</strong></td>
<td width="30%" class="tdstyle"><strong>圖片地址</strong></td>
<td width="30%" class="tdstyle"><strong>圖片連接</strong></td>
<td width="12%" class="tdstyle"><strong>顯示頁面</strong></td>
<td width="10%" class="tdstyle"><strong>修 改</strong></td>
<td width="10%" class="tdstyle"><strong>刪 除</strong></td>
</tr>
<%Set rs = Server.CreateObject("ADODB.Recordset")
sql="select * from SecondPic order by id desc"
rs.open sql,conn,0,1
do while not rs.eof%>
<form name="form1" method="post" action="?Act=a">
<tr>
<td height="20" align="center" class="tdstyle"><%=rs("id")%> <input name="id" type="hidden" id="id" value="<%=rs("id")%>"></td>
<td class="tdstyle">
<input name="Pic" type="text" class="input1" id="Pic" value="<%=rs("Pic")%>" size="25"></td>
<td class="tdstyle"> <strong>
<input name="url" type="text" class="input1" id="url" value="<%=rs("url")%>" size="25">
</strong></td>
<td align="center" class="tdstyle">
<%places=rs("BigId")%>
<select name="BigId" class="input1" id="BigId">
<option value="0" <%=judges(places,"0")%>>默認(rèn)(所有分類)</option>
<%Set rs2 = Server.CreateObject("ADODB.Recordset")
sql="select * from BigClass order by BigId"
rs2.open sql,conn,0,1
do while not rs2.eof%>
<option value="<%=rs2("BigId")%>" <%=judges(places,rs2("BigId"))%>><%=rs2("BCName")%></option>
<%rs2.movenext
loop
%>
</select>
</td>
<td align="center" class="tdstyle">
<input name="Submit" type="submit" class="button2" value="修 改"></td>
<td align="center" class="tdstyle">
<input name="Submit2" type="button" class="button2" value="刪 除" onclick="if(confirm('您確定要?jiǎng)h除嗎?')) location.href='Default.asp?Act=c&id=<%=rs("id")%>'"></td>
</tr>
</form>
<%rs.movenext
loop%>
</table>
<form action="?Act=b" method="post" name="form" id="form">
<table width="100%" border="0" align="center" cellpadding="1" cellspacing="0">
<tr align="center">
<td height="50" colspan="2" class="tdstyle"><font color="#000000" size="3"><strong>添加新圖片</strong></font></td>
</tr>
<tr>
<td width="20%" align="right" class="tdstyle">圖片地址:</td>
<td width="80%" class="tdstyle">
<input name="Pic" type="text" class="input1" id="Pic" size="25">
</td>
</tr>
<tr>
<td align="right" class="tdstyle">上傳圖片:</td>
<td class="tdstyle"> <iframe name="ad" frameborder=0 width=100% height=25 scrolling=no src=Up.asp></iframe></td>
</tr>
<tr>
<td align="right" class="tdstyle">圖片連接:</td>
<td class="tdstyle"> <input name="url" type="text" class="input1" id="url" size="25"></td>
</tr>
<tr>
<td align="right" class="tdstyle">顯示頁面:</td>
<td class="tdstyle">
<select name="BigId" class="input1" id="BigId">
<option value="0" selected>默認(rèn)(所有分類)</option>
<%Set rs2 = Server.CreateObject("ADODB.Recordset")
sql="select * from BigClass order by BigId"
rs2.open sql,conn,0,1
do while not rs2.eof%>
<option value="<%=rs2("BigId")%>"><%=rs2("BCName")%></option>
<%rs2.movenext
loop%>
</select>注意:每個(gè)頁面的圖片總長度必須為746像素,否則會(huì)影響頁面美觀!
</td>
</tr>
<tr>
<td height="30" colspan="2" align="center" class="tdstyle"> <input name="Submit3" type="submit" class="button" value="提 交"> </td>
</tr>
</table>
</form>
<br><br>
<% Select case request("Act")
case "a"
conn.execute("Update SecondPic set Pic = '"&request("Pic")&"',url = '"&request("Url")&"',BigId = "&request("BigId")&" where id="&request("id")&"")
Response.redirect "Default.asp"
case "b"
conn.execute("Insert into SecondPic(Pic,Url,BigId)values('"&request("Pic")&"','"&request("Url")&"',"&request("BigId")&")")
Response.redirect "Default.asp"
case "c"
conn.execute("Delete From SecondPic where id="&request("id")&"")
Response.redirect "Default.asp"
End Select
%>
</body>
</html>
?? 快捷鍵說明
復(fù)制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號(hào)
Ctrl + =
減小字號(hào)
Ctrl + -