?? book_add.asp
字號:
<%@LANGUAGE="VBSCRIPT" CODEPAGE="936"%>
<!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="../css.css" rel="stylesheet" type="text/css" />
<style type="text/css">
<!--
.style1 {font-size: 16px}
body {
background-color: #E7EEF5;
}
-->
</style>
</head>
<!--#include file="conn.asp"-->
<%
if request("act")="add" then
B_ISBN=trim(request("B_ISBN"))
B_NAME=trim(request("B_NAME"))
B_SORT=trim(request("B_SORT"))
B_DATE=trim(request("B_DATE"))
B_WRITER=trim(request("B_WRITER"))
B_CONCERN=trim(request("B_CONCERN"))
B_REMARK=trim(request("B_REMARK"))
B_CHECK_DATE=trim(request("B_CHECK_DATE"))
B_NUM=trim(request("B_NUM"))
if B_NAME="" then
response.write"<script language='javascript'>alert('書名不能為空！');history.back();</script>"
elseif B_isbn="" then
response.write"<script language='javascript'>alert('ISBN不能為空！');history.back();</script>"
elseif B_num="" then
response.write"<script language='javascript'>alert('圖書數量不能為空！');history.back();</script>"
else
sql="insert into [book](B_ISBN,B_NAME,B_SORT,B_DATE,B_WRITER,B_CONCERN,B_REMARK,B_NUM)values('"&B_ISBN&"','"&B_NAME&"',"&B_SORT&",'"&B_DATE&"','"&B_WRITER&"','"&B_CONCERN&"','"&B_REMARK&"',"&B_NUM&")"
conn.execute(sql)
response.write"<script language='javascript'>alert('操作成功！');window.location.href='ad_book.asp';</script>"
end if
end if
%>
<body>
<form action="?act=add" method="post" name="form1">
<center>
<table width="600" border="0" cellspacing="0" cellpadding="3">
<tr align="center" valign="middle" >
<td height="30" colspan="2"><span class="style1">添加圖書</span></td>
</tr>
<tr>
<td width="232" height="25" align="right">書名：</td>
<td width="356" height="25" align="left"><input name="B_NAME" type="text" size="25" /></td>
</tr>
<tr>
<td height="25" align="right">類別： </td>
<td height="25" align="left"><select name="B_sort" id="B_sort">
<option selected="selected" value="">所有類別</option>
<%set rslb=conn.execute("select * from lb order by id asc")
while not rslb.eof
%>
<option value="<%=rslb("id")%>"><%=rslb("name")%></option>
<%rslb.movenext
wend %>
</select></td>
</tr>
<tr>
<td height="25" align="right">ISBN： </td>
<td height="25" align="left"><input name="B_isbn" type="text" id="B_isbn" size="25" /></td>
</tr>
<tr>
<td width="232" height="25" align="right">作者：</td>
<td height="25" align="left"><input name="B_WRITER" type="text" id="B_WRITER" size="20" /></td>
</tr>
<tr>
<td width="232" height="25" align="right">出版社：</td>
<td height="25" align="left"><input name="B_CONCERN" type="text" id="B_CONCERN" size="20" /></td>
</tr>
<tr>
<td width="232" height="25" align="right">出版日期：</td>
<td height="25" align="left"><input name="B_DATE" type="text" id="B_DATE" size="20" /></td>
</tr>
<tr>
<td height="25" align="right">數量： </td>
<td height="25" align="left"><input name="B_num" type="text" id="B_num" size="10" />
冊</td>
</tr>
<tr>
<td height="25" align="right">簡介： </td>
<td height="25" align="left"><textarea name="B_REMARK" cols="40" rows="7" id="B_REMARK"></textarea></td>
</tr>
<tr align="center" valign="middle">
<td height="40" colspan="2"><input type="submit" name="Submit" value=" 提 交 " />
<input type="reset" name="Submit2" value=" 重 置 " /></td>
</tr>
</table>
</center>
</form>
</body>
</html>
?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -