query6.java

郭克华j2ee高级框架实战教学视频源代码 这个是比较值得一看的 由郭克华博士在总结多年Java培训的基础上

package test;

import java.util.List;

import org.hibernate.SQLQuery;
import org.hibernate.Session;

import po.Customer;

//Hibernate实现查询余额>1000的人
public class Query6 {
	public static void main(String[] args) {
		Session session = util.HibernateSessionFactory.getSession();
		
		 SQLQuery sqlQuery = session.createSQLQuery("SELECT ACCOUNT,PASSWORD,CNAME,CBALANCE FROM T_CUSTOMER");
		 sqlQuery.addEntity(Customer.class);//和po绑定
		List list = sqlQuery.list();
		
		for(int i=0;i<list.size();i++){
			Customer cus = (Customer)list.get(i);
			System.out.println(cus.getCname() + " " + cus.getCbalance());
		}
		
		util.HibernateSessionFactory.closeSession();
		/*调用存储过程
		java.sql.Connection conn = session.connection();
		conn.prepareCall(arg0);
		*/

	}

}