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

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

  1. HOME
  2. Java
  3. org.springframework
  4. org.springframework.jdbc.support.rowset.*
  5. SqlRowSet
  6. getInt

Introduction

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

Prototype

int getInt(String columnLabel) throws InvalidResultSetAccessException;

Source Link

Document

Retrieve the value of the indicated column in the current row as an int.

Usage

From source file:com.hygenics.parser.getDAOTemplate.java

/**
 * check for column/*from ww w.  ja  v a  2 s  . c o m*/
 */
public boolean columnExists(String table, String column) {
    String[] data = table.split("\\.");
    if (data.length > 1) {
        String query = "SELECT count(column_name) FROM information_schema.columns WHERE table_name='".trim()
                + data[1].trim() + "' AND table_schema='" + data[0] + "' AND column_name='" + column.trim()
                + "'";
        SqlRowSet rs = this.jdbcTemplateObject.queryForRowSet(query);

        if (rs.next()) {
            if (rs.getInt(1) != 0) {
                return true;
            }
        }

    }

    return false;
}

From source file:com.hygenics.parser.getDAOTemplate.java

/**
 * Called when needing a count of distincts or other numerical result.
 * Returns an Integer so only an integer should be used
 * /*from   w  w  w  . j a  v  a2 s  .c om*/
 * @param sql
 * @param columns
 * @return
 */
public int queryForInt(String sql) {
    SqlRowSet rs = this.jdbcTemplateObject.queryForRowSet(sql);

    if (rs.next()) {
        if (rs.getMetaData().getColumnNames().length > 0) {
            return rs.getInt(1);
        }
    }
    return 0;

}

From source file:net.freechoice.dao.impl.DaoUser.java

@Deprecated
@Override/*  www .jav a2  s.  c  om*/
public Result getPasswordOfUser(String nameOrEmail) {

    SqlRowSet rowSet;
    if (nameOrEmail.contains("@")) {
        rowSet = getJdbcTemplate().queryForRowSet("select id, password from fc_user "
                + "where is_valid = true and email = " + quote(nameOrEmail));
    } else {
        rowSet = getJdbcTemplate().queryForRowSet("select id, password from fc_user "
                + "where is_valid = true and name_login = " + quote(nameOrEmail));
    }

    if (rowSet.next()) {
        if (rowSet.isLast()) {
            Result result = new Result();
            result.id = rowSet.getInt(1);
            result.password = rowSet.getString(2);
            return result;
        } else {
            throw new RuntimeException("multiple user found, should be one only");
        }
    } else {
        return null;
    }
}

From source file:com.joliciel.talismane.terminology.postgres.PostGresTerminologyBase.java

void addParents(List<Term> childTerms) {
    NamedParameterJdbcTemplate jt = new NamedParameterJdbcTemplate(this.getDataSource());
    String sql = "SELECT " + SELECT_TERM + ", term_expansion_id FROM term"
            + " INNER JOIN text ON term_text_id=text_id"
            + " INNER JOIN term_expansions ON term_id = termexp_term_id"
            + " WHERE term_project_id = :term_project_id" + " AND termexp_expansion_id IN (:child_terms)";

    MapSqlParameterSource paramSource = new MapSqlParameterSource();
    paramSource.addValue("term_project_id", this.getCurrentProjectId());
    List<Integer> termIds = new ArrayList<Integer>();
    Map<Integer, PostGresTerm> childTermMap = new HashMap<Integer, PostGresTerm>();
    for (Term childTerm : childTerms) {
        PostGresTerm termInternal = (PostGresTerm) childTerm;
        if (termInternal.getParentsInternal() == null) {
            termIds.add(termInternal.getId());
            termInternal.setParentsInternal(new TreeSet<Term>());
            childTermMap.put(termInternal.getId(), termInternal);
        }//from   w  ww  . j  a v  a 2  s  .c om
    }
    paramSource.addValue("child_terms", termIds);

    LOG.trace(sql);
    LogParameters(paramSource);

    SqlRowSet rs = jt.queryForRowSet(sql, paramSource);
    TermMapper termMapper = new TermMapper();
    List<Term> parentTerms = new ArrayList<Term>();
    while (rs.next()) {
        Term term = termMapper.mapRow(rs);
        parentTerms.add(term);
        int childId = rs.getInt("termexp_expansion_id");
        PostGresTerm childTerm = childTermMap.get(childId);
        childTerm.getParentsInternal().add(term);
    }
    if (parentTerms.size() > 0) {
        this.addParents(parentTerms);
    }
}

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  . j  a  v a2  s. c o  m*/
        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:net.freechoice.dao.impl.DaoUser.java

