利用blob類型儲存圖片

SavePicture.java :

public class SavePicture {public static void main(String[] args) {Connection conn=null;PreparedStatement pstmt=null;String sql="insert into student(id,name,photo) values(?,?,?)";try {Class.forName("oracle.jdbc.driver.OracleDriver");conn=DriverManager.getConnection("jdbc:oracle:thin:@localhost:1521:orcl","scott","tiger");pstmt=conn.prepareStatement(sql);pstmt.setInt(1,1);pstmt.setString(2,"tom");//以下為重點部分File f=new File("src\\coder.jpg");FileInputStream fis=new FileInputStream(f);pstmt.setBinaryStream(3,fis,(int)f.length());int n=pstmt.executeUpdate();System.out.println(n+"條記錄被插入");} catch (ClassNotFoundException e) {e.printStackTrace();} catch (SQLException e) {e.printStackTrace();} catch (FileNotFoundException e) {e.printStackTrace();}finally{//關閉資源}}}

GetPicture.java :

public class GetPicture {public static void main(String[] args) {Connection conn=null;PreparedStatement pstmt=null;ResultSet rs=null;String sql="select id,name,photo from student where id=?";try {Class.forName("oracle.jdbc.driver.OracleDriver");conn=DriverManager.getConnection("jdbc:oracle:thin:@localhost:1521:orcl","scott","tiger");pstmt=conn.prepareStatement(sql);pstmt.setInt(1,1);rs=pstmt.executeQuery();if(rs.next()){//重點開始InputStream is=rs.getBinaryStream("photo");FileOutputStream fos=new FileOutputStream(new File("abc.jpg"));byte[] buffer=new byte[1024];int len=0;while((len=is.read(buffer))!=-1){fos.write(buffer,0,len);}fos.close();is.close();}} catch (ClassNotFoundException e) {e.printStackTrace();} catch (SQLException e) {e.printStackTrace();} catch (FileNotFoundException e) {e.printStackTrace();} catch (IOException e) {e.printStackTrace();}finally{//關閉資源}}}

運行程式，重新整理工程，得到：

可以看到abc.jpg和coder.jpg是相同的圖片。