BLOB + displayTag

public class BlobSample {
    public static void main(String[] args) throws Exception, IOException, SQLException {
        Class.forName("com.mysql.jdbc.Driver");
        Connection conn = DriverManager.getConnection("jdbc:mysql://localhost:3307/bdb", "root", "root");

        FileInputStream fis = null;
        PreparedStatement ps = null;
        try {
            //save image as blob
            
            File file = new File("c:\\arquivoteste.txt");
            fis = new FileInputStream(file);
            

            //read back
            String SELECT_PICTURE = "Select blobTeste from t_2008 where rawID=1";
            ps = conn.prepareStatement(SELECT_PICTURE);
            ResultSet rs =  ps.executeQuery();

            while (rs.next()) {
                //save blob as an image
                FileOutputStream fos = new FileOutputStream("c:\\arquivoteste2.txt");
                InputStream is  = rs.getBinaryStream(3);
                byte[] buf = new byte[3000];
                int read = 0;
                while ((read = is.read(buf)) > 0) {
                    fos.write(buf, 0, read);
                }
                fos.close();
                is.close();
            }

        } finally {
            ps.close();
            fis.close();
        }
    }
}