inbookok.asp

来自「基于ASP和数据库的对查询图书的实现的源代码。希望对大家有帮助」· ASP 代码 · 共 28 行

<%
bookname=request.form("bookname")
author=request.form("author")
price=request.form("price")
press=request.form("press")
amount=request.form("amount")
years=request.form("year")
month1=request.form("month")
cbrq=years&"年"&month1&"月"
set con=server.createobject("adodb.connection")
con.connectionstring="dsn=mydsn;uid=sa;pwd="
con.open
set rs=server.createobject("adodb.recordset")
rs.open "select * from books where 1=0",con,2,2
rs.addnew
rs("书名")=bookname
rs("作者")=author
rs("出版社")=press
rs("出版日期")=cbrq
rs("定价")=price
rs("数量")=amount
rs.update
rs.close
set rs=nothing
'con.execute("insert into books(书名,作者,出版社,出版日期,定价,数量) values('"&bookname&"','"&author&"','"&press&"','"&cbrq&"','"&price&"','"&amount&"')")
con.close
set con=nothing
%>