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