how to save toolkitimage in derby blob
I am trying to save an Image to Derby Db(JDBC),but it gives exception
void imageload () {
FileDialog fd = new FileDialog(MainFram.this,"Open", FileDialog.LOAD);
fd.show();
if(fd.getFile() == null){
//Label1.setText("You have not chosen any image files yet");
}
else{
String d = (fd.getDirectory() + fd.getFile());
Toolkit toolkit = Toolkit.getDefaultToolkit();
Image1 = toolkit.getImage(d);`
Object saveImage=Image1;
insertImage(saveImage) //开发者_开发问答Db function
` Here is my DB function
public void insertImage(String CUST_ID, Object saveImage) throws SQLException {
try {
Class.forName(driver);
con = DriverManager.getConnection(connectionURL);
} catch (SQLException ex) {
Logger.getLogger(Connect.class.getName()).log(Level.SEVERE, null, ex);
} catch (ClassNotFoundException ex) {
Logger.getLogger(Connect.class.getName()).log(Level.SEVERE, null, ex);
}
FileInputStream fis = new FileInputStream(saveImage);
stm = con.prepareStatement("insert into customer (PHOTO ) values(?)); //it gives errorr here
stm.setObject(5,saveImage);
stm.executeUpdate();
}
void imageload () {
FileDialog fd = new FileDialog(MainFram.this,"Open", FileDialog.LOAD);
fd.show();
if(fd.getFile() == null){
//Label1.setText("You have not chosen any image files yet");
}
else{
String d = (fd.getDirectory() + fd.getFile());
//Toolkit toolkit = Toolkit.getDefaultToolkit();
//Image1 = toolkit.getImage(d);`
//Object saveImage=Image1;
insertImage(d) //Db function
then
public void insertImage(String CUST_ID, String d) throws SQLException {
try {
Class.forName(driver);
con = DriverManager.getConnection(connectionURL);
} catch (SQLException ex) {
Logger.getLogger(Connect.class.getName()).log(Level.SEVERE, null, ex);
} catch (ClassNotFoundException ex) {
Logger.getLogger(Connect.class.getName()).log(Level.SEVERE, null, ex);
}
File image = new File(d);
FileInputStream fis = new FileInputStream(image);
stm = con.prepareStatement("insert into customer (PHOTO ) values(?)); //it gives errorr here
stmt.setBinaryStream(5, fis, (int) image.length());
//stm.setObject(5,saveImage);
//stm.executeUpdate();
stm.execute();
}
精彩评论