作者:阿尔及利亚奥兰叉 | 来源:互联网 | 2023-09-04 07:45
我是连接oracle数据库的自建的info表,里面只有rbsj是日期型,数据库连接没有任何问题,可以从库中读数据出来,但是在asp的录入页面里面却不能将数据写入数据库。这个页以前是
我是连接oracle数据库的自建的info表,里面只有rbsj是日期型,数据库连接没有任何问题,可以从库中读数据出来,但是在asp的录入页面里面却不能将数据写入数据库。这个页以前是连接SqlServer的数据库,那时候没有任何问题。现在改成oracle以后就只能将旧数据取出,新数据写不进去,各位高手帮我看看是怎么回事好么?整个相关的页面我也都打包在附件里面了,大家可以帮我看看。我是新手……也可以在QQ上面给我指导一下,24606053
具体的存贮数据页面代码如下:
<%
student_count=request.form(&#8220;student_count&#8221;)
for i=1 to student_count
clhm=request.form(&#8220;clhm&#8221;&i&&#8221;&#8221;)
cllx=request.form(&#8220;cllx&#8221;&i&&#8221;&#8221;)
sjxm=request.form(&#8220;sjxm&#8221;&i&&#8221;&#8221;)
sjsj=request.form(&#8220;sjsj&#8221;&i&&#8221;&#8221;)
rbsj=request.form(&#8220;rbsj&#8221;&i&&#8221;&#8221;)
zrs=request.form(&#8220;zrs&#8221;&i&&#8221;&#8221;)
clxc=request.form(&#8220;clxc&#8221;&i&&#8221;&#8221;)
clzt=request.form(&#8220;clzt&#8221;&i&&#8221;&#8221;)
ctgl=request.form(&#8220;ctgl&#8221;&i&&#8221;&#8221;)
zbxs=request.form(&#8220;zbxs&#8221;&i&&#8221;&#8221;)
qssj=request.form(&#8220;qssj&#8221;&i&&#8221;&#8221;)
jcsj=request.form(&#8220;jcsj&#8221;&i&&#8221;&#8221;)
sybm=request.form(&#8220;sybm&#8221;&i&&#8221;&#8221;)
syry=request.form(&#8220;syry&#8221;&i&&#8221;&#8221;)
ycbz=request.form(&#8220;ycbz&#8221;&i&&#8221;&#8221;)
clid=request.form(&#8220;clid&#8221;&i&&#8221;&#8221;)
if i=1 and request.form(&#8220;clhm1&#8243;)=&#8221;&#8221; then
fOnuderr=&#8221;true&#8221;
errmsg=&#8221;
数值为空,请从第一个车号开始输入&#8221; elseif cllx=&#8221;&#8221; then
exit for
else
&#8216;set rs=conn.execute(&#8220;select ch from info where ch='&#8221;&ch&&#8221;&#8216;&#8221;)
&#8216;if not(rs.eof and rs.bof) then
&#8216;fOnuderr=&#8221;true&#8221;
&#8216;errmsg=errmsg&&#8221;
条目&#8221;&i&&#8221;的车号(&#8221;&ch&&#8221;)已存在&#8221; &#8216;end if
&#8216;set rs=nothing
if zrs=&#8221;&#8221; then
fOnuderr=&#8221;true&#8221;
errmsg=errmsg&&#8221;
请填写&#8221;&i&&#8221;的载人数&#8221; end if
end if
j=j+1
next
if fOnuderr=&#8221;true&#8221; then
call errormsg()
else
for i=1 to j
clhm=request.form(&#8220;clhm&#8221;&i&&#8221;&#8221;)
cllx=request.form(&#8220;cllx&#8221;&i&&#8221;&#8221;)
sjxm=request.form(&#8220;sjxm&#8221;&i&&#8221;&#8221;)
sjsj=request.form(&#8220;sjsj&#8221;&i&&#8221;&#8221;)
rbsj=request.form(&#8220;rbsj&#8221;&i&&#8221;&#8221;)
zrs=request.form(&#8220;zrs&#8221;&i&&#8221;&#8221;)
clxc=request.form(&#8220;clxc&#8221;&i&&#8221;&#8221;)
clzt=request.form(&#8220;clzt&#8221;&i&&#8221;&#8221;)
ctgl=request.form(&#8220;ctgl&#8221;&i&&#8221;&#8221;)
zbxs=request.form(&#8220;zbxs&#8221;&i&&#8221;&#8221;)
qssj=request.form(&#8220;qssj&#8221;&i&&#8221;&#8221;)
jcsj=request.form(&#8220;jcsj&#8221;&i&&#8221;&#8221;)
sybm=request.form(&#8220;sybm&#8221;&i&&#8221;&#8221;)
syry=request.form(&#8220;syry&#8221;&i&&#8221;&#8221;)
ycbz=request.form(&#8220;ycbz&#8221;&i&&#8221;&#8221;)
clid=request.form(&#8220;clid&#8221;&i&&#8221;&#8221;)
conn.execute(&#8220;insert into info(clhm,cllx,sjxm,sjsj,rbsj,zrs,clxc,clzt,ctgl,zbxs,qssj,jcsj,sybm,syry,ycbz,clid) values(&#8216;&clhm&#8217;,&#8217;&cllx&#8217;,&#8217;&sjxm&#8217;,&#8217;&sjsj&#8217;,&#8217;&rbsj&#8217;,&#8217;&zrs&#8217;,&#8217;&clxc&#8217;,&#8217;&clzt&#8217;,&#8217;&ctgl&#8217;,&#8217;&zbxs&#8217;,&#8217;&qssj&#8217;,&#8217;&jcsj&#8217;,&#8217;&sybm&#8217;,&#8217;&syry&#8217;,&#8217;&ycbz&#8217;,&#8217;&clid&#8217;);commit;&#8221;)
next
rigmsg=&#8221;
&#8221;&j&&#8221;条信息添加成功返回&#8221; response.write&#8221;
操作成功:
&#8221;&rigmsg&&#8221;返回上一页&#8221; Response.End
end if
sub errormsg()
response.write&#8221;
操作出错:
&#8221;&errmsg&&#8221;返回上一页&#8221; end sub
sub rightmsg()
&#8216;自动返回前一页(也可根据backurl设定)
response.write&#8221;
操作成功:(1秒后自动返回)
&#8221;&rigmsg&&#8221;返回上一页&#8221; end sub
%>