hibernate添加修改删除查询
? Student s = new Student();
??s.setId(8);
??s.setSname("卫江波");
??s.setSex("boy");
??s.setAge(24);
??s.setSchool("黑龙江科技大学");
??Configuration con = new Configuration().configure(); //??读取hibernate.cfg.xml配置文件
??SessionFactory factory = con.buildSessionFactory();//??通过hibernate.cfg.xml中的配置，创建SessionFactory
??Session session = factory.openSession();//??通过SessionFactory打开一个和数据库的会话
??Transaction tr = session.beginTransaction();//??通过Session开启事务
??tr.begin();
??session.save(s);//向数据库添加数据
??session.update(s);//修改
??session.delete(s);//删除
?
??tr.commit();//提交事务
??/*List studentList = null;
??String hql = "FROM Student";
??Query query = session.createQuery(hql);
??studentList = query.list();
??Iterator it = studentList.iterator();
??while(it.hasNext()) {
???Student temp = (Student) it.next();
???System.out.println(temp.getId()+"-->"+temp.getSname()+"-->"+temp.getSex()+"" +
?????"-->"+temp.getAge()+"-->"+temp.getSchool());
??}*/
?
??List studentList = null;
??String hql = "FROM Student WHERE id=?";
??Query query = session.createQuery(hql);
??query.setInteger(0,6);
??studentList = query.list();
??Iterator it = studentList.iterator();
??if(it.hasNext()) {
???Student temp = (Student) it.next();
???System.out.println(temp.getId()+"-->"+temp.getSname()+"-->"+temp.getSex()+"" +
?????"-->"+temp.getAge()+"-->"+temp.getSchool());
??}
//??关闭session
??session.close();
?
?
分页
Query query = getSession().createQuery(sql);
??????? query.setFirstResult((page - 1) * pagesize);
??????? query.setMaxResults(pagesize);
??????? return query.list();
?
?
?
String sql = "from Resource where owner.id = ?";
return getSession().createQuery(sql).setInteger(0, owner.getId().intValue()).list();
?
?
createCriteria
