📄 newbookchaxun.asp

📁 这是一个图书管理系统,也许能给大家一些帮助
💻 ASP
📖 第 1 页 / 共 2 页
字号:
12 下一页
<%@LANGUAGE="VBSCRIPT" CODEPAGE="936"%>
<!--#include file="Connections/db1.asp" -->
<%
Dim Recordset1
Dim Recordset1_numRows

Set Recordset1 = Server.CreateObject("ADODB.Recordset")
Recordset1.ActiveConnection = MM_db1_STRING
Recordset1.Source = "SELECT * FROM join_table"
Recordset1.CursorType = 0
Recordset1.CursorLocation = 2
Recordset1.LockType = 1
Recordset1.Open()

Recordset1_numRows = 0
%>
<%
Dim Recordset2__MMColParam
Recordset2__MMColParam = "1"
If (Request.Form("textfield1") <> "") Then 
  Recordset2__MMColParam = Request.Form("textfield1")
End If
%>
<%
Dim Recordset2
Dim Recordset2_numRows

Set Recordset2 = Server.CreateObject("ADODB.Recordset")
Recordset2.ActiveConnection = MM_db1_STRING
Recordset2.Source = "SELECT * FROM 图书 WHERE 入馆日期 >= '" + Replace(Recordset2__MMColParam, "'", "''") + "' ORDER BY 入馆日期 ASC"
Recordset2.CursorType = 0
Recordset2.CursorLocation = 2
Recordset2.LockType = 1
Recordset2.Open()

Recordset2_numRows = 0
%>
<%
Dim Repeat1__numRows
Dim Repeat1__index

Repeat1__numRows = -1
Repeat1__index = 0
Recordset2_numRows = Recordset2_numRows + Repeat1__numRows
%>
<%
' *** Validate request to log in to this site.
MM_LoginAction = Request.ServerVariables("URL")
If Request.QueryString<>"" Then MM_LoginAction = MM_LoginAction + "?" + Server.HTMLEncode(Request.QueryString)
MM_valUsername=CStr(Request.Form("ttt"))
If MM_valUsername <> "" Then
  MM_fldUserAuthorization=""
  MM_redirectLoginSuccess="loginok.asp"
  MM_redirectLoginFailed="loginerror.asp"
  MM_flag="ADODB.Recordset"
  set MM_rsUser = Server.CreateObject(MM_flag)
  MM_rsUser.ActiveConnection = MM_db1_STRING
  MM_rsUser.Source = "SELECT id, password"
  If MM_fldUserAuthorization <> "" Then MM_rsUser.Source = MM_rsUser.Source & "," & MM_fldUserAuthorization
  MM_rsUser.Source = MM_rsUser.Source & " FROM join_table WHERE id='" & Replace(MM_valUsername,"'","''") &"' AND password='" & Replace(Request.Form("textfield2"),"'","''") & "'"
  MM_rsUser.CursorType = 0
  MM_rsUser.CursorLocation = 2
  MM_rsUser.LockType = 3
  MM_rsUser.Open
  If Not MM_rsUser.EOF Or Not MM_rsUser.BOF Then 
    ' username and password match - this is a valid user
    Session("MM_Username") = MM_valUsername
    If (MM_fldUserAuthorization <> "") Then
      Session("MM_UserAuthorization") = CStr(MM_rsUser.Fields.Item(MM_fldUserAuthorization).Value)
    Else
      Session("MM_UserAuthorization") = ""
    End If
    if CStr(Request.QueryString("accessdenied")) <> "" And false Then
      MM_redirectLoginSuccess = Request.QueryString("accessdenied")
    End If
    MM_rsUser.Close
    Response.Redirect(MM_redirectLoginSuccess)
  End If
  MM_rsUser.Close
  Response.Redirect(MM_redirectLoginFailed)
