示例#1
1
 public ArrayList<ListaAlquiler> get_alquiler_byclientefecha(String condicion) {
   Connection cnn = null;
   CallableStatement cstmt = null;
   ArrayList<ListaAlquiler> listAlquiler = new ArrayList<ListaAlquiler>();
   try {
     cnn = BD.getConnection();
     String sql = "select * from  get_alquiler_byclientefecha where " + condicion;
     cstmt = cnn.prepareCall(sql);
     ResultSet rs = cstmt.executeQuery();
     while (rs.next()) {
       ListaAlquiler a = new ListaAlquiler();
       a.setIdCliente(rs.getInt("int_id"));
       a.setVar_nombre_cliente(rs.getString("var_nombre_cliente"));
       a.setVar_apepaterno(rs.getString("var_apepaterno"));
       a.setVar_apematerno(rs.getString("var_apematerno"));
       a.setVar_nombre_material(rs.getString("var_nombre_material"));
       a.setDat_fechinicio(rs.getTimestamp("dat_fechinicio"));
       a.setDat_fechfin(rs.getTimestamp("dat_fechfin"));
       a.setInt_cantidad(rs.getInt("int_cantidad"));
       a.setDec_monto(rs.getDouble("dec_monto"));
       a.setDat_fechaRegistro(rs.getTimestamp("dat_fechaRegistro"));
       a.setVar_numero(rs.getString("var_numero"));
       listAlquiler.add(a);
     }
     cstmt.close();
     cnn.close();
   } catch (SQLException a) {
     System.out.println("" + a);
   }
   return listAlquiler;
 }
 /**
  * Find Role by PK
  *
  * @param pk : get parameter
  * @return bean
  * @throws DatabaseException
  */
 public RoleBean findByPK(long pk) throws ApplicationException {
   log.debug("Model findByPK Started");
   StringBuffer sql = new StringBuffer("SELECT * FROM demo_ors.st_role WHERE ID=?");
   RoleBean bean = null;
   Connection conn = null;
   try {
     conn = JDBCDataSource.getConnection();
     PreparedStatement pstmt = conn.prepareStatement(sql.toString());
     pstmt.setLong(1, pk);
     ResultSet rs = pstmt.executeQuery();
     while (rs.next()) {
       bean = new RoleBean();
       bean.setId(rs.getLong(1));
       bean.setName(rs.getString(2));
       bean.setDescription(rs.getString(3));
       bean.setCreatedBy(rs.getString(4));
       bean.setModifiedBy(rs.getString(5));
       bean.setCreatedDatetime(rs.getTimestamp(6));
       bean.setModifiedDatetime(rs.getTimestamp(7));
     }
     rs.close();
   } catch (Exception e) {
     log.error("Database Exception..", e);
     throw new ApplicationException("Exception : Exception in getting User by pk");
   } finally {
     JDBCDataSource.closeConnection(conn);
   }
   log.debug("Model findByPK End");
   return bean;
 }
 /**
  * Returns job information in the DDBB.
  *
  * @param jobId the job identification.
  * @return the {@link eu.aliada.ckancreation.model.Job} which contains the job information.
  * @since 2.0
  */
 public Job getJob(final int jobId) {
   // Get the job information from the DDBB
   final Job job = new Job();
   job.setId(jobId);
   try {
     final Statement sta = getConnection().createStatement();
     final String sql = "SELECT * FROM ckancreation_job_instances WHERE job_id=" + jobId;
     final ResultSet resultSet = sta.executeQuery(sql);
     while (resultSet.next()) {
       job.setStartDate(resultSet.getTimestamp("start_date"));
       job.setEndDate(resultSet.getTimestamp("end_date"));
       job.setCkanOrgURL(resultSet.getString("ckan_org_url"));
       job.setCkanDatasetURL(resultSet.getString("ckan_dataset_url"));
       // Determine job status
       String status = JOB_STATUS_IDLE;
       if (job.getStartDate() != null) {
         status = JOB_STATUS_RUNNING;
         if (job.getEndDate() != null) {
           status = JOB_STATUS_FINISHED;
         }
       }
       job.setStatus(status);
     }
     resultSet.close();
     sta.close();
   } catch (SQLException exception) {
     LOGGER.error(MessageCatalog._00024_DATA_ACCESS_FAILURE, exception);
     return null;
   }
   return job;
 }
    public DetailedAccountStatementItem mapRow(ResultSet rs, int rowNum) throws SQLException {
      DetailedAccountStatementItem item = new DetailedAccountStatementItem();

      item.setId(rs.getInt("id"));
      item.setMarketId(rs.getInt("market_id"));
      item.setMarketName(rs.getString("market_name"));
      item.setMarketType(rs.getString("market_type"));
      item.setFullMarketName(rs.getString("full_market_name"));

      item.setSelectionId(rs.getInt("selection_id"));
      item.setSelectionName(rs.getString("selection_name"));

      item.setBetId(rs.getLong("bet_id"));

      item.setEventTypeId(rs.getInt("event_type_id"));
      item.setBetCategoryType(rs.getString("bet_category_type"));
      item.setBetType(rs.getString("bet_type"));
      item.setBetSize(rs.getDouble("bet_size"));
      item.setAvgPrice(rs.getDouble("avg_price"));
      item.setPlacedDate(rs.getTimestamp("placed_date"));
      item.setStartDate(rs.getTimestamp("start_date"));
      item.setSettledDate(rs.getTimestamp("settled_date"));
      item.setAmount(rs.getDouble("amount"));
      item.setCommission(rs.getBoolean("commission"));

      item.setStateMachineId(rs.getString("state_machine_id"));
      item.setStateName(rs.getString("state_name"));

      return item;
    }
