读书人

hibernate平添修改删除查询

发布时间: 2012-09-29 10:30:01 作者: rapoo

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

读书人网 >移动开发

热点推荐