materialbuydetaildao.java

JSP移动商品管理平台源代码.........

package imis_mate.DAO;

import imis_mate.bean.MaterialBuyBean;
import imis_mate.bean.MaterialBuyDetailBean;

import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import java.util.ArrayList;
import java.util.Iterator;

import cmis.database.DBPoolManager;

public class MaterialBuyDetailDAO {
	private boolean flag;

	private PreparedStatement pstmt;

	private Statement st;

	private DBPoolManager dbpool;

	public MaterialBuyDetailDAO() {
		dbpool = new DBPoolManager();
	}

	public boolean save(MaterialBuyDetailBean mbdb) {
		flag = false;
		dbpool.getConnection();

		// String sql = "insert into
		// Material_Buy_Detail(BuyId,BuyNo,MaterialTypeName,MaModel,MaBrand,MaMadeIn,MaterialTypeNo,PriceUnit,InCount)
		// values(BuyId.nextval,?,?,?,?,?,?,?,?)";
		String sql = "insert into Material_Buy_Detail(BuyId,BuyNo,MaterialTypeName,MaModel,MaBrand,MaMadeIn,MaterialTypeNo,PriceUnit,InCount) values(BuyId.nextval,'";
		sql = sql + mbdb.getBuyNo() + "','";
		sql = sql + mbdb.getMaterialTypeName() + "','";
		sql = sql + mbdb.getMaModel() + "','";
		sql = sql + mbdb.getMaBrand() + "','";
		sql = sql + mbdb.getMaMadeIn() + "','";
		sql = sql + mbdb.getMaterialTypeNo() + "',";
		sql = sql + mbdb.getPriceUnit() + ",";
		sql = sql + mbdb.getInCount() + ")";

	
		try {

			st = dbpool.conn.createStatement();
			flag = st.executeUpdate(sql) > 0 ? true : false;
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
			flag = false;
		} finally {
			dbpool.freeConnection();
			if (pstmt != null) {
				try {
					pstmt.close();
				} catch (SQLException e) {
					// TODO Auto-generated catch block
					e.printStackTrace();
				}
				pstmt = null;
			}
		}
		return flag;
	}

	public boolean update(MaterialBuyDetailBean mbdb) {
		flag = false;
		dbpool.getConnection();
		//String sql = "update Material_Buy_Detail set BuyNo=?,MaterialTypeName=?,MaModel=?,MaBrand=?,MaMadeIn=?,MaterialTypeNo=?,PriceUnit=?,InCount=? where BuyId=?";
		String sql = "update Material_Buy_Detail set BuyNo='";
			sql=sql+mbdb.getBuyNo()+"',MaterialTypeName='";
			sql = sql + mbdb.getMaterialTypeName()+"',MaModel='";
			sql = sql + mbdb.getMaModel() +"',MaBrand='";
			sql = sql + mbdb.getMaBrand() +"',MaMadeIn='";
			sql = sql + mbdb.getMaMadeIn() +"',MaterialTypeNo='";
			sql = sql + mbdb.getMaterialTypeNo() +"',PriceUnit=";
			sql = sql + mbdb.getPriceUnit() +",InCount=";
			sql = sql + mbdb.getInCount();
			sql = sql + " where BuyId=";
			sql = sql + mbdb.getBuyId() ;
			//System.out.println("updateDetail:"+sql);
		try {
			st = dbpool.conn.createStatement();
			flag = st.executeUpdate(sql)>0? true : false;
				
		
			  
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
			flag = false;
		} finally {
			dbpool.freeConnection();
			if (st != null) {
				try {
					st.close();
				} catch (SQLException e) {
					// TODO Auto-generated catch block
					e.printStackTrace();
				}
				st = null;
			}
		}
	
		return flag;
	}

	public boolean delete(MaterialBuyDetailBean mbdb) {
		flag = false;
		dbpool.getConnection();
		String sql = "delete from  Material_Buy_Detail where BuyId="
				+ mbdb.getBuyId();
		try {
			st = dbpool.conn.createStatement();
			st.executeUpdate(sql);
			flag = pstmt.executeUpdate(sql) > 0 ? true : false;
			dbpool.commit();
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
			flag = false;
		} finally {
			dbpool.freeConnection();
			if (pstmt != null) {
				try {
					pstmt.close();
				} catch (SQLException e) {
					// TODO Auto-generated catch block
					e.printStackTrace();
				}
				pstmt = null;
			}
		}
		return flag;
	}

	public boolean delete(int buyId) {
		flag = false;
		dbpool.getConnection();
		String sql = "delete from  Material_Buy_Detail where BuyId=" + buyId;
		try {
			st = dbpool.conn.createStatement();
			flag = st.executeUpdate(sql) > 0 ? true : false;
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
			flag = false;
		} finally {
			dbpool.freeConnection();
			if (st != null) {
				try {
					st.close();
				} catch (SQLException e) {
					// TODO Auto-generated catch block
					e.printStackTrace();
				}
				st = null;
			}
		}
		return flag;
	}

