//以二进制形式保存文件到数据库
public void setImages(File file){
Connection conn = null;
String sql = "insert into imageTab(IMAGE) values(?)";
PreparedStatement ps = null;
FileInputStream is = null;
try {
is = new FileInputStream(file);
ps = conn.prepareStatement(sql);
conn = DbUtil.getConnection();
ps.setBinaryStream(1, is, (int) file.length());
ps.executeUpdate();
} catch (FileNotFoundException ex) {
Logger.getLogger(TPositionBIZ.class.getName()).log(Level.SEVERE, null, ex);
} catch (SQLException ex) {
Logger.getLogger(TPositionBIZ.class.getName()).log(Level.SEVERE, null, ex);
}
}
//获取数据
public Image getImageSteam()throws NullPointerException{
String sql = "select image from imageTab";
ResultSet rs = DbUtil.executeQuery(sql);
Image image=null;
try {
while (rs.next()) {
byte[] c = rs.getBytes("image");
image=Toolkit.getDefaultToolkit().createImage(c);
}
} catch (SQLException e) {
e.printStackTrace();
}finally {
DbUtil.closeConnection();
}
return image;
}
//显示图片
TBookImageBIZ imagbiz=new TBookImageBIZ();
try{
Image image=imagbiz.getImageSteam(o.getBookId());
LabImage.setIcon(new ImageIcon(image));
}catch(NullPointerException ex){
LabImage.setIcon(new ImageIcon("1.jpg"));
}
public void setImages(File file){
Connection conn = null;
String sql = "insert into imageTab(IMAGE) values(?)";
PreparedStatement ps = null;
FileInputStream is = null;
try {
is = new FileInputStream(file);
ps = conn.prepareStatement(sql);
conn = DbUtil.getConnection();
ps.setBinaryStream(1, is, (int) file.length());
ps.executeUpdate();
} catch (FileNotFoundException ex) {
Logger.getLogger(TPositionBIZ.class.getName()).log(Level.SEVERE, null, ex);
} catch (SQLException ex) {
Logger.getLogger(TPositionBIZ.class.getName()).log(Level.SEVERE, null, ex);
}
}
//获取数据
public Image getImageSteam()throws NullPointerException{
String sql = "select image from imageTab";
ResultSet rs = DbUtil.executeQuery(sql);
Image image=null;
try {
while (rs.next()) {
byte[] c = rs.getBytes("image");
image=Toolkit.getDefaultToolkit().createImage(c);
}
} catch (SQLException e) {
e.printStackTrace();
}finally {
DbUtil.closeConnection();
}
return image;
}
//显示图片
TBookImageBIZ imagbiz=new TBookImageBIZ();
try{
Image image=imagbiz.getImageSteam(o.getBookId());
LabImage.setIcon(new ImageIcon(image));
}catch(NullPointerException ex){
LabImage.setIcon(new ImageIcon("1.jpg"));
}