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