hibernate查询问题

import java.util.List;

import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;

import org.apache.struts.action.Action;
import org.apache.struts.action.ActionForm;
import org.apache.struts.action.ActionForward;
import org.apache.struts.action.ActionMapping;
import org.hibernate.Hibernate;
import org.hibernate.Query;
import org.hibernate.Session;
import org.hibernate.Transaction;

import com.senyo.database.HibernateUtil;

/**
*
* @author senyo 2009-05-09
* 商品类别及商品的相关操作
*
*/
public class CommodityAction extends Action {

@Override
public ActionForward execute(ActionMapping mapping, ActionForm form,
HttpServletRequest request, HttpServletResponse response)
throws Exception {
List cateList = null;

ActionForward forward=null;

try{
cateList = browseCategory();

if (cateList!=null) {
request.setAttribute("cateList", cateList);

forward=mapping.findForward("index");
}else{
forward=mapping.findForward("error");
}
}catch(Exception e){
e.printStackTrace();
}

return forward;
}
/** 浏览商品分类 */
public List browseCategory() throws Exception {
Session session = HibernateUtil.currentSession();
Transaction tx = null;
List list = null;
try{
Query query = session.createQuery("from Category as c order by c.id");
tx = session.beginTransaction();
list = query.list();
tx.commit();
if (!Hibernate.isInitialized(list)) {
Hibernate.initialize(list);
}
}catch(Exception ex){
if(tx!=null)tx.rollback();
System.out.println("在执行browseCategory方法时出错：\n");
ex.printStackTrace();
}finally{
HibernateUtil.closeSession();
}
return list;
}

}
为什么会是这样？？？？一运行就出现这样的情况！！！！！
Hibernate: select category0_.cateid as cateid1_, category0_.categoryName as category2_1_, category0_.categoryInfo as category3_1_ from t_category category0_ order by category0_.cateid
Hibernate: select category0_.cateid as cateid1_, category0_.categoryName as category2_1_, category0_.categoryInfo as category3_1_ from t_category category0_ order by category0_.cateid
Hibernate: select category0_.cateid as cateid1_, category0_.categoryName as category2_1_, category0_.categoryInfo as category3_1_ from t_category category0_ order by category0_.cateid
Hibernate: select category0_.cateid as cateid1_, category0_.categoryName as category2_1_, category0_.categoryInfo as category3_1_ from t_category category0_ order by category0_.cateid
Hibernate: select category0_.cateid as cateid1_, category0_.categoryName as category2_1_, category0_.categoryInfo as category3_1_ from t_category category0_ order by category0_.cateid
Hibernate: select category0_.cateid as cateid1_, category0_.categoryName as category2_1_, category0_.categoryInfo as category3_1_ from t_category category0_ order by category0_.cateid
Hibernate: select category0_.cateid as cateid1_, category0_.categoryName as category2_1_, category0_.categoryInfo as category3_1_ from t_category category0_ order by category0_.cateid
Hibernate: select category0_.cateid as cateid1_, category0_.categoryName as category2_1_, category0_.categoryInfo as category3_1_ from t_category category0_ order by category0_.cateid
Hibernate: select category0_.cateid as cateid1_, category0_.categoryName as category2_1_, category0_.categoryInfo as category3_1_ from t_category category0_ order by category0_.cateid
Hibernate: select category0_.cateid as cateid1_, category0_.categoryName as category2_1_, category0_.categoryInfo as category3_1_ from t_category category0_ order by category0_.cateid
Hibernate: select category0_.cateid as cateid1_, category0_.categoryName as category2_1_, category0_.categoryInfo as category3_1_ from t_category category0_ order by category0_.cateid
Hibernate: select category0_.cateid as cateid1_, category0_.categoryName as category2_1_, category0_.categoryInfo as category3_1_ from t_category category0_ order by category0_.cateid
Hibernate: select category0_.cateid as cateid1_, category0_.categoryName as category2_1_, category0_.categoryInfo as category3_1_ from t_category category0_ order by category0_.cateid
Hibernate: select category0_.cateid as cateid1_, category0_.categoryName as category2_1_, category0_.categoryInfo as category3_1_ from t_category category0_ order by category0_.cateid
Hibernate: select category0_.cateid as cateid1_, category0_.categoryName as category2_1_, category0_.categoryInfo as category3_1_ from t_category category0_ order by category0_.cateid
Hibernate: select category0_.cateid as cateid1_, category0_.categoryName as category2_1_, category0_.categoryInfo as category3_1_ from t_category category0_ order by category0_.cateid
Hibernate: select category0_.cateid as cateid1_, category0_.categoryName as category2_1_, category0_.categoryInfo as category3_1_ from t_category category0_ order by category0_.cateid
Hibernate: select category0_.cateid as cateid1_, category0_.categoryName as category2_1_, category0_.categoryInfo as category3_1_ from t_category category0_ order by category0_.cateid
Hibernate: select category0_.cateid as cateid1_, category0_.categoryName as category2_1_, category0_.categoryInfo as category3_1_ from t_category category0_ order by category0_.cateid
Hibernate: select category0_.cateid as cateid1_, category0_.categoryName as category2_1_, category0_.categoryInfo as category3_1_ from t_category category0_ order by category0_.cateid
Hibernate: select category0_.cateid as cateid1_, category0_.categoryName as category2_1_, category0_.categoryInfo as category3_1_ from t_category category0_ order by category0_.cateid
Hibernate: select category0_.cateid as cateid1_, category0_.categoryName as category2_1_, category0_.categoryInfo as category3_1_ from t_category category0_ order by category0_.cateid

评论

1 楼 weixla 2009-05-11  

你说为什么会显示SQL语句？？？
改配置文件hibernate.cfg.xml中的hibernate.show_sql属性值 为false
不知道是不是这个意思??