示例#5
1
  /**
   * Trouve tous les prets.
   *
   * @return La liste des prets; une liste vide sinon
   * @throws DAOException S'il y a une erreur avec la base de données
   */
  public List<PretDTO> getAll() throws DAOException {

    List<PretDTO> listeDTO = Collections.EMPTY_LIST;

    PretDTO pretDTO = null;
    try (PreparedStatement getAllPreparedStatement =
            getConnection().prepareStatement(PretDAO.GET_ALL_REQUEST);
        ResultSet resultSet = getAllPreparedStatement.executeQuery(); ) {

      if (resultSet.next()) {
        listeDTO = new ArrayList<>();
        do {
          pretDTO = new PretDTO();
          pretDTO.setIdPret(resultSet.getInt(1));
          pretDTO.getMembreDTO().setIdMembre(resultSet.getInt(2));
          pretDTO.getLivreDTO().setIdLivre(resultSet.getInt(3));
          pretDTO.setDatePret(resultSet.getTimestamp(4));
          pretDTO.setDateRetour(resultSet.getTimestamp(5));
          listeDTO.add(pretDTO);
        } while (resultSet.next());
      }

    } catch (final SQLException sqlException) {
      throw new DAOException(sqlException);
    }
    return listeDTO;
  }
  // <editor-fold defaultstate="collapsed" desc="ret_version_details">
  public static List<to_version> ret_version_details() {

    List<to_version> datas = new ArrayList();

    try {
      Connection conn = MyConnection1.connect();

      String s0 =
          "select a.account_name, a.exp_date, a.date_added from " + MyDB.getNames() + ".accounts a";

      Lg.$.severe(s0);

      PreparedStatement stmt = conn.prepareStatement(s0);
      ResultSet rs = stmt.executeQuery(s0);

      while (rs.next()) {
        String name = rs.getString("account_name");
        Date exp_date = rs.getTimestamp("exp_date");
        Date date_added = rs.getTimestamp("date_added");

        to_version to = new to_version(name, exp_date, date_added);
        datas.add(to);
      }

      return datas;
    } catch (Exception e) {

      throw new RuntimeException(e);
    } finally {
      MyConnection1.close();
    }
  }
 public Funcionario findById(int id) {
   Connection conexao = new Conexao().getConexao();
   Funcionario funcionario = null;
   try {
     PreparedStatement preparedStatement =
         conexao.prepareStatement(
             "SELECT * FROM funcionarios INNER JOIN enderecos on (endereco_id = enderecos.id) WHERE id = ?;");
     preparedStatement.setInt(1, id);
     ResultSet resultSet = preparedStatement.executeQuery();
     resultSet.next();
     funcionario =
         new Funcionario(
             resultSet.getInt("id"),
             resultSet.getString("nome"),
             resultSet.getString("sobrenome"),
             resultSet.getString("cpf"),
             resultSet.getString("telefone"),
             new EnderecoDAO().findById(resultSet.getInt("endereco_id")),
             resultSet.getString("email"),
             resultSet.getDate("nascimento"),
             resultSet.getDouble("salario"),
             resultSet.getBoolean("gerente"),
             resultSet.getString("senha"),
             resultSet.getBoolean("status"),
             new Date(resultSet.getTimestamp("created").getTime()),
             new Date(resultSet.getTimestamp("edited").getTime()));
   } catch (SQLException ex) {
     Logger.getLogger(FuncionarioDAO.class.getName()).log(Level.SEVERE, null, ex);
   }
   return funcionario;
 }
示例#8
0
  @Override
  public int read(Object pk, java.sql.Statement statement) {
    int[] key = (int[]) pk;
    String sql = "";
    java.sql.ResultSet resultSet = null;

    mnLastDbActionResult = SLibConstants.UNDEFINED;
    reset();

    try {
      sql =
          "SELECT d.*, un.usr, ue.usr, ud.usr "
              + "FROM trn_dsm_nts AS d "
              + "INNER JOIN erp.usru_usr AS un ON "
              + "d.fid_usr_new = un.id_usr "
              + "INNER JOIN erp.usru_usr AS ue ON "
              + "d.fid_usr_edit = ue.id_usr "
              + "INNER JOIN erp.usru_usr AS ud ON "
              + "d.fid_usr_del = ud.id_usr "
              + "WHERE id_year = "
              + key[0]
              + " AND id_doc = "
              + key[1]
              + " AND id_nts = "
              + key[2]
              + " ";
      resultSet = statement.executeQuery(sql);
      if (!resultSet.next()) {
        throw new Exception(SLibConstants.MSG_ERR_REG_FOUND_NOT);
      } else {
        mnPkYearId = resultSet.getInt("d.id_year");
        mnPkDocId = resultSet.getInt("d.id_doc");
        mnPkNotesId = resultSet.getInt("d.id_nts");
        msNotes = resultSet.getString("d.nts");
        mbIsPrintable = resultSet.getBoolean("d.b_prt");
        mbIsDeleted = resultSet.getBoolean("d.b_del");
        mnFkUserNewId = resultSet.getInt("d.fid_usr_new");
        mnFkUserEditId = resultSet.getInt("d.fid_usr_edit");
        mnFkUserDeleteId = resultSet.getInt("d.fid_usr_del");
        mtUserNewTs = resultSet.getTimestamp("d.ts_new");
        mtUserEditTs = resultSet.getTimestamp("d.ts_edit");
        mtUserDeleteTs = resultSet.getTimestamp("d.ts_del");

        msDbmsUserNew = resultSet.getString("un.usr");
        msDbmsUserEdit = resultSet.getString("ue.usr");
        msDbmsUserDelete = resultSet.getString("ud.usr");

        mbIsRegistryNew = false;
        mnLastDbActionResult = SLibConstants.DB_ACTION_READ_OK;
      }
    } catch (java.sql.SQLException e) {
      mnLastDbActionResult = SLibConstants.DB_ACTION_READ_ERROR;
      SLibUtilities.printOutException(this, e);
    } catch (java.lang.Exception e) {
      mnLastDbActionResult = SLibConstants.DB_ACTION_READ_ERROR;
      SLibUtilities.printOutException(this, e);
    }

    return mnLastDbActionResult;
  }
