Problems downloading files from ORACLE database ??? Urgent ~

3590200

I used the following code to download and the process did not report an error
But the downloaded stuff is always 86 bytes, and it is always garbled when opened. Why is this?
Please help .. thanks
Class.forName ("oracle.jdbc.driver.OracleDriver"). NewInstance ();
    String url = "jdbc: oracle: thin: @ 192.168.31.109: 1521: iasdb";
    // orcl is the SID of your database
    String user = "news";
    String password = "up722006";
    String name = "xxx";
    Connection conn = DriverManager.getConnection (url, user, password);
    
    PreparedStatement st = conn.prepareStatement ("select up_file from test where name =?");
      st.setString (1, name);
      // ResultSet rs = st.executeQuery ();
      ResultSet rs = st.executeQuery ();
      if (rs.next ())
      {
      byte [] cnt = rs.getBytes ("up_file");
      System.out.print ("here");
      response.getOutputStream (). write (cnt);
      System.out.print ("hehe");
      }
    }

3590200

Does anyone know? 55555555555555555555

zsjstill

Is the file binary? In this case, it is over when it encounters 0.

悲雪狂沙

mstrBackName = result.getString("randomname");
mstrfileName = result.getString("markname");
pintid = result.getInt("id");
InputStream inStream=result.getBinaryStream("MarkBody");
String aa=getServletContext().getRealPath("/")+"upload/showFile/";
FileOutputStream fs=new FileOutputStream(aa+mstrBackName);
if(mstrBackName!=null&&mstrBackName!="")
{
byte[] buffer =new byte[1444];
while ((int byteread=inStream.read(buffer))!=-1)
{
fs.write(buffer,0,byteread);
}
}
You try to change yours according to this