@Warning(values = { "injection" })
@Deprecated//from   ww  w.j  a va  2  s.  co  m
@Override
public AvgUser getRoleByEmail(final String email) {

    AvgUser role = null;

    SqlRowSet rowSet = getJdbcTemplate().queryForRowSet("select U.id, U.password, U.name_login, M.value "
            + " from FC_User as U left outer join FC_User_Meta as M " + " on U.id = M.id_user_ "
            + " where U.is_valid = true and email = " + quote(email) + " and M.key = " + SuperUser.TIME_EXPIRE);
    if (rowSet.next()) {
        if (rowSet.isLast()) {
            /**
             * only super user have expire time
             */
            String timeExpire = rowSet.getString(4);
            if (timeExpire == null || (timeExpire != null && DateUtil.hasExpired(timeExpire))) {

                role = new AvgUser();
            } else {
                role = new SuperUser();
            }
            role.id = rowSet.getInt(1);
            role.hashedPswWithSalt = rowSet.getString(2);
            role.name_login = rowSet.getString(3);
            role.email = email;
        } else {
            throw new RuntimeException("multiple user found, should be one only");
        }
    }
    return role;
}

From source file:com.joliciel.lefff.LefffDaoImpl.java

@Override
public Map<String, List<LexicalEntry>> findEntryMap(List<String> categories) {
    NamedParameterJdbcTemplate jt = new NamedParameterJdbcTemplate(this.getDataSource());
    String sql = "SELECT " + SELECT_ENTRY + "," + SELECT_WORD + "," + SELECT_LEMMA + "," + SELECT_CATEGORY + ","
            + SELECT_PREDICATE + "," + SELECT_ATTRIBUTE + " FROM lef_entry"
            + " INNER JOIN lef_word ON entry_word_id = word_id"
            + " INNER JOIN lef_lemma ON entry_lemma_id = lemma_id"
            + " INNER JOIN lef_category ON entry_category_id = category_id"
            + " INNER JOIN lef_predicate ON entry_predicate_id = predicate_id"
            + " INNER JOIN lef_attribute ON entry_morph_id = attribute_id" + " WHERE entry_status < 3";

    if (categories != null && categories.size() > 0) {
        sql += " AND category_code in (:categoryCodes)";
    }//w w w.  j  a  va 2 s . com

    sql += " ORDER BY entry_status, entry_id";
    MapSqlParameterSource paramSource = new MapSqlParameterSource();

    if (categories != null && categories.size() > 0) {
        paramSource.addValue("categoryCodes", categories);
    }
    LOG.info(sql);
    LefffDaoImpl.LogParameters(paramSource);
    double requiredCapacity = 500000;
    Map<String, List<LexicalEntry>> entryMap = new HashMap<String, List<LexicalEntry>>(
            ((int) Math.ceil(requiredCapacity / 0.75)));
    EntryMapper entryMapper = new EntryMapper(this.lefffServiceInternal);
    WordMapper wordMapper = new WordMapper(this.lefffServiceInternal);
    CategoryMapper categoryMapper = new CategoryMapper(this.lefffServiceInternal);
    LemmaMapper lemmaMapper = new LemmaMapper(this.lefffServiceInternal);
    PredicateMapper predicateMapper = new PredicateMapper(this.lefffServiceInternal);
    AttributeMapper attributeMapper = new AttributeMapper(this.lefffServiceInternal);
    SqlRowSet rowSet = jt.queryForRowSet(sql, paramSource);

    Map<Integer, Category> categoryMap = new HashMap<Integer, Category>();
    Map<Integer, Predicate> predicateMap = new HashMap<Integer, Predicate>();
    Map<Integer, Attribute> attributeMap = new HashMap<Integer, Attribute>();
    Map<Integer, Lemma> lemmaMap = new HashMap<Integer, Lemma>();

    while (rowSet.next()) {
        LefffEntryInternal entry = entryMapper.mapRow(rowSet);
        WordInternal word = wordMapper.mapRow(rowSet);
        entry.setWord(word);

        int categoryId = rowSet.getInt("category_id");
        Category category = categoryMap.get(categoryId);
        if (category == null) {
            category = categoryMapper.mapRow(rowSet);
            categoryMap.put(categoryId, category);
        }
        entry.setCategory(category);

        int predicateId = rowSet.getInt("predicate_id");
        Predicate predicate = predicateMap.get(predicateId);
        if (predicate == null) {
            predicate = predicateMapper.mapRow(rowSet);
            predicateMap.put(predicateId, predicate);
        }
        entry.setPredicate(predicate);

        int lemmaId = rowSet.getInt("lemma_id");
        Lemma lemma = lemmaMap.get(lemmaId);
        if (lemma == null) {
            lemma = lemmaMapper.mapRow(rowSet);
            lemmaMap.put(lemmaId, lemma);
        }
        entry.setLemma(lemma);

        int attributeId = rowSet.getInt("attribute_id");
        Attribute attribute = attributeMap.get(attributeId);
        if (attribute == null) {
            attribute = attributeMapper.mapRow(rowSet);
            attributeMap.put(attributeId, attribute);
        }
        entry.setMorphology(attribute);

        List<LexicalEntry> entries = entryMap.get(word.getText());
        if (entries == null) {
            entries = new ArrayList<LexicalEntry>();
            entryMap.put(word.getText(), entries);
        }
        entries.add(entry);
    }

    for (String word : entryMap.keySet()) {
        List<LexicalEntry> entries = entryMap.get(word);
        ArrayList<LexicalEntry> entriesArrayList = (ArrayList<LexicalEntry>) entries;
        entriesArrayList.trimToSize();
    }
    return entryMap;
}