示例#9
0
  /**
   * タイムカード登録情報のなかから最大値を取得 <br>
   * 登録情報が無い場合はシステム日付から年を取得
   *
   * @return int 最大値
   * @throws SQLException SQL実行例外
   */
  public int getMaxYear() throws SQLException {

    PreparedStatement pstmt = null;
    ResultSet rs = null;
    Connection con = null;
    UDate sysDate = new UDate();
    int ret = sysDate.getYear();
    con = getCon();

    try {
      // SQL文
      SqlBuffer sql = new SqlBuffer();
      sql.addSql(" select ");
      sql.addSql("   max(TCD_DATE) as MAXDATE");
      sql.addSql(" from ");
      sql.addSql("   TCD_TCDATA");

      pstmt = con.prepareStatement(sql.toSqlString());
      log__.info(sql.toLogString());
      rs = pstmt.executeQuery();
      if (rs.next() && rs.getTimestamp("MAXDATE") != null) {
        UDate maxDate = UDate.getInstanceTimestamp(rs.getTimestamp("MAXDATE"));
        ret = maxDate.getYear();
      }
    } catch (SQLException e) {
      throw e;
    } finally {
      JDBCUtil.closeResultSet(rs);
      JDBCUtil.closeStatement(pstmt);
    }
    return ret;
  }
示例#10
0
  /**
   * CSV出力用モデルを生成
   *
   * @param rs ResultSet
   * @return created TcdCsvModel
   * @throws SQLException SQL実行例外
   */
  private TcdCsvModel __getTcdCsvFromRs(ResultSet rs) throws SQLException {
    TcdCsvModel bean = new TcdCsvModel();
    bean.setUsrSid(rs.getInt("USR_SID"));
    bean.setUserName(rs.getString("USI_SEI") + " " + rs.getString("USI_MEI"));

    bean.setTcdDate(UDate.getInstanceTimestamp(rs.getTimestamp("TCD_DATE")));
    bean.setTcdIntime(rs.getTime("TCD_INTIME"));
    bean.setTcdOuttime(rs.getTime("TCD_OUTTIME"));
    bean.setTcdStrikeIntime(rs.getTime("TCD_STRIKE_INTIME"));
    bean.setTcdStrikeOuttime(rs.getTime("TCD_STRIKE_OUTTIME"));
    bean.setTcdBiko(rs.getString("TCD_BIKO"));
    bean.setTcdStatus(rs.getInt("TCD_STATUS"));
    bean.setTcdHolkbn(rs.getInt("TCD_HOLKBN"));
    bean.setTcdHolother(rs.getString("TCD_HOLOTHER"));
    bean.setTcdHolcnt(rs.getBigDecimal("TCD_HOLCNT"));
    bean.setTcdChkkbn(rs.getInt("TCD_CHKKBN"));
    bean.setTcdSoukbn(rs.getInt("TCD_SOUKBN"));
    bean.setTcdLockFlg(rs.getInt("TCD_LOCK_FLG"));
    bean.setTcdAuid(rs.getInt("TCD_AUID"));
    bean.setTcdAdate(UDate.getInstanceTimestamp(rs.getTimestamp("TCD_ADATE")));
    bean.setTcdEuid(rs.getInt("TCD_EUID"));
    bean.setTcdEdate(UDate.getInstanceTimestamp(rs.getTimestamp("TCD_EDATE")));

    return bean;
  }
示例#11
0
文件: Bans.java 项目: Kait18/geSuit
  public Ban getBanInfo(String player) {
    ConnectionHandler connectionHandler = DatabaseManager.connectionPool.getConnection();

    Ban b = null;

    try {
      PreparedStatement banInfo = connectionHandler.getPreparedStatement("banInfo");
      banInfo.setString(1, player);

      ResultSet res = banInfo.executeQuery();
      while (res.next()) {
        b =
            new Ban(
                res.getInt("id"),
                res.getString("display"),
                res.getString("banned_by"),
                res.getString("reason"),
                res.getString("type"),
                res.getTimestamp("banned_on"),
                res.getTimestamp("banned_until"));
      }

      res.close();
    } catch (Exception e) {
      e.printStackTrace();
    } finally {
      connectionHandler.release();
    }

    return b;
  }
