Example usage for org.springframework.jdbc.support.rowset SqlRowSet next

Introduction

In this page you can find the example usage for org.springframework.jdbc.support.rowset SqlRowSet next.

Prototype

boolean next() throws InvalidResultSetAccessException;

Source Link

Document

Move the cursor to the next row.

Usage

From source file:com.gst.infrastructure.dataqueries.service.ReadWriteNonCoreDataServiceImpl.java

private List<ResultsetRowData> fillDatatableResultSetDataRows(final String sql) {

    final SqlRowSet rs = this.jdbcTemplate.queryForRowSet(sql);

    final List<ResultsetRowData> resultsetDataRows = new ArrayList<>();

    final SqlRowSetMetaData rsmd = rs.getMetaData();

    while (rs.next()) {
        final List<String> columnValues = new ArrayList<>();
        for (int i = 0; i < rsmd.getColumnCount(); i++) {
            final String columnName = rsmd.getColumnName(i + 1);
            final String columnValue = rs.getString(columnName);
            columnValues.add(columnValue);
        }//from   ww  w  .j a  v  a 2 s.c o  m

        final ResultsetRowData resultsetDataRow = ResultsetRowData.create(columnValues);
        resultsetDataRows.add(resultsetDataRow);
    }

    return resultsetDataRows;
}

---

From source file:com.joliciel.frenchTreebank.TreebankDaoImpl.java

public List<PhraseUnit> findAllPhraseUnits(Phrase phrase) {
    NamedParameterJdbcTemplate jt = new NamedParameterJdbcTemplate(this.getDataSource());
    String sql = "SELECT " + SELECT_PHRASE_UNIT + "," + SELECT_PHRASE_SUBUNIT + " FROM ftb_phrase_unit pu"
            + " LEFT JOIN ftb_phrase_subunit psu ON pu.punit_id = psu.psubunit_punit_id"
            + " INNER JOIN ftb_phrase_child pc ON punit_phrase_id = pchild_child_id AND pchild_phrase_id = :pchild_phrase_id"
            + " ORDER BY punit_position, psubunit_position";
    MapSqlParameterSource paramSource = new MapSqlParameterSource();
    paramSource.addValue("pchild_phrase_id", phrase.getId());

    LOG.info(sql);//from  ww  w  .  j a  v  a 2 s .  c  om
    TreebankDaoImpl.LogParameters(paramSource);
    SqlRowSet rowSet = jt.queryForRowSet(sql, paramSource);
    PhraseUnitMapper phraseUnitMapper = new PhraseUnitMapper(this.treebankServiceInternal);
    PhraseSubUnitMapper phraseSubUnitMapper = new PhraseSubUnitMapper(this.treebankServiceInternal);

    List<PhraseUnit> phraseUnits = new ArrayList<PhraseUnit>();
    int currentPunitId = 0;
    PhraseUnitInternal currentPhraseUnit = null;
    while (rowSet.next()) {
        int phraseUnitId = rowSet.getInt("punit_id");
        if (phraseUnitId != currentPunitId) {
            currentPhraseUnit = phraseUnitMapper.mapRow(rowSet);
            currentPhraseUnit.setSubunitsInternal(new ArrayList<PhraseSubunit>());
            phraseUnits.add(currentPhraseUnit);
            currentPunitId = phraseUnitId;
        }

        int phraseSubunitId = rowSet.getInt("psubunit_id");
        if (phraseSubunitId != 0) {
            PhraseSubunit psubunit = phraseSubUnitMapper.mapRow(rowSet);
            currentPhraseUnit.getSubunitsInternal().add(psubunit);
        }
    }
    return phraseUnits;
}

---

From source file:com.joliciel.frenchTreebank.TreebankDaoImpl.java

