Hibernate查询数据的几种方式
Java代码public void query(){
Session session = null;
Query query = null;
String hql = null;
try {
session = HibernateSessionFactory.getSession();
hql="From TUser user where user.suser='admin'";
query = session.createQuery(hql);
List list = query.list();
for (Iterator iter = list.iterator(); iter.hasNext();) {
TUser user = (TUser) iter.next();
System.out.println("----Query---");
System.out.println("-Suser-="+user.getSuser());
System.out.println("-Name--="+user.getName());
System.out.println("-Email-="+user.getEmail());
}
} catch (Exception e) {
e.printStackTrace();
}finally{
HibernateSessionFactory.closeSession();
}
}public void query(){ Session session = null; Query query = null; String hql = null; try { session = HibernateSessionFactory.getSession(); hql="From TUser user where user.suser='admin'"; query = session.createQuery(hql); List list = query.list(); for (Iterator iter = list.iterator(); iter.hasNext();) { TUser user = (TUser) iter.next(); System.out.println("----Query---"); System.out.println("-Suser-="+user.getSuser()); System.out.println("-Name--="+user.getName()); System.out.println("-Email-="+user.getEmail()); } } catch (Exception e) { e.printStackTrace(); }finally{ HibernateSessionFactory.closeSession(); } }
Java代码public void criteria(){
Session session = null;
Criteria criteria = null;
try {
session = HibernateSessionFactory.getSession();
criteria = session.createCriteria(TUser.class);
criteria.add(Restrictions.isNotNull("suser"));
criteria.add(Restrictions.ilike("name", "%T%"));
criteria.addOrder(Order.desc("nation"));
List list = criteria.list();
for (Iterator iter = list.iterator(); iter.hasNext();) {
TUser user = (TUser) iter.next();
System.out.println("----Criteria---");
System.out.println("-Suser-="+user.getSuser());
System.out.println("-Name--="+user.getName());
System.out.println("-Email-="+user.getEmail());
System.out.println("-Nation="+user.getNation());
}
} catch (Exception e) {
e.printStackTrace();
}finally{
HibernateSessionFactory.closeSession();
}
}public void criteria(){ Session session = null; Criteria criteria = null; try { session = HibernateSessionFactory.getSession(); criteria = session.createCriteria(TUser.class); criteria.add(Restrictions.isNotNull("suser")); criteria.add(Restrictions.ilike("name", "%T%")); criteria.addOrder(Order.desc("nation")); List list = criteria.list(); for (Iterator iter = list.iterator(); iter.hasNext();) { TUser user = (TUser) iter.next(); System.out.println("----Criteria---"); System.out.println("-Suser-="+user.getSuser()); System.out.println("-Name--="+user.getName()); System.out.println("-Email-="+user.getEmail()); System.out.println("-Nation="+user.getNation()); } } catch (Exception e) { e.printStackTrace(); }finally{ HibernateSessionFactory.closeSession(); } }
Java代码public void nativeSql() {
Session session =null;
Query query = null;
String sql = null;
try {
session = HibernateSessionFactory.getSession();
sql = "select suser,name,email,nation from t_user";
query = session.createQuery(sql);
List list = query.list();
for (Iterator iter = list.iterator(); iter.hasNext();) {
Object[] obj = (Object[]) iter.next();
System.out.println("-Suser-="+obj[0]);
System.out.println("-Name--="+obj[1]);
System.out.println("-Email-="+obj[2]);
System.out.println("-Nation="+obj[3]);
}
} catch (Exception e) {
e.printStackTrace();
}finally{
HibernateSessionFactory.closeSession();
}
}public void nativeSql() { Session session =null; Query query = null; String sql = null; try { session = HibernateSessionFactory.getSession(); sql = "select suser,name,email,nation from t_user"; query = session.createQuery(sql); List list = query.list(); for (Iterator iter = list.iterator(); iter.hasNext();) { Object[] obj = (Object[]) iter.next(); System.out.println("-Suser-="+obj[0]); System.out.println("-Name--="+obj[1]); System.out.println("-Email-="+obj[2]); System.out.println("-Nation="+obj[3]); } } catch (Exception e) { e.printStackTrace(); }finally{ HibernateSessionFactory.closeSession(); } }
Java代码public void getOrLoad(){
Session session = null;
try {
session = HibernateSessionFactory.getSession();
TUser user = (TUser)session.load(TUser.class, "test1");
System.out.println("-Suser-="+user.getSuser());
System.out.println("-Name--="+user.getName());
System.out.println("-Email-="+user.getEmail());
System.out.println("-Nation="+user.getNation());
} catch (Exception e) {
e.printStackTrace();
}finally{
HibernateSessionFactory.closeSession();
}
}public void getOrLoad(){ Session session = null; try { session = HibernateSessionFactory.getSession(); TUser user = (TUser)session.load(TUser.class, "test1"); System.out.println("-Suser-="+user.getSuser()); System.out.println("-Name--="+user.getName()); System.out.println("-Email-="+user.getEmail()); System.out.println("-Nation="+user.getNation()); } catch (Exception e) { e.printStackTrace(); }finally{ HibernateSessionFactory.closeSession(); } }
HQL用法及参数的几种使用方法
Java代码public void batchUpdate() {
Session session = null;
Transaction transaction = null;
Query query = null;
String hql ="update TUser set name='阿德' where suser=:user";
try {
session = HibernateSessionFactory.getSession();
transaction =session.beginTransaction();
query = session.createQuery(hql);
query.setString("user", "test9");
int i = query.executeUpdate();
transaction.commit();
System.out.println("--update--"+i);
} catch (Exception e) {
e.printStackTrace();
transaction.rollback();
}finally{
HibernateSessionFactory.closeSession();
}
}public void batchUpdate() { Session session = null; Transaction transaction = null; Query query = null; String hql ="update TUser set name='阿德' where suser=:user"; try { session = HibernateSessionFactory.getSession(); transaction =session.beginTransaction(); query = session.createQuery(hql); query.setString("user", "test9"); int i = query.executeUpdate(); transaction.commit(); System.out.println("--update--"+i); } catch (Exception e) { e.printStackTrace(); transaction.rollback(); }finally{ HibernateSessionFactory.closeSession(); } }
Java代码public void batchDelete() {
Session session = null;
Transaction transaction = null;
Query query = null;
String hql = "delete from t_user suser=:user";
try {
session = HibernateSessionFactory.getSession();
transaction = session.beginTransaction();
query = session.createQuery(hql);
query.setString("user", "test11");
int i = query.executeUpdate();
transaction.commit();
System.out.println("--delete--"+i);
} catch (Exception e) {
e.printStackTrace();
transaction.rollback();
}finally{
HibernateSessionFactory.closeSession();
}
}public void batchDelete() { Session session = null; Transaction transaction = null; Query query = null; String hql = "delete from t_user suser=:user"; try { session = HibernateSessionFactory.getSession(); transaction = session.beginTransaction(); query = session.createQuery(hql); query.setString("user", "test11"); int i = query.executeUpdate(); transaction.commit(); System.out.println("--delete--"+i); } catch (Exception e) { e.printStackTrace(); transaction.rollback(); }finally{ HibernateSessionFactory.closeSession(); } }
Java代码public void queryUsers() {
Session session = null;
Transaction transaction = null;
Query query = null;
String hql =null;
try {
session = HibernateSessionFactory.getSession();
hql = "from TUser where suser=:user";
transaction = session.beginTransaction();
query = session.createQuery(hql);
TUser user = new TUser();
user.setSuser("test1");
query.setProperties(user);
List list = query.list();
for (Iterator iter = list.iterator(); iter.hasNext();) {
Object[] obj = (Object[]) iter.next();
System.out.println("-Suser-="+obj[0]);
System.out.println("-Name--="+obj[1]);
System.out.println("-Email-="+obj[2]);
System.out.println("-Nation="+obj[3]);
}
} catch (Exception e) {
e.printStackTrace();
transaction.rollback();
}finally{
HibernateSessionFactory.closeSession();
}
}