hibernate也支持直接使用sql进行查询,例子代码如下:
/** * 原生sql测试 */ public class SqlQueryTest extends TestCase {
public void testQuery1() { Session session = null; try { session = HibernateUtils.getSession(); session.beginTransaction(); List students = session.createSQLQuery ("select * from t_student").list(); for (Iterator iter=students.iterator(); iter.hasNext();) { Object[] obj = (Object[])iter.next(); System.out.println(obj[0] + "," + obj[1]); } session.getTransaction().commit(); }catch(Exception e) { e.printStackTrace(); session.getTransaction().rollback(); }finally { HibernateUtils.closeSession(session); } } } |