|
Insert an Image into a Database Using JDBCAverage Rating: 3.3/5 | Rate this item | 36 users have rated this item.
|
Expertise: Advanced
Language: Java
August 20, 2003
Insert an Image into a Database Using JDBC
//create the file object,
//set the image to the statement object as
//binary stream
try{
...
File fileObject = new File(...);
FileInputStream fisObject = new FileInputStream(fileObject);
PreparedStatement pstmt =
conn.prepareStatement("insert into IMAGE_TABLE values (?,?)");
pstmt.setString(1,fileObject.getName());
pstmt.setBinaryStream(2,fis,(int)file.length());
pstmt.executeUpdate();
......
}
catch(...)
{
...
}
Elayaraja David
If you have a hot tip and we publish it, we'll pay you. However, due to accounting overhead we no longer pay $10 for a single tip submission. You must accumulate 10 acceptable tips to receive payment. Be sure to include a clear explanation of what the technique does and why it's useful. If it includes code, limit it to 20 lines if possible. Submit your tip here.
|