/**
* @param conn
* @param fingerprint
* @param sampleID
* @return
* @throws SQLException
*/
private static void insertSampleSet(Connection conn, Fingerprint fingerprint, Integer sampleID)
throws SQLException {
if (fingerprint.getSampleSetID() == null) {
/*
* Insert whole new SampleSetID.
*/
String query = "INSERT INTO `SampleSets`(`SampleID`) VALUES(?);";
PreparedStatement insertSampleSet =
conn.prepareStatement(query, Statement.RETURN_GENERATED_KEYS);
insertSampleSet.setInt(1, sampleID);
insertSampleSet.execute();
ResultSet rs = insertSampleSet.getGeneratedKeys();
if (rs.next()) {
fingerprint.setSampleSetID(rs.getInt(1));
}
rs.close();
insertSampleSet.close();
} else {
/*
* Insert new SampleID for existing SampleSetID.
*/
String query = "INSERT INTO `SampleSets`(`SampleSetID`,`SampleID`) VALUES(?, ?);";
PreparedStatement insertSampleSet = conn.prepareStatement(query);
insertSampleSet.setInt(1, fingerprint.getSampleSetID());
insertSampleSet.setInt(2, sampleID);
insertSampleSet.execute();
insertSampleSet.close();
}
}
