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])
}