示例#12
0
 /**
  * Retrieve a JDBC column value from a ResultSet, using the most appropriate value type. The
  * returned value should be a detached value object, not having any ties to the active ResultSet:
  * in particular, it should not be a Blob or Clob object but rather a byte array respectively
  * String representation.
  *
  * <p>Uses the {@code getObject(index)} method, but includes additional "hacks" to get around
  * Oracle 10g returning a non-standard object for its TIMESTAMP datatype and a {@code
  * java.sql.Date} for DATE columns leaving out the time portion: These columns will explicitly be
  * extracted as standard {@code java.sql.Timestamp} object.
  *
  * @param rs is the ResultSet holding the data
  * @param index is the column index
  * @return the value object
  * @throws SQLException if thrown by the JDBC API
  * @see java.sql.Blob
  * @see java.sql.Clob
  * @see java.sql.Timestamp
  */
 public static Object getResultSetValue(ResultSet rs, int index) throws SQLException {
   Object obj = rs.getObject(index);
   String className = null;
   if (obj != null) {
     className = obj.getClass().getName();
   }
   if (obj instanceof Blob) {
     obj = rs.getBytes(index);
   } else if (obj instanceof Clob) {
     obj = rs.getString(index);
   } else if ("oracle.sql.TIMESTAMP".equals(className)
       || "oracle.sql.TIMESTAMPTZ".equals(className)) {
     obj = rs.getTimestamp(index);
   } else if (className != null && className.startsWith("oracle.sql.DATE")) {
     String metaDataClassName = rs.getMetaData().getColumnClassName(index);
     if ("java.sql.Timestamp".equals(metaDataClassName)
         || "oracle.sql.TIMESTAMP".equals(metaDataClassName)) {
       obj = rs.getTimestamp(index);
     } else {
       obj = rs.getDate(index);
     }
   } else if (obj != null && obj instanceof java.sql.Date) {
     if ("java.sql.Timestamp".equals(rs.getMetaData().getColumnClassName(index))) {
       obj = rs.getTimestamp(index);
     }
   }
   return obj;
 }
示例#13
0
 List<StoredWikipediaRuleMatch> list() throws SQLException {
   try (PreparedStatement prepSt = conn.prepareStatement("SELECT * FROM feed_matches")) {
     ResultSet resultSet = prepSt.executeQuery();
     List<StoredWikipediaRuleMatch> result = new ArrayList<>();
     while (resultSet.next()) {
       String ruleId = resultSet.getString("rule_id");
       String ruleSubId = resultSet.getString("rule_sub_id");
       String ruleDescription = resultSet.getString("rule_description");
       String ruleMessage = resultSet.getString("rule_message");
       String errorContext = resultSet.getString("error_context");
       String title = resultSet.getString("title");
       Date editDate = new Date(resultSet.getTimestamp("edit_date").getTime());
       Timestamp fixTimeStamp = resultSet.getTimestamp("fix_date");
       Date fixDate =
           fixTimeStamp != null ? new Date(resultSet.getTimestamp("fix_date").getTime()) : null;
       long diffId = resultSet.getLong("diff_id");
       long fixDiffId = resultSet.getLong("fix_diff_id");
       result.add(
           new StoredWikipediaRuleMatch(
               ruleId,
               ruleSubId,
               ruleDescription,
               ruleMessage,
               errorContext,
               title,
               editDate,
               fixDate,
               diffId,
               fixDiffId));
     }
     return result;
   }
 }
示例#14
0
  protected Post makePost(ResultSet rs) throws SQLException {
    Post post = new Post();
    post.setId(rs.getInt("post_id"));
    post.setTopicId(rs.getInt("topic_id"));
    post.setForumId(rs.getInt("forum_id"));
    post.setUserId(rs.getInt("user_id"));

    Timestamp postTime = rs.getTimestamp("post_time");
    post.setTime(new Date(postTime.getTime()));
    post.setUserIp(rs.getString("poster_ip"));
    post.setBbCodeEnabled(rs.getInt("enable_bbcode") > 0);
    post.setHtmlEnabled(rs.getInt("enable_html") > 0);
    post.setSmiliesEnabled(rs.getInt("enable_smilies") > 0);
    post.setSignatureEnabled(rs.getInt("enable_sig") > 0);
    post.setEditCount(rs.getInt("post_edit_count"));

    Timestamp editTime = rs.getTimestamp("post_edit_time");
    post.setEditTime(editTime != null ? new Date(editTime.getTime()) : null);

    post.setSubject(rs.getString("post_subject"));
    post.setText(this.getPostTextFromResultSet(rs));
    post.setPostUsername(rs.getString("username"));
    post.hasAttachments(rs.getInt("attach") > 0);
    post.setModerate(rs.getInt("need_moderate") == 1);

    SimpleDateFormat df = new SimpleDateFormat(SystemGlobals.getValue(ConfigKeys.DATE_TIME_FORMAT));
    post.setFormatedTime(df.format(postTime));

    post.setKarma(DataAccessDriver.getInstance().newKarmaDAO().getPostKarma(post.getId()));

    return post;
  }
示例#15
0
 public UrgeVerifyInfo mapRow(ResultSet rs, int rowNum) throws SQLException {
   UrgeVerifyInfo t = new UrgeVerifyInfo();
   t.setId(rs.getString("ID"));
   t.setTaskid(rs.getString("TASKID"));
   t.setUid(rs.getString("UID"));
   t.setUserrealname(rs.getString("USERREALNAME"));
   t.setUsertype(rs.getString("USERTYPE"));
   t.setRegistreason(rs.getString("REGISTREASON"));
   t.setRemark(rs.getString("REMARK"));
   t.setRecord(rs.getString("RECORD"));
   t.setOwner(rs.getString("REALNAME"));
   t.setUserid(rs.getString("USERID"));
   String utype = rs.getString("UTYPE");
   if (utype != null) {
     t.setUtype(UrgeType.enumOf(utype));
   }
   String urgestatus = rs.getString("URGESTATUS");
   if (urgestatus != null) {
     t.setUrgestatus(UrgeStatus.enumOf(urgestatus));
   }
   t.setUsername(rs.getString("USERNAME"));
   t.setRegdate(rs.getTimestamp("REGDATE"));
   t.setLastlogindate(rs.getTimestamp("LASTLOGINDATE"));
   t.setBuynum(rs.getInt("BUYNUM"));
   t.setSellnum(rs.getInt("SELLNUM"));
   t.setAuthnum(rs.getInt("AUTHNUM"));
   t.setVerifynum(rs.getInt("VERIFYNUM"));
   t.setLastverifydate(rs.getTimestamp("LASTVERIFYDATE"));
   t.setCompanyType(CompanyType.getText(rs.getString("COMPANYTYPE")));
   t.setAuthStatus(AuthRecordStatus.getText(rs.getString("AUTHSTATUS")));
   t.setPassAmount(rs.getString("AMOUNT"));
   return t;
 }
