spring中原生SQL查询(多表查询)

spring中原生SQL查询(多表查询)

核心代码如下:

public List<Object[]> getBorrowRecord(final String uid)

 {
  String sql="select u.u_name,b.b_id,b.b_name,b1.b_time,b1.b_status from users u, books b, borrow b1 where b1.u_id=u.u_id and b1.b_id=b.b_id and b1.u_id='"+uid+"'";
  List<Object[]> list=null;
  try {
   SessionFactory sessionFactory = getHibernateTemplate()
     .getSessionFactory();
   Session session = sessionFactory.openSession();
   Query query = session.createSQLQuery(sql);
    list =  query.list();
  } catch (Exception e) {
   System.out.println("ddd");
  }
  return list;
 }

获取查询指定元素:(例如输出所有姓名)

for(Object[] object : list )

 {

       System.out.println(object[0])

}