利用blob类型存储图片

来源：互联网发布：ftp服务器默认端口编辑：程序博客网时间：2024/05/14 21:27

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是相同的图片。