Examples of org.springframework.jdbc.support.rowset.SqlRowSet

Package org.springframework.jdbc.support.rowset

Examples of org.springframework.jdbc.support.rowset.SqlRowSet

org.springframework.jdbc.support.rowset.SqlRowSet
Mirror interface for javax.sql.RowSet, representing disconnected java.sql.ResultSet data.
The main difference to the standard JDBC RowSet is that an SQLException is never thrown here. This allows a SqlRowSet to be used without having to deal with checked exceptions. A SqlRowSet will throw Spring's org.springframework.jdbc.InvalidResultSetAccessException instead (when appropriate).
Note: This interface extends the java.io.Serializable marker interface. Implementations, which typically hold disconnected data, are encouraged to be actually serializable (as far as possible). @author Thomas Risberg @author Juergen Hoeller @since 1.2 @see javax.sql.RowSet @see java.sql.ResultSet @see org.springframework.jdbc.InvalidResultSetAccessException @see org.springframework.jdbc.core.JdbcTemplate#queryForRowSet

       getJdbcTemplate().getDataSource().getConnection().setCatalog(catalog);
  }


  private int getTableFieldNums(String tablename) {
    String sql = " desc  " + tablename;
    SqlRowSet set = getJdbcTemplate().queryForRowSet(sql);
    int rownum = 0;
    while (set.next()) {
      rownum++;
    }
    return rownum;
  }

View Full Code Here


  public List<CmsTable> listTables() {
    String sql = "select table_name,table_comment,engine,table_rows,auto_increment from tables where table_schema='"
        + db + "'";
    List<CmsTable> tables = new ArrayList<CmsTable>();
    SqlRowSet set = getJdbcTemplate().queryForRowSet(sql);
    while (set.next()) {
      CmsTable table = new CmsTable();
      table.setName(set.getString(1));
      table.setComment(set.getString(2).split(";")[0]);
      table.setEngine(set.getString(3));
      table.setRows(set.getInt(4));
      table.setAuto_increment(set.getInt(5));
      tables.add(table);
    }
    return tables;
  }

