数据库图片导出

import java.io.File;import java.io.FileInputStream;import java.io.FileNotFoundException;import java.io.FileOutputStream;import java.io.IOException;import java.io.InputStream;import java.sql.Connection;import java.sql.DriverManager;import java.sql.ResultSet;import java.sql.SQLException;import java.sql.Statement;import com.mysql.jdbc.PreparedStatement;public class Output {/** * @param args * @throws IOException  */public static void main(String[] args) throws IOException {// TODO Auto-generated method stubtry {Class.forName("com.mysql.jdbc.Driver");} catch (ClassNotFoundException e1) {// TODO Auto-generated catch blocke1.printStackTrace();}try {Connection conn=DriverManager.getConnection("jdbc:mysql://127.0.0.1:3306/test", "root", "root");System.out.println("数据库链接成功");InputStream fis=null;File file=new File("D:/photo/2.jpg");//1FileOutputStream fos=new FileOutputStream(file);//2PreparedStatement ps=(PreparedStatement) conn.prepareStatement("select photo from user where UserID=?");ps.setInt(1, 1);ResultSet rs=ps.executeQuery();if(rs.next()){fis=rs.getBinaryStream(1);System.out.println("找到图片");if(fis!=null){byte b[]=new byte[8*1024];int len=0;while((len=fis.read(b))!=-1){fos.write(b,0,len);}fis.close();}rs.close();conn.close();}System.out.println("图片读取成功");} catch (SQLException e) {// TODO Auto-generated catch blocke.printStackTrace();}}}