JDBC - how to retrive the files from blob storage

SimpleBlobExample.java

import java.io.FileOutputStream;
import java.sql.Blob;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.Statement;

public class SimpleBlobExample {

	public static void main(String[] args) {

		try {
			Connection con;
			Statement stat;
			Class.forName("com.mysql.jdbc.Driver");

			con = DriverManager.getConnection(
					"jdbc:mysql://localhost:3306/schemaName", "username",
					"password");

			stat = con.createStatement();

			String query = "select pic_id,pic_name,pic_file from blobtest;";

			ResultSet rset = stat.executeQuery(query);

			Blob blob = null;
			while (rset.next()) {
				System.out.println(rset.getString("pic_id") + " "
						+ rset.getString("pic_name"));
				blob = rset.getBlob("pic_file");

				writeBlobFile(rset.getString("pic_name"), blob.getBytes(1,
						(int) blob.length()));
			}

			stat.close();
			con.close();

		} catch (Exception e) {
			e.printStackTrace();
		}
	}

	// Write byte array to a file using FileOutputStream
	public static void writeBlobFile(String filename, byte[] data) {
		try {
			FileOutputStream fos = new FileOutputStream("C:/" + filename);
			fos.write(data);
			fos.close();
		} catch (Exception e) {
			e.printStackTrace();
		}
	}
}