做了一个测试项目
hibernate3.x+mysql3.0
使用自动生成的dao类，但是根据字符串类型参数查询的话就查询不到任何结果。一开始考虑可能是编码的问题，但是在页面测试输出没有问题。下面是代码，大家帮忙看看。
<%
//jsp中的代码
out.print("<br /><br /><font color='red'>根据类别编号查询:</font><br />");
TableNewsDAO dao = new TableNewsDAO();
List<TableNews> list = dao.findByNewsTypeId(1);
out.print(list.size());
for(TableNews model : list){
out.print(model.getNewsTitle()+"<br />");
}
out.print("<br /><br /><font color='red'>根据新闻标题查询:</font><br />");
List<TableNews> list1 = dao.findByNewsTitle("朝阳大棚棉被网站隆重上线运营");
out.print(list1.size());
for(TableNews model : list1){
out.print(model.getNewsTitle());
}
%>
//DAO中的代码
public List findByProperty(String propertyName, Object value) {
log.debug("finding TableNews instance with property: " + propertyName
+ ", value: " + value);
try {
String queryString = "from TableNews as model where model."
+ propertyName + "= ?";
Query queryObject = getSession().createQuery(queryString);
queryObject.setParameter(0, value);
return queryObject.list();
} catch (RuntimeException re) {
log.error("find by property name failed", re);
throw re;
}
}
public List findByNewsTitle(Object newsTitle) {
return findByProperty(NEWS_TITLE, newsTitle);
}
<?xml version="1.0" encoding="utf-8"?>
<!DOCTYPE hibernate-mapping PUBLIC "-//Hibernate/Hibernate Mapping DTD 3.0//EN"
"http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd">
<hibernate-mapping>
<class name="com.zhang.bean.TableNews" table="table_news" catalog="lncorp">
<id name="newsId" type="java.lang.Integer">
<column name="NewsID" />
<generator class="native" />
</id>
<property name="newsTitle" type="java.lang.String">
<column name="NewsTitle" />
</property>
<property name="newsImgUrl" type="java.lang.String">
<column name="NewsImgURL" />
</property>
<property name="newsContent" type="java.lang.String">
<column name="NewsContent" />
</property>
<property name="newsAddDate" type="java.sql.Timestamp">
<column name="NewsAddDate" length="0" />
</property>
<property name="newsUpdateDate" type="java.sql.Timestamp">
<column name="NewsUpdateDate" length="0" />
</property>
<property name="newsTypeIntro" type="java.lang.String">
<column name="NewsTypeIntro" />
</property>
<property name="author" type="java.lang.String">
<column name="Author" />
</property>
<property name="newsTypeId" type="java.lang.Integer">
<column name="NewsTypeID" />
</property>
<property name="remark" type="java.lang.String">
<column name="Remark" />
</property>
</class>
</hibernate-mapping>
