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

List of usage examples for org.springframework.jdbc.support.rowset SqlRowSet next

  1. HOME
  2. Java
  3. org.springframework
  4. org.springframework.jdbc.support.rowset.*
  5. SqlRowSet
  6. 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:mylife.respository.userDAO.java

/**
 *
 * @return/*  w  ww .j  av  a2s. c  om*/
 */
public int getuserCount() {
    String sql = "SELECT COUNT(username) AS rowcount FROM users";
    SqlRowSet rs = template.queryForRowSet(sql);

    if (rs.next()) {
        return rs.getInt("rowcount");
    }

    return 1;
}

From source file:mylife.respository.interactionsDAO.java

/**
 *
 * @return//  w  w  w.  java 2  s .  c o m
 */
public int getinteractionsCount() {
    String sql = "SELECT COUNT(interactioniD) AS rowcount FROM interactions";
    SqlRowSet rs = template.queryForRowSet(sql);

    if (rs.next()) {
        return rs.getInt("rowcount");
    }

    return 1;
}

From source file:mylife.respository.client1DAO.java

/**
 *
 * @return// w w w.  ja  v  a2 s.com
 */
public int getclient1Count() {
    String sql = "SELECT COUNT(idclient1) AS rowcount FROM client1";
    SqlRowSet rs = template.queryForRowSet(sql);

    if (rs.next()) {
        return rs.getInt("rowcount");
    }

    return 1;
}

From source file:edu.uca.aca2016.impulse.repository.UsersDAO.java

/**
 *getUsersCount method and SQL Query//from   ww  w .j a  v a2  s  .  c  om
 * @return
 */
public int getUsersCount() {
    String sql = "SELECT COUNT(username) AS rowcount FROM users";
    SqlRowSet rs = template.queryForRowSet(sql);

    if (rs.next()) {
        return rs.getInt("rowcount");
    }

    return 1;
}

From source file:mylife.respository.interactionsDAO.java

/**
 *
 * @return// w w  w.  j  a v a2s  .c o  m
 */
public Map<Integer, String> getclient1Map() {
    Map<Integer, String> client1 = new LinkedHashMap<Integer, String>();
    String sql = "SELECT idclient1, firstname FROM client1 ORDER BY firstname";

    SqlRowSet rs = template.queryForRowSet(sql);

    while (rs.next()) {
        client1.put(rs.getInt(1), rs.getString(2));
    }

    return client1;
}

From source file:edu.uca.aca2016.impulse.repository.ClientDAO.java

/**
 *getClientCount method and SQL Query/*from  www .  ja v a 2s . c o  m*/
 * @return
 */
public int getClientCount() {
    String sql = "SELECT COUNT(ClientID) AS rowcount FROM client";
    SqlRowSet rs = template.queryForRowSet(sql);

    if (rs.next()) {
        return rs.getInt("rowcount");
    }

    return 1;
}

From source file:au.com.jwatmuff.genericdb.p2p.DatabaseUpdateStore.java

@Override
public Update loadUpdate() throws IOException {
    Update update = new Update();

    log.debug("Loading update data");
    SqlRowSet rows = template.queryForRowSet("SELECT data FROM update_log");
    while (rows.next()) {
        try {//from  w  w w.j  a  va  2  s.  c o m
            byte[] bytes = (byte[]) rows.getObject(1);
            //                Serializable object = ObjectCopier.bytesToObject(bytes);
            Object object = FST_CONFIG.asObject(bytes);

            if (object instanceof Update) {
                log.debug(object);
                try {
                    update.mergeWith((Update) object);
                } catch (RuntimeException e) {
                    if (update.size() > 0) {
                        log.error(
                                "POSSIBLE DATA CORRUPTION - Failed to merge update during load, may be due to out-of-order updates",
                                e);
                    } else {
                        log.error(
                                "Failed to merge update during load, but update was empty so no harm was done (check for other error messages though)");
                    }
                }
            }
            if (object instanceof UpdatePosition) {
                log.debug(object);
                committedPosition = (UpdatePosition) object;
            }
        } catch (InvalidResultSetAccessException e) {
            log.error("Error processing update log", e);
        }
    }

    log.debug("Finished update load");

    return update;
}

From source file:org.xeneo.db.recommendation.MarkovRecommendation.java

