📄 book_add.asp
字号:
<%
'这是安全模块，如果客户不是管理员用户，立即重定向到首页.
'这样可以防止某些客户直接访问admin下面的文件。
If Session("UserType")<>"A" Then
Response.Redirect "../index.asp"
End If
%>
<!--#INCLUDE FILE="../odbc_connection2.asp"-->
<!--#INCLUDE FILE="../function2.asp"-->
<html>
<head>
<title>添加书籍</title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<link href="../style.css" rel="stylesheet" type="text/css">
<script language="JavaScript">
<!--
function check_Null(){
if (document.form1.BookName.value==""){
alert("名称不能为空!");
return false;
}
if (document.form1.BookAuthor.value==""){
alert("作者不能为空!");
return false;
}
if (document.form1.BookPrice.value==""){
alert("价格不能为空!");
return false;
}
if (document.form1.BookNum.value==""){
alert("数量不能为空!");
return false;
}
if (document.form1.KindId.value==""){
alert("类别不能为空!");
return false;
}
return true;
}
// -->
</script>
</head>
<body >
<h2 align="center">添加书籍</h2>
<center>
<FORM name="form1" action="" method="post" onsubmit="javascript: return check_Null();" >
<table width="80%" border=0 cellpadding="4" cellspacing="1" bgcolor="#999999">
<tr bgcolor="#FFFFFF">
<td width="21%" height="25">名称</td>
<td width="79%"><input size="40" name="BookName" class="inputbox">*</td>
</tr>
<tr bgcolor="#FFFFFF">
<td width="21%" height="25">作者</td>
<td width="79%"><input size="20" name="BookAuthor" class="inputbox">*</td>
</tr>
<tr bgcolor="#FFFFFF">
<td width="21%" height="25">价格</td>
<td width="79%"><input size="20" name="BookPrice" class="inputbox">*</td>
</tr>
<tr bgcolor="#FFFFFF">
<td width="21%" height="25">数量</td>
<td width="79%"><input size="20" name="BookNum" class="inputbox">*</td>
</tr>
<tr bgcolor="#FFFFFF">
<td width="21%" height="25">所属类别</td>
<td width="79%">
<Select Name="KindId">
<option></option>
<%
'下面输出类别信息
Dim rs,strSql
strSql="Select * From Kind Order By KindId"
Set rs=db.Execute(strSql)
Do While Not rs.Eof
Response.Write "<option value='" & rs("KindId") & "'>" & rs("KindName") & "</option>"
rs.MoveNext
Loop
%>
</Select>*
</td>
</tr>
<tr bgcolor="#FFFFFF">
<td width="21%" height="25">内容简介</td>
<td><textarea name="BookIntro" rows="7"cols="50" ></textarea></td>
</tr>
<tr bgcolor="#FFFFFF">
<td width="21%" height="25">目录</td>
<td><textarea name="BookIndex" rows="7"cols="50" ></textarea></td>
</tr>
</table>
<br>
<input type=submit value=" 确 定 " name=submit class="inputbutton">
</FORM>
<br>
<%
'各项验证正确无误，则可继续注册，否则返回
If Request.Form("BookName")<>"" then
'以下将书籍保存到数据库
Dim sqla,sqlb
sqla="Insert Into book(BookName,BookAuthor,BookPrice,BookNum,KindId,SubmitDate"
sqlb = "Values('" & Request.Form("BookName") & "','" & Request.Form("BookAuthor") & "'," & Request.Form("BookPrice") & "," & Request.Form("BookNum") & "," & Request.Form("KindId") & ",#" & Now() & "#"
If Request.Form("BookIntro")<>"" Then
sqla = sqla & ",BookIntro"
sqlb = sqlb & ",'" & MyReplace(Request.Form("BookIntro")) & "'" '调用函数处理，主要为了换行
End If
If Request.Form("BookIndex")<>"" Then
sqla = sqla & ",BookIndex"
sqlb = sqlb & ",'" & MyReplace(Request.Form("BookIndex")) & "'" '调用函数处理
End If
strSql = sqla & ") " & sqlb & ")"
db.Execute(strSql)
'马上返回该书的BookId，后面上传图片要用
strSql="Select Top 1 * From book Where BookName='" & Request.Form("BookName") & "' And BookAuthor='" & Request.Form("BookAuthor") & "' Order By SubmitDate Desc"
Set rs=db.Execute(strSql)
Session("BookId")=rs("BookId")
Response.Redirect "book_add_picture.asp"
end If
%>
</center>
</body>
</html>⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -