clothesinmanagementdaoimpl.java

一个优秀的干洗店管理系统

package dao.clothesindao.impl;

import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.Iterator;
import java.util.Vector;

import javax.swing.JOptionPane;

import vo.OrderItemVo;
import vo.OrderVo;

import common.LogWriter;

import dao.clothesindao.ClothesInManagementDao;
import dao.commomdao.CommonDao;
import dao.commomdao.impl.CommonDaoImpl;
import dao.common.DBConnectionManager;
import dao.common.DbException;
import dao.common.sql.DbSql;

public class ClothesInManagementDaoImpl implements ClothesInManagementDao{
	private DBConnectionManager manager = DBConnectionManager.getInstance();
	private LogWriter log;
	public ClothesInManagementDaoImpl(LogWriter log) {
		super();
		this.log = log;
	}
	CommonDao dao = new CommonDaoImpl(log);

	public Vector findClothesInGether(String fromDate, String toDate,String operator,String itemId) throws DbException {
		Vector v = null;
		Vector<OrderItemVo> orderItemVector = null;
		Connection con = null;
		PreparedStatement pstmt = null;
		ResultSet set = null;
		try {
			con = manager.getConnection("oracle");
			if(operator == "不限制" && itemId.equals("")){
			pstmt = con.prepareStatement(DbSql.GET_CLOTHESIN_GETHER);
			pstmt.setString(1, fromDate);
			pstmt.setString(2, toDate);
			}else if(itemId.equals("")){
				pstmt = con.prepareStatement(DbSql.GET_CLOTHESIN_GETHER + DbSql.WITH_OPERATOR);
				pstmt.setString(1, fromDate);
				pstmt.setString(2, toDate);
				pstmt.setString(3, operator);
			}else if(operator == "不限制"){
				pstmt = con.prepareStatement(DbSql.GET_CLOTHESIN_GETHER  + DbSql.WITH_ORDERID);
				pstmt.setString(1, fromDate);
				pstmt.setString(2, toDate);			
				pstmt.setString(3, itemId);
			}else{
				pstmt = con.prepareStatement(DbSql.GET_CLOTHESIN_GETHER + DbSql.WITH_OPERATOR + DbSql.WITH_ORDERID);
				pstmt.setString(1, fromDate);
				pstmt.setString(2, toDate);
				pstmt.setString(3, operator);
				pstmt.setString(4, itemId);
			}
			set = pstmt.executeQuery();
			v = new Vector();
			while (set.next()) {				
				long orderId = set.getLong("order_id");				
				int vipId = set.getInt("vip_id");				
				double orderValue = set.getDouble("order_value");
				String inDate = set.getString("in_date").substring(0,10);
				String outDate = set.getString("out_date_prodicted").substring(0,10);
				String paid = set.getString("paid_or_not");
				boolean paidOrNot = false;
				if (paid.equals("是")) {
					paidOrNot = true;
				}
				String taked = set.getString("take_or_not");
				boolean takeOrNot = false;
				if (taked.equals("是")) {
					takeOrNot = true;
				}
				String operaterName = set.getString("operator_name");	
				orderItemVector = new Vector();
				Vector v1 = dao.getOrderItemByOrderId(orderId);
				Iterator iter = v1.iterator();
				while(iter.hasNext()){
					orderItemVector.addElement((OrderItemVo)iter.next());
				}
				v.addElement(new OrderVo(orderId, orderItemVector, vipId, orderValue, inDate,
						outDate, paidOrNot, takeOrNot, operaterName));
			}
			if (v.size() == 0) {
				JOptionPane.showMessageDialog(null, "数据库中不存在从"+fromDate+"到"+toDate+"的符合条件的记录");
				//throw new DbException("数据库中不存在符合条件的记录");
			}		
		}catch(SQLException e){
			JOptionPane.showMessageDialog(null, "收取衣物汇总查找dao异常:= " + e.getMessage());
//			System.out.println("收取衣物汇总查找dao异常:= " + e.getMessage());
		}finally{
			manager.freeConnection("oracle", con);
		}
		return v;
	}	
}