public List<PhraseUnitInternal> findPhraseUnits(Phrase phrase) {
    NamedParameterJdbcTemplate jt = new NamedParameterJdbcTemplate(this.getDataSource());
    String sql = "SELECT " + SELECT_PHRASE_UNIT + "," + SELECT_PHRASE_SUBUNIT + " FROM ftb_phrase_unit pu"
            + " LEFT JOIN ftb_phrase_subunit psu ON pu.punit_id = psu.psubunit_punit_id"
            + " WHERE punit_phrase_id = :phrase_id" + " ORDER BY punit_position, psubunit_position";
    MapSqlParameterSource paramSource = new MapSqlParameterSource();
    paramSource.addValue("phrase_id", phrase.getId());

    LOG.info(sql);/*from   w  ww . j  av a 2 s. c om*/
    TreebankDaoImpl.LogParameters(paramSource);
    SqlRowSet rowSet = jt.queryForRowSet(sql, paramSource);
    PhraseUnitMapper phraseUnitMapper = new PhraseUnitMapper(this.treebankServiceInternal);
    PhraseSubUnitMapper phraseSubUnitMapper = new PhraseSubUnitMapper(this.treebankServiceInternal);

    List<PhraseUnitInternal> phraseUnits = new ArrayList<PhraseUnitInternal>();
    int currentPunitId = 0;
    PhraseUnitInternal currentPhraseUnit = null;
    while (rowSet.next()) {
        int phraseUnitId = rowSet.getInt("punit_id");
        if (phraseUnitId != currentPunitId) {
            currentPhraseUnit = phraseUnitMapper.mapRow(rowSet);
            currentPhraseUnit.setSubunitsInternal(new ArrayList<PhraseSubunit>());
            phraseUnits.add(currentPhraseUnit);
            currentPunitId = phraseUnitId;
        }

        int phraseSubunitId = rowSet.getInt("psubunit_id");
        if (phraseSubunitId != 0) {
            PhraseSubunit psubunit = phraseSubUnitMapper.mapRow(rowSet);
            currentPhraseUnit.getSubunitsInternal().add(psubunit);
        }
    }
    return phraseUnits;
}

---

From source file:com.ardhi.businessgame.services.BusinessGameService.java

public String getEntireZone() {
    String val = "";
    ArrayList<String> zoneList = new ArrayList<String>();
    SqlRowSet srs = db.getJdbc().queryForRowSet("select id from info_zone");
    while (srs.next()) {
        zoneList.add(srs.getString("id"));
    }//from  ww  w  .  java 2 s  .  co m

    val = gson.toJson(zoneList);

    srs = null;
    zoneList = null;
    gc();

    return val;
}

---

From source file:com.ardhi.businessgame.services.BusinessGameService.java

public String getSuggestedPrice(HttpServletRequest req) {
    //Suggested price still based on info_product
    //Lately, it must use a DSS based, like AHP, or any easier method..
    String val = "0";
    double price = 0;

    //Deciding price starts here :
    System.out.println(req.getParameter("id"));
    System.out.println(req.getParameter("id").substring(0, 2));
    if (req.getParameter("id").substring(0, 2).equals("PR")) {
        val = "select price from desc_product where id=(select storage_product.[desc] from storage_product where id='"
                + req.getParameter("id") + "')";
    }/*from ww w.  ja  va 2s.  c  om*/

    else if (req.getParameter("id").substring(0, 2).equals("EQ")) {
        val = "select price from desc_equipment where id=(select list_equipment.[desc] from list_equipment where id='"
                + req.getParameter("id") + "')";
    }

    SqlRowSet srs = db.getJdbc().queryForRowSet(val);
    if (srs.next())
        price = srs.getDouble("price");
    else
        return "0";

    //Deciding price ends here.

    srs = db.getJdbc().queryForRowSet(
            "select [zone] from user_market_license where [user]='" + req.getParameter("user") + "'");
    ArrayList<String> marketZone = new ArrayList<String>();
    while (srs.next()) {
        marketZone.add(srs.getString("zone"));
    }

    ArrayList<String> data = new ArrayList<String>();
    data.add(gson.toJson(price));
    data.add(gson.toJson(marketZone));

    val = gson.toJson(data);

    marketZone = null;
    data = null;
    srs = null;

    gc();

    return val;
}

---

From source file:com.ardhi.businessgame.services.BusinessGameService.java

public String submitProposal(HttpServletRequest req) {
    String val = "0", turn, idInc, zone;
    SqlRowSet srs = db.getJdbc().queryForRowSet("select [value] from info_values where name='turn'");

    if (srs.next())
        turn = srs.getString("value");
    else//from w  w  w.  ja  v a  2 s .co m
        return val;

    srs = db.getJdbc().queryForRowSet(
            "select [zone] from businessgame.dbo.[user] where name='" + req.getParameter("user") + "'");
    if (srs.next())
        zone = srs.getString("zone");
    else
        return val;

    idInc = getUniqueIncrementIdNew("req_borrow_bank");

    db.getJdbc()
            .execute("insert into req_borrow_bank values ('" + KEY_REQUEST_BORROW_BANK + idInc + "','"
                    + req.getParameter("user") + "','" + turn + "','" + req.getParameter("sector") + "','"
                    + req.getParameter("turn") + "','"
                    + (Boolean.parseBoolean(req.getParameter("storage")) ? 1 : 0) + "','" + zone + "')");
    val = "Ok";

    turn = null;
    zone = null;
    idInc = null;
    srs = null;

    gc();

    return val;
}

---

From source file:com.ardhi.businessgame.services.BusinessGameService.java

