⭐ 欢迎来到虫虫下载站! | 📦 资源下载 📁 资源专辑 ℹ️ 关于我们
⭐ 虫虫下载站

📄 pro_edit.asp

📁 图书管理系统是典型的信息管理系统(MIS),其开发主要包括后台数据库的建立和维护以及前端应用程序的开发两个方面
💻 ASP
字号:
<%@ LANGUAGE="VBSCRIPT" %>

<!--#include file="inc/conn.asp"--> 
<!--#include file="inc/config.asp"-->
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<title>图书馆管理系统</title>
<link href="../style.css" rel="stylesheet" type="text/css">
</head>
<body>

<%
   set rs=server.createobject("adodb.recordset")
sql="select * from category order by categoryid"
   rs.open sql,conn,1,1
   if err.Number<>0 then 
err.clear %>
 数 据 库 操 作 失 败 !
   <%  else  %>
<table width="780" border="0" align="center" cellpadding="0" cellspacing="0">
  <tr>
    <td width="219" align="left" valign="top"><br>
      <!--#include file="menu.htm"-->

        <br></td><td width="561" align="left" valign="top">     <br>      <table border="0" cellpadding="0" cellspacing="0">
        <tr>
          <td width="18"><img src="../images/w.gif" width="18" height="18"></td>
          <td width="66" style="color:#415373">编辑图书</td>
        </tr>
      </table><%
   set rs2=server.createobject("adodb.recordset")
   sql2="select * from content where id="&request("id")
   rs2.open sql2,conn,1,1%>      <br>      <form action="pro_save.asp" method="post" name="myform" id="myform">
        <table width="100%" border="0" align="center" cellpadding="2" cellspacing="2">
          <tr> 
            <td> <span class="redfont">*</span>选择分类:</td>
            <td colspan="2">
			
<select name="categoryid" size="1" style="font-size: 9pt">
  <%
         Do while not rs.eof%>
<option value="<%=rs("categoryid")%>" <%if int(rs2("categoryid"))=rs("categoryid") then%>selected<%end if%>><%=rs("category")%></option>
<%rs.MoveNext
         Loop
%></select></td>
          </tr>
          <tr> 
            <td><span class="redfont">*</span>图书名:</td>
            <td colspan="2"><input name="id" type="hidden" value="<%=rs2("id")%>">
              <input name="name" type="text" id="name" size="30" value="<%=rs2("name")%>">
            </td>
          </tr>
          <tr> 
            <td><span class="redfont">*</span>作者:</td>
            <td colspan="2">
              <input name="author" type="text" id="author" size="20" value="<%=rs2("author")%>">
            </td>
          </tr>
          <tr> 
            <td><span class="redfont">*</span>出版社: </td>
            <td colspan="2"> 
              <input name="mark" type="text" id="mark" size="30" value="<%=rs2("mark")%>" >
            </td>
          </tr>
          <tr> 
            <td>装帧:</td>
            <td colspan="2"> 
              <input name="introduce" type="text" id="introduce" size="30" value="<%=rs2("introduce")%>" >
            </td>
          </tr>
          <tr> 
            <td><span class="redfont">*</span>出版日期:</td>
            <td colspan="2">
              <input name=productdate type=text size=10 value="<%=rs2("productdate")%>">
              (格式yyyy-mm-dd)</td>
          </tr>
          <tr> 
            <td><span class="redfont">*</span>价格: </td>
            <td colspan="2">
              <input name="price" type="text" id="price" VALUE="<%=rs2("price")%>" size="6">
元<br>
            </td>
          </tr>
          <tr> 
            <td>开本:</td>
            <td colspan="2">
              <input name="format" type="text" id="format" size="10" value="<%=rs2("format")%>">
            </td>
          </tr>
          <tr> 
            <td>版次:</td>
            <td colspan="2"> 
              <input name="printed" type="text" id="printed" value="<%=rs2("printed")%>">
            </td>
          </tr>
          <tr> 
            <td>页数: </td>
            <td colspan="2"> 
              <input name="pagenum" type="text" id="pagenum" value="<%=rs2("pagenum")%>">
            </td>
          </tr>
          <tr> 
            <td><span class="redfont">*</span>ISBN:</td>
            <td colspan="2">
              <input name="type" type="text" id="type2" size="30" value="<%=rs2("type")%>">
            </td>
          </tr>
          <tr> 
            <td>&nbsp;</td>
            <td colspan="2">&nbsp;</td>
          </tr>
          <tr> 
            <td>详细说明:</td>
            <td colspan="2"> 
              <textarea name="detail" cols="46" rows="8" id="detail"><%=HTMLDecode(rs2("detail"))%></textarea>
            </td>
          </tr>
          <tr> 
            <td valign="top">目录:</td>
            <td colspan="2">
              <TEXTAREA NAME="content" COLS="46" ROWS="8" ID="content"><%=HTMLDecode(rs2("content"))%></TEXTAREA>
            </td>
          </tr>
          <tr align="center"> 
            <td colspan="3"> 
              <input name="AddProSubmit" type="submit" id="AddProSubmit" onClick="return checkpro();" value="修改">
<script language="JavaScript">
<!--
function checkpro()
{
    if(document.myform.name.value=="") {
	document.myform.name.focus();
    alert("请输入图书名!");
	return false;
  }

	if(document.myform.author.value=="") {
	document.myform.author.focus();
    alert("请输入作者!");
	return false;
  }
	if(document.myform.mark.value=="") {
	document.myform.mark.focus();
    alert("请输入出版社!");
	return false;
  }

	if(document.myform.type.value=="") {
	document.myform.type.focus();
    alert("请输入ISBN!");
	return false;
  }

     if(document.myform.price.value=="") {
	document.myform.price.focus();
    alert("请输入价格!");
	return false;
  } 
}
//-->                        
</script>
            </td>
          </tr>
        </table>
      </form></td>
  </tr>
</table>

</body>
</html>
<%rs2.close
set rs2=nothing

     rs.close
     conn.close
     set conn=nothing
end if
%>

⌨️ 快捷键说明

复制代码 Ctrl + C
搜索代码 Ctrl + F
全屏模式 F11
切换主题 Ctrl + Shift + D
显示快捷键 ?
增大字号 Ctrl + =
减小字号 Ctrl + -