mateoutdetaildao.java

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

package imis_mate.DAO;

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 java.util.List;

import imis_mate.bean.MateOutBaseBean;
import imis_mate.bean.MateOutDetailBean;
import cmis.database.DBPoolManager;

public class MateOutDetailDAO {
	private DBPoolManager dbpool;
	private boolean flag;
	private Statement pstmt;
	

	public MateOutDetailDAO(){
		dbpool = new DBPoolManager();

	}
	
	public boolean save(MateOutDetailBean modb){
		flag = false;
		dbpool.getConnection();
		String saveSql = "insert into Material_Out_Detail(outNoId,outNo,materialName,maModel," +
				"maBrand,maMadeIn,materialTypeNo,materialNo,priceUnit,outCount)  values(OutNoId.nextval," +
				"'"+modb.getOutNo()+"','"+modb.getMaterialName()+"','"+modb.getMaModel()+"','"+modb.getMaBrand()+"','"+
				modb.getMaMadeIn()+"','"+modb.getMaterialTypeNo()+"',"+modb.getMaterialNo()+","+modb.getPriceUnit()+","+modb.getOutCount()+")";
		try {
			pstmt=dbpool.conn.createStatement();
			flag = pstmt.executeUpdate(saveSql)>0?true:false;		
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}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(MateOutDetailBean modb){
		flag = false;
		dbpool.getConnection();
		String sql="update Material_Out_Detail set outNo='"+modb.getOutNo()+
		"',materialName='"+ modb.getMaterialName()+"',maModel='"+modb.getMaModel()+"',maBrand='"+modb.getMaBrand()
		+"',maMadeIn='"+modb.getMaMadeIn()+"',materialTypeNo='"+modb.getMaterialTypeNo()+"',materialNo="+modb.getMaterialNo()
		+",priceUnit="+modb.getPriceUnit()+",outCount="+modb.getOutCount()+" where outNoId="+modb.getOutNoId();
		try {
			
			pstmt=dbpool.conn.createStatement();
			flag=pstmt.executeUpdate(sql)>0?true:false;
			
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			flag=false;
			e.printStackTrace();
		}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(MateOutDetailBean modb){
		flag=false;
		dbpool.getConnection();
		String sql ="delete from Material_Out_Detail where outNoId="+modb.getOutNoId();
		try {
			pstmt=dbpool.conn.createStatement();
			flag=pstmt.executeUpdate(sql)>0?true:false;
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			flag=false;
			e.printStackTrace();
		} 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 OutNoId){
		flag=false;
		dbpool.getConnection();
		String sql ="delete from Material_Out_Detail where outNoId="+OutNoId;
		try {
			pstmt=dbpool.conn.createStatement();
			flag=pstmt.executeUpdate(sql)>0?true:false;
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			flag=false;
			e.printStackTrace();
		} 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(List list){
		flag=false;
		dbpool.getConnection();
		Iterator it = list.iterator();
		dbpool.setAutoCommit(false);
		MateOutDetailBean modb = new MateOutDetailBean();
		while(it.hasNext()){
		modb=(MateOutDetailBean)it.next();
		
		{
		String sql ="UPDATE Material_Table SET nowCount = nowCount + "+modb.getOutCount()	+ "WHERE materialNo = "+modb.getMaterialNo();
		String sql1 ="delete from Material_Out_Detail where outNoId="+modb.getOutNoId();
		try {
			
			pstmt=dbpool.conn.createStatement();
			flag=pstmt.executeUpdate(sql1)>0?true:false;
//			if(flag){
//				flag=pstmt.executeUpdate(sql)>0?true:false;
//			}
			if(flag){
				pstmt.executeUpdate(sql);
			}
			
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			flag=false;
			e.printStackTrace();
		}
		
		
		}if(flag==false){
	 		dbpool.rollback();
			break;
		}
	}
		dbpool.commit();
	
		
		
			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(String OutNo){
		flag=false;
		dbpool.getConnection();

		if(getMateOutDetailBeanOfOutNo(OutNo).size()!=0)
		{
		String sql ="delete from Material_Out_Detail where outNo='"+OutNo+"'";
		try {
			
			pstmt=dbpool.conn.createStatement();
			flag=pstmt.executeUpdate(sql)>0?true:false;
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			flag=false;
			e.printStackTrace();
		} finally{
			dbpool.freeConnection();
			if(pstmt!=null){
				try {
					pstmt.close();
				} catch (SQLException e) {
					// TODO Auto-generated catch block
					e.printStackTrace();
				}
				pstmt=null;
			}
		}
		return flag;}
		else {
			return true;
			}
	}
	
	public MateOutDetailBean getMateOutDetailBeanOfOutNoId(int outNoId){
		MateOutDetailBean modb = new MateOutDetailBean();
		dbpool.getConnection();
		String sql ="select OutNoId,OutNo,MaterialName,MaModel,MaBrand,MaMadeIn,MaterialTypeNo,MaterIalNo,PriceUnit,OutCount,ChaFlag from Material_Out_Detail where OutNoId="+outNoId;
		Statement stmt;
		try {
			stmt = dbpool.conn.createStatement();
			ResultSet rs = stmt.executeQuery(sql);
			while(rs.next()){
				
				modb.setOutNoId(rs.getInt("OutNoId"));
				if(rs.getString("OutNo")==null){
					modb.setOutNo("");
				}else{
					modb.setOutNo(rs.getString("OutNo").trim());
				}
				if(rs.getString("MaterialName")==null){
					modb.setMaterialName("");
				}else{
					modb.setMaterialName(rs.getString("MaterialName").trim());
				}
				if(rs.getString("MaModel")==null){
					modb.setMaModel("");
				}else{
					modb.setMaModel(rs.getString("MaModel").trim());
				}
				if(rs.getString("MaBrand")==null){
					modb.setMaBrand("");
				}else{
					modb.setMaBrand(rs.getString("MaBrand").trim());
				}
				if(rs.getString("MaMadeIn")==null){
					modb.setMaMadeIn("");
				}else{
					modb.setMaMadeIn(rs.getString("MaMadeIn").trim());
				}
				if(rs.getString("MaterialTypeNo")==null){
					modb.setMaterialTypeNo("");
				}else{
					modb.setMaterialTypeNo(rs.getString("MaterialTypeNo").trim());
				}
				modb.setMaterialNo(rs.getInt("MaterialNo"));
				modb.setPriceUnit(rs.getDouble("PriceUnit"));
				modb.setOutCount(rs.getInt("OutCount"));
				if(rs.getString("ChaFlag")==null){
					modb.setChaFlag("");
				}else{
					modb.setChaFlag(rs.getString("ChaFlag").trim());
				}
			}
		
			stmt.close();
			rs.close();
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}finally{
			dbpool.freeConnection();
		}
		return modb;	
	}
	
	public ArrayList getMateOutDetailBean(){
		ArrayList list = new ArrayList();
		MateOutDetailBean modb = new MateOutDetailBean();
		dbpool.getConnection();
		String sql ="select OutNoId,OutNo,MaterialName,MaModel,MaBrand,MaMadeIn,MaterialTypeNo,MaterIalNo,PriceUnit,OutCount,ChaFlag from Material_Out_Detail";
		try {
			Statement stmt = dbpool.conn.createStatement();
			ResultSet rs = stmt.executeQuery(sql);
			while(rs.next()){
				modb.setOutNoId(rs.getInt("OutNoId"));
				if(rs.getString("OutNo")==null){
					modb.setOutNo("");
				}else{
					modb.setOutNo(rs.getString("OutNo").trim());
				}
				if(rs.getString("MaterialName")==null){
					modb.setMaterialName("");
				}else{
					modb.setMaterialName(rs.getString("MaterialName").trim());
				}
				if(rs.getString("MaModel")==null){
					modb.setMaModel("");
				}else{
					modb.setMaModel(rs.getString("MaModel").trim());
				}
				if(rs.getString("MaBrand")==null){
					modb.setMaBrand("");
				}else{
					modb.setMaBrand(rs.getString("MaBrand").trim());
				}
				if(rs.getString("MaMadeIn")==null){
					modb.setMaMadeIn("");
				}else{
					modb.setMaMadeIn(rs.getString("MaMadeIn").trim());
					
				}
				if(rs.getString("MaterialTypeNo")==null){
					modb.setMaterialTypeNo("");
				}else{
					modb.setMaterialTypeNo(rs.getString("MaterialTypeNo").trim());
				}
				modb.setMaterialNo(rs.getInt("MaterialNo"));
				modb.setPriceUnit(rs.getDouble("PriceUnit"));
				modb.setOutCount(rs.getInt("OutCount"));
				if(rs.getString("ChaFlag")==null){
					modb.setChaFlag("");
				}else{
					modb.setChaFlag(rs.getString("ChaFlag").trim());
				}
				list.add(modb);
			}
			stmt.close();
			rs.close();
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}finally{
			dbpool.freeConnection();
		}
		return list;