private static void persist(List<Movie> movies) {
Connection conn = DBUtil.getJDBCConnection();
PreparedStatement ps = null;
String sql =
"insert into "
+ TABLE_NAME
+ " ( "
+ ID_COLUMN
+ ", "
+ NAME_COLUMN
+ ", "
+ PUBLISHED_YEAR_COLUMN
+ ", "
+ TYPE_COLUMN
+ ") values (?, ?, ?, ?)";
try {
conn.setAutoCommit(false);
ps = conn.prepareStatement(sql);
for (Movie movie : movies) {
ps.setInt(1, movie.getId());
ps.setString(2, movie.getName());
ps.setString(3, movie.getYear());
ps.setString(4, StringUtil.connectString(movie.getType(), ", "));
ps.addBatch();
}
ps.executeBatch();
conn.commit();
} catch (SQLException e) {
e.printStackTrace();
} finally {
try {
ps.close();
conn.close();
} catch (SQLException e) {
e.printStackTrace();
}
}
}