End If
%>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<title>无标题文档</title>
<style type="text/css">
<!--
.style27 {font-size: 13px; color: #FFFFFF; }
body {
	margin-top: 0px;
}
.style35 {font-size: 13px; color: #FFFFFF; font-family: "新宋体"; }
.style36 {color: #0000CC}
a:link {
	color: #000000;
	text-decoration: none;
}
a:visited {
	text-decoration: none;
	color: #999999;
}
a:hover {
	text-decoration: underline;
	color: #FF9900;
}
a:active {
	text-decoration: none;
	color: #FF9900;
}
.s {
	font-size: 12px;
	color: #000000;
	text-decoration: none;
}
.s:link {
	color: #000000;
	text-decoration: none;
}
.s:hover {
	color: #FF9900;
	text-decoration: none;
}
.s:visited {
	color: #999999;
	text-decoration: none;
}
.style43 {font-size: 12px}
.style45 {
	color: #FFFFFF;
	font-weight: bold;
	font-family: "楷体_GB2312";
}
.style46 {color: #000000}
.style48 {color: #005EB6}
.style49 {
	font-size: 16px;
	color: #0066CC;
}
.style50 {
	font-size: 16px;
	font-family: "幼圆";
	color: #0066CC;
}
-->
</style>
</head>

<body>
<table width="805" border="0" align="center" cellpadding="0" cellspacing="0">
  <tr>
    <td width="805" valign="top"><div align="center">
      <table width="100%"  border="0" cellspacing="0" cellpadding="0">
        <tr>
          <td colspan="2" valign="top"><img src="&#26410;&#26631;&#39064;-1%20&#25335;&#36125;.jpg" width="805" height="120" align="absmiddle"></td>
        </tr>
        <tr>
          <td colspan="2" align="left" bgcolor="#99CCFF"><div align="left"></div></td>
        </tr>
        <tr  valign="middle">
          <td width="84%" align="left" background="11111.jpg"><div align="center"><a href="index.asp"><img src="&#26410;&#26631;&#39064;-3.jpg" width="85" height="32" border="0"></a><img src="menu_2.png" width="85" height="32"><img src="menu_3.png" width="85" height="32"><a href="tushuguan/duzhechaxun.asp" target="_blank"><img src="menu_5.png" width="85" height="32" border="0"></a><a href="tushuguan/index.asp" target="_blank"><img src="menu_10.png" width="85" height="32" border="0"></a><a href="xhbook/index.asp" target="_blank"><img src="menu_6.png" width="85" height="32" border="0"></a><a href="download.asp" target="_blank"><img src="menu_11.png" width="80" height="32" border="0"></a><a href="xhbook/index1.asp" target="_blank"><img src="menu_8.png" width="85" height="32" border="0"> </a></div></td>
          <td width="16%" align="right" background="11111.jpg"><div align="center">
            <script language=JavaScript>
today=new Date();
function initArray(){
this.length=initArray.arguments.length
for(var i=0;i<this.length;i++)
this[i+1]=initArray.arguments[i] }
var d=new initArray(
"星期日",
"星期一",
"星期二",
"星期三",
"星期四",
"星期五",
"星期六");
document.write(
"<font color=#ffffff style='font-size:9pt;font-family: 宋体'> ",
today.getYear(),"年",
today.getMonth()+1,"月",
today.getDate(),"日",
d[today.getDay()+1],
"</font>" ); 
            </script>
</div></td>
        </tr>
      </table>
    </div></td>
  </tr>
  <tr>
    <td height="733" valign="top" bgcolor="#FFFFFF"><table width="100%" border="1" align="center" cellpadding="1" cellspacing="1" bordercolor="#59A9CF" bgcolor="#FFFFFF" >
      <tr align="left">
        <TD width="22%" height="729" align="left" vAlign=top bordercolor="#CCCCCC" bgColor=#59A9CF>
          <P align=center>          
          <table width="89%"  border="1" cellpadding="0" cellspacing="0" bordercolor="#59A9CF">
            <tr>
              <td height="28" bgcolor="#59A9CF"><table width="100%" height="19"  border="1" cellpadding="0" cellspacing="1" bordercolor="#59A9CF">
                <tr>
                  <td height="15" valign="middle" bordercolor="#59A9CF" bgcolor="#59A9CF"><h4 class="style45">::图书馆公告::</h4></td>
                </tr>
              </table></td>
            </tr>
            <tr>
              <td><marquee id=scrolltext onMouseOver=this.stop() 
                  onMouseOut=this.start() scrollamount=1 scrolldelay=30 
                  direction=up width=140 height=130
                  name="scrolltext">
                <span class="style35"> 　　目前的图书馆多为手工管理，手续繁琐，耗费大量的人力，而且由于信息比较多，图书借阅信息的管理工作混乱而又复杂；一般借阅情况是记录在借书证上，图书的数目和内容记录在文件中，图书馆的工作人员和管理员也只是当时对它比较清楚，时间一长，如再要进行查询，就得在众多的资料中翻阅、查找了，造成查询费时、费力。如要对很长时间以前的图书进行更改就更加困难了。 </span>
                <p class="style35"></p>
                <span class="style35">　　因此，我们设计这个图书馆系统，管理读者的登记、图书的购入、借出、归还以及注销等。管理人员还可以查询某位读者、某本图书的借阅情况，对当前借阅情况给出一些统计，给出统计表格，以全面掌握图书的流通情况。同时本系统基于 WEB 页面有很好的连网功能，也便于在校教师，学生查询自己的借阅信息，在馆图书情况，可以在网上自行续借图书，大大节省了图书馆的人力资源，方便了教师、学生的借阅，查询。</span> <span class="style27"><br>
                </span>
                </marquee>
                  <p class="style27"></p></td>
            </tr>
          </table>          
          <table width="88%" border=1 cellpadding=1 cellspacing=1 bordercolor=#CCCCFF 
      bordercolorlight=#ccccff 
      bordercolordark=#ffffff>
12 下一页
💿 文件大小 549 K
👤 上传用户 gqingwei
📂 所属分类教育系统应用
🏷️ 相关标签

#图书管理 #家
⌨️ 快捷键说明

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