只能输入一次到数据库，为什么啊解决办法

2012-03-16

只能输入一次到数据库，为什么啊！！！！！！！！！写了一个asp程序，但是为什么执行一次程序只能写入一组数据啊？再写

只能输入一次到数据库，为什么啊！！！！！！！！！
写了一个asp程序，但是为什么执行一次程序只能写入一组数据啊？
再写就写不了了。一定要重新再开ie才能再写入，并且重开是不能有一个打开的ie页面，一定要完全重开。

哪位大侠告诉我是什么原因啊？
帮我改一改吧，谢谢了。

源代码如下：


<%
if Request.Form( "bookname ") <> " " and session( "bookname ")= " " then
session( "barcode ")=request.Form( "barcode ")
session( "bookname ")=Request.Form( "bookname ")
bookconcern=request.Form( "bookconcern ")
shortname=Request.Form( "shortname ")
author=Request.Form( "author ")
price=Request.Form( "price ")
kind=Request.Form( "kind ")
cover=Request.Form( "cover ")
memo=Request.Form( "memo ")
Ins_sql = "Insert into tb_bookinfo(bookname,shortname,barcode,bookconcern,author,price,kind,cover,memo) values( ' "&session( "bookname ")& " ', ' "&shortname& " ', ' "&session( "barcode ")&_
" ', ' "&bookconcern& " ', ' "&author& " ', ' "&price&_
" ', ' "&kind& " ', ' "&cover& " ', ' "&memo& " ') "
response.write Ins_sql
conn.execute(Ins_sql)
response.redirect( "register_book.asp ")
end if

%>
<%
'Set rs_Max = Server.CreateObject( "ADODB.Recordset ")
'sql_max= "SELECT MAX(bookname) AS Maxbook FROM tb_bookinfo "
'rs_max=conn.execute(sql_max)
%>
<html>
<head>
<meta http-equiv= "Content-Type " content= "text/html; charset=gb2312 ">
<title> 新书入库 </title>
<LINK rel= "stylesheet " href= "CSS/STYLE.CSS " type= "text/css ">
</head>

<body leftmargin= "0 " topmargin= "0 ">
<table width= "690 " height= "54 " border= "0 " align= "center " cellpadding= "-1 " cellspacing= "-1 ">
<tr>
<td height= "54 " style= "filter:progid:DXImageTransform.Microsoft.Gradient(startColorStr= '#FFCC00 ', endColorStr= '#FFFFFF ', gradientType= '1 ') "> <div align= "center " style= "font-size:12px ">
<p> <br>
新书入库 <br>
<br>
</p>
</div> </td>
</tr>
</table>
<table width= "660 " height= "278 " border= "0 " align= "center " cellpadding= "-1 " cellspacing= "-1 ">
<tr>
<td height= "278 " valign= "top " background= "images/buycar_bottom.jpg "> <div align= "center ">

<input type= "text " name= "kind " value= " " size= "32 " style= "border:1px solid;border-color:#000000 ">
</div> </td>
</tr>
<tr>
<td height= "27 " align= "right " nowrap> 封面： </td>
<td height= "27 "> <div align= "center ">
<input type= " " name= "cover " value= " " size= "32 " style= "border:1px solid;border-color:#000000 ">
</div> </td>
</tr>
<tr>
<td height= "27 " align= "right " nowrap> 简介： </td>
<td height= "27 "> <div align= "center ">
<input type= "text " name= "memo " value= " " size= "32 " style= "border:1px solid;border-color:#000000 ">
</div> </td>
</tr>
<script language= "JavaScript ">
function myreset(){
form1.reset();
event.returnValue=false;
}
function mysubmit(){
if (form1.bookname.value== " ")
{alert( "请输入书名！ ");form1.bookname.focus();return false;}
if (form1.shortname.value== " ")
{alert( "请输入简称！ ");form1.shortname.focus();return false;}
if (form1.barcode.value== " ")
{alert( "请输入标识码！ ");form1.barcode.focus();return false;}
if (form1.bookconcern.value== " ")
{alert( "请输入出版社！ ");form1.bookconcern.focus();return false;}
if (form1.author.value== " ")
{alert( "请输入作者！ ");form1.author.focus();return false;}
if (form1.price.value== " ")
{alert( "请输入价格！ ");form1.price.focus();return false;}
if (form1.kind.value== " ")
{alert( "请输入类型！ ");form1.kind.focus();return false;}

if (form1.cover.value== " ")
{alert( "请输入封面！ ");form1.cover.focus();return false;}
if (form1.memo.value== " ")
{alert( "请输入简介！ ");form1.memo.focus();return false;}
return true;
}
</script>
</table>
<table>
<tr>
<td width= "314 " colspan= "2 " align= "right " valign= "bottom " nowrap> <div align= "center ">
<input type= "submit " value= "提交 " style= "border:1px solid;border-color:#AAAAFF;background-color:#ffcf00 ">
<input type= "reset " name= "Submit " value= "重置 "
onClick= "myreset() " style= "border:1px solid;border-color:#AAAAFF;background-color:#ffcf00 ">
<input type= "button " value= "返回 " onClick= "javascript:window.history.back(); " style= "border:1px solid;border-color:#AAAAFF;background-color:#ffcf00 ">
</div> </td>
</tr>
</table>
<table width= "100% " height= "50 " border= "0 " cellpadding= "-2 " cellspacing= "-2 ">
<tr>
<td width= "23% " height= "26 ">   </td>
</tr>
</table>
</form>

</div> </td>
</tr>
</table>
</body>
</html>

[解决办法]
if Request.Form( "bookname ") <> " " and session( "bookname ")= " " then

问一下小下下哦~! 如果session的条件不成立了~咋办呢?
[解决办法]
程序逻辑问题....

问题就出在 session 上..
因为SESSION是同一进程的IE窗口相同的.

所以会有只能插入一条的结果....

想要插入多条???
那么,先从流程图画起吧....
先把自己的思路理清再说吧...
[解决办法]
if Request.Form( "bookname ") <> " " and session( "bookname ")= " " then
session( "bookname ")=Request.Form( "bookname ")

session( "bookname ")被赋值后第二次提交时还有值呀。
那么
if Request.Form( "bookname ") <> " " and session( "bookname ")= " " then
这个条件就通不过了。当然不能提交第二组数据。
改成
if Request.Form( "bookname ") <> " " then
应该就行了。

热点排行

ASP

只能输入一次到数据库，为什么啊解决办法