Hibernate批量資料操作

/*Hibernate批量資料操作*/

import org.hibernate.cfg.Configuration;

import org.hibernate.SessionFactory;

import org.hibernate.Session;

import org.hibernate.Transaction;

import org.hibernate.Query;

import java.util.List;

class 

{

 public static void main(String[] args)

 {

  Session session=util.HibernateSessionFactory.getSession();

  /*1、查詢所有資料*/

  String hql="from Customer where Cbalance>1000";

  Query query=session.createQuery(hql);

  List list=query.list();

  for(int i=0;i<list.size();i++)

  {

   Customer cus=(Customer)list.get(i);

   System.out.println(cus.getCaccount());

      System.out.println(cus.getPassword());

      System.out.println(cus.getCbalance());

      System.out.println(cus.getUsername());

  }

  /*2、查詢指定資料*/

  double money=1000;

  String hql="Select account , Cbalance from Customer where Cbalance>:money";

  query.setDouble("money",money);

   Object[] obj=(Object[])list.get(i);

   System.out.println(Obj[0]);

      System.out.println(Obj[1]);