handleproduct.java

基于mvc的java进销存系统

/*
 * HandleProduct.java
 *
 * Created on 2007年4月23日, 下午12:51
 *by 陈诗昭
 * To change this template, choose Tools | Template Manager
 * and open the template in the editor.
 */

package task;

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

/**
 *
 * @author 下雪天
 */
public class HandleProduct {
    //private PreparedStatement ps = null;
    //private ResultSet rs = null;
    private DBSession dbsession=new DBSession();
    
    /** Creates a new instance of HandleProduct */
    public HandleProduct() {
    }
    //查找所有销售
    public ArrayList findAll(){
        PreparedStatement ps = null;
        ResultSet rs = null;
        ArrayList arraylist=new ArrayList();
        try {
            String sql = PropertiesUtil.getSql_resource().getString("selectproduct").trim();
            ps = dbsession.DPreparedStatement(sql);
            rs = ps.executeQuery();
        } catch (SQLException ex) {
            ex.printStackTrace();
        }
        try {
            while(rs.next()){
                Product product=new Product();
                product.setProductID(rs.getString("ProductID"));
                product.setProductName(rs.getString("ProductName"));
                product.setSafeStock(rs.getDouble("SafeStock"));
                product.setQuantity(rs.getDouble("Quantity"));
                product.setSuggestBuyPrice(rs.getDouble("SuggestBuyPrice"));
                product.setSuggestSalePrice(rs.getDouble("SuggestSalePrice"));         
                product.setLastPurchaseDate(rs.getDate("LastPurchaseDate"));
                product.setLastDeliveryDate(rs.getDate("LastDeliveryDate"));
                arraylist.add(product);
            }
        } catch (SQLException ex) {
            ex.printStackTrace();
        }
        //dbsession.closedALL(rs);
        return arraylist;
    }
    //删除销售
     public void save(Product product){
         PreparedStatement ps = null;
        try {
            String sql = PropertiesUtil.getSql_resource().getString("insertproduct").trim();
            ps = dbsession.DPreparedStatement(sql);
            ps.setString(1,product.getProductID());
            ps.setString(2,product.getProductName());
            ps.setDouble(3,product.getSafeStock());
            ps.setDouble(4,product.getQuantity());
            ps.setDouble(5,product.getSuggestBuyPrice());
            ps.setDouble(6,product.getSuggestSalePrice());
            ps.setDate(7,product.getLastPurchaseDate());
            ps.setDate(8,product.getLastDeliveryDate());
            ps.executeUpdate();
        } catch (SQLException ex) {
            ex.printStackTrace();
        }
         try {
            ps.close();
        } catch (SQLException ex) {
            ex.printStackTrace();
        }
        dbsession.connClose();
    }
    //修改销售单
     public void addupdate(Product product){
         PreparedStatement ps = null;
        try {
            String sql = PropertiesUtil.getSql_resource().getString("addupdateproduct").trim();
            ps = dbsession.DPreparedStatement(sql);
            //ps.setString(1,product.getProductName());
            //ps.setDouble(2,product.getSafeStock());
            ps.setDouble(1,product.getQuantity());
            ps.setString(2,product.getProductID());
            //ps.setDouble(4,product.getSuggestBuyPrice());
            //ps.setDouble(5,product.getSuggestSalePrice());
            //ps.setDate(6,product.getLastPurchaseDate());
            //ps.setDate(7,product.getLastDeliveryDate());
            ps.executeUpdate();
        } catch (SQLException ex) {
            ex.printStackTrace();
        }
         try {
            ps.close();
        } catch (SQLException ex) {
            ex.printStackTrace();
        }
        dbsession.connClose();
    }
     
     public void update(Product product){
         PreparedStatement ps = null;
        try {
            String sql = PropertiesUtil.getSql_resource().getString("updateproduct").trim();
            ps = dbsession.DPreparedStatement(sql);
            ps.setString(1,product.getProductName());
            ps.setDouble(2,product.getSafeStock());
            ps.setDouble(3,product.getQuantity());
            ps.setDouble(4,product.getSuggestBuyPrice());
            ps.setDouble(5,product.getSuggestSalePrice());
            ps.setDate(6,product.getLastPurchaseDate());
            ps.setDate(7,product.getLastDeliveryDate());
            ps.setString(8,product.getProductID());
            ps.executeUpdate();
        } catch (SQLException ex) {
            ex.printStackTrace();
        }
         try {
            ps.close();
        } catch (SQLException ex) {
            ex.printStackTrace();
        }
        dbsession.connClose();
    }
     public void updateQuantity(Product product){
         PreparedStatement ps = null;
        try {
            String sql = PropertiesUtil.getSql_resource().getString("updateQuantityproduct").trim();
            ps = dbsession.DPreparedStatement(sql);
            //ps.setString(1,product.getProductName());
            //ps.setDouble(2,product.getSafeStock());
            ps.setDouble(1,product.getQuantity());
            ps.setString(2,product.getProductID());
            //ps.setDouble(4,product.getSuggestBuyPrice());
            //ps.setDouble(5,product.getSuggestSalePrice());
            //ps.setDate(6,product.getLastPurchaseDate());
            //ps.setDate(7,product.getLastDeliveryDate());
            ps.executeUpdate();
        } catch (SQLException ex) {
            ex.printStackTrace();
        }
        // try {
            //ps.close();
//        } catch (SQLException ex) {
//            ex.printStackTrace();
//        }
        //dbsession.connClose();
    }
     
     public boolean isdelete(Product product){
         PreparedStatement ps = null;
         ResultSet rs = null;
        try {
            String sql = PropertiesUtil.getSql_resource().getString("selproduct").trim();
            ps = dbsession.DPreparedStatement(sql);
            ps.setString(1,product.getProductID());
            rs = ps.executeQuery();
        } catch (SQLException ex) {
            ex.printStackTrace();
        }
        try {
            while(rs.next()){
                if(rs.getDouble("Quantity")<product.getQuantity()){
                    dbsession.closedALL(rs);
                    return false;
                }
            }
        } catch (SQLException ex) {
            ex.printStackTrace();
        }
        //dbsession.closedALL(rs);
        return true;
    }
     //删除销售单
     public void delete(Product product){
         PreparedStatement ps = null;
        try {
            String sql = PropertiesUtil.getSql_resource().getString("deleteproduct").trim();
            ps = dbsession.DPreparedStatement(sql);
            ps.setString(1,product.getProductID());
            ps.executeUpdate();
        } catch (SQLException ex) {
            ex.printStackTrace();
        }
         try {
            ps.close();
        } catch (SQLException ex) {
            ex.printStackTrace();
        }
        dbsession.connClose();
    }
     //是否能够删除
     public boolean isDelete(Product product){
         PreparedStatement ps = null;
         ResultSet rs = null;
        try {
            String sql = PropertiesUtil.getSql_resource().getString("selectsupplier").trim();
            ps = dbsession.DPreparedStatement(sql);
            ps.setString(1,product.getProductID());
            rs = ps.executeQuery();
        } catch (SQLException ex) {
            ex.printStackTrace();
        }
        try {
            while(rs.next()){
                if((rs.getString("LastPurchaseDate")!=null)||(rs.getString("LastDeliveryDate")!=null))
                {
                    dbsession.closedALL(rs);
                    return false; 
                }
            }
        } catch (SQLException ex) {
            ex.printStackTrace();
        }
        dbsession.closedALL(rs);
        return true;
    }
}