src/com/InsuranceBusiness/dao/impl/ProductListDaoImpl.java

这里只显示每个文件的开头 60 行。登录后可以解锁完整代码。

微信扫码关注公众号，代码整理好后第一时间通知你。

package com.InsuranceBusiness.dao.impl;

import java.util.ArrayList;
import java.util.List;

import javax.annotation.Resource;

import org.hibernate.SQLQuery;
import org.hibernate.Session;
import org.hibernate.SessionFactory;
import org.hibernate.Transaction;
import org.springframework.stereotype.Component;

import com.InsuranceBusiness.dao.ProductListDao;
import com.InsuranceBusiness.model.ProductList;

@Component(value="ProductListDao")
public class ProductListDaoImpl implements ProductListDao {
	private SessionFactory sessionFactory;
	public SessionFactory getSessionFactory() {
		return sessionFactory;
	}
	@Resource(name="sessionFactory")
	public void setSessionFactory(SessionFactory sessionFactory) {
		this.sessionFactory = sessionFactory;
	}
	
	public void addProduct(ProductList pl) {
		Session session = sessionFactory.openSession();
		Transaction tran = session.beginTransaction();
		String sql = "INSERT INTO product_list (product_name, product_desc, product_cost, product_time) " +
		"VALUES ('"+pl.getProduct_name()+"', '"+pl.getProduct_desc()+"', '"+pl.getProduct_cost()+"', now())";
		session.createSQLQuery(sql).executeUpdate();
		tran.commit();
		session.close();
	}

	public void delProduct(String pid) {
		Session session = sessionFactory.openSession();
		Transaction tran = session.beginTransaction();
		String sql = "delete from product_list where product_id = '"+pid+"'";
		session.createSQLQuery(sql).executeUpdate();
		tran.commit();
		session.close();
	}

	public List<ProductList> selProductList() {
		Session session = sessionFactory.openSession();
		String sql="select * from product_list";
		Transaction tran = session.beginTransaction();
		SQLQuery sq = session.createSQLQuery(sql);
		List<Object[]> list = sq.list();
		List<ProductList> plist = new ArrayList<ProductList>();
		for(Object[] obj : list){
			ProductList pl = new ProductList();
			pl.setProduct_id((Integer)obj[0]);
			pl.setProduct_name((String)obj[1]);
			pl.setProduct_desc((String)obj[2]);
			pl.setProduct_cost((String)obj[3]);
			pl.setProduct_time((String)obj[4]);