Package org.apache.commons.dbutils

Examples of org.apache.commons.dbutils.ResultSetHandler

553
554
555
556
557
558
559
560
561
562
563
    Map columnMap)
    throws ControllerException, UpdaterException {

    Connection conn = null;
    QueryRunner queryRunner = new QueryRunner(dataSource);
    ResultSetHandler rsh = new MapHandler();
    String sql = null;

    try {
      conn = dataSource.getConnection();
      conn.setAutoCommit(false); // Start transaction
View Full Code Here
701
702
703
704
705
706
707
708
709
710
711
    if (!isDefault) {
      return;
    }

    QueryRunner queryRunner = new QueryRunner(dataSource);
    ResultSetHandler rsh = new MapHandler();
    String sql = null;
    sql = "select * from " + tableName;
    sql += " where (";
    sql += " (is_default=true)";

View Full Code Here
33
34
35
36
37
38
39
40
41
42
43
 
  public void go() {
   
    DataSource dataSource= DataSourceHandler.getDataSource();
    QueryRunner runner = new QueryRunner(dataSource);
    ResultSetHandler rsh = new MapHandler();
    String sql = "select * from Client where (ClientID=1)";
    Map clientMap = null;
    try {
      clientMap = (Map) runner.query(sql, null, rsh);
    } catch (SQLException se) {
View Full Code Here
116
117
118
119
120
121
122
123
124
125
126
   */
  public List findAllWhere(String tableName, String orderClause, String whereClause)
  throws ControllerException  {

    QueryRunner queryRunner = new QueryRunner();
    ResultSetHandler rsh = new MapListHandler();
    String sql = null;

    try {
      sql = "SELECT * FROM " + tableName;
     
View Full Code Here
150
151
152
153
154
155
156
157
158
159
160
   */
  public Map findWhere(String tableName, String whereClause)
  throws ControllerException, FinderException  {

    QueryRunner queryRunner = new QueryRunner();
    ResultSetHandler rsh = new MapListHandler();
    String sql = null;

    try {
      sql = "SELECT * FROM " + tableName;
     
View Full Code Here
294
295
296
297
298
299
300
301
302
303
304
   */
  public int updateRecord(String tableName, String primaryKeyName, Map columnMap) 
    throws ControllerException, UpdaterException  {
   
    QueryRunner queryRunner = new QueryRunner();
    ResultSetHandler rsh = new MapHandler();
    String sql = null;

    try {
      sql = "select * from " + tableName;
      sql += " where (" + primaryKeyName + "=?)";
View Full Code Here
79
80
81
82
83
84
85
86
87
88
89
    throws ControllerException  {
   
    List resultList = new ArrayList();
    Map titleMap;
    QueryRunner queryRunner = new QueryRunner(dataSource);
    ResultSetHandler rsh = new MapListHandler();
    String sql = null;

    try {
      sql = "select * from contact_detail, contact_type";
      sql += " where (";
View Full Code Here
109
110
111
112
113
114
115
116
117
118
119
  public Map findDefaultContactDetails(int clientID)
    throws ControllerException  {
   
      DataSource dataSource = DataSourceHandler.getDataSource();
      QueryRunner queryRunner = new QueryRunner(dataSource);
      ResultSetHandler rsh = new MapHandler();
      String sql = null;

      try {
        sql = "select * from contact_detail INNER JOIN contact_type ON (contact_detail.contact_type_id=contact_type.contact_type_id)";
        sql += " where (";
View Full Code Here
176
177
178
179
180
181
182
183
184
185
186
   */
  public List findPayments(int invoiceID)
    throws ControllerException  {
   
    QueryRunner queryRunner = new QueryRunner(dataSource);
    ResultSetHandler rsh = new MapListHandler();
    String sql = null;

    try {
      // Get connection from the connection pool
      sql = "select * from payment, tender";
View Full Code Here
206
207
208
209
210
211
212
213
214
215
216
217
   */
  public List findInvoices(int clientID)
      throws ControllerException  {
   
    QueryRunner queryRunner = new QueryRunner(dataSource);
    ResultSetHandler mapListRsh = new MapListHandler();
    ResultSetHandler mapRsh = new MapHandler();
    String sql = null;
 
    try {
      // Get connection from the connection pool
      sql = "select * from invoice";
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.