图片存入数据库中:先将图片转换成二进制流,在将其存入数据库中,字段类型为image
/*引的包*/
import com.sun.image.codec.jpeg.JPEGCodec;
import com.sun.image.codec.jpeg.JPEGImageDecoder;
import java.awt.Image;
import java.io.FileInputStream;
import java.io.IOException;
import java.io.InputStream;
/*存图片到数据库*/
public insertImage(String path, String number){
FileInputStream fi = null;
String path2 = path.replaceAll(" ", " "); //转换图片路径格式 为 E://1.jpg
try {
连接数据库
.....
PreparedStatement pstm = conn.prepareStatement("insert into DBImg (image) values (?)");
fi = new FileInputStream(path2);
pstm.setBinaryStream(1, fi, fi.available());
pstm.execute();
} catch (Exception e) {
e.printStackTrace();
} finally {
if (fi != null) {
tr