示例#16
0
  /** {@inheritDoc} */
  @Override
  public List<PretDTO> getAll(Connexion connexion, String sortByPropertyName)
      throws InvalidHibernateSessionException, InvalidSortByPropertyException, DAOException {

    if (connexion == null) {
      throw new InvalidHibernateSessionException("La connexion ne peut être null");
    }
    if (sortByPropertyName == null) {
      throw new InvalidSortByPropertyException(
          "La propriété utilisée pour classer les prets ne peut être null");
    }

    List<PretDTO> listeDTO = Collections.EMPTY_LIST;
    try (PreparedStatement getAllPreparedStatement =
            connexion.getConnection().prepareStatement(PretDAO.GET_ALL_REQUEST);
        ResultSet resultSet = getAllPreparedStatement.executeQuery(); ) {
      PretDTO pretDTO = null;
      if (resultSet.next()) {
        listeDTO = new ArrayList<>();
        do {
          pretDTO = new PretDTO();
          pretDTO.setIdPret(resultSet.getString(1));
          pretDTO.getMembreDTO().setIdMembre(resultSet.getString(2));
          pretDTO.getLivreDTO().setIdLivre(resultSet.getString(3));
          pretDTO.setDatePret(resultSet.getTimestamp(4));
          pretDTO.setDateRetour(resultSet.getTimestamp(5));
          listeDTO.add(pretDTO);
        } while (resultSet.next());
      }

    } catch (final SQLException sqlException) {
      throw new DAOException(sqlException);
    }
    return listeDTO;
  }
  @Test
  public void testModifierSeance() throws Exception {
    Seance seance =
        new Seance(
            1L,
            "monTitre",
            "maDescription",
            new GregorianCalendar(2014, Calendar.SEPTEMBER, 6).getTime(),
            true,
            new GregorianCalendar(2014, Calendar.SEPTEMBER, 6, 18, 5).getTime(),
            TypeSeance.TP);
    seanceDao.modifierSeance(seance);

    Connection connection = DataSourceProvider.getInstance().getDataSource().getConnection();
    Statement stmt = connection.createStatement();
    ResultSet results = stmt.executeQuery("SELECT * FROM seance WHERE id=1");
    if (results.next()) {
      Assert.assertEquals(1L, results.getLong("id"));
      Assert.assertEquals("monTitre", results.getString("titre"));
      Assert.assertEquals("maDescription", results.getString("description"));
      Assert.assertEquals(
          new GregorianCalendar(2014, Calendar.SEPTEMBER, 6, 0, 0).getTime(),
          results.getTimestamp("date"));
      Assert.assertTrue(results.getBoolean("isnote"));
      Assert.assertEquals(
          new GregorianCalendar(2014, Calendar.SEPTEMBER, 6, 18, 5).getTime(),
          results.getTimestamp("datelimiterendu"));
      Assert.assertEquals(TypeSeance.TP, TypeSeance.valueOf(results.getString("type")));
    } else {
      Assert.fail();
    }
    stmt.close();
    connection.close();
  }
    private void buildConfig(final ResultSet rs, final long docId) throws SQLException {
      final long docOid = rs.getLong("DOC_OID");
      final Timestamp versionFrom = rs.getTimestamp("VER_FROM_INSTANT");
      final Timestamp versionTo = rs.getTimestamp("VER_TO_INSTANT");
      final Timestamp correctionFrom = rs.getTimestamp("CORR_FROM_INSTANT");
      final Timestamp correctionTo = rs.getTimestamp("CORR_TO_INSTANT");
      UniqueId uniqueId = createUniqueId(docOid, docId);

      ManageableMarketDataSnapshot marketDataSnapshot;
      // PLAT-1378
      if (_includeData) {
        LobHandler lob = getDialect().getLobHandler();
        byte[] bytes = lob.getBlobAsBytes(rs, "DETAIL");
        marketDataSnapshot =
            FUDGE_CONTEXT.readObject(
                ManageableMarketDataSnapshot.class, new ByteArrayInputStream(bytes));
        if (!_includeData) {
          marketDataSnapshot.setGlobalValues(null);
          marketDataSnapshot.setYieldCurves(null);
        }
      } else {
        marketDataSnapshot = new ManageableMarketDataSnapshot();
        marketDataSnapshot.setName(rs.getString("NAME"));
        marketDataSnapshot.setUniqueId(uniqueId);
      }
      MarketDataSnapshotDocument doc = new MarketDataSnapshotDocument();
      doc.setUniqueId(uniqueId);
      doc.setVersionFromInstant(DbDateUtils.fromSqlTimestamp(versionFrom));
      doc.setVersionToInstant(DbDateUtils.fromSqlTimestampNullFarFuture(versionTo));
      doc.setCorrectionFromInstant(DbDateUtils.fromSqlTimestamp(correctionFrom));
      doc.setCorrectionToInstant(DbDateUtils.fromSqlTimestampNullFarFuture(correctionTo));
      doc.setSnapshot(marketDataSnapshot);
      _documents.add(doc);
    }
