在hibernate4.3.5+struts2.0中实现从数据库中读取数据存在list中,然后取出的时候就是显现不了
package lee;
import org.hibernate.Transaction;
import org.hibernate.Session;
import java.text.DateFormat;
import java.text.SimpleDateFormat;
import java.util.*;
import org.crazyit.app.domain.*;
public class HqlQuery
{
public static void main(String[] args)
throws Exception
{
HqlQuery mgr = new HqlQuery();
mgr.findPersonProperty();
}
// 第三个查询方法:查询属性
public List<myBook> findPersonProperty()
{
// 获得Hibernate Session
Session sess = HibernateUtil.currentSession();
// 开始事务
Transaction tx = sess.beginTransaction();
// 以HQL语句创建Query对象.
List list = sess.createQuery("select mb.bookAuthor,mb.bookName , mb.bookPrice,mb.image "
+ "from myBook mb").list();
// Query调用list()方法访问查询得到的全部属性
// 遍历查询的全部结果
for (Object ele : list)
{
Object[] objs = (Object[])ele;
System.out.println(java.util.Arrays.toString(objs));
}
// 提交事务
tx.commit();
HibernateUtil.closeSession();
return list;
}
}
}
package org.crazyit.app.action;
import java.util.List;
import lee.HqlQuery;
import org.crazyit.app.domain.myBook;
import com.opensymphony.xwork2.ActionContext;
public class testAction {
public String execute() throws Exception
{
myBook mb=new myBook();
HqlQuery mgr = new HqlQuery();
List list=mgr.findPersonProperty();
ActionContext.getContext().put("list", list);
return "success";
}
}
<%@taglib prefix="s" uri="/struts-tags" %>
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
Insert title here
/s:debug
name | author | price | image |
---|---|---|---|
${mb.bookName} | ${mb.bookAuthor} | ${mb.bookPrice} |