View Full Code Here


  public CmsTable findTable(String tablename) {
    String sql = "select table_name,table_comment,engine,table_rows,auto_increment from tables where table_schema='"
        + db + "' and table_name='" + tablename + "'";
    List<CmsTable> tables = new ArrayList<CmsTable>();
    SqlRowSet set = getJdbcTemplate().queryForRowSet(sql);
    while (set.next()) {
      CmsTable table = new CmsTable();
      table.setName(set.getString(1));
      table.setComment(set.getString(2).split(";")[0]);
      table.setEngine(set.getString(3));
      table.setRows(set.getInt(4));
      table.setAuto_increment(set.getInt(5));
      tables.add(table);
    }
    if (tables.size() > 0) {
      return tables.get(0);
    }else{

View Full Code Here


  public List<CmsField> listFields(String tablename) {
    String sql = "select column_name,column_type,column_default,column_key,column_comment,is_nullable,extra from columns where table_schema='"
        + db + "' and table_name='" + tablename + "'";
    List<CmsField> fields = new ArrayList<CmsField>();
    SqlRowSet set = getJdbcTemplate().queryForRowSet(sql);
    while (set.next()) {
      CmsField field = new CmsField();
      field.setName(set.getString(1));
      field.setFieldType(set.getString(2));
      field.setFieldDefault(set.getString(3));
      field.setFieldProperty(set.getString(4));
      field.setComment(set.getString(5));
      field.setNullable(set.getString(6));
      field.setExtra(set.getString(7));
      fields.add(field);
    }
    return fields;
  }

View Full Code Here


  public List<CmsConstraints> listConstraints(String tablename) {
    String sql = "select constraint_name,table_name,column_name,referenced_table_name,referenced_column_name from information_schema.KEY_COLUMN_USAGE where constraint_schema='"
        + db + "' and table_name='" + tablename + "'";
    List<CmsConstraints> constraints = new ArrayList<CmsConstraints>();
    SqlRowSet set = getJdbcTemplate().queryForRowSet(sql);
    while (set.next()) {
      CmsConstraints constraint = new CmsConstraints();
      constraint.setName(set.getString(1));
      constraint.setTableName(set.getString(2));
      constraint.setColumnName(set.getString(3));
      constraint.setReferencedTableName(set.getString(4));
      constraint.setReferencedColumnName(set.getString(5));
      constraints.add(constraint);
    }
    return constraints;
  }

View Full Code Here

    }
    return value;
  }


  private String resolveJdbcPlaceholder(String placeholder) {
    SqlRowSet rs = new JdbcTemplate(dataSource).queryForRowSet(sql,new Object[]{placeholder});
    int columnCount = rs.getMetaData().getColumnCount();
    Assert.isTrue(columnCount == 1 || columnCount == 2,"error resultSet columnCount,sql example: select config_value,[default_value] from app_config where config_key=?,[default_value] is option");
    if(!rs.next()) 
      return null;
    
    switch(columnCount) {
    case 1:
      return rs.getString(1);
    case 2:
      String value = rs.getString(1);
      String defaultValue = rs.getString(2);
      if(value == null) {
        value = defaultValue;
      }
      return value;
    default:

View Full Code Here

        assertEquals(insertCommit.getTimestamp(), record.get("REV_CREATED"));
        assertEquals("foo", record.get("TESTID"));
        assertEquals(42, record.get("TESTINTEGER"));


        // check revisions
        SqlRowSet rowset =
            jdbc().queryForRowSet("SELECT * FROM " + index.getHistoryTableName() + " ORDER BY REV_TIMESTAMP");


        assertTrue(rowset.next());
        assertEquals("foo", rowset.getString("TESTID"));
        assertEquals(1, rowset.getInt("TESTINTEGER"));
        assertEquals("INSERT", rowset.getString("REV_OPERATION"));


        assertTrue(rowset.next());
        assertEquals("foo", rowset.getString("TESTID"));
        assertEquals(42, rowset.getInt("TESTINTEGER"));
        assertEquals("UPDATE", rowset.getString("REV_OPERATION"));


        assertFalse(rowset.next());
    }

View Full Code Here

        assertEquals(0, jdbc().queryForInt("SELECT COUNT(*) FROM " + index.getHeadTableName()));
        assertEquals(2, jdbc().queryForInt("SELECT COUNT(*) FROM " + index.getHistoryTableName()));


        // check revisions
        String sql = "SELECT * FROM " + index.getHistoryTableName() + " ORDER BY REV_TIMESTAMP";
        SqlRowSet rowset = jdbc().queryForRowSet(sql);


        assertTrue(rowset.next());
        assertEquals("foo", rowset.getString("TESTID"));
        assertEquals(1, rowset.getInt("TESTINTEGER"));
        assertEquals("INSERT", rowset.getString("REV_OPERATION"));


        assertTrue(rowset.next());
        assertEquals("foo", rowset.getString("TESTID"));
        assertEquals(1, rowset.getInt("TESTINTEGER"));
        assertEquals("DELETE", rowset.getString("REV_OPERATION"));


        assertFalse(rowset.next());
    }

View Full Code Here

   * @throws PollNotFoundException если голосование не существует
   */
  public Poll getPoll(final int pollId) throws PollNotFoundException {
    int currentPollId = getCurrentPollId();


    SqlRowSet rs = jdbcTemplate.queryForRowSet(queryPool, pollId);


    if (!rs.next()) {
      throw new PollNotFoundException();
    }


    return new Poll(
            pollId,
            rs.getInt("topic"),
            rs.getBoolean("multiselect"),
            pollId == currentPollId,
            getVoteDTO(pollId)
    );
  }

View Full Code Here

  ) {
    String q =
            "SELECT topics.title as subj, lastmod, userid, topics.id as msgid, deleted, topics.stat1, topics.stat3, topics.stat4, topics.sticky, topics.resolved " +
            "FROM topics WHERE sticky AND NOT deleted AND topics.groupid=? ORDER BY postdate DESC";


    SqlRowSet rs = jdbcTemplate.queryForRowSet(q, group.getId());


    return prepareTopic(rs, messagesInPage);
  }

View Full Code Here

0 1 2 3 4 5 6

TOP

Related Classes of org.springframework.jdbc.support.rowset.SqlRowSet

cn.org.rapid_framework.spring.beans.factory.config.JdbcPlaceholderConfigurer

com.jeecms.cms.dao.assist.impl.CmsDataBackDaoImpl

com.jeecms.cms.dao.assist.impl.CmsDataDaoImpl

com.jverstry.Controller.MyController

com.salesforce.dataloader.dao.database.DatabaseTestUtil

com.services.otg.db.TrackingTemplate

it.pdor.gestionePratica.dao.jdbc.GestionePraticaDaoJdbcImpl

org.beangle.ems.avatar.service.DataBaseAvatarBase

org.beangle.webapp.avatar.service.DataBaseAvatarBase

org.geoserver.jdbcconfig.internal.DbMappings

All source code are property of their respective owners. Java is a trademark of Sun Microsystems, Inc and owned by ORACLE Inc. Contact coftware#gmail.com.