package com.test.service;


import java.util.Iterator;
import java.util.List;

import org.apache.log4j.Logger;
import org.hibernate.Criteria;
import org.hibernate.Query;
import org.hibernate.Session;
import org.hibernate.SessionFactory;
import org.hibernate.criterion.Criterion;
import org.hibernate.criterion.Order;
import org.hibernate.criterion.Restrictions;
import org.junit.After;
import org.junit.Before;
import org.junit.Test;

import com.test.model.Student;
import com.test.util.HibernateUtil;

public class StudentTest {

private SessionFactory sessionFactory = HibernateUtil.getSessionFactory(); // 获取Session工厂
private Session session;
private Logger logger = Logger.getLogger(StudentTest.class);
@Before
public void setUp() throws Exception {
session=sessionFactory.openSession(); // 生成一个session
    session.beginTransaction(); // 开启事务
}

@After
public void tearDown() throws Exception {
session.getTransaction().commit(); // 提交事务
    session.close(); // 关闭session
}

@Test
public void testSQLQuery() {

String sql = "select * from t_student";
Query query = session.createSQLQuery(sql).addEntity(Student.class);

List studentList = query.list();
Iterator it = studentList.iterator();
while(it.hasNext()){
Student s = (Student) it.next();
System.out.println(s);
}
logger.debug("这是一个debug信息");
logger.info("这是一个info信息");
logger.error("这是一个error信息");
}

}