public void calcRecommendations() throws InvalidResultSetAccessException {

    List<String> caseTypeList = new ArrayList<String>();
    List<RecommendationObject> recObjectList = new ArrayList<RecommendationObject>();

    //retrieve the needed fields from the database
    String sql = "select a.CreationDate, tc.TaskURI, c.CaseTypeURI" + " from Activity as a"
            + " inner join TaskContext as tc" + " on a.ActivityURI = tc.ActivityURI" + " inner join `Case` as c"
            + " on tc.CaseURI = c.CaseURI"
            //+ " where a.CreationDate > '2012-06-13 15:44:42.0'"
            + " order by a.CreationDate";

    System.out.println(sql);/*w w  w. ja  v  a  2  s .c  o m*/

    //mapps the returned row of the sql select to a list of DBEntries
    List<DBEntry> entryList = jdbcTemplate.query(sql, new DBEntryRowMapper());

    //Iterate through the list of entries to extract all different CaseTypes
    //logger.info("extracting CaseTypes ...");
    for (DBEntry entry : entryList) {
        if (!caseTypeList.contains(entry.getCaseTypeUri())) {
            caseTypeList.add(entry.getCaseTypeUri());
        }
    }

    //logger.info("extracting recommendations ...");
    for (String caseType : caseTypeList) {

        List<DBEntry> tmpList = new ArrayList<DBEntry>();
        System.out.println("---------------------------" + caseType + "---------------------------------");
        //seperate each CaseType in a List
        for (DBEntry entry : entryList) {
            if (entry.getCaseTypeUri().equals(caseType)) {
                tmpList.add(entry);
            }
        }
        //create RecommendationObjects for each CaseType
        for (int i = 0; i < tmpList.size() - 1; i++) {
            String pre = tmpList.get(i).getTaskUri();
            String suc = tmpList.get(i + 1).getTaskUri();
            double rel = tmpList.get(i + 1).getCreationDate().getTime() / 10000000000000.0;
            recObjectList.add(new RecommendationObject(caseType, pre, suc, rel));
            //System.out.println(caseType+";"+pre+"; "+suc+"; "+rel);
        }

    }
    //insert RecommendationObjects in database
    for (RecommendationObject rec : recObjectList) {
        String caseTypeURI = rec.caseTypeURI;
        String predecessor = rec.predecessor;
        String successor = rec.successor;
        double relevance = rec.relevance;

        String sql1 = "select * from Recommendation" + " WHERE CaseTypeURI = '" + caseTypeURI + "' AND"
                + " Predecessor = '" + predecessor + "' AND" + " Successor = '" + successor + "'";
        SqlRowSet rs = jdbcTemplate.queryForRowSet(sql1);

        if (rs.next()) {
            double oldrelevance = rs.getDouble("Relevance");
            double newrelevance = oldrelevance + rec.relevance;
            String updatesql = "update Recommendation" + " SET Relevance = " + newrelevance + ""
                    + " WHERE CaseTypeURI = '" + caseTypeURI + "' AND" + " Predecessor = '" + predecessor
                    + "' AND" + " Successor = '" + successor + "'";
            jdbcTemplate.update(updatesql);
            //update
        } else {
            String insertsql = "insert into Recommendation(CaseTypeURI, Predecessor, Successor, Relevance)"
                    + " values('" + caseTypeURI + "','" + predecessor + "','" + successor + "'," + relevance
                    + ")";
            jdbcTemplate.execute(insertsql);
            //insert
        }
    }

}

From source file:no.dusken.barweb.plugin.duskeninternplugin.admin.ImportPersonController.java

public ModelAndView doImport() {
    Map<String, String> map = new HashMap<String, String>();
    if (isImporting) {
        log.error("import already running");
        map.put("message", "Import already running");
        return new ModelAndView(view, map);

    } else {//  w  w  w.ja va2  s .c om
        isImporting = true;
    }

    JdbcTemplate jt = getJdbcTemplate();
    jt.setFetchSize(100);

    Gjeng g = gjengService.getByName("Under dusken");
    if (g == null) {
        g = new Gjeng();
        g.setDefaultGjeng(true);
        g.setName("Under dusken");
        gjengService.saveAndFlush(g);
    }
    // importing persons
    SqlRowSet medarbeidere = jt.queryForRowSet("SELECT * FROM medarbeidere");
    while (medarbeidere.next()) {
        Long externalID = Long.parseLong(medarbeidere.getString("medarb_ref"));
        String username = medarbeidere.getString("brukernavn");
        if (username == null || username.equals("")) {
            continue;
        }
        // use username instead of external id
        BarPerson p = barPersonService.getByUsername(username);
        if (p == null) {
            p = new BarPerson();
            p.setExternalID(externalID);
            p.setUsername(username);
            p.setFirstname(medarbeidere.getString("fornavn"));
            p.setSurname(medarbeidere.getString("etternavn"));
            p.setActive(medarbeidere.getBoolean("aktiv"));
            p.setEmailAddress(username + "@underdusken.no");
            p.setMoney(medarbeidere.getInt("saldo"));
            p.setExternalSource("db_web");
            p.setExternalID(externalID);
            p.setGjeng(g);
            p = barPersonService.save(p);
        }
        log.info("Imported BarPerson: " + p.toString());

    }
    return new ModelAndView(view, map);
}

From source file:transaction.script.ClearQuestTrScript.java

/**
 * TODO: ?   DC/*from  w  w w  .j a v  a 2 s .  c o  m*/
 * @param projectName
 * @return
 * @throws SQLException
 */
public HashMap<String, String> getAllBuildDefChanges(String projectName) throws SQLException {
    Checker.checkStringForEmpty("project name", projectName, false);

    String query = dcQueryTemplate.substitute("project", projectName);

    JdbcTemplate template = JdbcTemplateFactory.getClearQuestDBTemplate();

    HashMap<String, String> dcMap = new HashMap<String, String>();

    logger.info("query \n" + query);

    SqlRowSet set = template.queryForRowSet(query);
    logger.info("resultset rows count " + set.getRow());

    while (set.next()) {
        logger.info("resultset rows count " + set.getRow());

        dcMap.put(set.getString(DCNUMBER), set.getString(HEADLINE));
    }

    return dcMap;
}