图片批量导入oracle数据库

/** * Project Name:uploadtest * File Name:UpLoadPhoto.java * Package Name:com.iflytek.test * Date:2016-4-23下午10:20:22 * Copyright (c) 2016, syzhao@iflytek.com All Rights Reserved. * */ package com.iflytek.test; import java.io.BufferedInputStream; import java.io.File; import java.io.FileInputStream; import java.sql.Connection; import java.sql.PreparedStatement; import java.sql.SQLException; public class UpLoadPhoto { /** * UpLoad:(上传到数据库). <br/> * @author syzhao * @param path 文件路径 * @since JDK 1.6 */ public static void UpLoad(String path) { Connection connection = GetConnection.getConnection(); insertPhoto(path, connection); } /** * insertPhoto:(向数据库插入图片). <br/> * @author syzhao * @param path 图片文件夹 * @param connection 连接对象 * @since JDK 1.6 */ private static void insertPhoto(String path, Connection connection) { File file = new File(path); //获取该path下的所有的文件 String[] photoName = file.list(); PreparedStatement pstmt = null; int num = 0; try { String sql = "insert into cjry_photo (id,soureid,souretype,filename,filesize,content,UPDATETIME) values(?,?,?,?,?,?,sysdate)"; for (int i = 0; i < photoName.length; i++) { //取出具体的图片文件 File file2 = new File(path + "\\" + photoName[i]); //读取图片 BufferedInputStream bis = new BufferedInputStream(new FileInputStream(file2)); pstmt = connection.prepareStatement(sql); //设置主键 pstmt.setLong(1, i + 1); //获取文件名 pstmt.setString(2, photoName[i].split(".jpg")[0]); //设置来源 pstmt.setString(3, "CJRY"); //文件名+格式 pstmt.setString(4, photoName[i]); //大小 pstmt.setLong(5, file2.length()); //设置图片内容 特别说明 连接驱动版本低只是实现了int类型的参数，但是file2.length()是返回long型的，如何你的文件比较大，请更新最新的数据库驱动 pstmt.setBinaryStream(6, bis, (int)file2.length()); num += pstmt.executeUpdate(); System.out.println("上传成功！"); } } catch (Exception e) { e.printStackTrace(); } finally { try { if (pstmt != null) { pstmt.close(); } if (connection != null) { connection.close(); } } catch (SQLException e) { e.printStackTrace(); } } System.out.println("成功上传：" + num + "图片"); } }