src/com/InsuranceBusiness/dao/impl/OrderListDaoImpl.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.OrderListDao;
import com.InsuranceBusiness.model.OrderList;

@Component(value="OrderListDao")
public class OrderListDaoImpl implements OrderListDao {
	private SessionFactory sessionFactory;
	public SessionFactory getSessionFactory() {
		return sessionFactory;
	}
	@Resource(name="sessionFactory")
	public void setSessionFactory(SessionFactory sessionFactory) {
		this.sessionFactory = sessionFactory;
	}
	
	public void addOrder(OrderList ol) {
		Session session = sessionFactory.openSession();
		Transaction tran = session.beginTransaction();
		String sql = "INSERT INTO order_list (order_name, order_cost, order_time, order_uname, order_uid, order_state, product_id) " +
		"VALUES ('"+ol.getOrder_name()+"', '"+ol.getOrder_cost()+"', now(), '"+ol.getOrder_uname()+"', '"+ol.getOrder_uid()+"', '0', '"+ol.getProduct_id()+"')";
		session.createSQLQuery(sql).executeUpdate();
		tran.commit();
		session.close();
	}

	public void delOrder(String oid) {
		Session session = sessionFactory.openSession();
		Transaction tran = session.beginTransaction();
		String sql = "delete from order_list where order_id = '"+oid+"'";
		session.createSQLQuery(sql).executeUpdate();
		tran.commit();
		session.close();
	}

	public List<OrderList> selOrderList(String state) {
		Session session = sessionFactory.openSession();
		String sql="select * from order_list where order_state in ("+state+")";
		Transaction tran = session.beginTransaction();
		SQLQuery sq = session.createSQLQuery(sql);
		List<Object[]> list = sq.list();
		List<OrderList> olist = new ArrayList<OrderList>();
		for(Object[] obj : list){
			OrderList ol = new OrderList();
			ol.setOrder_id((Integer)obj[0]);
			ol.setOrder_name((String)obj[1]);
			ol.setOrder_cost((String)obj[2]);
			ol.setOrder_time((String)obj[3]);
			ol.setOrder_uname((String)obj[4]);