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:lydichris.smashbracket.persistence.UserPersistence.java

public User getUserByUserName(String username) {
    String SQL = "select * from users where username = ?";
    SqlRowSet result = jdbcTemplateObject.queryForRowSet(SQL, username);
    if (result.next()) {
        User user = jdbcTemplateObject.queryForObject(SQL, new Object[] { username }, new UserMapper());
        return user;
    } else {/*from   w w w .  jav a2  s . c  o m*/
        return null;
    }
}

From source file:CRM.repository.ClientsDAO.java

public int getClientCount() {
    String sql = "SELECT COUNT(client_id) AS rowcount FROM clients";
    SqlRowSet rs = template.queryForRowSet(sql);
    if (rs.next()) {
        return rs.getInt("rowcount");
    }/* w w w.jav  a2s.  co  m*/

    return 1;
}

From source file:CRM.repository.InteractionsDAO.java

public int getInteractionsCount() {
    String sql = "SELECT COUNT(interaction_id) AS rowcount FROM interactions";
    SqlRowSet rs = template.queryForRowSet(sql);
    if (rs.next()) {
        return rs.getInt("rowcount");
    }//from w w w  . j  a  v  a 2 s  . c om
    return 1;
}

From source file:CRM.repository.InteractionsDAO.java

public Map<Integer, String> getClientsMap() {
    Map<Integer, String> clients = new LinkedHashMap<Integer, String>();
    String sql = "SELECT client_id, first_name,last_name FROM clients";

    SqlRowSet srs = template.queryForRowSet(sql);

    while (srs.next()) {
        clients.put(srs.getInt("client_id"), srs.getString("first_name") + " " + srs.getString("last_name"));
    }//ww w  .  j  a v  a2s. c  o  m
    return clients;
}

From source file:org.beangle.ems.avatar.service.DataBaseAvatarBase.java

protected byte[] getBytes(String name) {
    SqlRowSet rowSet = jdbcTemplate.queryForRowSet(sql, name);
    Blob obj = null;/*from w  w  w.  j  a v a2s  . c o m*/
    if (rowSet.next()) {
        obj = (Blob) rowSet.getObject(1);
        try {
            return obj.getBytes(1L, (int) obj.length());
        } catch (SQLException e) {
            e.printStackTrace();
            return null;
        }
    } else {
        return null;
    }
}

From source file:transaction.script.ClearQuestTrScript.java

/**
 *
 * @param projectName/*from  ww  w.  j a  v a 2  s  .  co m*/
 * @return
 * @throws SQLException
 */
public HashMap<String, String> getLastBuildSQLDefChanges(String projectName) throws SQLException {
    Checker.checkStringForEmpty("project name", projectName, false);

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

    JdbcTemplate cqTemplate = JdbcTemplateFactory.getClearQuestDBTemplate();
    HashMap<String, String> sqlMap = new HashMap<String, String>();

    SqlRowSet set = cqTemplate.queryForRowSet(query);
    while (set.next()) {
        String dcHeadline = set.getString(HEADLINE);
        if (dcHeadline.contains("sql")) {
            sqlMap.put(set.getString(DCNUMBER), dcHeadline);
        }
    }

    return sqlMap;
}

From source file:transaction.script.ClearQuestTrScript.java

/**
 *
 * @param projectName/*from w w  w  . jav a2  s  .  c o m*/
 * @return
 * @throws SQLException
 */
public HashMap<String, String> getLastBuildDQLDefChanges(String projectName) throws SQLException {
    Checker.checkStringForEmpty("project name", projectName, false);

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

    JdbcTemplate cqTemplate = JdbcTemplateFactory.getClearQuestDBTemplate();
    HashMap<String, String> dqlmap = new HashMap<String, String>();

    SqlRowSet set = cqTemplate.queryForRowSet(query);
    while (set.next()) {
        String dcHeadline = set.getString(HEADLINE);
        if (dcHeadline.contains("dql")) {
            dqlmap.put(set.getString(DCNUMBER), dcHeadline);
        }
    }

    return dqlmap;
}

From source file:com.jaxio.celerio.configuration.database.mysql.MySqlEnumExtractorTest.java

@Test
@Ignore/*  www.  j a  v  a  2s .c om*/
public void film() {
    SqlRowSet queryForRowSet = jdbcTemplate().queryForRowSet("show columns from film where type like 'enum%'");
    while (queryForRowSet.next()) {
        String field = queryForRowSet.getString("Field");
        String type = queryForRowSet.getString("Type");
        MysqlEnumValuesExtractor mysqlEnumValuesExtractor = new MysqlEnumValuesExtractor();
        System.out.println("Extracting values from " + field + "." + type);
        for (String a : mysqlEnumValuesExtractor.extract(type)) {
            System.out.println(a);
        }
    }
}

From source file:repository.InteractionsDAO.java

public int getInteractionsCount() {
    String sql = "SELECT COUNT(interactionid) AS irow FROM interactions";
    SqlRowSet rs = template.queryForRowSet(sql);

    if (rs.next()) {
        return rs.getInt("irow");
    }//w  w w.j  av  a  2  s . c o  m

    return 1;
}

From source file:repository.InteractionsDAO.java

public Map<Integer, String> getClientInteractMap() {
    Map<Integer, String> Clients = new LinkedHashMap<Integer, String>();
    String sql = "SELECT id, firstname, lastname FROM clients ORDER BY firstname";

    SqlRowSet rs = template.queryForRowSet(sql);

    while (rs.next()) {
        Clients.put(rs.getInt(1), rs.getString(2) + " " + rs.getString(3));
    }/*from w w w  .  ja  v  a  2 s .c om*/

    return Clients;
}