Thanks for sharing your approach Douglas, Kim.
I was wondering what the most elegant way of making the handle available
was when 99% of queries are well supported by the @SqlQuery("…");
On Tuesday, October 18, 2016 at 10:09:38 AM UTC-7, Kim Kantola wrote:
>
> Thank you so much Evan and Douglas for taking the time to help.
> I did end up going with your approach Douglas, I am using annotated SQL
> where I can, but for the dynamic queries, I am using the jdbi handle and
> executing the SQL that way.
>
> In case anyone else finds this thread looking for similar help, I should
> add that in my DAO class, I imported the following class which comes
> bundled with dropwizard
> org.skife.jdbi.v2.sqlobject.mixins.GetHandlecode here...
>
>
> Then, I made my class implement GetHandle, by doing that, I can then do
>
> this.getHandle();
>
> in order to get access to the database connection.
>
>
> On Friday, October 14, 2016 at 1:15:11 PM UTC-7, Kim Kantola wrote:
>>
>> Hi All,
>>
>> I am new to JDBI. I have seen several simple examples of annotating a
>> DAO with a query like "Select * from tableName where id=?".
>>
>> Could someone point me to documentation for more complex queries such as
>> searching by a dynamic list of parameters? For example, a user can search
>> by name, age, id, height, etc, but I am unaware until runtime which
>> combination of these search parameters may come in to my search method. I
>> may not get a search value for age, and so do not need to bind anything to
>> the search query for that.
>>
>> Any pointers appreciated,
>> ~Kim
>>
>
--
You received this message because you are subscribed to the Google Groups
"dropwizard-user" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
For more options, visit https://groups.google.com/d/optout.
