761003.xml

论坛精华帖子

<?xml version='1.0' encoding='GB2312'?>
<?xml-stylesheet type='text/xsl' href='../csdn.xsl'?>
<Topic>
<Issue>
<PostUserNickName></PostUserNickName>
<rank>二级(初级)</rank>
<ranknum>user2</ranknum>
<credit>100</credit>
<TopicId>761003</TopicId>
<TopicName>快疯了：怎样从JSP中向Oracle_816中插入LONG型字符串？</TopicName>
<PostUserId>262781</PostUserId>
<PostUserName>vangies</PostUserName>
<RoomName>JSP</RoomName>
<ReplyNum>4</ReplyNum>
<PostDateTime>2002-5-29 9:48:46</PostDateTime>
<Point>100</Point>
<ReadNum>0</ReadNum>
<RoomId>28</RoomId>
<EndState>2</EndState>
<Content>我向Oracle_816中插入LONG型字符串，老是报错说：字符串太长。

原因据说在插入的时候受PL/SQL变量大小限制。希望有高手能提供解决办法，最好能提供详细些的源码。另，我不愿使用LOB。

我的信箱：[e-mail]

</Content>
</Issue>
<Replys>
<Reply>
<PostUserNickName>穆斯林信徒</PostUserNickName>
<rank>三级(初级)</rank>
<ranknum>user3</ranknum>
<credit>92</credit>
<ReplyID>4958378</ReplyID>
<TopicID>761003</TopicID>
<PostUserId>179289</PostUserId>
<PostUserName>pingju</PostUserName>
<Point>100</Point>
<Content>&lt;%&#32;&#32;&#32;
&#32;DriverManager.registerDriver(new&#32;oracle.jdbc.driver.OracleDriver());
&#32;Connection&#32;conn&#32;=&#32;DriverManager.getConnection("java:oracle:thin:@srv:1521:srv","yp","yp");
&#32;String&#32;sql=&#32;"INSERT&#32;&#32;INTO&#32;&#32;speedfaw.news&#32;VALUES(?,?)";
&#32;PreparedStatement&#32;pstmt=conn.prepareStatement(sql);
&#32;String&#32;&#32;title=request.getParameter("title");
&#32;String&#32;&#32;content=request.getParameter("content");
&#32;String&#32;temp&#32;=&#32;new&#32;String(content.getBytes("ISO8859-1"),"GBK");
&#32;byte[]&#32;&#32;pic&#32;&#32;=&#32;&#32;temp.getBytes("GBK");

&#32;ByteArrayInputStream&#32;&#32;baisss&#32;&#32;=&#32;&#32;new&#32;&#32;ByteArrayInputStream(pic);
&#32;InputStreamReader&#32;&#32;bais&#32;&#32;=&#32;&#32;new&#32;&#32;InputStreamReader(baisss,"GBK");

&#32;pstmt.setString(1,title);
&#32;pstmt.setCharacterStream(2,bais,pic.length);
&#32;pstmt.execute();
&#32;pstmt.close();
&#32;conn.close();
&#32;&#32;

&#32;%&gt;

&#32;好使的。刚试过。读时候就getString&#32;就行。
</Content>
<PostDateTime>2002-5-29 9:59:38</PostDateTime>
</Reply>
<Reply>
<PostUserNickName>zz</PostUserNickName>
<rank>五级(中级)</rank>
<ranknum>user5</ranknum>
<credit>95</credit>
<ReplyID>4959089</ReplyID>
<TopicID>761003</TopicID>
<PostUserId>107094</PostUserId>
<PostUserName>zhu_liping</PostUserName>
<Point>0</Point>
<Content>OKOK,就是这样的</Content>
<PostDateTime>2002-5-29 10:31:05</PostDateTime>
</Reply>
<Reply>
<PostUserNickName></PostUserNickName>
<rank>二级(初级)</rank>
<ranknum>user2</ranknum>
<credit>100</credit>
<ReplyID>4959372</ReplyID>
<TopicID>761003</TopicID>
<PostUserId>262781</PostUserId>
<PostUserName>vangies</PostUserName>
<Point>0</Point>
<Content>OK!thx&#32;a&#32;lot!
</Content>
<PostDateTime>2002-5-29 10:43:33</PostDateTime>
</Reply>
<Reply>
<PostUserNickName></PostUserNickName>
<rank>二级(初级)</rank>
<ranknum>user2</ranknum>
<credit>100</credit>
<ReplyID>4959906</ReplyID>
<TopicID>761003</TopicID>
<PostUserId>262781</PostUserId>
<PostUserName>vangies</PostUserName>
<Point>0</Point>
<Content>pingju请看看自己的专家分涨了没有，我刚才结帐的时候出现了“找不到服务器”，Ft!&#32;点了管理后显示已经给你加分了，也不知道是不是真的加上了。如果没有的话，请说一声。</Content>
<PostDateTime>2002-5-29 11:06:21</PostDateTime>
</Reply>
</Replys>
</Topic>