用createSqlQuery(),要不就照下面的写
public ArrayList getBookAndUser(){
String sql = "select {b.*},{u.*},{bu.*} from t_user u,book b,bookanduser bu where u.userid = bu.userid and b.bookid = bu.bookid";
org.hibernate.classic.Session session = (org.hibernate.classic.Session) HibernateSessionFactory.getSession();
//Connection conn = session.connection();
Transaction t = session.beginTransaction();
Query query = session.createSQLQuery(sql,new String[] {"b","u","bu"},new Class[]{Book.class,User.class,BookAndUser.class});
ArrayList al = (ArrayList) query.list();
t.commit();
session.close();
return al;
}
public ArrayList getBookAndUser(){
String sql = "select {b.*},{u.*},{bu.*} from t_user u,book b,bookanduser bu where u.userid = bu.userid and b.bookid = bu.bookid";
org.hibernate.classic.Session session = (org.hibernate.classic.Session) HibernateSessionFactory.getSession();
//Connection conn = session.connection();
Transaction t = session.beginTransaction();
Query query = session.createSQLQuery(sql,new String[] {"b","u","bu"},new Class[]{Book.class,User.class,BookAndUser.class});
ArrayList al = (ArrayList) query.list();
t.commit();
session.close();
return al;
}
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货