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

        David Portabella created issue -
        Dennis Lundberg made changes -
        Field Original Value New Value
        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
        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:

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

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

        {code}
        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);
        {code}

        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?

        {code}
        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);
        {code}

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


        Regards,
        DAvid Portabella
        Hide
        Dennis Lundberg added a comment -

        Fixed in r637681.

        Show
        Dennis Lundberg added a comment - Fixed in r637681.
        Dennis Lundberg made changes -
        Resolution Fixed [ 1 ]
        Status Open [ 1 ] Closed [ 6 ]
        Fix Version/s 1.2 [ 12312139 ]
        Assignee Dennis Lundberg [ dennisl@apache.org ]
        dennisl committed 637681 (1 file)
        Reviews: none

        [DBUTILS-38] example documentation page, update query.

        - Add examples on how to insert and update data.
        - Add an example on how to use the BeanListHandler to fetch a List of beans.

          People

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

            Dates

            • Created:
              Updated:
              Resolved:

              Development