Save Object JDBC : JDBC Data Type « Database SQL JDBC « Java

Save Object JDBC


MySQL and Java Developer's Guide

Mark Matthews, Jim Cole, Joseph D. Gradecki
Publisher Wiley,
Published February 2003, 
ISBN 0471269239


import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;

public class Thumbnail {
  Connection connection;

  PreparedStatement statement;

  public Thumbnail() {
    try {
      connection = DriverManager
    } catch (Exception e) {
      System.err.println("Unable to find and load driver");

  public void doWork(String[] args) {
    try {
      byte[] bytes = new byte[50000];

      FileInputStream fs = new FileInputStream(args[2]);
      BufferedInputStream bis = new BufferedInputStream(fs);;

      ID id = new ID();
      id.nail_id = Integer.parseInt(args[0]);
      id.acc_id = Integer.parseInt(args[1]);

      statement = connection
          .prepareStatement("INSERT INTO thumbnail VALUES(?,?,?,?, 0, now())");

      statement.setInt(1, id.nail_id);
      statement.setInt(2, id.acc_id);
      statement.setBytes(3, bytes);
      statement.setObject(4, id);

      int i = statement.executeUpdate();
      System.out.println("Rows updated = " + i);

    } catch (Exception e) {

  public static void main(String[] args) {
    Thumbnail nail = new Thumbnail();

class ID implements Serializable {

  public int nail_id;

  public int acc_id;

  public byte[] bytes;

  public ID() {


Related examples in the same category

1.Enumeration Type: JDBC
2.Get the java.sql.Types type to which this database-specific type is mapped
3.converting a java.sql.Types integer value into a printable name
4.Getting the Name of a JDBC Type
5.Get the database-specific type name
6.Retrieve type info from the result set
7.Listing Available SQL data Types Used by a Database
8.uses reflection to get all the field names from java.sql.Types.
9.Determining the Type of a Character: determine the properties of a character for the entire Unicode character set.