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();
}
}
}
数据库图片导出
最新推荐文章于 2022-11-30 15:27:16 发布