9899100101102103104105106107108
else s.setNull(i + 1, Types.VARCHAR); s.setDate(10, createdTimestamp); for (int i = 0; i < ifields.length; i++) s.setInt(11 + i, ifields[i]); c.addBatch(); } catch (SQLException e) { logger.log(Level.SEVERE, e.getMessage(), e); } }
7980818283848586878889
PreparedStatement s = c.prepareStatement(STATEMENT); //s.setString(1, userName); //s.setString(2, friend); s.setInt(1, id); s.setInt(2, friend); c.addBatch(); } } catch (SQLException e) { logger.log(Level.SEVERE, e.getMessage(), e); //LoadController.increaseErrorCount(); }
6061626364656667686970
ThreadConnection c = ThreadConnection.getInstance(); try { PreparedStatement s = c.prepareStatement(STATEMENT); s.setString(1, tag); s.setInt(2, 0); // Initialize it to 0 first, count and add later. c.addBatch(); } catch (SQLException e) { logger.log(Level.SEVERE, e.getMessage(), e); Loader.increaseErrorCount(); } }
8283848586878889909192
s.setString(1, userNames[i]); s.setInt(2, eventId); s.setString(3, comments[i]); s.setInt(4, ratings[i]); s.setDate(5, created_at); c.addBatch(); } } catch (SQLException e) { logger.log(Level.SEVERE, e.getMessage(), e); //LoadController.increaseErrorCount();
90919293949596979899100
} s.setString(2, requestorUsername); s.setString(3, friend); alternate++; c.addBatch(); } } catch (SQLException e) { logger.log(Level.SEVERE, e.getMessage(), e); System.out.println("the exception is "+ e.getMessage()); //LoadController.increaseErrorCount();
7273747576777879808182
try { for (int tagId : tagIds) { PreparedStatement s = c.prepareStatement(STATEMENT); s.setInt(1, tagId); s.setInt(2, eventId); c.addBatch(); } } catch (SQLException e) { logger.log(Level.SEVERE, e.getMessage(), e); } }
for (int i = 0; i < fields.length; i++) if (fields[i] != null) s.setString(i + 1, fields[i]); else s.setNull(i + 1, Types.VARCHAR); c.addBatch(); } catch (SQLException e) { logger.log(Level.SEVERE, e.getMessage(), e); //LoadController.increaseErrorCount(); }
7374757677787980818283
try { for (String userName : userNames) { PreparedStatement s = c.prepareStatement(STATEMENT); s.setString(1, userName); s.setInt(2, eventId); c.addBatch(); } } catch (SQLException e) { logger.log(Level.SEVERE, e.getMessage(), e); } }
7677787980818283848586
try { PreparedStatement s = c.prepareStatement(STATEMENT); for (int i = 0; i < fields.length; i++) s.setString(i + 1, fields[i]); s.setInt(11, addressId); c.addBatch(); } catch (SQLException e) { logger.log(Level.SEVERE, e.getMessage(), e); } } /**
100101102103104105106107108109110
else s.setNull(i + 1, Types.VARCHAR); s.setDate(12, createdTimestamp); for (int i = 0; i < ifields.length; i++) s.setInt(13 + i, ifields[i]); c.addBatch(); } catch (SQLException e) { logger.log(Level.SEVERE, e.getMessage(), e); } } }