📄
字号:
<%
dim Pri
mkmc=request("mkmc")
Pri=CheckUrl(mkmc)
%>
<!--#include virtual="/school/public/CheckUrl.asp"-->
<html>
<!--谭建华MADE HAIKOU-->
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb_2312-80">
<meta name="tjh" content="Microsoft FrontPage Express 2.0">
<meta name="GENERATOR" content="Microsoft FrontPage 3.0">
<title>借书记录维护 欢迎使用欣科软件</title>
</head>
<body background="Bkg35.jpg">
<p><img src="../images/cat1.gif"> <font size="6" color="#FF0000">借书记录维护</font>
<object id="RDS1" classid="ClsID:BD96C556-65A3-11D0-983A-00C04FC29E33" align="baseline"
border="0" width="25" height="4">
<param name="AllowAddnew" value="true">
<param name="AllowDelete" value="true">
<param name="AllowUpdate" value="true">
<param name="allowarrows" value="true">
</object>
<object id="RDS2" classid="ClsID:BD96C556-65A3-11D0-983A-00C04FC29E33" align="baseline"
border="0" width="26" height="12">
<param name="AllowAddnew" value="true">
<param name="AllowDelete" value="true">
<param name="AllowUpdate" value="true">
<param name="allowarrows" value="true">
</object><hr color="#ff0000">
<script language="vbscript">
public l_YN
public l_update
public text11
RDS1.Server = "http://<%=Request.ServerVariables("SERVER_NAME")%>"
RDS1.Connect = "database=school;uid=sa;pwd=;dsn=school"
RDS1.SQL = "select 分类编号,种次号=主序号,次序号,借书证号,姓名,借出日期,还书日期,限借天数 from tjsdj order by 分类编号 "
rds1.executeoptions=1
RDS1.Refresh
RDS2.Server = "http://<%=Request.ServerVariables("SERVER_NAME")%>"
RDS2.Connect = "database=school;uid=sa;pwd=;dsn=school"
</script>
<div align="left">
<table border="1" width="740" height="235">
<tr>
<td valign="top" width="715" height="229">
<OBJECT align=baseline classid="clsid:00028CD1-0000-0000-0000-000000000046" data=data:application/x-oleobject;base64,0YwCAAAAAAAAAAAAAAAARv7/AAAECgIA0YwCAAAAAAAAAAAAAAAARgEAAAAhCI/7ZAEbEITtCAArLscTQAAAAHEiAAAzAAAA0wcAAKABAADUBwAAqAEAAAACAACwAQAAEAAAALgBAAAIAAAAwAEAACMAAACkCAAAtAAAAHQOAAABAAAAeA4AAAIAAACADgAABAAAAIgOAAD4/f//kA4AAAj+//+YDgAABwAAAKAOAACPAAAAqA4AACUAAACwDgAACgAAALgOAABQAAAAwA4AAP79///IDgAADAAAANAOAACRAAAA2A4AAEoAAADgDgAADwAAAOgOAAD6/f//8A4AAAECAAD8DgAALwAAAHwdAAAwAAAAhB0AADEAAACMHQAAMgAAAJQdAAAzAAAAnB0AAJUAAACkHQAAlgAAAKwdAACXAAAAtB0AALAAAAC8HQAAsgAAAMQdAACzAAAAzB0AAKMAAADUHQAApAAAANwdAABcAAAA5B0AAF0AAADwHQAAsQAAAPwdAABhAAAACB4AAF8AAAAQHgAAYAAAABgeAAB9AAAAIB4AAH4AAAAoHgAAmAAAADAeAACZAAAAOB4AAIQAAABAHgAAnwAAAEgeAACgAAAAUB4AAAAAAABYHgAAAwAAABY6AAADAAAA5iEAAAIAAAAAAAAAAwAAAAEAAIBLEAAAAgAAAGkDAAD+/wAABAoCAOCMAgAAAAAAAAAAAAAAAEYBAAAAIQiP+2QBGxCE7QgAKy7HEzwCAAA5AwAAFgAAAAICAAC4AAAABAIAAMAAAAAYAAAAyAAAAEcAAADMAAAASAAAANQAAAAFAAAA3AAAADoAAADoAAAACAAAAPQAAAAkAAAAAAEAAAkAAAAIAQAAEQAAABQBAAAsAAAAIAEAAC0AAAAsAQAARAAAADQBAAAvAAAAPAEAAEYAAABIAQAAMQAAAFQBAAA0AAAAXAEAADUAAABkAQAAQAAAAGwBAABBAAAAdAEAAAAAAAB8AQAAAwAAAAAAAAACAAAABQAAAAAAAAALAAAA//8AAAsAAAD//wAAHgAAAAEAAAAAAAAAHgAAAAEAAAAAAAAAHgAAAAEAAAAAAAAAAwAAAAAAAAAeAAAAAQAAAAAAAAAeAAAAAQAAAAAAAAAeAAAAAQAAAAAAAAALAAAAAAAAAAsAAAAAAAAAHgAAAAEAAAAAAAAAHgAAAAEAAAAAAAAAAwAAAAAAAAALAAAAAAAAAAsAAAAAAAAACwAAAAAAAAALAAAAAAAAABYAAAAAAAAACAAAAENvbHVtbjAANQAAAA0AAABCdXR0b25BbHdheXMAQQAAAA0AAABCdXR0b25Gb290ZXIAQAAAAA0AAABCdXR0b25IZWFkZXIAMQAAAA4AAABCdXR0b25QaWN0dXJlADQAAAALAAAAQnV0dG9uVGV4dAAFAAAACAAAAENhcHRpb24ACAAAAAoAAABEYXRhRmllbGQAJAAAAAoAAABEYXRhV2lkdGgACQAAAA0AAABEZWZhdWx0VmFsdWUALwAAAAkAAABEcm9wRG93bgAsAAAACQAAAEVkaXRNYXNrAEQAAAAOAAAARWRpdE1hc2tSaWdodAAtAAAADwAAAEVkaXRNYXNrVXBkYXRlAEYAAAAPAAAARXh0ZXJuYWxFZGl0b3IASAAAAA4AAABGb290ZXJEaXZpZGVyADoAAAALAAAARm9vdGVyVGV4dABHAAAADgAAAEhlYWRlckRpdmlkZXIAEQAAAA0AAABOdW1iZXJGb3JtYXQAGAAAAAsAAABWYWx1ZUl0ZW1zAAQCAAAPAAAAX01heENvbWJvSXRlbXMAAgIAAAwAAABfVmxpc3RTdHlsZQBpAwAA/v8AAAQKAgDgjAIAAAAAAAAAAAAAAABGAQAAACEIj/tkARsQhO0IACsuxxOpBQAAOQMAABYAAAACAgAAuAAAAAQCAADAAAAAGAAAAMgAAABHAAAAzAAAAEgAAADUAAAABQAAANwAAAA6AAAA6AAAAAgAAAD0AAAAJAAAAAABAAAJAAAACAEAABEAAAAUAQAALAAAACABAAAtAAAALAEAAEQAAAA0AQAALwAAADwBAABGAAAASAEAADEAAABUAQAANAAAAFwBAAA1AAAAZAEAAEAAAABsAQAAQQAAAHQBAAAAAAAAfAEAAAMAAAAAAAAAAgAAAAUAAAAAAAAACwAAAP//AAALAAAA//8AAB4AAAABAAAAAAAAAB4AAAABAAAAAAAAAB4AAAABAAAAAAAAAAMAAAAAAAAAHgAAAAEAAAAAAAAAHgAAAAEAAAAAAAAAHgAAAAEAAAAAAAAACwAAAAAAAAALAAAAAAAAAB4AAAABAAAAAAAAAB4AAAABAAAAAAAAAAMAAAAAAAAACwAAAAAAAAALAAAAAAAAAAsAAAAAAAAACwAAAAAAAAAWAAAAAAAAAAgAAABDb2x1bW4xADUAAAANAAAAQnV0dG9uQWx3YXlzAEEAAAANAAAAQnV0dG9uRm9vdGVyAEAAAAANAAAAQnV0dG9uSGVhZGVyADEAAAAOAAAAQnV0dG9uUGljdHVyZQA0AAAACwAAAEJ1dHRvblRleHQABQAAAAgAAABDYXB0aW9uAAgAAAAKAAAARGF0YUZpZWxkACQAAAAKAAAARGF0YVdpZHRoAAkAAAANAAAARGVmYXVsdFZhbHVlAC8AAAAJAAAARHJvcERvd24ALAAAAAkAAABFZGl0TWFzawBEAAAADgAAAEVkaXRNYXNrUmlnaHQALQAAAA8AAABFZGl0TWFza1VwZGF0ZQBGAAAADwAAAEV4dGVybmFsRWRpdG9yAEgAAAAOAAAARm9vdGVyRGl2aWRlcgA6AAAACwAAAEZvb3RlclRleHQARwAAAA4AAABIZWFkZXJEaXZpZGVyABEAAAANAAAATnVtYmVyRm9ybWF0ABgAAAALAAAAVmFsdWVJdGVtcwAEAgAADwAAAF9NYXhDb21ib0l0ZW1zAAICAAAMAAAAX1ZsaXN0U3R5bGUAAABLEAAAAQAAAMMFAAD+/wAABAoCAOKMAgAAAAAAAAAAAAAAAEYBAAAAIQiP+2QBGxCE7QgAKy7HEyAJAACTBQAAFwAAAAYCAADAAAAAIAAAAMgAAAA6AAAA0AAAADsAAADYAAAAAQAAAOAAAAADAAAA6AAAAB8AAADwAAAABAAAAPgAAAAFAAAAAAEAAAcAAAAIAQAABgAAABABAAAPAAAAGAEAABAAAAAgAQAAEQAAACgBAAADAgAAMAEAACkAAAB0AwAAKgAAAHwDAAArAAAAhAMAAC8AAACMAwAAMgAAAJQDAAAzAAAAnAMAADUAAACoAwAAAAAAALADAAADAAAAAAAAAAsAAAAAAAAACwAAAP//AAALAAAAAAAAAAsAAAAAAAAAAgAAAAEAAAADAAAABgAAAAsAAAAAAAAACwAAAP//AAADAAAAAAAAAAIAAAABAAAACwAAAP//AAALAAAA//8AAAMAAAAEAAAAQQAAAEACAABCaWdSZWQBAgIAAAABAAAAEQAAAAQAAAAZBQAADhEAAAAuxxMEAAAAAQUAAAEAAAAAAAAABAAAAP8EAACAgIAAAAAAAAQAAADuBAAAAQAAAABNuwIEAAAABwUAAAEAAAAAT7sCBAAAACUEAAAEAAAAAEi7AgQAAAArBAAAAQAAAAAAAAAEAAAA1AQAAAAAAAAAT7sCBAAAAMgEAAAAAAAAAE+7AgQAAACEBAAAAAAAAAAAAAAEAAAAlAUAAAEAAAAAb2x1BAAAACMEAAABAAAAAAAAAAQAAADIBQAAAAAAAADCowIEAAAAwgUAAAAAAAAAAAAABAAAAOYFAAAAAAAAAE1heAQAAADqBQAAAAAAAAAAAAAEAAAA+QUAAAEAAAAAcwAAAgAAABEAAAAEAAAAGQUAAA4RAAAAAAAABAAAAAEFAAABAAAAAGVmYQQAAAD/BAAAgICAAAAAAAAEAAAA7gQAAAEAAAAA3WcABAAAAAcFAAABAAAAAAAAAAQAAAAlBAAABAAAAAD///8EAAAAKwQAAAEAAAAAAAAABAAAANQEAAAAAAAAAN1nAAQAAADIBAAAAAAAAAAAAAAEAAAAhAQAAAAAAAAAAPL/BAAAAJQFAAABAAAAAAAAAAQAAAAjBAAAAgAAAAAA8v8EAAAAyAUAAAAAAAAAAAAABAAAAMIFAAAAAAAAAIO7AgQAAADmBQAAAAAAAAAuxxMEAAAA6gUAAAAAAAAAAAAABAAAAPkFAAABAAAAAAAAAAsAAAD//wAACwAAAAAAAAALAAAA//8AAAsAAAAAAAAACwAAAAAAAAAeAAAAAQAAAAAAAAADAAAAAAAAABcAAAAAAAAABwAAAFNwbGl0MAAqAAAADQAAAEFsbG93Q29sTW92ZQApAAAADwAAAEFsbG93Q29sU2VsZWN0AAUAAAALAAAAQWxsb3dGb2N1cwArAAAADwAAAEFsbG93Um93U2VsZWN0AA8AAAAPAAAAQWxsb3dSb3dTaXppbmcABAAAAAwAAABBbGxvd1NpemluZwAyAAAAFAAAAEFsdGVybmF0aW5nUm93U3R5bGUAOwAAABIAAABBbmNob3JSaWdodENvbHVtbgAzAAAACAAAAENhcHRpb24ANQAAAA0AAABEaXZpZGVyU3R5bGUAIAAAABIAAABFeHRlbmRSaWdodENvbHVtbgAvAAAADgAAAEZldGNoUm93U3R5bGUAAQAAAAcAAABMb2NrZWQAHwAAAA0AAABNYXJxdWVlU3R5bGUAOgAAABMAAABQYXJ0aWFsUmlnaHRDb2x1bW4AEAAAABAAAABSZWNvcmRTZWxlY3RvcnMAEQAAAAsAAABTY3JvbGxCYXJzAAMAAAAMAAAAU2Nyb2xsR3JvdXAABgAAAAUAAABTaXplAAcAAAAJAAAAU2l6ZU1vZGUAAwIAAA0AAABfQ29sdW1uUHJvcHMABgIAAAsAAABfVXNlckZsYWdzAAAAAAAACwAAAAAAAAALAAAAAAAAAAsAAAD//wAAAwAAAAEAAAADAAAAAQAAAAsAAAD//wAACwAAAAAAAAADAAAAAAAAAAQAAAAAAAAACwAAAP//AAALAAAA//8AAAQAAAAAAIA/BAAAAAAAgD8LAAAA//8AAAMAAAACAAAAHgAAAAEAAAAAAAAAQQAAAHwOAABVU3R5bGUBBQAAAAAlAAAAAAAAAP//////CQD/AAAAAAQAAAAFAACACAAAgLAEhgDLzszlAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAP//////////AAAAAAEAAAAAAAAAAAAAAAAAAAAEAAAABQAAgAgAAIAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAD//////////wAAAAACAAAAAQAAAAAAAAAAAAAABAAAAAUAAIAIAACAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA//////////8AAAAAAwAAAAEAAAAAAAAAAAAAAAQAAAAFAACACAAAgAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAP//////////AAAAAAQAAAACAAAAAAAAAAAAAAAEAAAABQAAgAgAAIAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAD//////////wAAAAAFAAAAAgAAAMAAAAAAAAAABAAAAA8AAIASAACAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA//////////8AAAAABgAAAAEAAAAAAAAAAAAAAAQAAAAFAACACAAAgAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAP//////////AAAAAAcAAAABAAAAAAAAAAAAAAAEAAAABQAAgAgAAIAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAD//////////wAAAAAIAAAAAQAAAAAAAAAAAAAABAAAAAUAAIAIAACAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA//////////8AAAAACQAAAAEAAAAAAAAAAAAAAAQAAAAFAACACAAAgAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAP//////////AAAAAAoAAAABAAAAAAAAAAAAAAAEAAAABQAAgAgAAIAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAD//////////wAAAAALAAAAAQAAAAAAAAAAAAAABAAAAAUAAIAIAACAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA//////////8AAAAADAAAAAIAAAAAAAAAAAAAAAQAAAAFAACACAAAgAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAP//////////AAAAAA0AAAADAAAAAAAAAAAAAAAEAAAABQAAgAgAAIAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAD//////////wAAAAAOAAAABQAAAAAAAAAAAAAABAAAAA8AAIASAACAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA//////////8AAAAADwAAAAcAAAAAAAAAAAAAAAQAAAAFAACACAAAgAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAP//////////AAAAABAAAAAGAAAAAAAAAAAAAAAEAAAABQAAgAgAAIAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAD//////////wAAAAARAAAACAAAAAAAAAAAAAAABAAAAAUAAIAIAACAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA//////////8AAAAAEgAAAAkAAAAAAAAAAAAAAAQAAAAFAACACAAAgAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAP//////////AAAAABMAAAAKAAAAAAAAAAAAAAAEAAAABQAAgAgAAIAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAD//////////wAAAAAUAAAABAAAAAAAAAAAAAAABAAAAAUAAIAIAACAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA//////////8AAAAAFQAAAAwAAAAAAAAAAAAAAAQAAAAFAACACAAAgAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAP//////////AAAAABYAAAANAAAAAAAAAAAAAAAEAAAABQAAgAgAAIAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAD//////////wAAAAAXAAAADwAAAAAAAAAAAAAABAAAAAUAAIAIAACAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA//////////8AAAAAGAAAAAsAAAAAAAAAAAAAAAQAAAAFAACACAAAgAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAP//////////AAAAABkAAAAMAAAAAAAAAAAAAAAEAAAABQAAgAgAAIAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAD//////////wAAAAAaAAAADQAAAAAAAAAAAAAABAAAAAUAAIAIAACAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA//////////8AAAAAGwAAAA8AAAAAAAAAAAAAAAQAAAAFAACACAAAgAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAP//////////AAAAABwAAAALAAAAAAAAAAAAAAAEAAAABQAAgAgAAIAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAD//////////wAAAAAdAAAAAAAAAAAAAAAAAAAABAAAAAUAAIAIAACAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA//////////8AAAAAHgAAAB0AAADAAgEAAAIAABQAAAAPAACAEgAAgAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAP//////////AAAAAB8AAAAdAAAAwAABAAAAAAAUAAAADwAAgBIAAIAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAD//////////wAAAAAgAAAAHQAAAMAAAAAAAAAABAAAAA0AAIAOAACAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA//////////8AAAAAIQAAAB4AAAAAAQAAAAAAABEAAAAPAACAEgAAgAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAP//////////AAAAACIAAAAdAAAAwAAAAAAAAAAEAAAACAAAgAUAAIAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAD//////////wAAAAAjAAAAHQAAAIAAAAAAAAAABAAAAAD//wAIAACAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA//////////8AAAAAJAAAAB0AAAAAAAAAAAAAAAQAAAAFAACACAAAgAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAP//////////AAAAAB0AAAAAAAAAAAAAAAAAAAAAAAAA//////////8BAAAAAAAAAAAAAAABAAAA/v///wQAAAAAAAAAAAAAAAUAAAD9////AgAAAAAAAAAAAAAAAgAAAOr///8DAAAAAAAAAAAAAAADAAAA/P///wUAAAAAAAAAAAAAAP/////7////BgAAAAAAAAAAAAAABAAAAPr///8HAAAAAAAAAAAAAAD/////8f///wgAAAAAAAAAAAAAAAYAAADv////CQAAAAAAAAAAAAAABwAAAO7///8KAAAAAAAAAAAAAAAIAAAA+f///wsAAAABAAAAAAAAAP/////r////FAAAAAEAAAAAAAAA//////j///8MAAAAAQAAAAAAAAD/////6f///w0AAAABAAAAAAAAAP/////3////DgAAAAEAAAAAAAAA//////b///8QAAAAAQAAAAAAAAD/////9f///w8AAAABAAAAAAAAAP/////w////EQAAAAEAAAAAAAAA/////+3///8SAAAAAQAAAAAAAAD/////7P///xMAAAABAAAAAAAAAP/////0////GAAAAAEAAAABAAAA//////P///8VAAAAAQAAAAEAAAD/////6P///xYAAAABAAAAAQAAAP/////y////FwAAAAEAAAABAAAA//////T///8cAAAAAQAAAAIAAAD/////8////xkAAAABAAAAAgAAAP/////o////GgAAAAEAAAACAAAA//////L///8bAAAAAQAAAAIAAAD/////CAAAAE5vcm1hbAACoOe7AhDouwJBcHBlYXJhbmNlAAD0////HQAAAEhlYWRpbmcAwAS7AmAKuwLACrsCEBK7AgAAAABfRXh0HgAAAEZvb3RpbmcAAAAAAF9Sb3dIZWlnaHQAAGllZFJvdwACHwAAAFNlbGVjdGVkAAAAgA8AAIAAAAAAAAAAAAAAAAAAO6oCIAAAAENhcHRpb24AAAAAAEhlYWRMaW5lcwClAgAAAACQFrsCIQAAAEhpZ2hsaWdodFJvdwDrngIAAJ4Cd+ueAuxWTQDl654CIgAAAEV2ZW5Sb3cAmBi7AlTkZwC0AAAAylieAtCRngJR6Z4CIwAAAE9kZFJvdwBkTmV3APT///8dAAAAAAAAAAIAAAAAAAAAJAAAAAsAAAD//wAAAwAAAAAAAAALAAAAAAAAAAMAAAAAAAAACwAAAAAAAAADAAAAAAAAAAMAAAAAAAAAAwAAAAAAAAADAAAAAAAAAAMAAAAAAAAAAwAAAAAAAAADAAAAAAAAAAMAAAAAAAAAHgAAAAEAAAAAAAAAHgAAAAEAAAAAAAAAHgAAAAEAAAAAAAAAAwAAAAAAAAALAAAAAAAAAAMAAAAAAAAABAAAAAAAAAADAAAA6AMAAAsAAAD//wAACwAAAAAAAAADAAAAAQAAAAMAAAAAAAAAAwAAAAAAAAAzAAAAAAAAAAYAAABncmlkMQACAAAADAAAAEFsbG93QWRkTmV3AC8AAAAMAAAAQWxsb3dBcnJvd3MAAQAAAAwAAABBbGxvd0RlbGV0ZQAEAAAADAAAAEFsbG93VXBkYXRlAPj9//8LAAAAQXBwZWFyYW5jZQAI/v//DAAAAEJvcmRlclN0eWxlAPr9//8IAAAAQ2FwdGlvbgBgAAAACQAAAENlbGxUaXBzAH4AAAAOAAAAQ2VsbFRpcHNEZWxheQB9AAAADgAAAENlbGxUaXBzV2lkdGgAjwAAAA4AAABDb2x1bW5Gb290ZXJzAAcAAAAOAAAAQ29sdW1uSGVhZGVycwAIAAAACAAAAENvbHVtbnMAJQAAAAkAAABEYXRhTW9kZQAKAAAADAAAAERlZkNvbFdpZHRoAFAAAAANAAAARWRpdERyb3BEb3duAF8AAAAKAAAARW1wdHlSb3dzAP79//8IAAAARW5hYmxlZAAwAAAADwAAAEV4cG9zZUNlbGxNb2RlAJEAAAAKAAAARm9vdExpbmVzAAwAAAAKAAAASGVhZExpbmVzAJgAAAALAAAASW5zZXJ0TW9kZQBdAAAADwAAAExheW91dEZpbGVOYW1lAFwAAAALAAAATGF5b3V0TmFtZQCxAAAACgAAAExheW91dFVSTABKAAAADgAAAE1hcnF1ZWVVbmlxdWUAowAAAAoAAABNb3VzZUljb24ApAAAAA0AAABNb3VzZVBvaW50ZXIAhAAAAAwAAABNdWx0aVNlbGVjdABhAAAADgAAAE11bHRpcGxlTGluZXMAnwAAAAwAAABPTEVEcmFnTW9kZQCgAAAADAAAAE9MRURyb3BNb2RlAJcAAAARAAAAUGljdHVyZUFkZG5ld1JvdwCVAAAAEgAAAFBpY3R1cmVDdXJyZW50Um93ALMAAAARAAAAUGljdHVyZUZvb3RlclJvdwCyAAAAEQAAAFBpY3R1cmVIZWFkZXJSb3cAlgAAABMAAABQaWN0dXJlTW9kaWZpZWRSb3cAsAAAABMAAABQaWN0dXJlU3RhbmRhcmRSb3cAtAAAAAsAAABQcmludEluZm9zAA8AAAAQAAAAUm93RGl2aWRlclN0eWxlACMAAAAHAAAAU3BsaXRzADEAAAAQAAAAVGFiQWNyb3NzU3BsaXRzADIAAAAKAAAAVGFiQWN0aW9uAJkAAAAXAAAAVHJhbnNwYXJlbnRSb3dQaWN0dXJlcwAzAAAAEAAAAFdyYXBDZWxsUG9pbnRlcgDTBwAACQAAAF9FeHRlbnRYANQHAAAJAAAAX0V4dGVudFkAAAIAAAwAAABfTGF5b3V0VHlwZQAQAAAACwAAAF9Sb3dIZWlnaHQAAQIAAAsAAABfU3R5bGVEZWZzAA==
dataSrc=#rds1 height=300 id=grid1 name=grid1 style="LEFT: 0px; TOP: 0px" width=660
border="0" VIEWASTEXT></OBJECT>
</td>
<td valign="top"><p align="center"><input type="button" value="添加数据" name="insert" disabled
onclick="addrecord()" style="font-family: 宋体; font-size: 13"></p>
<p align="center"><input type="button" value="删除数据" name="delete"
onclick="delrecord()" style="font-family: 宋体; font-size: 13"></p>
<p align="center"><input type="button" value="保存数据" name="save"
onclick="SubmitChanges()" style="font-family: 宋体; font-size: 13"></p>
<p align="center"><input type="button" value="取消修改" name="cancle"
onclick="cancelupdate()" style="font-family: 宋体; font-size: 13"></p>
<p>借书证号:<br><input type="text" id="jszh" name="jszh" size="12"
style="font-family: 宋体; font-size: 13"></p>
<p align="center"><input type="button" value="查 询" name="FIND"
onclick="find_click()" style="font-family: 宋体; font-size: 14">
<p align="center"><input type="button" value="退 出" name="back" onclick="backing()" style="font-family: 宋体; font-size: 14"></td>
</tr>
</table>
</div><script language="vbscript">
'grid1.AllowAddnew = true
' grid1.AllowDelete = true
' grid1.AllowUpdate = true
</script>
<script language="vbscript">
Sub SubmitChanges()
moveflag = true
if grid1.row > 0 then
grid1.row = grid1.row - 1
else
grid1.row =grid1.row +1
moveflag = false
end if
grid1.Editactive = False
On Error resume next
RDS1.SubmitChanges
If Err.Number <> 0 Then
'RDS1.CancelUpdate
MsgBox "无法更新数据!"
End If
if moveflag then
grid1.row = grid1.row +1
else
grid1.row = grid1.row -1
end if
End Sub
Sub CancelUpdate()
On Error Resume Next
RDS1.CancelUpdate
If Err.Number <> 0 Then
'RDS1.CancelUpdate
MsgBox "无法恢复原来数据!"
End If
Grid1.Rebind
End Sub
sub addrecord()
msgbox rds1.recordset.recordcount
End sub
sub delrecord()
IF NOT rds1.recordset.EOF and NOT rds1.recordset.BOF then
rds1.recordset.delete
grid1.Rebind
else
msgbox "已经到数据库的末尾或开始!不能删除!"
end if
end sub
sub grid1_BeforeColUpdate(colindex,oldvalue,cancle)
new_value = grid1.columns.item(colindex)
select case colindex
case 0
rds2.sql = "select * from tfl where rtrim(ltrim(分类编号))='"&rtrim(ltrim(new_value))&"'"
rds2.ExecuteOptions = 1
rds2.refresh
if rds2.recordset.recordCount>0 then
msgbox "分类编号重复!请重新输入"
cancle = true
end if
end select
end sub
sub field_Gotfocus()
if len(trim(condition_id.value)) = 0 then
field_select = false
compare_select = false
express_select = false
logic_select = false
end if
if colcount > 0 then
exit sub
end if
colcount = grid1.columns.count
fieldname(0)="学号"
for i=1 to colcount-1
colcaption = grid1.columns.item(i).caption
fieldname(i) = colcaption
set oOption = document.createElement("OPTION")
oOption.text = colcaption
oOption.value = cstr(i+1)
document.all.field_id.add(oOption)
next
end sub
sub field_getSelect()
if field_select then
exit sub
end if
condvalue = condition_id.value
condition_id.value = condvalue + fieldname(field_id.selectedindex)
field_select = true
compare_select = false
express_select = false
logic_select = false
end sub
sub compare_getSelect()
if compare_select then
msgbox "已经输入比较操作符!"
exit sub
end if
condvalue = condition_id.value
if len(trim(condvalue)) = 0 then
condvalue = "学号"
end if
select case compare_id.selectedindex
case 0
condvalue = condvalue + "="
case 1
condvalue = condvalue + ">"
case 2
condvalue = condvalue + "<"
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -