public static void main(String args[]) {
Connection c = null;
PreparedStatement stmt = null;
try {
Class.forName("org.postgresql.Driver");
c = DriverManager.getConnection("jdbc:postgresql://localhost:5432/test", "pdv", "pdv");
System.out.println("Opened database successfully");
List<String> results = new ArrayList<String>();
File dir = new File("D:/jboss/eclipse/workspace/LTF");
Iterator<File> files =
FileUtils.iterateFilesAndDirs(dir, TrueFileFilter.INSTANCE, TrueFileFilter.INSTANCE);
StopWatch timerAll = new StopWatch();
timerAll.start();
while (files.hasNext()) {
File file = (File) files.next();
if (file.isFile()) {
StopWatch timeForAFile = new StopWatch();
timeForAFile.start();
String toDB = encodeFileToBase64Binary(file);
String sql =
"INSERT INTO test (file_id,file_name,file_data,file_date) VALUES (nextval('test_file_id_seq'),?,?,?)";
stmt = c.prepareStatement(sql);
stmt.setString(1, file.getAbsolutePath());
stmt.setString(2, toDB);
stmt.setDate(3, new java.sql.Date(Calendar.getInstance().getTimeInMillis()));
stmt.executeUpdate();
timeForAFile.stop();
System.out.println(timeForAFile.toString());
}
}
timerAll.stop();
System.out.println("=================================================");
System.out.println(timerAll.toString());
stmt.close();
/*
* Statement statement = null; statement = c.createStatement();
* ResultSet rs = statement.executeQuery(
* "select file_data from test limit 1"); while (rs.next()) { String
* encoded = rs.getString("file_data"); byte[] decoded =
* Base64.getDecoder().decode(encoded); FileOutputStream fos = new
* FileOutputStream("c:/temp/2.jpg"); fos.write(decoded);
* fos.close(); }
*/
c.close();
} catch (Exception e) {
System.err.println(e.getClass().getName() + ": " + e.getMessage());
System.exit(0);
}
System.out.println("Table created successfully");
}
