Answer is yes. I tested it out.
mule_user wrote: > > New to iBatis. > > I want to select two colums from TABLE_1 (e.g., COL_A and COL_B) and two > columns from TABLE_2 (e.g, COL_C and COL_D). These 4 columns (selected > from two separate tables) are attributes in MyObj.java (e.g attributeA, > attributeB, attributeC and attributeD) respectively. > > My questions: > 1. Can I avoid writing lengthy resultMap entries and still accomplish the > above? I know that I can accomplish selection from a single table by not > writing resultMap entries. > 2. If the answer to the above question is yes, I would like to verify; if > this magic is possible because of me specifing the attribute name of the > Java object beside the column name as: > T1.COL_A as attributeA, > T1.COL_B as attributeB, > 3. If I did not have entry for resultMap and did not specify matching > column with matching attribute (as shown in point 2 above), was there any > way for iBatis to map database column to object attribute? If yes, is the > requirement is to have the same name of the column as to the name of the > attribute? This is just another question to better understand. It may not > be advisable, nor practical to have same name for the database column and > attribute name for the Java object. > 4. Can I use code similar to the one below and get the result in > MyObj.java, where MyObj.java has 4 attributes namely attributeA, > attributeB, attributeC, attributeD matching COL_A and COL_B from TABLE_1 > and COL_C and COL_D from TABLE_2 respectively. > > <select > id="myQuery" > parameterClass="int" > resultClass="MyObj" > > > select > T1.COL_A as attributeA, > T1.COL_B as attributeB, > T2.COL_C as attributeC, > T2.COL_D as attributeD > from TABLE_1 as T1 > join TABLE_2 as T2 > on T1.COL_A= T2.COL_C > </select> > > -- View this message in context: http://www.nabble.com/Avoid-resultMap-for-Selecting-multiple-columns-from-multiple-tables-tp18927904p18963774.html Sent from the iBATIS - User - Java mailing list archive at Nabble.com.
