- 论坛徽章:
- 0
|
要从数据库中获得数据,要从BB(business bean)开始,在BB中声明UCC,调用UCC的数据库查询函数,UCC中的函数在IUCC(UCC接口中定义),在UCC中实现,UCC文件中使用相应的BS,再调用BS中相应的函数,此函数在IBS中声明(BS接口定义),BS文件中使用publicDao的相应函数,此函数在IPublicDao中定义,在publicDao中才形成查询语句,通过Hibernate执行查询。
例子:查询客户名为customerBaseId的客户信息
====CreditBadDebtBB.java=====
IPlanCaseBasicInfoUCC planUCC;//使用IUCC
// 客户基本信息
List baseList;
baseList = planUCC.findByAny("CustomerBaseBO", "customerBaseId", String.valueOf(customerBaseId), "");
if (baseList != null && baseList.size() > 0) {
//取得客户信息BO,BO为系统根据数据库表自动生成,一个数据库表对应一个BO文件(*BO.java),一个BO对象对应数据库中的一条记录
customerBaseBO = (CustomerBaseBO) baseList.iterator().next();
}
===============================
====IPlanCaseBasicInfoUCC.java=====
//声明findByAny()函数
public List findByAny(String boName,String attributeName ,Object attributeValue,String order) throws BizException;
===================================
====PlanCaseBasicInfoUCC.java=====
IPlanCaseBasicInfoBS planCaseBasicInfoBS;
public List findByAny(String boName, String attributeName, Object attributeValue, String order) throws BizException {
return planCaseBasicInfoBS.findByAny(boName,attributeName,attributeValue,order);
}
===================================
====IPlanCaseBasicInfoBS.java=====
//声明findByAny()函数
public List findByAny(String boName,String attributeName ,Object attributeValue,String order) throws BizException;
===================================
=====PlanCaseBasicInfoBS.java=====
private IPublicDao publicDAO;
public List findByAny(String boName, String attributeName, Object attributeValue, String order) throws BizException {
return publicDAO.findByAny(boName, attributeName,attributeValue,order);
}
===================================
=====IPublicDao.java=====
public List findByAnyString(String boname,String attributename,String attributevalue,String order);
==========================
====PublicDao.java=====
private HibernateTemplate hibernateTemplate;
public List findByAny(String boname,String attributename,Object attributevalue,String order){
if(order == null) order = "";
String hql = "from "+boname+" as bo where bo."+attributename+"="+attributevalue+order;
log.debug(hql);
System.out.println(hql);
return hibernateTemplate.find(hql);
}
==========================
本文来自ChinaUnix博客,如果查看原文请点:http://blog.chinaunix.net/u/24352/showart_184525.html |
|