hibernate 执行原生sql,select返回string,long

A1867350

于 2024-04-01 21:21:32 发布

阅读量676

点赞数 18

分类专栏：程序员文章标签： hibernate sql windows

本文链接：https://blog.csdn.net/A1867350/article/details/137247150

版权

本文介绍了如何在Java中使用Hibernate执行原生SQL查询，包括查询多表、使用addScalar映射结果到对象，以及startBatch()的用法。示例代码涵盖不同类型的查询，如LEFT JOIN和自定义SQL，最后分享了Java开发者的个人经历和面试知识点总结。

摘要由CSDN通过智能技术生成

List retList = query.list();

4.查询多表

Java代码

String hql = “select new map(dept.deptID as deptID,dept.depNo as deptNo,dept.deptName as deptName,emp.empName as empName,emp.empID as empID,emp.empAge as age,emp.empNo as empNo) from Department dept ,Employee emp where dept.depID = emp.depID and emp.empName = ? and emp.sex = ?”;
return getHibernateTemplate().find(hql, new Object[] { name, sex });

每个字段都保存在map中（key是字段名，value是此字段的值如：[{empID=1,empName=leona,…},…]）

5.查询多表

Java代码

String sql = “select dept.deptID as deptID,dept.depNo as deptNo,dept.deptName as deptName,emp.empName as empName,emp.empID as empID,emp.empAge as age,emp.empNo as empNo,emp.birthday as birthday from Employee emp LEFT JOIN Department dept on dept.depID = emp.depID where empName = ?”;
return (List) this.getSession()
.createSQLQuery(sql)
.addScalar(“deptID”, Hibernate.STRING)
.addScalar(“deptNo”, Hibernate.STRING)
.addScalar(“d