首页 > 代码库 > Hibernate,hql语言
Hibernate,hql语言
1、
/** * 查询Admin, query.list() */ @Test public void eg1() { Session session = null; try {// 创建session session = HibernateUtil.getSessionFactory().openSession(); // 声明变量，并初始化 String hql = "from Admin"; // 构建query对象 Query query = session.createQuery(hql); // 执行查询 List<Admin> adminList = query.list(); // 遍历并输出结果 for (Admin admin : adminList) { System.out.println("账户：" + admin.getLoginId()); } } catch (Exception e) { e.printStackTrace(); } finally { if (session != null) { session.close(); } } }
2、
/** * 查询Admin,query.iterator() */ @Test public void eg2(){ Session session = null; try {// 创建session session = HibernateUtil.getSessionFactory().openSession(); // 声明变量，并初始化 String hql = "from Admin"; // 构建query对象 Query query = session.createQuery(hql); // 执行查询 Iterator<Admin> adminIterator=query.iterate(); // 遍历并输出结果 while (adminIterator.hasNext()) { Admin admin = adminIterator.next(); System.out.println("账户："+admin.getLoginId()); } } catch (Exception e) { e.printStackTrace(); } finally { if (session != null) { session.close(); } } }
3、
/** * 设置占位符 */ @Test public void eg3(){ Session session = null; try {// 创建session session = HibernateUtil.getSessionFactory().openSession(); // 声明变量，并初始化 String hql = "from Admin where loginId=?"; // 构建query对象 Query query = session.createQuery(hql); //为占位符赋值 query.setString(0, "admin"); // 执行查询 Iterator<Admin> adminIterator=query.iterate(); // 遍历并输出结果 while (adminIterator.hasNext()) { Admin admin = adminIterator.next(); System.out.println("账户密码："+admin.getLoginPwd()); } } catch (Exception e) { e.printStackTrace(); } finally { if (session != null) { session.close(); } } }
4、
/** *命名参数 */ @Test public void eg4() { Session session = null; try {// 创建session session = HibernateUtil.getSessionFactory().openSession(); // 声明变量，并初始化 String hql = "from Admin where loginId=:loginId"; // 构建query对象 Query query = session.createQuery(hql); // query.setString("loginId", "admin"); // 执行查询 Iterator<Admin> adminIterator=query.iterate(); // 遍历并输出结果 while (adminIterator.hasNext()) { Admin admin = adminIterator.next(); System.out.println("账户密码："+admin.getLoginPwd()); } } catch (Exception e) { e.printStackTrace(); } finally { if (session != null) { session.close(); } } }
5、
/** * 设置占位符,setParameter */ @Test public void eg5_1() { Session session = null; try {// 创建session session = HibernateUtil.getSessionFactory().openSession(); // 声明变量，并初始化 String hql = "from Admin where loginId=?"; // 构建query对象 Query query = session.createQuery(hql); //为占位符赋值 query.setParameter(0, "admin"); // 执行查询 Iterator<Admin> adminIterator=query.iterate(); // 遍历并输出结果 while (adminIterator.hasNext()) { Admin admin = adminIterator.next(); System.out.println("账户密码："+admin.getLoginPwd()); } } catch (Exception e) { e.printStackTrace(); } finally { if (session != null) { session.close(); } } }
6、
/** * setParameter */ @Test public void eg5_2(){ Session session = null; try {// 创建session session = HibernateUtil.getSessionFactory().openSession(); // 声明变量，并初始化 String hql = "from Admin where loginId=:loginId"; // 构建query对象 Query query = session.createQuery(hql); // query.setParameter("loginId", "admin"); // 执行查询 Iterator<Admin> adminIterator=query.iterate(); // 遍历并输出结果 while (adminIterator.hasNext()) { Admin admin = adminIterator.next(); System.out.println("账户密码："+admin.getLoginPwd()); } } catch (Exception e) { e.printStackTrace(); } finally { if (session != null) { session.close(); } } }
7、
/** * 动态设置查询参数 */ @Test public void eg6() throws Exception{ Session session = null; try {// 创建session session = HibernateUtil.getSessionFactory().openSession(); //准备查询条件 Admin admin=new Admin(); admin.setLoginId("admin"); //准备hql,hql根据条件动态生成 StringBuilder hql=new StringBuilder("from Admin as emp where 1=1"); if(null!=admin.getClass()){ hql.append(" and loginId=:loginId"); } // 构建query对象 Query query = session.createQuery(hql.toString()); //使用query对象的setProperties()方法为参数赋值 query.setProperties(admin); // 执行查询 Iterator<Admin> adminIterator=query.iterate(); // 遍历并输出结果 while (adminIterator.hasNext()) { System.out.println("账户密码："+adminIterator.next().getLoginPwd()); } } catch (Exception e) { e.printStackTrace(); } finally { if (session != null) { session.close(); } } }
8、
/** * uniqueResult */ public void eg7(){ Session session = null; try {// 创建session session = HibernateUtil.getSessionFactory().openSession(); // 声明变量，并初始化 String hql = "from Admin where loginId=?"; // 构建query对象 Query query = session.createQuery(hql); query.setParameter(0, "%ad"); // 执行查询 Admin admin=(Admin) query.uniqueResult(); System.out.println("账户密码："+admin.getLoginPwd()); } catch (Exception e) { e.printStackTrace(); } finally { if (session != null) { session.close(); } } }
9、
声明：以上内容来自用户投稿及互联网公开渠道收集整理发布，本网站不拥有所有权，未作人工编辑处理，也不承担相关法律责任，若内容有误或涉及侵权可进行投诉： 投诉/举报 工作人员会在5个工作日内联系你，一经查实，本站将立刻删除涉嫌侵权内容。