增加
@Test
public void testAdd(){
Student student=new Student("aa", 18);
session.save(student);
}
查询单个
@Test
public void testGet(){
//查询单个
Student student=session.get(Student.class, 1);
System.out.println("查询单个:"+student.getSid()+" "+student.getSname());
查询所有
List<Student> students=session.createCriteria(Student.class).list();
for (Student student : students) {
System.out.println(student.getSname());
}
}
}
查询单个的列
List<String> names=session.createQuery("select pname from Person").list();
// for (String string : names) {
// System.out.println(string);
// }
分页
int pageNo=2;
// int pageSize=2;
// List<Person> persons=session.createQuery("from Person").setFirstResult((pageNo-1)*pageSize).setMaxResults(pageSize).list();
// for (Person person : persons) {
// System.out.println(person);
// }