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

        Transition Time In Source Status Execution Times Last Executer Last Execution Date
        Open Open Closed Closed
        291d 15h 5m 1 Dennis Lundberg 16/Mar/08 22:48
        Dennis Lundberg made changes -
        Resolution Fixed [ 1 ]
        Status Open [ 1 ] Closed [ 6 ]
        Fix Version/s 1.2 [ 12312139 ]
        Assignee Dennis Lundberg [ dennisl@apache.org ]
        Hide
        Dennis Lundberg added a comment -

        Fixed in r637681.

        Show
        Dennis Lundberg added a comment - Fixed in r637681.
        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
        David Portabella created issue -

          People

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

            Dates

            • Created:
              Updated:
              Resolved:

              Development