java连接Access2010读取图片二进制
需积分: 10 135 浏览量
2014-02-21
21:28:11
上传
评论
收藏 15KB DOCX 举报
package com.access;
import java.awt.image.BufferedImage;
import java.io.File;
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 javax.imageio.ImageIO;
public class MainLogic {
public static void main(String[] args) throws Exception {
readJDBC();
}
//连接数据库
public static Statement getConn() throws
ClassNotFoundException, SQLException{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
String url = "jdbc:odbc:sfz";// 此为 ODBC 连接方式
String url1 = "jdbc:odbc:Driver={Microsoft Access Driver
(*.mdb, *.accdb)};DBQ=D:\sfz.mdb ";//access2010
Connection conn = DriverManager.getConnection(url1, "",
"");
Statement stmt = conn.createStatement();
//ResultSet rs = stmt.executeQuery(sql);
return stmt;
}
//读取数据库-把二进制数据转换为图片
public static void readJDBC() throws Exception{
Statement stmt = getConn();
ResultSet rs = stmt.executeQuery("select * from image");
int imageName= 1;
while (rs.next()){
String id = rs.getString("id");
InputStream in= rs.getBinaryStream("data");
BufferedImage bi1 =ImageIO.read(in);
File temp = new File("d:\sfz\" +
String.valueOf(imageName) + ".jpg");
ImageIO.write(bi1, "png", temp);
imageName++;
}
}
}
资源评论
