00000000.htm

来自「水木清华BBS」· HTM 代码 · 共 110 行

HTM
110
字号
<HTML><HEAD>  <TITLE>BBS水木清华站∶精华区</TITLE></HEAD><BODY><CENTER><H1>BBS水木清华站∶精华区</H1></CENTER>发信人:&nbsp;Sailors&nbsp;(GiGi),&nbsp;信区:&nbsp;Java&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<BR>&nbsp;<BR>我用insert命令,形式如下:&nbsp;<BR>&nbsp;&nbsp;&nbsp;<BR>&nbsp;&nbsp;insert&nbsp;into&nbsp;tablename&nbsp;values(***)&nbsp;<BR>&nbsp;&nbsp;&nbsp;<BR>&nbsp;&nbsp;当&quot;***&quot;是具体的数时,可以成功地写入,但当&quot;***&quot;为已经赋值的变量名时,却出错,&nbsp;<BR>&nbsp;&nbsp;&nbsp;<BR>&nbsp;&nbsp;我把语句改成&nbsp;insert&nbsp;into&nbsp;tablename&nbsp;from&nbsp;array&nbsp;arrayname,也不行,这可是msdn上&nbsp;<BR>&nbsp;&nbsp;指明的方法呀,为什么,为什么,好郁闷的说.&nbsp;&nbsp;<BR>&nbsp;<BR>&nbsp;<BR>发信人:&nbsp;realchick&nbsp;(小鸡),&nbsp;信区:&nbsp;Java&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<BR>&nbsp;<BR>【&nbsp;在&nbsp;Sailors&nbsp;(GiGi)&nbsp;的大作中提到:&nbsp;】&nbsp;<BR>∶<I>&nbsp;我用insert命令,形式如下:&nbsp;</I><BR>∶<I>&nbsp;&nbsp;&nbsp;insert&nbsp;into&nbsp;tablename&nbsp;values(***)&nbsp;</I><BR>∶<I>&nbsp;&nbsp;&nbsp;当&quot;***&quot;是具体的数时,可以成功地写入,但当&quot;***&quot;为已经赋值的变量名时,却出错,&nbsp;</I><BR>∶<I>&nbsp;&nbsp;&nbsp;我把语句改成&nbsp;insert&nbsp;into&nbsp;tablename&nbsp;from&nbsp;array&nbsp;arrayname,也不行,这可是msdn上&nbsp;</I><BR>∶<I>&nbsp;&nbsp;&nbsp;指明的方法呀,为什么,为什么,好郁闷的说&nbsp;</I><BR>&nbsp;<BR>不是要用string的吗?&nbsp;<BR>不能把变量放在字符串内,要用StrinG的‘+’。&nbsp;<BR>&nbsp;<BR>&nbsp;<BR>&nbsp;<BR>发信人:&nbsp;Sailors&nbsp;(GiGi),&nbsp;信区:&nbsp;Java&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<BR>&nbsp;<BR>【&nbsp;在&nbsp;realchick&nbsp;(小鸡)&nbsp;的大作中提到:&nbsp;】&nbsp;<BR>∶<I>&nbsp;不是要用string的吗?&nbsp;</I><BR>∶<I>&nbsp;不能把变量放在字符串内,要用StrinG的‘+’。&nbsp;</I><BR>这位大虾,我现在把我的这段程序列出,请指出错误,&nbsp;<BR>&nbsp;有劳告诉在下怎么改.&nbsp;<BR>pstmt1.executeUpdate(&quot;INSERT&nbsp;INTO&nbsp;resultable1&nbsp;VALUES(rateofstable[0],rateof&nbsp;<BR>stable[1],rateofstable[2],rateofstable[3],rateofstable[4],rateofstable[5],ra&nbsp;<BR>teofstable[6],rateofstable[7],rateofstable[8],rateofstable[9],rateofstable[1&nbsp;<BR>0],rateofstable[11],rateofstable[12],rateofstable[13],rateofstable[14],rateo&nbsp;<BR>fstable[15])&quot;);&nbsp;<BR>其中,rateofstable[]是一个数组.&nbsp;<BR>&nbsp;<BR>&nbsp;<BR>&nbsp;<BR>&nbsp;<BR>发信人:&nbsp;realchick&nbsp;(小鸡),&nbsp;信区:&nbsp;Java&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<BR>&nbsp;<BR>【&nbsp;在&nbsp;Sailors&nbsp;(GiGi)&nbsp;的大作中提到:&nbsp;】&nbsp;<BR>∶<I>&nbsp;这位大虾,我现在把我的这段程序列出,请指出错误,&nbsp;</I><BR>∶<I>&nbsp;&nbsp;有劳告诉在下怎么改.&nbsp;</I><BR>∶<I>&nbsp;pstmt1.executeUpdate(&quot;INSERT&nbsp;INTO&nbsp;resultable1&nbsp;VALUES(rateofstable[0],rateof&nbsp;</I><BR>∶<I>&nbsp;stable[1],rateofstable[2],rateofstable[3],rateofstable[4],rateofstable[5],ra&nbsp;</I><BR>∶<I>&nbsp;teofstable[6],rateofstable[7],rateofstable[8],rateofstable[9],rateofstable[1&nbsp;</I><BR>∶<I>&nbsp;0],rateofstable[11],rateofstable[12],rateofstable[13],rateofstable[14],rateo&nbsp;</I><BR>∶<I>&nbsp;fstable[15])&quot;);&nbsp;</I><BR>∶<I>&nbsp;其中,rateofstable[]是一个数组.&nbsp;</I><BR>&nbsp;<BR>我想应该是&nbsp;<BR>pstmt1.executeUpdate(&quot;INSERT&nbsp;INTO&nbsp;resultable1&nbsp;values(&quot;+rateofstable[0]+&quot;,&quot;&nbsp;<BR>+rateofteofstable[6]+&quot;,&quot;+rateofstable[2]+.................&nbsp;<BR>&nbsp;<BR>后面应该是以此类推就行了.希望你调试成功。&nbsp;<BR>&nbsp;<BR>&nbsp;<BR>&nbsp;<BR>发信人:&nbsp;jjhwang&nbsp;(小受),&nbsp;信区:&nbsp;Java&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<BR>&nbsp;<BR>你干嘛不用个循环来构造这个SQL语句?&nbsp;<BR>//faint&nbsp;<BR>况且了,还要看这个数组里的值是什么。&nbsp;<BR>假如是字符串,在它外面还要加上单引号''。&nbsp;<BR>总之,一切要视具体情况而定,不能统统照搬。&nbsp;<BR>Good&nbsp;luck!&nbsp;<BR>【&nbsp;在&nbsp;realchick&nbsp;(小鸡)&nbsp;的大作中提到:&nbsp;】&nbsp;<BR>∶<I>&nbsp;我想应该是&nbsp;</I><BR>∶<I>&nbsp;pstmt1.executeUpdate(&quot;INSERT&nbsp;INTO&nbsp;resultable1&nbsp;values(&quot;+rateofstable[0]+&quot;,&quot;&nbsp;</I><BR>∶<I>&nbsp;+rateofteofstable[6]+&quot;,&quot;+rateofstable[2]+.................&nbsp;</I><BR>∶<I>&nbsp;后面应该是以此类推就行了.希望你调试成功。&nbsp;</I><BR>&nbsp;<BR>&nbsp;<BR>&nbsp;<BR>&nbsp;<BR>发信人:&nbsp;Sailors&nbsp;(GiGi),&nbsp;信区:&nbsp;Java&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<BR>&nbsp;<BR>【&nbsp;在&nbsp;realchick&nbsp;(小鸡)&nbsp;的大作中提到:&nbsp;】&nbsp;<BR>∶<I>&nbsp;我想应该是&nbsp;</I><BR>∶<I>&nbsp;pstmt1.executeUpdate(&quot;INSERT&nbsp;INTO&nbsp;resultable1&nbsp;values(&quot;+rateofstable[0]+&quot;,&quot;&nbsp;</I><BR>∶<I>&nbsp;+rateofteofstable[6]+&quot;,&quot;+rateofstable[2]+.................&nbsp;</I><BR>∶<I>&nbsp;后面应该是以此类推就行了.希望你调试成功。&nbsp;</I><BR>果然是大虾级的人物,大虾一出手,问题就没有.&nbsp;<BR>&nbsp;<BR>&nbsp;<BR>&nbsp;<BR><CENTER><H1>BBS水木清华站∶精华区</H1></CENTER></BODY></HTML>

⌨️ 快捷键说明

复制代码Ctrl + C
搜索代码Ctrl + F
全屏模式F11
增大字号Ctrl + =
减小字号Ctrl + -
显示快捷键?