public static String readFile(File f) throws IOException {
return new String(Files.readAllBytes(f.toPath()));
}
- public static void main(String[] args) throws SQLException,
- ClassNotFoundException, IOException {
+
+ public static void main(String[] args) throws SQLException, ClassNotFoundException, IOException {
if (args.length == 0) {
Properties p = new Properties();
p.load(new FileReader("config/gigi.properties"));
- args = new String[]{p.getProperty("sql.driver"),
- p.getProperty("sql.url"), p.getProperty("sql.user"),
- p.getProperty("sql.password")};
+ args = new String[] { p.getProperty("sql.driver"), p.getProperty("sql.url"), p.getProperty("sql.user"),
+ p.getProperty("sql.password") };
}
if (args.length < 4) {
- System.err
- .println("Usage: com.mysql.jdbc.Driver jdbc:mysql://localhost/cacert user password");
+ System.err.println("Usage: com.mysql.jdbc.Driver jdbc:mysql://localhost/cacert user password");
return;
}
run(args);
}
- public static void run(String[] args) throws ClassNotFoundException,
- SQLException, IOException {
+
+ public static void run(String[] args) throws ClassNotFoundException, SQLException, IOException {
Class.forName(args[0]);
- Connection conn = DriverManager
- .getConnection(args[1], args[2], args[3]);
+ Connection conn = DriverManager.getConnection(args[1], args[2], args[3]);
Statement stmt = conn.createStatement();
addFile(stmt, new File("doc/tableStructure.sql"));
File localData = new File("doc/sampleData.sql");
stmt.executeBatch();
stmt.close();
}
- private static void addFile(Statement stmt, File f) throws IOException,
- SQLException {
+
+ private static void addFile(Statement stmt, File f) throws IOException, SQLException {
String sql = readFile(f);
String[] stmts = sql.split(";");
for (String string : stmts) {