hibernate 执行原生sql,select返回string,long
来源:互联网 发布:cap理论 数据库 编辑:程序博客网 时间:2024/05/22 02:02
http://heisetoufa.iteye.com/blog/1564095
1.执行sql,返回一个结果集,适用查询一个字段并返回一条记录
- public Long findSeqTbTest() {
- String sql = "select SEQ_TB_TEST.nextval from dual";
- SQLQuery query = this.getSession().createSQLQuery(sql);
- String str = query.uniqueResult().toString();
- return Long.valueOf(str);
- }
- //获取表中最小的id
- String sql = "select min(a.employeeid) from Emplyees a";
- Long id = (Long) session.createQuery(sql).uniqueResult();
- //获取数据库时间mysql
- String sql = "select now() from dual";
- String time = session.createSQLQuery(sql).uniqueResult().toString();
2.删除、更新等操作,这里参数是从0开始的
- public void deleteTbTest(Long id) {
- String hql = "DELETE FROM TbTest WHERE ID = ?";
- this.getSession().createQuery(hql).setLong(0, id).executeUpdate();
- }
- public void updateTbTest(Date date, boolean flag) {
- String sql = "update tb_test set t_name=? where t_status!=1 and t_date" + (flag ? "<?" : "=?");
- SQLQuery query = this.getSession().createSQLQuery(sql);
- query.setString(0,flag ? "hello": "hi").setDate(1, date).executeUpdate();
- }
3.执行sql,查询单表中多条数据
//尽量避免适用"*"
String sql = "select * from employee e where e.valid=1 and not exists (select employeeid from attendance a where a.employeeid=e.employeeid and a.date = ?)";
SQLQuery query = getSession().createSQLQuery(sql);
query.addEntity(Employee.class).setDate(0, day);
List<Employee> 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<EmpBean>) 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<Attendance> 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;
- }
- });
- }
0 0
- hibernate 执行原生sql,select返回string,long
- hibernate 执行sql ,select 返回string long
- hibernate 执行sql ,select 返回string long
- hibernate 执行sql ,select 返回String ,Long
- hibernate 执行sql ,select 返回string long
- hibernate 执行sql ,select 返回string long
- hibernate执行原生sql
- Hibernate 执行原生sql
- hibernate执行原生SQL
- Hibernate 执行原生SQL
- Hibernate执行原生sql
- hibernate 原生sql返回结果执行AddEntity方法
- hibernate 原生sql返回结果执行AddEntity方法
- Hibernate执行原生SQL查询
- Hibernate 原生sql的执行
- Hibernate直接执行原生SQL
- [转载]hibernate执行原生sql
- Hibernate SQLQuery执行原生SQL
- Nginx配置文件nginx.conf中文详解
- RTMP直播应用与延时分析
- linux系统启动过程
- 非标准base64编码
- mybatis学习(一) 快速入门
- hibernate 执行原生sql,select返回string,long
- localStrorage用法
- 线程池配置相关信息
- JAVA获取同一路径下所有子类或接口实现类
- UML类图几种关系的总结
- servlet工作原理
- Coursera 机器学习第9周作业2
- Git 与 Github 基础(二)—— Git for Windows
- Spring源码分析——BeanFactory体系之接口详细分析