示例#19
0
文件: Event.java 项目: pa06/gatecrash
  public static Event fromID(int ID) throws Exception {
    DBWrapper db = new DBWrapper();

    PreparedStatement st =
        db.getPreparedStatement(
            "SELECT e.ID as ID, e.Name as Name, e.Description as Description, e.CreatedBy as CreatedBy e.OwnedBy as OwnedBy, e.CreatedOn as CreatedOn, e.LastModifiedOn as LastModifiedOn, e.IsPrivate as IsPrivate, e.IsActive as IsActive, e.IsDeleted as IsDeleted FROM Event e WHERE e.ID=? LIMIT 1");
    st.setInt(0, ID);

    ResultSet rs = db.executeThisQuery(st);

    if (rs.first()) {
      Event e = new Event();
      e.ID = rs.getInt("ID");
      e.name = rs.getString("Name");
      e.description = rs.getString("Description");
      e.createdByID = rs.getInt("CreatedBy");
      e.ownedByID = rs.getInt("OwnedBy");
      e.createdOn = new DateTime((Date) rs.getTimestamp("CreatedOn"));
      e.lastModifiedOn = new DateTime((Date) rs.getTimestamp("LastModifiedOn"));
      e.isPrivate = rs.getInt("IsPrivate");
      e.isActive = rs.getInt("IsActive");
      e.isDeleted = rs.getInt("IsDeleted");
      e.isNew = false;

      return e;
    }

    return null;
  }
示例#20
0
  /**
   * Method to fetch a single instance of a given element.
   *
   * @param personId of the user
   * @param entryId of the element @ if this element can not be located @ if there are any fetch
   *     problems.
   */
  public ElementDataObject findElementInstance(String personId, BigDecimal entryId) {
    Committee committee = new Committee();
    Connection conn = null;
    PreparedStatement ps = null;
    ResultSet rs = null;

    try {
      conn = getDataSource().getConnection();
      ps = conn.prepareStatement(SELECT_QUERY_SINGLE);
      ps.setString(1, personId);
      ps.setBigDecimal(2, entryId);
      rs = ps.executeQuery();

      if (rs.next()) {
        committee.setPersonId(rs.getString("PERSON_ID"));
        committee.setEntryId(rs.getBigDecimal("ENTRY_ID"));
        committee.setDateCreated(rs.getTimestamp("DATE_CREATED"));
        committee.setModifiedDate(rs.getTimestamp("MODIFIED_DATE"));
        committee.setEntryName(rs.getString("ENTRY_NAME"));
        committee.setFromDate(rs.getTimestamp("FROM_DATE"));
        committee.setToDate(rs.getTimestamp("TO_DATE"));
        committee.setDescription(rs.getString("DESCRIPTION"));
      } else {
        return null;
      }
    } catch (SQLException sqle) {
      logService.error("Exception caught when attempting to query name table.", sqle);
      throw new DataAccessException(sqle);
    } finally {
      close(conn, ps, rs);
    }

    return committee;
  }
示例#21
0
 public Departement(ResultSet rs) throws SQLException {
   int nbColumnUnknown = 0;
   ResultSetMetaData metaData = rs.getMetaData();
   int nbColumn = metaData.getColumnCount();
   for (int i = 0; i < nbColumn; i++) {
     String nomColonne = metaData.getColumnLabel(i + 1);
     switch (nomColonne) {
       case "dpt_code_departement":
         code_departement = rs.getString(nomColonne);
         break;
       case "dpt_projection":
         dpt_projection = rs.getString(nomColonne);
         break;
       case "dpt_referentiel":
         dpt_referentiel = rs.getString(nomColonne);
         break;
       case "dpt_t0":
         t0 = rs.getTimestamp(nomColonne);
         break;
       case "dpt_t1":
         t1 = rs.getTimestamp(nomColonne);
         break;
       case "dpt_geometrie":
         geometrie = rs.getString(nomColonne);
         break;
       case "dpt_centroide":
         centroide = rs.getString(nomColonne);
         break;
       default:
         nbColumnUnknown = nbColumnUnknown + 1;
     }
   }
 }
示例#22
0
  /** @see SQLEntityAdapter#getEntity(Connection, ResultSet) */
  @Override
  public TaskInstance getEntity(Connection connection, ResultSet resultSet) throws SQLException {
    PluginInfo pluginInfo =
        new PluginInfo(
            resultSet.getString("plugin_id"),
            resultSet.getString("plugin_name"),
            resultSet.getFloat("plugin_version"),
            resultSet.getString("plugin_description"),
            null);

    TaskInstance taskInstance =
        new TaskInstance(
            resultSet.getString("id"),
            resultSet.getString("name"),
            resultSet.getString("description"),
            resultSet.getString("username"),
            pluginInfo,
            resultSet.getString("state"),
            resultSet.getFloat("completePercentage"),
            resultSet.getTimestamp("startDate"),
            resultSet.getTimestamp("finishDate"),
            resultSet.getString("report"));

    PluginParameter[] parameters = getTaskInstanceParameters(connection, taskInstance.getId());
    pluginInfo.setParameters(parameters);

    return taskInstance;
  }
