java文件写入blob_用java 写入BLOB

");

System.exit(0);

}

Class.forName("oracle.jdbc.driver.OracleDriver");

Connection connection = DriverManager.getConnection("jdbc:oracle:thin:@DataBaseName:1521:InstanceName", "test", "1234");

PreparedStatement pst = connection.prepareStatement("insert into BLOB_TEST values (" + args[0] + ", ?)");

InputStream in = null;

File f = null;

f = new File(args[1]);

System.out.println("File: " + f.getAbsolutePath());

in = new FileInputStream(f);

//If the column type is clob, you can call method pst.setAsciiStream(int parameterIndex,InputStream x,int length)

pst.setBinaryStream(1,in,(int)f.length());

try {

pst.executeUpdate();

} catch(Exception e){e.printStackTrace();}

in.close();

}

catch (SQLException ex) {

System.err.println("Cannot connect to this database.");

System.err.println(ex);

ex.printStackTrace();

}

catch(Exception e)

{

e.printStackTrace();

}

}

}