javaÈçºÎÀｫÎļþ´æµ½Êý¾Ý¿âÖÐ

public class InsertBlobData {
Connection con = null;
/**
* @param args
* @throws Exception
*/
public static void main(String[] args) throws Exception {
// TODO Auto-generated method stub
InsertBlobData data = new InsertBlobData();
data.insertBlogInfo("002jpg", "sdsdfdf", "2007-02-12", "002.jpg");
}
public void insertBlogInfo(String jmzh, String xm, String smsj,
String fileName) throws Exception {
// try {
con = ConnectionPoliceFactory.getFactory().getConnection();
// } catch (ClassNotFoundException e) {
// // TODO Auto-generated catch block
// e.printStackTrace();
// }
// ´¦ÀíÊÂÎñ
boolean defaultCommit = con.getAutoCommit();
con.setAutoCommit(false);
Statement st = con.createStatement();
// ²åÈëÒ»¸ö¿Õ¶ÔÏó
st.executeUpdate("insert into ksren_txxx(jmzh,xm,smsj,txsj) values('"
+ jmzh + "','" + xm + "',to_date('" + smsj
+ "','yyyy-mm-dd'),empty_blob())");
// ÓÃfor update·½Ê½Ëø¶¨Êý¾ÝÐÐ
ResultSet rs = st
.executeQuery("select txsj from ksren_txxx where jmzh='"
+ jmzh + "' and xm='" + xm + "' for update");
if (rs.next()) {
// µÃµ½java.sql.Blob¶ÔÏó£¬È»ºóCastΪoracle.sql.BLOB
oracle.sql.BLOB blob = (oracle.sql.BLOB) rs.getBlob(1);
// µ½Êý¾Ý¿âµÄÊä³öÁ÷
OutputStream outStream = blob.getBinaryOutputStream();
// ÕâÀïÓÃÒ»¸öÎļþÄ£ÄâÊäÈëÁ÷
InputStream fin = new FileInputStream(new File(fileName));
// ½«ÊäÈëÁ÷дµ½Êä³öÁ÷
byte[] b = new byte[blob.getBufferSize()];
int len = 0;
while ((len = fin.read(b)) != -1) {
outStream.write(b, 0, len);
// blob.putBytes(1,b);
}
// ÒÀ´Î¹Ø±Õ£¨×¢Òâ˳Ðò£©
fin.close();
outStream.flush();
outStream.close();
con.commit();
/* »Ö¸´Ô­Ìύ״̬ */
con.setAutoCommit(defaultCommit);
con.close();
}
}
}