Hibernate里怎么把查询的结果集,显示出来,hibernate查询
分享于 点击 21636 次 点评:279
Hibernate里怎么把查询的结果集,显示出来,hibernate查询
<%String name=request.getAttribute("name").toString();String phone=request.getAttribute("phone").toString();
String address=request.getAttribute("address").toString();
Iterator iter=DAOFactory.getAddressbookDAOInstance().searchUser(name, phone, address);
while(iter.hasNext())
{ Object[] result=(Object[])iter.next();
%>
<tr>
<td><%=result[0]%></td>
<td><%=result[1]%></td>
<td><%=result[2]%></td>
<td><%=result[3]%></td>
</tr> 其中的DAOFactory.getAddressbookDAOInstance().searchUser(name, phone, address)方法如下: public Iterator searchUser(String name, String phone, String address) {
// TODO Auto-generated method stub
String strsql=new String("select * from addressbook where");
if(!name.equals(""))
strsql=strsql+"name like '"+name+"%' and";
if(!phone.equals(""))
strsql=strsql+"phone like '"+phone+"%' and";
if(!address.equals(""))
strsql=strsql+"address like '"+address+"%'";
else
strsql=strsql.substring(0,strsql.length()-3);
strsql=strsql+"order by ID";
Query q=this.session.createQuery(strsql);
Iterator iter =q.list().iterator();
//Iterator iter=q.list().iterator();
return iter;
}
相关文章
- 暂无相关文章
用户点评