deleteproductbyid.java

来自「java c/s结构开发中使用Hibernate的一些实例」· Java 代码 · 共 39 行

package com.hibernate;

import org.hibernate.Query;
import org.hibernate.Session;
import org.hibernate.SessionFactory;
import org.hibernate.cfg.Configuration;

public class deleteProductByid {

	public static void main(String[] args) {
		//读取配置文件hibernate.cfg.xml
		Configuration cfg = new Configuration().configure();
		
		//创建SessionFactory
		SessionFactory factory = cfg.buildSessionFactory();
		
		//创建Session
		Session session = factory.openSession();
		
		//开启事务
		session.beginTransaction();
		
		// 使用HQL查询
		String hql = "DELETE Product WHERE id=?";
		Query q = session.createQuery(hql);
		q.setString(0, "0511236");
		q.executeUpdate();

		
		//事务提交
		session.getTransaction().commit();
		
		//关闭session
		if(session.isOpen()) {
			session.close();
		}
	}
}