public CellLine getCells(Experiment expt) throws SQLException, UnknownRoleException {
java.sql.Connection cxn = loader.getConnection();
PreparedStatement ps = cxn.prepareStatement("select cells from experiment" + " where id=?");
ps.setInt(1, expt.getDBID());
ResultSet rs = ps.executeQuery();
int cellsID = -1;
if (rs.next()) {
cellsID = rs.getInt(1);
}
rs.close();
ps.close();
return chipLoader.loadCellLine(cellsID);
}
public void setPreparedStatement(PreparedStatement ps) throws SQLException {
ps.setString(1, name);
ps.setInt(2, type);
}
public void loadLastID(PreparedStatement ps) throws SQLException {
ResultSet rs = ps.executeQuery();
id = rs.getInt(1);
rs.close();
}
public void setPreparedStatement(PreparedStatement ps) throws SQLException {
ps.setInt(1, platform.id);
ps.setString(2, name);
}