package com.layne.hibernate.uuid.test;
import java.util.Iterator;
import java.util.List;
import org.hibernate.SQLQuery;
import org.hibernate.Session;
import org.hibernate.criterion.Order;
import org.junit.Test;
import com.layne.hibernate.uuid.beans.Student;
import com.layne.hibernate.uuid.utils.HbnUtils;
public class myTest {
@Test
public void test00(){
Session session =
HbnUtils.getSession();
try {
session.beginTransaction();
for(
int i=0;i<=10;i++
){
Student student =
new Student("n_"+i,15+i,84+
i);
session.save(student);
}
session.getTransaction().commit();
} catch (Exception e) {
e.printStackTrace();
session.getTransaction().rollback();
}
}
@Test
public void test01_HQL(){
Session session =
HbnUtils.getSession();
try {
session.beginTransaction();
String hpl="from Student "
;
List<Student> list =
session.createQuery(hpl).list();
for(Student student:list){
System.out.println(student);
}
session.getTransaction().commit();
} catch (Exception e) {
e.printStackTrace();
session.getTransaction().rollback();
}
}
@Test
public void test01_SQL(){
Session session =
HbnUtils.getSession();
try {
session.beginTransaction();
String sql="select tid,tname,tscore,tage from t_student"
;
List<Student> list = session.createSQLQuery(sql).addEntity(Student.
class).list();
for(Student student:list){
System.out.println(student);
}
session.getTransaction().commit();
} catch (Exception e) {
e.printStackTrace();
session.getTransaction().rollback();
}
}
@Test
public void test01_QBC(){
Session session =
HbnUtils.getSession();
try {
session.beginTransaction();
List<Student> list = session.createCriteria(Student.
class).list();
for(Student student:list){
System.out.println(student);
}
session.getTransaction().commit();
} catch (Exception e) {
e.printStackTrace();
session.getTransaction().rollback();
}
}
@Test
public void test02_HQL(){
Session session =
HbnUtils.getSession();
try {
session.beginTransaction();
String hpl="from Student order by age desc"
;
List<Student> list =
session.createQuery(hpl).list();
for(Student student:list){
System.out.println(student);
}
session.getTransaction().commit();
} catch (Exception e) {
e.printStackTrace();
session.getTransaction().rollback();
}
}
@Test
public void test02_SQL(){
Session session =
HbnUtils.getSession();
try {
session.beginTransaction();
String sql="select tid,tname,tscore,tage from t_student order by taage desc"
;
List<Student> list = session.createSQLQuery(sql).addEntity(Student.
class).list();
for(Student student:list){
System.out.println(student);
}
session.getTransaction().commit();
} catch (Exception e) {
e.printStackTrace();
session.getTransaction().rollback();
}
}
@Test
public void test02_QBC(){
Session session =
HbnUtils.getSession();
try {
session.beginTransaction();
List<Student> list = session.createCriteria(Student.
class).addOrder(Order.desc("age"
)).list();
for(Student student:list){
System.out.println(student);
}
session.getTransaction().commit();
} catch (Exception e) {
e.printStackTrace();
session.getTransaction().rollback();
}
}
@Test
public void test03_HQL(){
Session session =
HbnUtils.getSession();
try {
session.beginTransaction();
String hpl="from Student where age>? and score<?"
;
List<Student> list =
session.createQuery(hpl).
setInteger(0, 20
).
setDouble(1, 94
).
list();
//HQL查询语句的赋值使用被传值的位置，使用set+【值类型】(位置,值)
for(Student student:list){
System.out.println(student);
}
session.getTransaction().commit();
} catch (Exception e) {
e.printStackTrace();
session.getTransaction().rollback();
}
}
@Test
public void test03_2_HQL(){
Session session =
HbnUtils.getSession();
try {
session.beginTransaction();
String hpl="from Student where age>:myage and score<:myscore"
;
List<Student> list =
session.createQuery(hpl).
setInteger("myage", 20
).
setDouble("myscore", 94
).
list();
//HQL查询语句的赋值使用被传值的位置，使用set+【值类型】(位置,值)
for(Student student:list){
System.out.println(student);
}
session.getTransaction().commit();
} catch (Exception e) {
e.printStackTrace();
session.getTransaction().rollback();
}
}
@Test
public void test03_3_HQL(){
Session session =
HbnUtils.getSession();
try {
session.beginTransaction();
String hpl="from Student where age>:myage and score<:myscore"
;
List<Student> list =
session.createQuery(hpl).
setParameter("myage", 20
).
setParameter("myscore", 94.0
).
list();
//HQL查询语句的赋值使用被传值的位置，使用set+【值类型】(位置,值)
for(Student student:list){
System.out.println(student);
}
session.getTransaction().commit();
} catch (Exception e) {
e.printStackTrace();
session.getTransaction().rollback();
}
}
@Test
public void test04_SQL(){
Session session =
HbnUtils.getSession();
try {
session.beginTransaction();
String sql="select * from t_student limit ?,?"
;
List<Student> list =
session.createSQLQuery(sql)
.addEntity(Student.class)
.setInteger(0,4
)
.setInteger(1,3
)
.list();
for(Student student:list){
System.out.println(student);
}
session.getTransaction().commit();
} catch (Exception e) {
e.printStackTrace();
session.getTransaction().rollback();
}
}
@Test
public void test04_HQL(){
Session session =
HbnUtils.getSession();
try {
session.beginTransaction();
String hql="from Student"
;
List<Student> list =
session.createQuery(hql).
setFirstResult(4
).
setMaxResults(3
).
list();
for(Student student:list){
System.out.println(student);
}
session.getTransaction().commit();
} catch (Exception e) {
e.printStackTrace();
session.getTransaction().rollback();
}
}
@Test
public void test05_HQL(){
Session session =
HbnUtils.getSession();
try {
session.beginTransaction();
String hql="from Student where name like :myname"
;
List<Student> list = session.createQuery(hql).setString("myname", "%张%"
).list();
for(Student student:list){
System.out.println(student);
}
session.getTransaction().commit();
} catch (Exception e) {
e.printStackTrace();
session.getTransaction().rollback();
}
}
@Test//唯一性查询
public void test06_HQL(){
Session session =
HbnUtils.getSession();
try {
session.beginTransaction();
String hql="from Student where id=:myid"
;
Student student= (Student) session.createQuery(hql).setInteger("myid", 3
).uniqueResult();
System.out.println(student);
session.getTransaction().commit();
} catch (Exception e) {
e.printStackTrace();
session.getTransaction().rollback();
}
}
@Test//聚合函数查询
public void test07_HQL(){
Session session =
HbnUtils.getSession();
try {
session.beginTransaction();
String hql="select count(*) from Student"
;
Long count =
(Long) session.createQuery(hql).uniqueResult();
System.out.println(count);
session.getTransaction().commit();
} catch (Exception e) {
e.printStackTrace();
session.getTransaction().rollback();
}
}
@Test//投影查询
public void test08_HQL(){
Session session =
HbnUtils.getSession();
try {
session.beginTransaction();
String hql="select new Student(name,age) from Student"
;
List<Student> list =
session.createQuery(hql).list();
for(Student student:list){
System.out.println(student);
}
session.getTransaction().commit();
} catch (Exception e) {
e.printStackTrace();
session.getTransaction().rollback();
}
}
@Test//分组查询 group by age 取的是各个年龄段的第一个
public void test09_HQL(){
Session session =
HbnUtils.getSession();
try {
session.beginTransaction();
//每个年龄段的第一个
/*String hql="from Student group by age";
List<Student> list = session.createQuery(hql).list();
for(Student student:list){
System.out.println(student);
}*/
//共有几个年龄段
/*String hql="select age from Student group by age";
List<Integer> list = session.createQuery(hql).list();
System.out.println(list);*/
String hql="select age from Student group by age having count(age) >:mycount";
//人数多于1人的分组
List<Integer> list = session.createQuery(hql).setInteger("mycount", 1
).list();
System.out.println(list);
session.getTransaction().commit();
} catch (Exception e) {
e.printStackTrace();
session.getTransaction().rollback();
}
}
@Test//iterate查询会先使用id查询缓存中是否有查询值 所以可以现用list查询，在有iterate查询
public void test10_HQL(){
Session session =
HbnUtils.getSession();
try {
session.beginTransaction();
String hql="from Student"
;
Iterator<Student> it =
session.createQuery(hql).iterate();
while(it.hasNext()){
Student student=
it.next();
System.out.println(student);
}
session.getTransaction().commit();
} catch (Exception e) {
e.printStackTrace();
session.getTransaction().rollback();
}
}
@Test//使用**。hbn.xml配置文件配置hql语句(命名空间查询)
public void test11_HQL(){
Session session =
HbnUtils.getSession();
try {
session.beginTransaction();
Student student = (Student) session.getNamedQuery("selectById").setInteger("myid", 2
).uniqueResult();
System.out.println(student);
session.getTransaction().commit();
} catch (Exception e) {
e.printStackTrace();
session.getTransaction().rollback();
}
}
}
转载于:https://www.cnblogs.com/flytogalaxy/p/7461478.html
