spring+hibernate3.0.5 的HQL中文搜索解决方法

/** 获取某人在某时间段内的访问记录 */
    public List getLogs (String trueName, String topDate, String bottomDate){
    List list = new ArrayList();
    Object [] parameter={"%"+trueName+"%"};
    String sql = "select s from Usrs u join u.SYSLOGSs s where u.TrueName like ? and s.OpeDatetime<='"+topDate+"' and s.OpeDatetime>='"+bottomDate+"'";
    list = this.getHibernateTemplate().find(sql,parameter);
    return list;
    }