iBatis多表查询

typeAlias alias=Product type=com.shopping.entity.Product/ typeAlias alias=ProductType type=com.shopping.entity.ProductType/ resultMap id=queryAllProduct class=Product result property=proId column=proid/ result property=proName column=prona

  select typeid,typename from producttype where typeid=#typeid#

  select proid,proname,prodesc,price,img,protime,size,typeid from product