userloghibernate.java

不错一代吗

package com.hibernate.dao;
import java.text.SimpleDateFormat;
import java.util.Date;
import java.util.List;
import org.hibernate.Query;
import org.hibernate.Session;
import com.HibernateSessionFactory;
import com.hibernate.bean.UserLog;

public class UserLogHibernate {
   public static String creatXML(String date)
   {
	   String xmlstart="<table width='98%' height='30'><tr><td  colspan='2' bgcolor='#98B8CD'>"+date+"</td></tr>";
	   String xmlbody="";
	   String xmlend="</table>";
	   Session session=HibernateSessionFactory.getSession();
	   String hql=" from UserLog where year(starttime)=year('"+date+"') and month(starttime)=month('"+date+"') and day(starttime)=day('"+date+"')";
	   Query query=session.createQuery(hql);
	   List ls=query.list();
	   for(int i=0;i<ls.size();i++)
	   {
		   UserLog ul=(UserLog)ls.get(i);
		   Date time=ul.getStarttime();
		   SimpleDateFormat simp=new SimpleDateFormat("HH:mm:ss");
		   xmlbody=xmlbody+"<tr><td width='15%'>"+simp.format(time)+"</td><td>"+ul.getContent()+"</td></tr>";
	   }
	   String xml=xmlstart+xmlbody+xmlend;
	   session.close();
	   return xml;
   }
}