ssh2分页查询初试,放着记录学习一下。
entity:student.java:
[html]
package com.zte.entity;
/**
* 数据持久化,跟数据库的的相应的表的字段是对应的。
*
*
*/
public class Student
{
private Integer id;
private String name;
private Integer age;
private Integer score;
private String email;
private String phone;
public String getEmail()
{
return email;
}
public void setEmail(String email)
{
this.email = email;
}
public String getPhone()
{
return phone;
}
public void setPhone(String phone)
{
this.phone = phone;
}
public Integer getId()
{
return id;
}
public void setId(Integer id)
{
this.id = id;
}
public String getName()
{
return name;
}
public void setName(String name)
{
this.name = name;
}
public Integer getAge()
{
return age;
}
public void setAge(Integer age)
{
this.age = age;
}
public Integer getScore()
{
return score;
}
public void setScore(Integer score)
{
this.score = score;
}
}
package com.zte.entity;
/**
* 数据持久化,跟数据库的的相应的表的字段是对应的。
*
*
*/
public class Student
{
private Integer id;
private String name;
private Integer age;
private Integer score;
private String email;
private String phone;
public String getEmail()
{
return email;
}
public void setEmail(String email)
{
this.email = email;
}
public String getPhone()
{
return phone;
}
public void setPhone(String phone)
{
this.phone = phone;
}
public Integer getId()
{
return id;
}
public void setId(Integer id)
{
this.id = id;
}
public String getName()
{
return name;
}
public void setName(String name)
{
this.name = name;
}
public Integer getAge()
{
return age;
}
public void setAge(Integer age)
{
this.age = age;
}
public Integer getScore()
{
return score;
}
public void setScore(Integer score)
{
this.score = score;
}
}
Student.hbm.xml:
[html]
< xml version="1.0" encoding="UTF-8" >
< xml version="1.0" encoding="UTF-8" >
dao层:StudentDao.java
[html]
public interface StudentDao
{
public QueryResult
}
public interface StudentDao
{
public QueryResult
}
StudentDaoImpl.java:
[html]
public class StudentImpl
{
private SessionFactory sessionFactory;// 通过spring注入数据持久化工厂(相当于spring帮你设置好了
// 对象,直接通过getter/setter的方式获取)
public SessionFactory getSessionFactory()
{
return sessionFactory;
}
public void setSessionFactory(SessionFactory sessionFactory)
{
this.sessionFactory = sessionFactory;
}
@Override
public QueryResult getScrollData(int firstindex, int maxresult)
{
QueryResult retuslt = new QueryResult
Query query =
sessionFactory.getCurrentSession().createQuery("from Student");
System.out.println("query---size---before>>>" + query.list().size());
retuslt.setTotalrecord(query.list().size());
query.setFirstResult(firstindex).setMaxResults(maxresult);
System.out.p