Hibernate第二天

package com.lovo.dao; import java.util.Iterator; import java.util.List; import org.hibernate.Hibernate; import org.hibernate.Query; import org.hibernate.Session; import org.hibernate.Transaction; import com.lovo.db.HibernateSessionFactory; import com.lovo.po.UserPO; public class UserDAO { public void addUser(UserPO user){ Session session = HibernateSessionFactory.getSession(); Transaction transaction = session.beginTransaction(); session.save(user); transaction.commit(); session.close(); } public void delUser(UserPO user){ Session session = HibernateSessionFactory.getSession(); Transaction transaction = session.beginTransaction(); session.delete(user); transaction.commit(); session.close(); } public void modUser(UserPO user){ Session session = HibernateSessionFactory.getSession(); Transaction transaction = session.beginTransaction(); session.update(user); transaction.commit(); session.close(); } public void getUserById(int id){ Session session = HibernateSessionFactory.getSession(); UserPO user = (UserPO)session.get(UserPO.class, id); // UserPO user = (UserPO)session.load(UserPO.class, id); System.out.println(user.getName() + " " + user.getPassword()); session.close(); } public void getAllUser(){ Session session = HibernateSessionFactory.getSession(); String hql = "select new UserPO(name,password) from UserPO where id = 1"; // String sql = "select * from t_user"; Query query = session.createQuery(hql); query.setMaxResults(10); query.setFirstResult(1); // Query query = session.createSQLQuery(sql); List allUsers = query.list(); for(int i = 0; i < allUsers.size(); i++){ // Object[] objs = (Object[])allUsers.get(i); // System.out.println(objs[1] + " " + objs[2]); UserPO user = (UserPO)allUsers.get(i); System.out.println(user.getName()); // Object[] name = (Object[])allUsers.get(i); // System.out.println(name[1]); } // Iterator it = query.iterate(); // while(it.hasNext()){ // UserPO user = (UserPO)it.next(); // String username = user.getName(); // System.out.println(username); // } session.close(); } public void getUsers(UserPO user) { String hql = "from UserPO where name = :name and password = :password"; Session session = HibernateSessionFactory.getSession(); Query query = session.createQuery(hql); // query.setString("name", user.getName()); // query.setString("password", user.getPassword()); query.setParameter("name", user.getName()); query.setParameter("password", user.getPassword()); // query.setProperties(user); List l = query.list(); System.out.println(l.size()); session.close(); } }

Session session = HibernateSessionFactory.getSession();获得连接

Transaction transaction = session.beginTransaction();//事务开启

session.createSQLQuery(sql);//执行SQL语句但返回的多行不是帮你封装好的对象而是一个个对象数组

用HQL语句就是把以前写的表单写成对象的属性

 

from UserPO where name = :name and password = :password

query.setString("name", user.getName());
  query.setString("password", user.getPassword());
  query.setParameter("name", user.getName());
  query.setParameter("password", user.getPassword());//可以通过这个方式设置值

但是··，Date不能通过这个方法赋值

查询

 用get 和lond的区别

lond要报异常 get 不会返回一个空

lond支持延迟加载 get:不支持延迟加载

 

用Lis遍历知会生成一条SQL语句

Iterator:会生成N+1条语句//它首先查询出所有记录的ID再根据ID查询。