Mega Code Archive
Save Object JDBC
<![CDATA[
/*
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() {
}
}
]]>