Commons DbUtils
  1. Commons DbUtils
  2. DBUTILS-38

example documentation page, update query

    Details

    • Type: Improvement Improvement
    • Status: Closed
    • Priority: Minor Minor
    • Resolution: Fixed
    • Affects Version/s: None
    • Fix Version/s: 1.2
    • Labels:
      None

      Description

      Hello,

      I came across DBUtils:
      http://jakarta.apache.org/commons/dbutils/examples.html

      and I found your contact email:
      http://jakarta.apache.org/commons/dbutils/team-list.html

      In this example page, you show how to query a db, and get a bean object:

      QueryRunner run = new QueryRunner(dataSource);
      ResultSetHandler h = new BeanHandler(Person.class);
      Person p = (Person) run.query("SELECT * FROM Person WHERE name=?", "John Doe", h); 
      

      It would be great to show also that it can handle list of objects:

      QueryRunner run = new QueryRunner(dataSource);
      ResultSetHandler h = new BeanHandler(Person.class);
      List list = (List) run.query("SELECT * FROM Person WHERE name=?", "John Doe", h); 
      while (Person p : list)
        System.out.println(p);
      

      or something like this.

      More importantly, it is not obvious how to execute an update query, using a bean object.
      I did not find it in the documentation.
      Would it be something like this?

      QueryRunner run = new QueryRunner(dataSource);
      ResultSetHandler h = new BeanHandler(Person.class);
      Person p = (Person) run.query("SELECT * FROM Person WHERE name=?", "John Doe", h); 
      p.setName("new name");
      run.update("UPDATE Person WHERE name = "John Doe", p);
      

      Could you please add the correct example in your example documentation webpage?

      Regards,
      DAvid Portabella

        Activity

        Hide
        Dennis Lundberg added a comment -

        Fixed in r637681.

        Show
        Dennis Lundberg added a comment - Fixed in r637681.

          People

          • Assignee:
            Dennis Lundberg
            Reporter:
            David Portabella
          • Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

            Dates

            • Created:
              Updated:
              Resolved:

              Development