Thumbnail.java Source code

Introduction

Here is the source code for Thumbnail.java

Source

/*
    
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() {
    }
}