📄 addsinger.asp
字号:
<HTML><HEAD>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<LINK href="style.css" rel=stylesheet type=text/css>
<%
if Request.ServerVariables("Request_Method")="POST" then
set conn=server.createobject("ADODB.Connection")
filepath=server.mappath("db.mdb")
conn.Open "driver={Microsoft Access Driver (*.mdb)};dbq=" & filepath
Set RS = SERVER.CreateObject("ADODB.Recordset")
strSQL = "SELECT * FROM singer where name='" & Request.Form("name") & "'"
RS.Open strSQL,conn,1,1
if RS.EOF or RS.BOF then
sql = "Insert Into singer (sort,name) Values("& Request.Form("sort") & ", '"& Request.Form("name") &"')"
conn.Execute sql
else
response.write ("<center><table><tr><td>该歌手已经存在</td></tr></table></center>")
end if
RS.close
Set RS=nothing
conn.close
Set conn=nothing
end if
%>
<title>添加歌手</title>
</HEAD>
<BODY leftMargin=0 topMargin=0 link="#000000">
<br>
<center>
<form method="POST" name="form2">
<table border="0" width="400" cellpadding="0" cellspacing="0">
<tr>
<td>类别</td>
<td>
<input type="text" name="sort" size="40" value="<%=Request("sort")%>"></td>
</tr>
<tr>
<td>歌手名</td>
<td><input type="text" name="name" size="40"></td>
</tr>
<tr>
<td colspan="2" align="center"><input type="submit" name="Submit1" value="提交"> <input type="reset" name="Submit2" value="重 置">
</td>
</tr>
</table>
</form>
</center>
</body>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -