personaddressoperate.java

来自「一款仿msdn聊天程序,用java编写,很好用!」· Java 代码 · 共 96 行

package org.lxh.hibernate.demo06.oper;

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

import org.hibernate.Query;
import org.hibernate.Session;
import org.hibernate.cfg.Configuration;
import org.lxh.hibernate.demo06.pojo.Address;
import org.lxh.hibernate.demo06.pojo.Person;

public class PersonAddressOperate {
	private Session session = null;

	public PersonAddressOperate() {
		this.session = new Configuration().configure().buildSessionFactory()
				.openSession();
	}

	// 插入人员
	public void insert(Person per) {
		this.session.save(per);
		this.session.beginTransaction().commit();
	}

	public void update(Person per) {
		this.session.update(per);
		this.session.beginTransaction().commit();
	}

	public void delete(String id) {
		String hql = "DELETE FROM Person WHERE id=?";
		Query q = this.session.createQuery(hql);
		q.setString(0, id);
		q.executeUpdate();
		this.session.beginTransaction().commit();
	}

	public Person queryById(String id) {
		Person p = null;
		String hql = "FROM Person AS p WHERE p.id=?";
		Query q = this.session.createQuery(hql);
		q.setString(0, id);
		List all = q.list();
		if (all.size() > 0) {
			p = (Person) all.get(0);
		}
		return p;
	}

	/**
	 * @param args
	 */
	public static void main(String[] args) {
		PersonAddressOperate pao = new PersonAddressOperate();
//		Person per = pao.queryById("ff8080811310a3d7011310a3db600001");
//		per.setName("LXh");
//		per.setAge(33);
		// per.setAddress(new HashSet());

		// 地址
		// Address ad = null;
		// ad = new Address();
		// ad.setName("中关村1");
		// ad.setZipcode("111111x");
		// ad.setPerson(per);
		// per.getAddress().add(ad);
		//
		// ad = new Address();
		// ad.setName("海淀区2");
		// ad.setZipcode("22222y");
		// ad.setPerson(per);
		// per.getAddress().add(ad);
		//
		// ad = new Address();
		// ad.setName("MLDN3");
		// ad.setZipcode("333333z");
		// ad.setPerson(per);
		// per.getAddress().add(ad);
		// pao.update(per) ;
		//
		// pao.insert(per);
		// Person p = pao.queryById("ff8080811310a3d7011310a3db600001") ;
		// System.out.println(p.getName()) ;
//		Iterator iter = per.getAddress().iterator();
//		while (iter.hasNext()) {
//			Address a = (Address) iter.next();
//			a.setName(a.getName() + "***");
//			per.getAddress().add(a);
//		}
//		pao.update(per);
		pao.delete("ff8080811310a3d7011310a3db600001") ;
	}
}