public String activateDeactivateInstallment(HttpServletRequest req) {
    String val = "";
    boolean active;
    SqlRowSet srs = db.getJdbc()
            .queryForRowSet("select active from installment where id='" + req.getParameter("id") + "'");
    if (srs.next())
        active = !srs.getBoolean("active");
    else//from  w  w  w.  j  av  a 2s .  c  o  m
        return "0";

    db.getJdbc().execute("update installment set active='" + (active ? 1 : 0) + "' where id='"
            + req.getParameter("id") + "'");

    val = gson.toJson(active);

    srs = null;

    return val;
}

---

From source file:com.ardhi.businessgame.services.BusinessGameService.java

public String getBorrowedMoney(HttpServletRequest req) {
    String val = "";
    double borrow;

    SqlRowSet srs = db.getJdbc()
            .queryForRowSet("select borrow from borrow_bank where [user]='" + req.getParameter("user") + "'");
    if (srs.next())
        borrow = srs.getDouble("borrow");
    else/*from  w w  w .jav  a  2  s .c o  m*/
        return "1";

    val = gson.toJson(borrow);

    return val;
}

---

From source file:com.ardhi.businessgame.services.BusinessGameService.java

public String loginUser(HttpServletRequest req) {
    String val = "Ok";
    SqlRowSet srs1 = db.getJdbc().queryForRowSet("select [value] from info_values where name='ver'"), srs2;

    if (srs1.next()) {
        if (!srs1.getString("value").equals(req.getParameter("ver")))
            return "2";
    } else/*from  ww w.j  a  v  a 2s.  co m*/
        return "0";

    srs1 = db.getJdbc().queryForRowSet(
            "select * from businessgame.dbo.[user] where name='" + req.getParameter("user") + "'");
    System.out.println("Ver : " + req.getParameter("ver"));
    User userAcc;
    if (srs1.next()) {
        if (req.getParameter("pass").equals(srs1.getString("pass"))) {
            HashMap<String, String> storages = new HashMap<String, String>(),
                    marketLicenses = new HashMap<String, String>(),
                    sectorBlueprints = new HashMap<String, String>();
            HashMap<String, Double> sectorCost = new HashMap<String, Double>();
            ArrayList<Installment> installments = getUserInstallments(req.getParameter("user"));

            srs2 = db.getJdbc()
                    .queryForRowSet("select cost from info_zone where id='" + srs1.getString("zone") + "'");
            double propCost;
            if (srs2.next()) {
                propCost = srs2.getDouble("cost");
            } else
                return "0";

            srs2 = db.getJdbc().queryForRowSet(
                    "select id,[zone] from storage where [user]='" + req.getParameter("user") + "'");
            while (srs2.next()) {
                storages.put(srs2.getString("zone"), srs2.getString("id"));
            }

            srs2 = db.getJdbc().queryForRowSet("select id,[zone] from user_market_license where [user]='"
                    + req.getParameter("user") + "'");
            while (srs2.next()) {
                marketLicenses.put(srs2.getString("zone"), srs2.getString("id"));
            }

            System.out.println(marketLicenses);

            srs2 = db.getJdbc().queryForRowSet(
                    "select id,sector,cost from user_sector_blueprint,info_sector where [user]='"
                            + req.getParameter("user") + "' and sector=name");
            while (srs2.next()) {
                sectorBlueprints.put(srs2.getString("sector"), srs2.getString("id"));
                sectorCost.put(srs2.getString("sector"), srs2.getDouble("cost"));
            }

            userAcc = new User(srs1.getString("name"), srs1.getString("email"), srs1.getString("dob"),
                    srs1.getString("about"), srs1.getDouble("money"), propCost, srs1.getLong("rep"),
                    srs1.getString("zone"), srs1.getInt("level"), storages, marketLicenses, sectorBlueprints,
                    sectorCost, installments);
            val = gson.toJson(userAcc);

            storages = null;
            marketLicenses = null;
            sectorBlueprints = null;
            sectorCost = null;
            installments = null;

        } else
            val = "0";

    } else
        val = "1";

    userAcc = null;
    srs1 = null;
    srs2 = null;

    gc();

    return val;
}

---

From source file:com.ardhi.businessgame.services.BusinessGameService.java

public String calculateFixPrice(HttpServletRequest req) {
    String val = "";
    SqlRowSet srs = db.getJdbc().queryForRowSet(
            "select durability,buy_price from list_equipment where id='" + req.getParameter("id") + "'");
    double price;
    if (srs.next())
        price = ((100 - srs.getDouble("durability")) / 100) * srs.getDouble("buy_price");
    else/*from   ww w  .  j  ava 2s  . c om*/
        return "0";

    val = gson.toJson(price);

    return val;
}

---

• «
• 1
• 2
• 3
• 4
• 5
• 6
• 7
• 8
• 9
• 10
• 11
• 12
• 13
• 14
• 15
• 16
• 17
• »