Mailing-List: contact user-java-help@ibatis.apache.org; run by ezmlm
Precedence: bulk
Reply-To: user-java@ibatis.apache.org
Received-SPF: pass (athena.apache.org: domain of clinton.begin@gmail.com
 designates 209.85.221.201 as permitted sender)
DomainKey-Signature: a=rsa-sha1; c=nofws;
        d=gmail.com; s=gamma;
        h=mime-version:in-reply-to:references:date:message-id:subject:from:to
         :content-type;
        b=tScL7ZRda6tsxBC4JJBdND7GBHQR7GMmH2ZP4QhQj3NJDwCutZg0+JeJgLGJ71b+mM
         YxD/JS/Tz/84x0dMZyD5/XX+pv8PFlzV23gWpj9tyaa21wKcTYQUeaPogRH7xIyEZOGd
         fBphvFnx+AXltIsFUB/tCFY4iDjyKl+wPc7TE=
MIME-Version: 1.0
In-Reply-To: <27148804.post@talk.nabble.com>
References: <27148804.post@talk.nabble.com>
Date: Wed, 13 Jan 2010 11:42:52 -0700
Message-ID: <16178eb11001131042p26ad6ea7h56f37045816841ee@mail.gmail.com>
Subject: Re: How to use @SelectProvider
From: Clinton Begin <clinton.begin@gmail.com>
To: user-java@ibatis.apache.org
Content-Type: multipart/alternative; boundary=00c09f9725055e0b3d047d1023b6

--00c09f9725055e0b3d047d1023b6
Content-Type: text/plain; charset=ISO-8859-1

@SelectProvider should be applied to your Mapper interface.  For example:

public interface MyMapper {
  @Select("SELECT * FROM users")
  User selectUsers();
}

The SelectProvider equivalent of this would be:


public interface MyMapper {
  @SelectProvider(type=com.me.SomeHelperClass,method="getSelectAllUsersSQL")

  User selectUsers();
}

public clas SomeHelperClass {
  public String getSelectAllUsersSQL() {
    return "SELECT * FROM users";
  }
}

Cheers,
Clinton


On Wed, Jan 13, 2010 at 11:37 AM, kruba02 <kruba02@ca.com> wrote:

>
> Hi,
>
> I am trying to execute a dynamic/custom query using iBATIS (using
> #SelectProvider) and am facing a couple of issues.
>
> 1. I have something like @SelectProvider(method = "selectTest", type =
> "com.a.b.DynamicSQL") where method is the method-name and type is the name
> of the class. I get an error here. Both the class and method exist.
> selectTest looks like following. Any idea how I can remove the error?
>
> public String selectTest(){
>                BEGIN();
>                SELECT("*");
>                FROM("test");
>                return SQL();
>        }
>
> 2. The documentation says that @SelectProvider is a method annotation. If I
> annotate a method say Foo() using the above @SelectProvider, what should
> the
> method itself have?
>
> 3. Lastly, how do I invoke this select query?
>
> Your help is much appreciated. Sorry, I am just getting started with
> iBATIS.
> Also, are there any other ways to execute queries which are constructed on
> the fly?
>
> Thanks in advance for your help.
> KA
> --
> View this message in context:
> http://old.nabble.com/How-to-use-%40SelectProvider-tp27148804p27148804.html
> Sent from the iBATIS - User - Java mailing list archive at Nabble.com.
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: user-java-unsubscribe@ibatis.apache.org
> For additional commands, e-mail: user-java-help@ibatis.apache.org
>
>

--00c09f9725055e0b3d047d1023b6
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable

@SelectProvider should be applied to your Mapper interface.=A0 For example:=
<br><br>public interface MyMapper {<br>=A0 @Select(&quot;SELECT * FROM user=
s&quot;)<br>=A0 User selectUsers();<br>}<br><br>The SelectProvider equivale=
nt of this would be:<br>
<br><br>public interface MyMapper {<br>
=A0 @SelectProvider(type=3Dcom.me.SomeHelperClass,method=3D&quot;getSelectA=
llUsersSQL&quot;) <br>
=A0 User selectUsers();<br>
}<br><br>public clas SomeHelperClass {<br>=A0 public String getSelectAllUse=
rsSQL() {<br>=A0 =A0 return &quot;SELECT * FROM users&quot;;<br>=A0 }<br>}<=
br><br>Cheers,<br>Clinton<br>
<br><br><br><div class=3D"gmail_quote">On Wed, Jan 13, 2010 at 11:37 AM, kr=
uba02 <span dir=3D"ltr">&lt;<a href=3D"mailto:kruba02@ca.com">kruba02@ca.co=
m</a>&gt;</span> wrote:<br><blockquote class=3D"gmail_quote" style=3D"borde=
r-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-le=
ft: 1ex;">
<br>
Hi,<br>
<br>
I am trying to execute a dynamic/custom query using iBATIS (using<br>
#SelectProvider) and am facing a couple of issues.<br>
<br>
1. I have something like @SelectProvider(method =3D &quot;selectTest&quot;,=
 type =3D<br>
&quot;com.a.b.DynamicSQL&quot;) where method is the method-name and type is=
 the name<br>
of the class. I get an error here. Both the class and method exist.<br>
selectTest looks like following. Any idea how I can remove the error?<br>
<br>
public String selectTest(){<br>
 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0BEGIN();<br>
 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0SELECT(&quot;*&quot;);<br>
 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0FROM(&quot;test&quot;);<br>
 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0return SQL();<br>
 =A0 =A0 =A0 =A0}<br>
<br>
2. The documentation says that @SelectProvider is a method annotation. If I=
<br>
annotate a method say Foo() using the above @SelectProvider, what should th=
e<br>
method itself have?<br>
<br>
3. Lastly, how do I invoke this select query?<br>
<br>
Your help is much appreciated. Sorry, I am just getting started with iBATIS=
.<br>
Also, are there any other ways to execute queries which are constructed on<=
br>
the fly?<br>
<br>
Thanks in advance for your help.<br>
KA<br>
<font color=3D"#888888">--<br>
View this message in context: <a href=3D"http://old.nabble.com/How-to-use-%=
40SelectProvider-tp27148804p27148804.html" target=3D"_blank">http://old.nab=
ble.com/How-to-use-%40SelectProvider-tp27148804p27148804.html</a><br>
Sent from the iBATIS - User - Java mailing list archive at Nabble.com.<br>
<br>
<br>
---------------------------------------------------------------------<br>
To unsubscribe, e-mail: <a href=3D"mailto:user-java-unsubscribe@ibatis.apac=
he.org">user-java-unsubscribe@ibatis.apache.org</a><br>
For additional commands, e-mail: <a href=3D"mailto:user-java-help@ibatis.ap=
ache.org">user-java-help@ibatis.apache.org</a><br>
<br>
</font></blockquote></div><br>

--00c09f9725055e0b3d047d1023b6--