我想把文件存到数据image字段里(image类型)然后在显示出来
保存代码
String path="D:/dk/kyzc/appKyzc/sjtj/aaaaaa.txt";
File f=new File(path);
FileInputStream is=new FileInputStream(f);
String sql="insert into tab_tzhz(image1,aa,bb) values(?,?,?)";
Connection con=DBconn.getConnection();
PreparedStatement pstmt=con.prepareStatement(sql);
pstmt.setBinaryStream(1,is,(int)f.length());
pstmt.setString(2,"aaaa");
pstmt.setString(3,"bbb");
pstmt.execute();显示代码
Connection con=DBconn.getConnection();
Statement stmt=DBconn.CreateStatement(con);
ResultSet rs=null;
int id=Integer.parseInt(request.getParameter("id"));
System.out.println("idaaaaaa"+id);
String sql="select image1 from tab_tzhz where id="+id+" ";
System.out.println("eeeee"+sql);
rs=stmt.executeQuery(sql);
rs.next();
InputStream inStream=rs.getBinaryStream("image1");
FileOutputStream fs=new FileOutputStream("d:/1.cell");
byte[]buffer=new byte[inStream.available()];
int byteread=0;
while((byteread=inStream.read(buffer))!=-1){
  fs.write(buffer);
  fs.flush();
}
inStream.close();
fs.close();在d盘可以生成1.cell文件但是没有里面的内容.
帮我看看什么问题.该怎么写 谢谢了