Package org.apache.commons.dbutils

Examples of org.apache.commons.dbutils.ResultSetHandler

266
267
268
269
270
271
272
273
274
275
276
    throws ControllerException  {
   
    List resultList = new ArrayList();
    Map roleMap;
    QueryRunner queryRunner = new QueryRunner(dataSource);
    ResultSetHandler rsh = new MapListHandler();
    String sql = null;

    try {
      // Get connection from the connection pool
      sql = "select * from person_role, role";
View Full Code Here
79
80
81
82
83
84
85
86
87
88
89
90
    DataSourceHandler.setUserName(userName);
    DataSourceHandler.setPassword(passWordInPlainText);
    DataSource dataSource = DataSourceHandler.getDataSource();
   
    QueryRunner queryRunner = new QueryRunner(dataSource);
    ResultSetHandler rshMap = new MapHandler();
    ResultSetHandler rshList = new MapListHandler();

    try {
      String sql =
        "select * from person" + " where (" + " (user_name=?)" + " )";
      personMap = (Map) queryRunner.query(sql, userName, rshMap);
View Full Code Here
189
190
191
192
193
194
195
196
197
198
199
   */
  public static void logoffPerson() {

    DataSource dataSource = DataSourceHandler.getDataSource();
    QueryRunner queryRunner = new QueryRunner(dataSource);
    ResultSetHandler rshMap = new MapHandler();

    try {
      String sql =
        "update login"
          + " set logoff_date=CURRENT_TIMESTAMP"
View Full Code Here
35
36
37
38
39
40
41
42
43
44
45
      System.out.println(se.getMessage());
      return;
    }
   
    QueryRunner runner = new QueryRunner();
    ResultSetHandler rsh = new MapHandler();
    String sql = null;
    Map clientMap = null;
    Object obj = null;
   
    try {
View Full Code Here
80
81
82
83
84
85
86
87
88
89
90
91
  public BeanHandlerTest(String name) {
    super(name);
  }

  public void testHandle() throws SQLException {
    ResultSetHandler h = new BeanHandler(TestBean.class);
        TestBean results = (TestBean) h.handle(this.rs);
       
    assertNotNull(results);
    assertEquals("1", results.getOne());
    assertEquals("2", results.getTwo());
    assertEquals("3", results.getThree());
View Full Code Here
91
92
93
94
95
96
97
98
99
100
    assertEquals("3", results.getThree());
        assertEquals("not set", results.getDoNotSet());
  }
   
    public void testEmptyResultSetHandle() throws SQLException {
        ResultSetHandler h = new BeanHandler(TestBean.class);
        TestBean results = (TestBean) h.handle(this.emptyResultSet);
       
        assertNull(results);
    }
View Full Code Here
82
83
84
85
86
87
88
89
90
91
92
93
  public BeanListHandlerTest(String name) {
    super(name);
  }

  public void testHandle() throws SQLException {
    ResultSetHandler h = new BeanListHandler(TestBean.class);
    List results = (List) h.handle(this.rs);

    assertNotNull(results);
    assertEquals(ROWS, results.size());

    Iterator iter = results.iterator();
View Full Code Here
102
103
104
105
106
107
108
109
110
111
112
    assertEquals("6", row.getThree());
    assertEquals("not set", row.getDoNotSet());
  }

  public void testEmptyResultSetHandle() throws SQLException {
    ResultSetHandler h = new BeanListHandler(TestBean.class);
    List results = (List) h.handle(this.emptyResultSet);

    assertNotNull(results);
    assertTrue(results.isEmpty());
  }
View Full Code Here
81
82
83
84
85
86
87
88
89
90
91
92
  public ArrayListHandlerTest(String name) {
    super(name);
  }

  public void testHandle() throws SQLException {
    ResultSetHandler h = new ArrayListHandler();
    List results = (List) h.handle(this.rs);

    assertNotNull(results);
    assertEquals(ROWS, results.size());

    Iterator iter = results.iterator();
View Full Code Here
100
101
102
103
104
105
106
107
108
109
110
    assertEquals("5", row[1]);
    assertEquals("6", row[2]);
  }

  public void testEmptyResultSetHandle() throws SQLException {
    ResultSetHandler h = new ArrayListHandler();
    List results = (List) h.handle(this.emptyResultSet);

    assertNotNull(results);
    assertTrue(results.isEmpty());
  }
View Full Code Here
TOP

Related Classes of org.apache.commons.dbutils.ResultSetHandler

  • hermes.store.schema.DefaultJDBCAdapter
  • nz.co.transparent.client.controller.GenericController
  • nz.co.transparent.client.controller.GenericTransactionController
  • nz.co.transparent.client.controller.LoginController
  • nz.co.transparent.client.controller.SpecificController
  • nz.co.transparent.client.controller.SystemDBController
  • nz.co.transparent.client.util.Parameter
  • org.apache.commons.dbutils.handlers.ArrayHandlerTest
  • org.apache.commons.dbutils.handlers.ArrayListHandlerTest
  • org.apache.commons.dbutils.handlers.BeanHandlerTest
    • 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.