bj.asp

asp写的一个简单的图书管理系统. 出于无奈.这种简单的项目也传上来.这个是我替同学做的考试作业,要是应付考试还是可以的.实现的比较简单

<%
	BookID = CInt(request.QueryString("bookID"))
%>

<%  
    set conn=server.CreateObject("ADODB.connection")
    conn.open "provider=microsoft.jet.oledb.4.0;data source=" & server.mappath("book.mdb")
    strsql="select * from book where bookID="&Trim(BookID)
    set rs=server.createobject("ADODB.Recordset")
    rs.open strsql, conn
%>
<%s=rs("bookid")%>
<table>
<form action = "bjdo.asp" method = "post">
	<tr>
		<td></td><td><input type="hidden" name = "bkid" value = "<%=rs("bookid")%>"</td>
	</tr>
	<tr>
			<td>图书名称:</td><td><input type="text" name = "bkname" value = "<%=rs("bookname")%>" </td>
	</tr>
	<tr>
		<td>图书数量:</td><td><input type="text" name = "bkaccount" value = "<%=rs("account")%>" </td>
	</tr>
	<tr>
		<td><input type = "submit" name = "btnUpdate" value = "保存"></td>
        <td></td>
	</tr>
</form>
</table>