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

1. Java
2. Database SQL JDBC
3. JDBC Data Type

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.io.BufferedInputStream;
import java.io.FileInputStream;
import java.io.Serializable;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;

public class Thumbnail {
  Connection connection;

  PreparedStatement statement;

  public Thumbnail() {
    try {
      Class.forName("com.mysql.jdbc.Driver").newInstance();
      connection = DriverManager
          .getConnection("jdbc:mysql://192.168.1.25/identification?user=spider&password=spider");
    } catch (Exception e) {
      System.err.println("Unable to find and load driver");
      System.exit(1);
    }
  }

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

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

      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);

      bis.close();
      fs.close();
      statement.close();
      connection.close();
    } catch (Exception e) {
      e.printStackTrace();
    }
  }

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

class ID implements Serializable {

  public int nail_id;

  public int acc_id;

  public byte[] bytes;

  public ID() {
  }
}

           
         
  

Related examples in the same category