示例#1
0
  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);
 }