848569.xml

论坛精华帖子

<?xml version='1.0' encoding='GB2312'?>
<?xml-stylesheet type='text/xsl' href='../csdn.xsl'?>
<Topic>
<Issue>
<PostUserNickName>LuBin</PostUserNickName>
<rank>一级(初级)</rank>
<ranknum>user1</ranknum>
<credit>100</credit>
<TopicId>848569</TopicId>
<TopicName>我想用JSP更新图片，我该怎么做？？</TopicName>
<PostUserId>248654</PostUserId>
<PostUserName>dooluby</PostUserName>
<RoomName>JSP</RoomName>
<ReplyNum>2</ReplyNum>
<PostDateTime>2002-7-4 8:51:35</PostDateTime>
<Point>80</Point>
<ReadNum>0</ReadNum>
<RoomId>28</RoomId>
<EndState>2</EndState>
<Content>我用的数据库是Oracle8i，现在我已经将图片存入数据库中，但是我需要更新它，我该怎么做？？谢谢。</Content>
</Issue>
<Replys>
<Reply>
<PostUserNickName>燕翩跹</PostUserNickName>
<rank>三级(初级)</rank>
<ranknum>user3</ranknum>
<credit>105</credit>
<ReplyID>5525074</ReplyID>
<TopicID>848569</TopicID>
<PostUserId>133218</PostUserId>
<PostUserName>icech</PostUserName>
<Point>80</Point>
<Content>&lt;%@&#32;page&#32;language="java"%&gt;
&lt;%@&#32;page&#32;contentType="text/html;charset=gb2312"&#32;%&gt;
&lt;%@&#32;page&#32;import="java.util.*"&#32;%&gt;
&lt;%@&#32;page&#32;import="java.sql.*"%&gt;
&lt;%@&#32;page&#32;import="java.text.*"%&gt;&#32;
&lt;%@&#32;page&#32;import="java.io.*"%&gt;&#32;&#32;

&lt;%
Class.forName("oracle.jdbc.driver.OracleDriver");&#32;
String&#32;url="jdbc:oracle:thin:@lubin:1521:b2bdb";&#32;
Connection&#32;con=DriverManager.getConnection(url,"demo","demo");&#32;

//插入数据库
String&#32;sql="UPDATE&#32;test_img&#32;SET&#32;img=?&#32;WHERE&#32;id=?";
//获取传值ID
String&#32;id=request.getParameter("ID");
System.out.println(id);
//获取image的路径
String&#32;kk=request.getParameter("image");
//转换成file格式
File&#32;filename=new&#32;File(kk);

//将文件的长度读出，并转换成Long型
long&#32;l1=filename.length();
int&#32;l2=(int)l1;

//以流的格式赋值
FileInputStream&#32;fis=new&#32;FileInputStream(filename);

PreparedStatement&#32;ps&#32;=con.prepareStatement(sql);
//ps.setString(1,filename.getName());
ps.setBinaryStream(1,fis,l2);&#32;
ps.setString(2,id);
//ps.setBinaryStream(3,fis,fis.available());&#32;
ps.executeUpdate();
//ps.execute();&#32;
ps.close();
fis.close();
out.println("ok!!!");

%&gt;</Content>
<PostDateTime>2002-7-4 17:46:14</PostDateTime>
</Reply>
<Reply>
<PostUserNickName>小所</PostUserNickName>
<rank>一级(初级)</rank>
<ranknum>user1</ranknum>
<credit>100</credit>
<ReplyID>5780433</ReplyID>
<TopicID>848569</TopicID>
<PostUserId>288739</PostUserId>
<PostUserName>suohui790616</PostUserName>
<Point>0</Point>
<Content>请问怎么将图片存入数据库中，谢谢</Content>
<PostDateTime>2002-7-21 13:26:01</PostDateTime>
</Reply>
</Replys>
</Topic>