数据库图片导出

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 stub
		try {
			Class.forName("com.mysql.jdbc.Driver");
		} catch (ClassNotFoundException e1) {
			// TODO Auto-generated catch block
			e1.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");//1
			FileOutputStream fos=new FileOutputStream(file);//2
			PreparedStatement 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 block
			e.printStackTrace();
		}

	}

}