public static void insertUser(User user) throws SQLException {
try {
PreparedStatement insertUserStmt = SqlHelper.getInsertUserStmt();
insertUserStmt.setLong(1, user.getId());
insertUserStmt.setString(2, user.getScreenName());
insertUserStmt.setString(3, user.getName());
insertUserStmt.setString(4, user.getDescription());
insertUserStmt.setString(5, user.getLang());
insertUserStmt.setInt(6, user.getFollowersCount());
insertUserStmt.setInt(7, user.getStatusesCount());
insertUserStmt.setString(8, user.getURL());
insertUserStmt.setString(9, user.getProfileImageURL());
insertUserStmt.executeUpdate();
} catch (MySQLIntegrityConstraintViolationException e) {
// ignore, this is just a duplicate user entry, that's normal
}
}
