getHibernateTemplate().find 问题?

[gyscsdn]

请教高手：
其他配置一样，只是下面的代码不一样，一个能查询到数据，另一个什么也查不到！
什么也查不到：
public List loadGoods(String strCategoryId)
{
StringBuffer sbSql = new StringBuffer();
sbSql.append("select ");
sbSql.append( "gi.goodsName,");
sbSql.append( "gi.price,");
sbSql.append( "gi.imageFile,");
sbSql.append( "gi.SComments,");
sbSql.append( "gi.LComments,");
sbSql.append( "gi.deleteDate ");
sbSql.append("from ");
sbSql.append( "TGood gi,");
sbSql.append( "TGoodsCategory gci ");
sbSql.append("where ");
sbSql.append( "gi.shopId = gci.shopId ");
sbSql.append( "and gi.categoryId = gci.categoryId ");
sbSql.append( "and gci.categoryId=?");

List retList = new ArrayList();
retList = getHibernateTemplate().find(sbSql.toString(),strCategoryId);

return retList;
}



能查询到数据：
public List loadGoods(String strCategoryId)
{
StringBuffer sbSql = new StringBuffer();
sbSql.append("select ");
sbSql.append( "gi.goodsName,");
sbSql.append( "gi.price,");
sbSql.append( "gi.imageFile,");
sbSql.append( "gi.SComments,");
sbSql.append( "gi.LComments,");
sbSql.append( "gi.deleteDate ");
sbSql.append("from ");
sbSql.append( "TGood gi,");
sbSql.append( "TGoodsCategory gci ");
sbSql.append("where ");
sbSql.append( "gi.shopId = gci.shopId ");
sbSql.append( "and gi.categoryId = gci.categoryId ");
sbSql.append( "and gci.categoryId='" + strCategoryId + "'" );

List retList = new ArrayList();
retList = getHibernateTemplate().find(sbSql.toString());

return retList;
}

[gyscsdn]

没有人知道？

[0xTonyWang]

用这种方法:
List orgList = getHibernateTemplate().find("from Organization org " +
" where org.survey_id = ?",new Object[]{id});

[keerqin]

用回调函数

[有来有往]

Hibernate 自动生成的DAO里面有一个 FindByExemple（Object object） 方法怎么用啊

[gyscsdn]

该问题已解决了：
是由于使用了Oracle DB 的 char 字段带来的问题！