HI,
Try this solution.
public void saveImage(File file){
try {
String img_id=JOptionPane.showInputDialog("Enter Image ID");
FileInputStream fis=null;
String query="insert into image(image_id,image) values (?,?)";
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
Connection con=DriverManager.getConnection("jdbc:odbc:image");
PreparedStatement pstm=con.prepareStatement(query);
fis=new FileInputStream(file);
pstm.setString(1, img_id);
pstm.setBinaryStream(2, (InputStream)fis, (int)file.length());
pstm.executeUpdate();
JOptionPane.showMessageDialog(null, "Image Successfully Uploaded to Database");
pstm.close();
con.close();
} catch (Exception ex) {
System.out.println("Exception Occured: "+ex);
}
}
And Retrieve it by again making Image from binary and Save it on some physical Location:
public void getSavedImages(){
try {
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
Connection con = DriverManager.getConnection("jdbc:odbc:image");
PreparedStatement pstm1 = con.prepareStatement("select * from image");
ResultSet rs1 = pstm1.executeQuery();
while(rs1.next()) {
InputStream fis1;
FileOutputStream fos;
String image_id;
try {
fis1 = rs1.getBinaryStream("image");
image_id=rs1.getString("image_id");
fos = new FileOutputStream(new File(Path to "C:\\" + (image_id) + "Your Extension(.jpg/.gif)"));
int c;
while ((c = fis1.read()) != -1) {
fos.write(c);
}
fis1.close();
fos.close();
} catch (Exception ex) {
System.out.println(ex);
}
}
pstm1.close();
con.close();
} catch (Exception ex) {
System.out.println("Exception Occured:"+ex);
}
}
Thanks