From source file:net.freechoice.dao.impl.DaoUser.java

@Deprecated
@Override//from   w w  w  .j a  v  a  2 s  . c  om
public AvgUser getRoleByLoginName(final String loginName) {

    AvgUser role = null;

    SqlRowSet rowSet = getJdbcTemplate().queryForRowSet("select U.id, U.password, U.email, M.value "
            + " from FC_User as U left outer join FC_User_Meta as M " + " on U.id = M.id_user_ "
            + " where U.is_valid = true and name_login = " + quote(loginName) + " and M.key = "
            + quote(SuperUser.TIME_EXPIRE));

    //System.err.println("SQL:" + 
    //            "select U.id, U.password, U.email, M.value "
    //            + " from FC_User as U left outer join FC_User_Meta as M "
    //                  +" on U.id = M.id_user_ "
    //            +" where U.is_valid = true and name_login = " + quote(loginName)
    //            +" and M.key = " + quote(SuperUser.TIME_EXPIRE)
    //      );

    if (rowSet.next()) {
        if (rowSet.isLast()) {
            /**
             * only super user have expire time
             */
            String timeExpire = rowSet.getString(4);
            if (timeExpire == null || (timeExpire != null && DateUtil.hasExpired(timeExpire))) {

                role = new AvgUser();
            } else {
                role = new SuperUser();
            }
            role.id = rowSet.getInt(1);
            role.hashedPswWithSalt = rowSet.getString(2);
            role.email = rowSet.getString(3);
            role.name_login = loginName;
        } else {
            throw new RuntimeException("multiple user found, should be one only");
        }
    }
    return role;
}

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

@Override
public void findAllWordsAndLemmas(Phrase phrase, List<? extends PhraseUnit> phraseUnits) {
    NamedParameterJdbcTemplate jt = new NamedParameterJdbcTemplate(this.getDataSource());
    String sql = "SELECT punit_id, w.word_id as w_word_id, w.word_text as w_word_text, w.word_original_text as w_word_original_text"
            + ", l.word_id as l_word_id, l.word_text as l_word_text, l.word_original_text as l_word_original_text"
            + " FROM ftb_phrase_unit pu"
            + " INNER JOIN ftb_phrase_child pc ON punit_phrase_id = pchild_child_id AND pchild_phrase_id = :pchild_phrase_id"
            + " INNER JOIN ftb_word w ON punit_word_id = w.word_id"
            + " INNER JOIN ftb_word l ON punit_lemma_id = l.word_id" + " ORDER BY punit_position";
    MapSqlParameterSource paramSource = new MapSqlParameterSource();
    paramSource.addValue("pchild_phrase_id", phrase.getId());

    LOG.info(sql);/*from www .  java 2 s . co m*/
    TreebankDaoImpl.LogParameters(paramSource);
    SqlRowSet rowSet = jt.queryForRowSet(sql, paramSource);
    WordMapper wordMapper = new WordMapper("w", this.treebankServiceInternal);
    WordMapper lemmaMapper = new WordMapper("l", this.treebankServiceInternal);
    while (rowSet.next()) {
        int phraseUnitId = rowSet.getInt("punit_id");
        Word word = wordMapper.mapRow(rowSet);
        Word lemma = lemmaMapper.mapRow(rowSet);
        for (PhraseUnit phraseUnit : phraseUnits) {
            if (phraseUnit.getId() == phraseUnitId) {
                PhraseUnitInternal iPhraseUnit = (PhraseUnitInternal) phraseUnit;
                iPhraseUnit.setWord(word);
                iPhraseUnit.setLemma(lemma);
                break;
            }
        }
    }
}

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);/* w ww.  ja v a 2 s  .com*/
    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;
}