	public boolean delete(String BuyNo){
		flag = false;
		DBPoolManager db = new DBPoolManager();
		db.getConnection();
		//dbpool.getConnection();
		
		if(getMaterialBuyDetailOfBuyNo(BuyNo).size() != 0){	
		
		String sql = "delete from  Material_Buy_Detail where BuyNO='"+BuyNo+"'";
		try {
			st = db.conn.createStatement();
			flag = st.executeUpdate(sql)>0?true:false;
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
			flag = false;
		}finally{
			db.freeConnection();
			if(st!=null){
				try {
					st.close();
				} catch (SQLException e) {
					// TODO Auto-generated catch block
					e.printStackTrace();
				}
				st=null;
			}
		
		}
		}
		else{
			flag = true;			
		}
		return flag;
		
	}

	public boolean updateFlag(MaterialBuyDetailBean mbdb) throws SQLException {
		//更改入库标志
		flag = false;
		dbpool.getConnection();
		st = dbpool.conn.createStatement();
		String sql = "update Material_Buy_Detail set Flag='*' where BuyId="+mbdb.getBuyId();
		try {
			
					
			flag = st.executeUpdate(sql) > 0 ? true : false;
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
			flag = false;
		} finally {
			dbpool.freeConnection();
			if (st != null) {
				try {
					st.close();
				} catch (SQLException e) {
					// TODO Auto-generated catch block
					e.printStackTrace();
				}
				st = null;
			}
		}
		return flag;
	}
	public boolean updateFlag(int buyId, boolean buyFlag) throws SQLException {
		//更改入库标志 根据采购单id
		flag = false;
		dbpool.getConnection();
		st = dbpool.conn.createStatement();
		String sql = null;
		if(buyFlag){
			sql = "update Material_Buy_Detail set Flag='*' where BuyId="+buyId;
		}else {
			sql = "update Material_Buy_Detail set Flag = null where BuyId="+buyId;
		} 
		
		try {	
			flag = st.executeUpdate(sql) > 0 ? true : false;
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
			flag = false;
		} finally {
			dbpool.freeConnection();
			if (st != null) {
				try {
					st.close();
				} catch (SQLException e) {
					// TODO Auto-generated catch block
					e.printStackTrace();
				}
				st = null;
			}
		}
		return flag;
	}

	public boolean updateReFlag(MaterialBuyDetailBean mbdb) throws SQLException {
		flag = false;
		dbpool.getConnection();
		st = dbpool.conn.createStatement();
		String sql = "update Material_Buy_Detail set ReFlag='*' where BuyId="+mbdb.getBuyId();
		try {
			flag = st.executeUpdate(sql) > 0 ? true : false;
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
			flag = false;
		} finally {
			dbpool.freeConnection();
			if (st != null) {
				try {
					st.close();
				} catch (SQLException e) {
					// TODO Auto-generated catch block
					e.printStackTrace();
					flag = false;
				}
				st = null;
			}
		}
		return flag;
	}

	public ArrayList getMaterialBuyDetail() {
		ArrayList list = new ArrayList();
		MaterialBuyDetailBean mbdb = new MaterialBuyDetailBean();
		dbpool.getConnection();

		String sql = "select BuyId,BuyNo,MaterialTypeName,MaModel,MaBrand,MaMadeIn,MaterialTypeNo,PriceUnit,InCount,Flag,ReFlag from Material_Buy_Detail";
		try {
			Statement stmt = dbpool.conn.createStatement();
			ResultSet rset = stmt.executeQuery(sql);
			while (rset.next()) {
				mbdb.setBuyId(rset.getInt("BuyId"));
				if (rset.getString("BuyNo") == null) {
					mbdb.setBuyNo("");
				} else {
					mbdb.setBuyNo(rset.getString("BuyNo").trim());
				}
				if (rset.getString("MaterialTypeName") == null) {
					mbdb.setMaterialTypeName("");
				} else {
					mbdb.setMaterialTypeName(rset.getString("MaterialTypeName")
							.trim());
				}
				if (rset.getString("MaModel") == null) {
					mbdb.setMaModel("");
				} else {
					mbdb.setMaModel(rset.getString("MaModel").trim());
				}
				if (rset.getString("Mabrand") == null) {
					mbdb.setMaBrand("");
				} else {
					mbdb.setMaBrand(rset.getString("Mabrand"));
				}
				if (rset.getString("MaMadeIn") == null) {
					mbdb.setMaMadeIn("");
				} else {
					mbdb.setMaMadeIn(rset.getString("MaMadeIn").trim());
				}
				if (rset.getString("MaterialTypeNo") == null) {
					mbdb.setMaterialTypeNo("");
				} else {
					mbdb.setMaterialTypeNo(rset.getString("MaterialTypeNo")
							.trim());
				}
				mbdb.setPriceUnit(rset.getDouble("PriceUnit"));
				mbdb.setInCount(rset.getInt("InCount"));
				if (rset.getString("Flag") == null) {
					mbdb.setFlag("");
				} else {
					mbdb.setFlag(rset.getString("Flag").trim());
				}
				if (rset.getString("ReFlag") == null) {
					mbdb.setReFlag("");
				} else {
					mbdb.setReFlag(rset.getString("ReFlag").trim());
				}
				list.add(mbdb);
			}
			stmt.close();
			rset.close();
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		} finally {
			dbpool.freeConnection();
		}