java操作保存图片到oracle数据库及获取图片到页面显示
Java取得本地IP,MAC【转】
oracle单引号处理
java操作保存图片到oracle数据库及获取图片到页面显示2010-03-23 10:33:54| 分类:java| 标签:|字号大中小订阅
【转自http://www.doczj.com/doc/5903a41a5f0e7cd184253625.html/taochenpfj/archive/2008/10/29/3177723.aspx,部分修改】
//一般是先通过select ... for update锁定blob列,然后写入blob值,然后提交。要用到特定的Oracle BLOB类。
《--------保存图片到数据库--------------》
public void savePic(InputStream is){
String insertsql = "insert into pic(id,pic) values(1,empty_blob())";//首先插入一个空的Blob类型
Connection conn = null;
Statement stmt = null;
PreparedStatementps = null;
ResultSetrs = null;
try {
conn = ds.getConnection();
conn.setAutoCommit(false);
stmt = conn.createStatement();
intrt = stmt.executeUpdate(insertsql);
if(rt> 0){
System.out.println("initialization succeed!!");
String preCursor = "select id,pic from pic where id='1' for update";
rs = stmt.executeQuery(preCursor);//锁定列
rs.next();
Blob b = (Blob)rs.getBlob("pic");
BufferedOutputStreambos = new BufferedOutputStream(b.setBinaryStream(0L));
BufferedInputStreambis = new BufferedInputStream(is);
int bytes;
try {
while((bytes = bis.read()) != -1){
bos.write(bytes);