示例#23
0
  /**
   * Lit un pret.
   *
   * @param idPret L'ID du pret à lire
   * @return Le pret lu
   * @throws DAOException S'il y a une erreur dans la base de données
   */
  public PretDTO read(int idPret) throws DAOException {

    PretDTO pretDTO = null;

    try (PreparedStatement readPreparedStatement =
        getConnection().prepareStatement(PretDAO.READ_REQUEST)) {
      readPreparedStatement.setInt(1, idPret);
      try (ResultSet resultSet = readPreparedStatement.executeQuery()) {
        if (resultSet.next()) {

          pretDTO = new PretDTO();
          pretDTO.setIdPret(resultSet.getInt(1));

          final MembreDTO membreDTO = new MembreDTO();
          membreDTO.setIdMembre(resultSet.getInt(2));
          pretDTO.setMembreDTO(membreDTO);

          final LivreDTO livreDTO = new LivreDTO();
          livreDTO.setIdLivre(resultSet.getInt(3));
          pretDTO.setLivreDTO(livreDTO);

          pretDTO.setDatePret(resultSet.getTimestamp(4));
          pretDTO.setDateRetour(resultSet.getTimestamp(5));
        }
      }

    } catch (final SQLException sqlException) {
      throw new DAOException(sqlException);
    }
    return pretDTO;
  }
    @Override
    public ChargeSession mapRow(ResultSet rs, int rowNum) throws SQLException {
      ChargeSession row = new ChargeSession();
      // Row order is: created, sessid_hi, sessid_lo, idtag, socketid, auth_status, xid, ended,
      // posted
      Timestamp ts = rs.getTimestamp(1, utcCalendar);
      if (ts != null) {
        row.setCreated(new Date(ts.getTime()));
      }
      row.setSessionId(new UUID(rs.getLong(2), rs.getLong(3)).toString());
      row.setIdTag(rs.getString(4));
      row.setSocketId(rs.getString(5));

      String s = rs.getString(6);
      if (s != null) {
        row.setStatus(AuthorizationStatus.valueOf(s));
      }

      Number n = (Number) rs.getObject(7);
      if (n != null) {
        row.setTransactionId(n.intValue());
      }

      ts = rs.getTimestamp(8, utcCalendar);
      if (ts != null) {
        row.setEnded(new Date(ts.getTime()));
      }

      ts = rs.getTimestamp(9, utcCalendar);
      if (ts != null) {
        row.setPosted(new Date(ts.getTime()));
      }

      return row;
    }
示例#25
0
  /**
   * Trouve les prêts non terminés à partir d'une date de retour.
   *
   * @param dateRetour La date de retour à utiliser
   * @return La liste des prets correspondants; une liste vide sinon
   * @throws DAOException S'il y a une erreur avec la base de données
   */
  public List<PretDTO> findByDateRetour(Timestamp dateRetour) throws DAOException {

    List<PretDTO> listePrets = Collections.EMPTY_LIST;
    PretDTO pretDTO = null;

    try (PreparedStatement findByDateRetourPreparedStatement =
        getConnection().prepareStatement(PretDAO.FIND_BY_DATE_RETOUR); ) {
      findByDateRetourPreparedStatement.setTimestamp(1, dateRetour);
      try (ResultSet resultSet = findByDateRetourPreparedStatement.executeQuery(); ) {
        if (resultSet.next()) {
          listePrets = new ArrayList<>();
          do {
            pretDTO = new PretDTO();
            pretDTO.setIdPret(resultSet.getInt(1));
            final MembreDTO membreDTO = new MembreDTO();
            membreDTO.setIdMembre(resultSet.getInt(2));
            pretDTO.setMembreDTO(membreDTO);
            // pretDTO.getMembreDTO().setIdMembre(resultSet.getInt(2));
            final LivreDTO livreDTO = new LivreDTO();
            livreDTO.setIdLivre(resultSet.getInt(3));
            pretDTO.setLivreDTO(livreDTO);
            // pretDTO.getLivreDTO().setIdLivre(resultSet.getInt(3));
            pretDTO.setDatePret(resultSet.getTimestamp(4));
            pretDTO.setDateRetour(resultSet.getTimestamp(5));
            listePrets.add(pretDTO);
          } while (resultSet.next());
        }
      }
    } catch (final SQLException sqlException) {
      throw new DAOException(sqlException);
    }
    return listePrets;
  }
示例#26
0
  /**
   * 根据审批ID得到审批项
   *
   * @param con
   * @param con_id
   * @return
   * @throws Exception
   */
  public static YmProcessApproval getApprovalByApprovalId(Connection con, String approval_id)
      throws Exception {
    YmProcessApproval approval = null;
    PreparedStatement pstmt = null;
    ResultSet rs = null;
    String sql = null;
    sql =
        " select approval_id, con_id, approver, status, approval_type, approval_type_name, "
            + "		   creater, createrName, created, pass_date "
            + " from t_ym_process_approval where approval_id = ? ";
    pstmt = con.prepareStatement(sql);
    pstmt.setString(1, approval_id);
    rs = pstmt.executeQuery();
    if (rs.next()) {
      approval = new YmProcessApproval();
      approval.setApproval_id(rs.getString("approval_id"));
      approval.setCon_id(rs.getString("con_id"));
      approval.setStatus(rs.getInt("status"));
      approval.setApprover(rs.getString("approver"));
      approval.setApproval_type(rs.getString("approval_type"));
      approval.setApproval_type_name(rs.getString("approval_type_name"));
      approval.setCreater(rs.getString("creater"));
      approval.setCreaterName(rs.getString("createrName"));
      approval.setCreated(rs.getTimestamp("created"));
      approval.setPass_date(rs.getTimestamp("pass_date"));
    }
    rs.close();
    pstmt.close();

    return approval;
  }
