方法一 ---------------------------------------------------------------------
首先生成2个表的HBM文件(注意,在建立HBM之前一定要参照“Hibernate建立HBM文件时候必须不要勾选的选项.jpg” 建立)
<mapping resource="com/saftsale/test/TopProductsDeputy.hbm.xml" />
<mapping resource="com/saftsale/test/TopProducts.hbm.xml" />
在DAO中这样写 (注意Select * from是错误的,必须写出你要查询的字段名称 .
注意 from TopProducts 不是表名而是HBM中的名字,搜索的字段也是一样全部以bean中的字段为准)
public List getProductsMenuSub(String classCode,String WEBNAME)
{
log.debug("getProductsMenuSub");
try
{
String queryString = "select a.productsName from TopProducts as a, TopProductsDeputy as b where a.productsId = b.productsId and b.productsClass = '"+ classCode +"' and b.productsWebSite = '"+ WEBNAME+"'";
Query queryObject = getSession().createQuery(queryString);
return queryObject.list();
}
catch (RuntimeException re)
{
log.error("getProductsMenuSub have error", re);
throw re;
}
}
本内容试读结束,登录后可阅读更多
下载后可阅读完整内容,剩余3页未读,立即下载