Hi Dan, Thanks a lot!
Mithra Rajah -----Original Message----- From: Daniel Henrique Ferreira e Silva [mailto:[EMAIL PROTECTED] Sent: Wednesday, October 26, 2005 2:55 PM To: [email protected] Subject: Re: How to set up a select map Hi Mithra, 1) Create a result-map from your expected resultset to your bean. Like: <resultMap id="foo"> .... map your resultset fields to bean properties here .... </resultMap> 2) Create the statement: <select id="getAllUsers" resultMap="foo"> select * from User </select> 3) In your java code do this: List allUsers = queryForList("getAllUsers"); You'll find more details in the Developer's Guide. Hope that helped, Daniel Silva. On 10/26/05, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote: > > Thanks a lot! It works. > > I had another question as well. I want to select a full table of data; > (Select * from User) . > How can I collect the result? (I have a class & beans for each row & an > array list to store the rows). > > Thanks, > > > Mithra Rajah > > > > ________________________________ > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of > Larry Meadors > Sent: Wednesday, October 26, 2005 11:53 AM > To: [email protected] > Subject: Re: How to set up a select map > > > Three ways: > > 1) Use "where value like #property# and put the pattern in your property. > > 2) Use "where value like '%' || #property# || '%'and put the value in your > property. > > 3) Use "where value like '%$property$%" and put the value in your property. > > The last option will open you you up to SQL injection, and is generally bad > practice. It also does not take advantage of some database vendors' > execution plan caching. > > Larry > > > > On 10/26/05, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote: > > > > Hi, > > I want to do a pattern matching search on the database; for e.g select all > rows that have text "ab" in them. The text can occur independantly or > embedded. How do I do a pattern matching Select with the IBATIS map? > > Thanks, > > > > Mithra Rajah > > > >