示例#27
0
  @Override
  public Article mapRow(ResultSet rs, int rowNum) throws SQLException {

    Article a = new Article();
    a.setId(rs.getInt("id"));
    a.setTitle(rs.getString("title"));

    Blob blob = rs.getBlob("content");
    int len = (int) blob.length();
    byte[] data = blob.getBytes(0, len);
    String content = new String(data);
    a.setContent(content);

    a.setCtime(rs.getTimestamp("ctime"));
    a.setUptime(rs.getTimestamp("uptime"));
    a.setTags(rs.getString("tags"));
    a.setCategory(rs.getString("category"));

    a.setAuthorId(rs.getInt("authorId"));
    a.setEditorId(rs.getInt("editorId"));
    a.setMediaId(rs.getInt("mediaId"));
    a.setPics(rs.getString("pics"));
    a.setExtra(rs.getString("extra"));

    return a;
  }
 public ArrayList<Funcionario> list() {
   ArrayList<Funcionario> funcionarios = new ArrayList();
   Connection conexao = new Conexao().getConexao();
   try {
     PreparedStatement preparedStatement =
         conexao.prepareStatement("SELECT * FROM funcionarios ORDER BY id;");
     ResultSet resultSet = preparedStatement.executeQuery();
     while (resultSet.next()) {
       funcionarios.add(
           new Funcionario(
               resultSet.getInt("id"),
               resultSet.getString("nome"),
               resultSet.getString("sobrenome"),
               resultSet.getString("cpf"),
               resultSet.getString("telefone"),
               new EnderecoDAO().findById(resultSet.getInt("endereco_id")),
               resultSet.getString("email"),
               resultSet.getDate("nascimento"),
               resultSet.getDouble("salario"),
               resultSet.getBoolean("gerente"),
               resultSet.getString("senha"),
               resultSet.getBoolean("status"),
               new Date(resultSet.getTimestamp("created").getTime()),
               new Date(resultSet.getTimestamp("edited").getTime())));
     }
     preparedStatement.close();
     conexao.close();
   } catch (SQLException ex) {
     Logger.getLogger(FuncionarioDAO.class.getName()).log(Level.SEVERE, null, ex);
   }
   return funcionarios;
 }
 @Override
 public VitalSign mapRow(ResultSet rs, int rowNum) throws SQLException {
   VitalSign v = new VitalSign();
   v.setRecordId(
       RowMapperUtil.getInteger(
           rs, MiasVitalSignRowMapper.VITAL_SIGNS_RECORD.RECORD_ID.toString()));
   v.setPatientId(rs.getString(MiasVitalSignRowMapper.VITAL_SIGNS_RECORD.PATIENT_ID.toString()));
   v.setVisitId(rs.getString(MiasVitalSignRowMapper.VITAL_SIGNS_RECORD.VISIT_ID.toString()));
   v.setTimePoint(
       RowMapperUtil.getDateTime(
           rs.getTimestamp(MiasVitalSignRowMapper.VITAL_SIGNS_RECORD.TIME_POINT.toString())));
   v.setVitalSignsItem(
       rs.getString(MiasVitalSignRowMapper.VITAL_SIGNS_RECORD.VITAL_SIGNS_ITEM.toString()));
   v.setVitalSignsValues(
       rs.getString(MiasVitalSignRowMapper.VITAL_SIGNS_RECORD.VITAL_SIGNS_VALUES.toString()));
   v.setUnits(rs.getString(MiasVitalSignRowMapper.VITAL_SIGNS_RECORD.UNITS.toString()));
   v.setRecorder(rs.getString(MiasVitalSignRowMapper.VITAL_SIGNS_RECORD.RECORDER.toString()));
   v.setRecordingDateTime(
       RowMapperUtil.getDateTime(
           rs.getTimestamp(
               MiasVitalSignRowMapper.VITAL_SIGNS_RECORD.RECORDING_DATE_TIME.toString())));
   v.setFlag(
       RowMapperUtil.getInteger(rs, MiasVitalSignRowMapper.VITAL_SIGNS_RECORD.FLAG.toString()));
   return v;
 }
 @Override
 public BizLoanTransferApply mapRow(ResultSet rs, int index) throws SQLException {
   BizLoanTransferApply apply = new BizLoanTransferApply();
   apply.setId(rs.getInt("id"));
   apply.setOriginalLoanId(rs.getInt("original_loan_id"));
   apply.setInitTransferLoanRate(rs.getBigDecimal("init_transfer_loan_rate"));
   apply.setTransferLoanRate(rs.getBigDecimal("transfer_loan_rate"));
   apply.setTransferDirection(TransferDirection.valueOf(rs.getString("transfer_direction")));
   if (StringUtils.isNotBlank(rs.getString("lender_user_id"))) {
     apply.setLenderUserId(rs.getInt("lender_user_id"));
   }
   if (StringUtils.isNotBlank(rs.getString("lender_hold_id"))) {
     apply.setLenderHoldId(rs.getInt("lender_hold_id"));
   }
   if (StringUtils.isNotBlank(rs.getString("middle_man_id"))) {
     apply.setMiddleManId(rs.getInt("middle_man_id"));
   }
   if (StringUtils.isNotBlank(rs.getString("middle_hold_id"))) {
     apply.setMiddleHoldId(rs.getInt("middle_hold_id"));
   }
   apply.setTransferCurrentAmount(rs.getBigDecimal("transfer_current_amount"));
   apply.setCreateDatetime(rs.getTimestamp("create_datetime"));
   apply.setLastUpdateDatetime(rs.getTimestamp("last_update_datetime"));
   apply.setTransferStatus(TransferApplyStatus.valueOf(rs.getString("transfer_status")));
   apply.setVersion(rs.getInt("version"));
   return apply;
 }