handlepurchasedetail.java

基于mvc的java进销存系统

/*
 * HandlePurchaseDetail.java
 *
 * Created on 2007年5月6日, 下午5:22
 *
 * To change this template, choose Tools | Template Manager
 * and open the template in the editor.
 */
//PurchaseID  采购单编号
//ProductID   商品编号
//Quantity     采购/退货数量
//Price      采购/退货单价
//Amount    总金额

package task;

import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.ArrayList;
import table.PurchaseDetail;
import util.DBSession;
import util.PropertiesUtil;

/**
 *负规责则录入、修改、删除采购（采购退货）单据的业务
 * @author 下雪天
 */
public class HandlePurchaseDetail {
    private DBSession dbsession=new DBSession();  
    /** Creates a new instance of HandlePurchaseDetail */
    public HandlePurchaseDetail() {
    }
    public ArrayList find(String str){
        PreparedStatement ps = null;
          ResultSet rs = null;
          ArrayList arraylist=new ArrayList();
        try {
            String sql = PropertiesUtil.getSql_resource().getString("selpurchaseDetail").trim();
            ps = dbsession.DPreparedStatement(sql);
            ps.setString(1,str);
            rs = ps.executeQuery();
        } catch (SQLException ex) {
            ex.printStackTrace();
        }
      try {
            while(rs.next()){
                PurchaseDetail p  =new PurchaseDetail();       
                p.setPurchaseID(rs.getString("PurchaseID"));
                p.setProductID(rs.getString("ProductID"));
                p.setQuantity(rs.getDouble("Quantity"));
                p.setPrice(rs.getDouble("Price"));
                p.setAmount(rs.getDouble("Amount"));
                arraylist.add(p);
            }
        } catch (SQLException ex) {
            ex.printStackTrace();
        }
        //dbsession.closedALL(rs);
        return arraylist;
    }
  public ArrayList findAll(){
          PreparedStatement ps = null;
          ResultSet rs = null;
          ArrayList arraylist=new ArrayList();
        try {
            String sql = PropertiesUtil.getSql_resource().getString("selectpurchaseDetail").trim();
            ps = dbsession.DPreparedStatement(sql);
            rs = ps.executeQuery();
        } catch (SQLException ex) {
            ex.printStackTrace();
        }
      try {
            while(rs.next()){
                PurchaseDetail purchaseDetail  =new PurchaseDetail();       
                purchaseDetail.setPurchaseID(rs.getString("PurchaseID"));
                purchaseDetail.setProductID(rs.getString("ProductID"));
                purchaseDetail.setQuantity(rs.getDouble("Quantity"));
                purchaseDetail.setPrice(rs.getDouble("Price"));
                purchaseDetail.setAmount(rs.getDouble("Amount"));
                arraylist.add(purchaseDetail);
            }
        } catch (SQLException ex) {
            ex.printStackTrace();
        }
        dbsession.closedALL(rs);
        return arraylist;
    }
   public void save(PurchaseDetail purchaseDetail ){
        PreparedStatement ps = null;
        ResultSet rs = null;
        try {
            String sql = PropertiesUtil.getSql_resource().getString("insertpurchaseDetail").trim();
            ps = dbsession.DPreparedStatement(sql);
            ps.setString(1,purchaseDetail.getPurchaseID());
            ps.setString(2,purchaseDetail.getProductID());
            ps.setDouble(3,purchaseDetail.getQuantity());
            ps.setDouble(4,purchaseDetail.getPrice());
            //ps.setDouble(5,purchaseDetail.getAmount());
            ps.executeUpdate();
        } catch (SQLException ex) {
            ex.printStackTrace();
        }
        try {
            ps.close();
        } catch (SQLException ex) {
            ex.printStackTrace();
        }
        dbsession.connClose();
    }
      public void update(PurchaseDetail purchaseDetail ){
          PreparedStatement ps = null;
          ResultSet rs = null;
        try {
            String sql = PropertiesUtil.getSql_resource().getString("updatepurchaseDetail").trim();
            ps = dbsession.DPreparedStatement(sql);
            ps.setString(1,purchaseDetail.getPurchaseID());
            ps.setString(2,purchaseDetail.getProductID());
            ps.setDouble(3,purchaseDetail.getQuantity());
            ps.setDouble(4,purchaseDetail.getPrice());
            ps.setDouble(5,purchaseDetail.getAmount());
            ps.executeUpdate();
        } catch (SQLException ex) {
            ex.printStackTrace();
        }
        try {
            rs.close();
        } catch (SQLException ex) {
            ex.printStackTrace();
        }
          dbsession.connClose();
    }
       public void delete(PurchaseDetail purchaseDetail){
        PreparedStatement ps = null;
        ResultSet rs = null;
        try {
            String sql = PropertiesUtil.getSql_resource().getString("deletepurchaseDetail").trim();
            ps = dbsession.DPreparedStatement(sql);
            ps.setString(1,purchaseDetail.getPurchaseID());
            ps.setString(2,purchaseDetail.getProductID());
            ps.executeUpdate();
        } catch (SQLException ex) {
            ex.printStackTrace();
        }
        try {
            ps.close();
        } catch (SQLException ex) {
            ex.printStackTrace();
        }
    }
    
}