hibernateを使用してフィールドの一部をクエリーする方法
1216 ワード
:
List<UserAudit> userList = null;
try {
String hql="select new UserAudit(startip,endip,begintime,endtime) from UserAudit where uname=?";
userList=(List<UserAudit>)super.createQuery(hql, userName).list();
} catch (HibernateException e) {
logger.error(e);
}
:
public class UserAudit implements Serializable{
private Integer uid;
private String uname;
private String upasswd;
private Integer utype;
private Integer umode;
private String uemail;
private String uphone;
private String udescription;
private Date udate;
private String upermission;
private String uclientip;
private Integer udel;
private String startip;
private String endip;
private String begintime;
private String endtime;
public UserAudit() {
super();
}
public UserAudit(String startip, String endip, String begintime,
String endtime) {
super();
this.startip = startip;
this.endip = endip;
this.begintime = begintime;
this.endtime = endtime;
}