Package com.sun.rowset

Examples of com.sun.rowset.CachedRowSetImpl

4697
4698
4699
4700
4701
4702
4703
4704
4705
4706
4707
4708
4709
4710
4711
4712
4713
4714
4715
4716
4717
4718
4719
4720
    assertEquals("John", crs.getString(1));
  }

  public void testBug48820() throws Exception {

    CachedRowSetImpl crs;

    Connection noBlobsConn = getConnectionWithProps("functionsNeverReturnBlobs=true");

    this.rs = noBlobsConn.createStatement().executeQuery(
        "SELECT PASSWORD ('SOMETHING')");
    this.rs.first();

    String fromPlainResultSet = this.rs.getString(1);

    this.rs = noBlobsConn.createStatement().executeQuery(
        "SELECT PASSWORD ('SOMETHING')");

    crs = new CachedRowSetImpl();
    crs.populate(this.rs);
    crs.first();

    assertEquals(fromPlainResultSet, crs.getString(1));
  }
View Full Code Here
65
66
67
68
69
70
71
72
73
74
75
        if (sqlConnection != null && sqlStatement != null && !sqlStatement.isEmpty()) {
            Statement statement = sqlConnection.createStatement();

            if (needResult) {
                cachedRowSet = new CachedRowSetImpl();
                cachedRowSet.populate(statement.executeQuery(sqlStatement));
            } else {
                statement.executeUpdate(sqlStatement);
            }
View Full Code Here
97
98
99
100
101
102
103
104
105
106
107
        CachedRowSet cachedRowSet = null;
        Connection sqlConnection = getConnection(credentials);

        if (sqlConnection != null && preparedStatement != null) {
            if (needResult) {
                cachedRowSet = new CachedRowSetImpl();
                cachedRowSet.populate(preparedStatement.executeQuery());
            } else {
                preparedStatement.executeUpdate();
            }
View Full Code Here
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
    public RowSet mapToResultType(ControlBeanContext context, Method m, ResultSet resultSet, Calendar cal) {
        final SQL methodSQL = (SQL) context.getMethodPropertySet(m, SQL.class);
        final int maxrows = methodSQL.maxRows();

        try {
            CachedRowSetImpl rows = new CachedRowSetImpl();

            if (maxrows > 0) {
                rows.setMaxRows(maxrows);
            }

            rows.populate(resultSet);
            return rows;
        } catch (SQLException e) {
            throw new ControlException(e.getMessage(), e);
        }
    }
View Full Code Here
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
    public RowSet mapToResultType(ControlBeanContext context, Method m, ResultSet resultSet, Calendar cal) {
        final SQL methodSQL = (SQL) context.getMethodPropertySet(m, SQL.class);
        final int maxrows = methodSQL.maxRows();

        try {
            CachedRowSetImpl rows = new CachedRowSetImpl();

            if (maxrows > 0) {
                rows.setMaxRows(maxrows);
            }

            rows.populate(resultSet);
            return rows;
        } catch (SQLException e) {
            throw new ControlException(e.getMessage(), e);
        }
    }
View Full Code Here
73
74
75
76
77
78
79
   * @throws SQLException if thrown by JDBC methods
   * @see #createSqlRowSet
   * @see com.sun.rowset.CachedRowSetImpl
   */
  protected CachedRowSet newCachedRowSet() throws SQLException {
    return new CachedRowSetImpl();
  }
View Full Code Here
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
         connection = dao_.getExoDatasource().getConnection();
         Statement statement =
            connection.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE, ResultSet.CONCUR_READ_ONLY);
         ResultSet resultSet = statement.executeQuery(query);

         CachedRowSet crs = new CachedRowSetImpl();
         crs.setPageSize(pageList.getPageSize());
         crs.populate(resultSet, (pageList.getCurrentPage() - 1) * pageList.getPageSize() + 1);

         while (crs.next())
         {
            T bean = dao_.createInstance();
            dao_.getDBObjectMapper().mapResultSet(crs, bean);
            currentListPage_.add(bean);
         }
View Full Code Here
352
353
354
355
356
357
358
359
360
361
362
363
          if (scrolling)
            model =  m_model.buildTableModel(rs);
            //model = new DefaultTableModel();
         
          else {
            CachedRowSet crs = new CachedRowSetImpl();
            crs.populate(rs);
            model = m_model.buildTableModel(crs);
          }

          table.setModel(model);
         
View Full Code Here
17
18
19
20
21
22
23
24
25
26
27
   {
      // load the MySQL driver
      Class.forName( "com.mysql.jdbc.Driver" );
     
      // specify properties of CachedRowSet
      rowSet = new CachedRowSetImpl(); 
      rowSet.setUrl( "jdbc:mysql://localhost/guestbook" );
      rowSet.setUsername( "jhtp6" );
      rowSet.setPassword( "jhtp6" );

    // obtain list of titles
View Full Code Here
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
         connection = dao_.getExoDatasource().getConnection();
         Statement statement =
            connection.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE, ResultSet.CONCUR_READ_ONLY);
         ResultSet resultSet = statement.executeQuery(query);

         CachedRowSet crs = new CachedRowSetImpl();
         crs.setPageSize(pageList.getPageSize());
         crs.populate(resultSet, (pageList.getCurrentPage() - 1) * pageList.getPageSize() + 1);

         while (crs.next())
         {
            T bean = dao_.createInstance();
            dao_.getDBObjectMapper().mapResultSet(crs, bean);
            currentListPage_.add(bean);
         }
View Full Code Here
TOP

Related Classes of com.sun.rowset.CachedRowSetImpl

  • com.deitel.jhtp6.jsp.beans.GuestDataBean
  • com.lbslocal.cc.common.Functions
  • com.lbslocal.cc.core.CommonAddress
  • com.lbslocal.cc.core.CommonProximity
  • com.lbslocal.cc.view.CRouteAPI
  • Controller$Lista_Listener
  • er.extensions.jdbc.ERXJDBCUtilities
  • GenericDBMS.DBDataSet
  • GenericDBMS.OfflineStatement
  • net.helipilot50.stocktrade.genericdbms.DBDataSet
    • Copyright © 2018 www.massapicom. All rights reserved.
    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.