jdbc 连接Oracle数据库保存图片

最基本的Oracle数据库连接代码（只针对Oracle11g）：

1、右键项目->构建路径->配置构建路径，选择第三项“库”，然后点击“添加外部Jar”，oracle jar包 ojdbc6_g.jar

public class ConnectOracle {

 public static void main(String[] args) throws IOException {
  // TODO Auto-generated method stub
  String driver="oracle.jdbc.OracleDriver";
  String url="jdbc:oracle:thin:@localhost:1521:orcl";
  String user="system";
  String password="123456";
  try {
   Class.forName(driver);
  } catch (ClassNotFoundException e1) {
   // TODO Auto-generated catch block
   e1.printStackTrace();
  }
  Connection con = null;
  try {
   con = DriverManager.getConnection(url, user, password);
  } catch (SQLException e) {
   // TODO Auto-generated catch block
   e.printStackTrace();
   System.out.println("oracle连接失败");
  }
 // String sql = "select GMSFHM from 'CZRK_SFZ_ZP'  where rownum <= 10";
  String sql = "select GMSFHM,ZP from czrk_sfz_zp  where rownum>0 and rownum <= 100000";
  PreparedStatement pstm = null;
  try {
   pstm = con.prepareStatement(sql);
  } catch (SQLException e) {
   // TODO Auto-generated catch block
   e.printStackTrace();
   System.out.println("oracle执行失败");
  }
  
  ResultSet rs = null;
  try {
   rs = pstm.executeQuery(); 
   int i=0;
   while (rs.next())
   {
    String str = rs.getString("GMSFHM");
    Blob img = rs.getBlob("ZP");
    InputStream ins = img.getBinaryStream();
    i++;
    FileOutputStream fos = new FileOutputStream("E:/imagesFromOracle/" + str+  ".bmp");
    byte[] data = new byte[1000000];
    int length = 0;
    try {
     while((length = ins.read(data, length,1000000)) != -1) {
       try {
      fos.write(data, 0 ,length);
     } catch (IOException e) {
      // TODO Auto-generated catch block
      e.printStackTrace();
     }
       fos.flush();
     }
    } catch (IOException e) {
     // TODO Auto-generated catch block
     e.printStackTrace();
    }
    fos.close();
    ins.close();
   }
  }
  catch (SQLException e) {
   // TODO Auto-generated catch block
   e.printStackTrace();
  }
 }

}