Using Blobs and Clobs to Manage Images and Documents - Java Database Programming Bible - page 359

public class BlobSaver{
private static String dbUserName = "jod";
private static String dbPassword = "jod";
public static void main(String args[]){
BlobSaver blobber = new BlobSaver();
blobber.saveImage(1,"Witch","Witch.gif");
}
public void saveImage(int imageID,String description,String filename){
String cmd =
"INSERT INTO Photos (ImageID,Description,Image) VALUES(?,?,?)";
File imgFile = new File(filename);
try {
Class.forName("com.inet.pool.PoolDriver");
com.inet.tds.TdsDataSource tds = new com.inet.tds.TdsDataSource();
tds.setServerName( "MARS" );
tds.setDatabaseName( "CONTACTS" );
tds.setUser( dbUserName );
tds.setPassword( dbPassword );
DataSource ds = tds;
Connection con = ds.getConnection(dbUserName,dbPassword);
PreparedStatement pstmt = con.prepareStatement(cmd);
pstmt.setInt(1, imageID);
pstmt.setString(2, description);
pstmt.setBinaryStream(3, new FileInputStream(filename),
(int)imgFile.length());
pstmt.executeUpdate();
con.close();
}
catch(ClassNotFoundException e){
e.printStackTrace();
}
catch(SQLException e){
e.printStackTrace();
}
catch(FileNotFoundException e){
e.printStackTrace();
}