List retList = query.list();
4.查询多表
-
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.查询多表
-
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(“deptName”, Hibernate.STRING)
-
.addScalar(“empName”, Hibernate.STRING)
-
.addScalar(“empID”, Hibernate.STRING)
-
.addScalar(“age”, Hibernate.LONG)
-
.addScalar(“birthday”, Hibernate.DATE)
-
.addScalar(“empNo”, Hibernate.STRING)
-
.setString(0, empName)
-
// 将结果集映射为EmpBean对象
-
.setResultTransformer(
-
Transformers.aliasToBean(EmpBean.class))
-
.list();
-
String hql = "from Attendance att where att.employeeid = ? and att.date =? ";
-
List list = this.getHibernateTemplate().find(hql,
-
new Object[] { employeeid, workDay });
-
if (null != list && !list.isEmpty()) {
-
return list.get(0);
-
}
-
String queryString = “FROM Attendance a WHERE a.employeeid=? AND DATE_FORMAT(a.date,‘%Y-%m’)=DATE_FORMAT(?,‘%Y-%m’) ORDER BY a.teamname”;
-
Query queryObject = getSession(). createQuery(queryString);
-
queryObject.setParameter(0, id);
-
queryObject.setParameter(1, date);
-
return queryObject.list();
-
Session session = getSession();
-
session.clear();
-
getSession().saveOrUpdate(transientInstance);
startBatch()的用法
-
public class LocalDaoImpl extends SqlMapClientDaoSupport implements LocalDao {
-
public void insertBuNaTaxBatLst(final PaginatedList list)
-
{
-
getSqlMapClientTemplate().execute(new SqlMapClientCallback() {
-
public Object doInSqlMapClient(SqlMapExecutor executor)
-
throws SQLException {
-
executor.startBatch();
-
// do some iBatis operations here
-
for(int i=0,count=list.size();i<count;i++)
-
{
-
executor.insert(“insertBuNaTaxBatLst”, list.get(i));
-
if (i % 50 == 0) {
-
System.out.println(“----” + i);//没有意义只为测试
-
}
-
}
-
executor.executeBatch();
-
return null;
-
}
自我介绍一下,小编13年上海交大毕业,曾经在小公司待过,也去过华为、OPPO等大厂,18年进入阿里一直到现在。
深知大多数Java工程师,想要提升技能,往往是自己摸索成长或者是报班学习,但对于培训机构动则几千的学费,着实压力不小。自己不成体系的自学效果低效又漫长,而且极易碰到天花板技术停滞不前!
因此收集整理了一份《2024年Java开发全套学习资料》,初衷也很简单,就是希望能够帮助到想自学提升又不知道该从何学起的朋友,同时减轻大家的负担。
既有适合小白学习的零基础资料,也有适合3年以上经验的小伙伴深入学习提升的进阶课程,基本涵盖了95%以上Java开发知识点,真正体系化!
由于文件比较大,这里只是将部分目录截图出来,每个节点里面都包含大厂面经、学习笔记、源码讲义、实战项目、讲解视频,并且会持续更新!
如果你觉得这些内容对你有帮助,可以扫码获取!!(备注Java获取)
最后
给大家送一个小福利
附高清脑图,高清知识点讲解教程,以及一些面试真题及答案解析。送给需要的提升技术、准备面试跳槽、自身职业规划迷茫的朋友们。
《互联网大厂面试真题解析、进阶开发核心学习笔记、全套讲解视频、实战项目源码讲义》点击传送门即可获取!
面试真题及答案解析。送给需要的提升技术、准备面试跳槽、自身职业规划迷茫的朋友们。
[外链图片转存中…(img-ahIExygC-1712576025879)]
《互联网大厂面试真题解析、进阶开发核心学习笔记、全套讲解视频、实战项目源码讲义》点击传送门即可获取!