java保存图片到oracle_java 保存读取图片到oracle

存入数据库

Connection conn = null;

ResultSet rs = null;

Statement stmt = null;

DBConnectionManager connMgr = null;

try

{

String insertsql = "insert into image (id,pic) values(18,empty_blob())";//首先插入一个空的Blob类型

String updateSql="select fujiannr from T_ZT_MYZJ_MYCJ where id=18 for update";

connMgr = DBConnectionManager.getInstance();

conn = connMgr.getConnection();

conn.setAutoCommit(false);

OutputStream os = null;

stmt=conn.createStatement();

stmt.executeUpdate(insertsql);

rs=stmt.executeQuery(updateSql);

if (rs.next())

{

oracle.sql.BLOB blob = (oracle.sql.BLOB) rs.getBlob("fujiannr");

os = blob.getBinaryOutputStream();

InputStream is1= new FileInputStream("c:\\1.png");

int i = 0;

while ((i = is1.read()) != -1) {

os.write(i);

}

}

os.flush();

os.close();

}

catch (Exception e)

{

e.printStackTrace();

}

finally {

closeAll(rs, stmt,conn);

}

//失放资源

ClassLoader cl = this.getClass().getClassLoader();

InputStream pro = cl.getResourceAsStream("\\config.properties");

Properties dbProps = new Properties();

try {

dbProps.load(pro);

} catch (Exception e) {

}

String driverClasses = dbProps.getProperty("dbDriver");

connMgr.freeConnection(driverClasses, conn);

从数据库中读取图片

Connection conn = null;

ResultSet rs = null;

Statement stmt = null;

InputStream issgg = null;

DBConnectionManager connMgr = null;

byte bs[] = null;

try

{

connMgr = DBConnectionManager.getInstance();

conn = connMgr.getConnection();

conn.setAutoCommit(false);

stmt=conn.createStatement();

String str = "select pic from image where id=18";

rs=stmt.executeQuery(str);

rs.next();

Blob ob = null;

ob=rs.getBlob(1);

long size = ob.length();

bs = ob.getBytes(1, (int)size);

File file = new File("c:\\" + "image.png");          if (!file.exists())          {              file.createNewFile(); // 如果文件不存在，则创建          }          FileOutputStream fos = new FileOutputStream(file);             if (data.length > 0)          {              fos.write(bs, 0, bs.length);          }          else          {              //while ((size = in.read(bs)) != -1)             // {                ///  fos.write(bs, 0, size);             // }             // in.close();          }          fos.close();   }   catch (Exception e)   {    e.printStackTrace();   }   finally {    closeAll(rs, stmt,conn);   }