handlesupplier.java

基于mvc的java进销存系统

/*
 * HandleSupplier.java
 *
 * Created on 2007年4月23日, 上午11:28
 *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.Supplier;
import util.DBSession;
import util.PropertiesUtil;

/**
 *
 * @author 下雪天
 */
public class HandleSupplier {
    //private PreparedStatement ps = null;
    //private ResultSet rs = null;
    //private DBConnection dbconnection=new DBConnection();
    private DBSession dbsession=new DBSession();
    
    /** Creates a new instance of HandleSupplier */
    public HandleSupplier() {
    }
    //查找所有供应商信息
    public ArrayList findAll(){
        PreparedStatement ps = null;
        ResultSet rs = null;
        ArrayList arraylist=new ArrayList();
        try {
            String sql = PropertiesUtil.getSql_resource().getString("selectsupplier").trim();
            ps = dbsession.DPreparedStatement(sql);
            rs = ps.executeQuery();
        } catch (SQLException ex) {
            ex.printStackTrace();
        }
        try {
            while(rs.next()){
                Supplier supplier=new Supplier();
                supplier.setSupplierID(rs.getString("SupplierID"));
                supplier.setSupplierName(rs.getString("SupplierName"));
                supplier.setOwerPost(rs.getString("OwerPost"));
                supplier.setOwer(rs.getString("Ower"));
                supplier.setPhone(rs.getString("Phone"));
                supplier.setMobilePhone(rs.getString("MobilePhone"));
                supplier.setSupplierAddress(rs.getString("SupplierAddress"));
                supplier.setLastPurchaseDate(rs.getDate("LastPurchaseDate"));
                arraylist.add(supplier);
            }
        } catch (SQLException ex) {
            ex.printStackTrace();
        }
        dbsession.closedALL(rs);
        return arraylist;
    }
    //保存
     public void save(Supplier supplier){
         PreparedStatement ps = null;
        try {
            String sql = PropertiesUtil.getSql_resource().getString("insertsupplier").trim();
            ps = dbsession.DPreparedStatement(sql);
            ps.setString(1,supplier.getSupplierID());
            ps.setString(2,supplier.getSupplierName());
            ps.setString(4,supplier.getOwerPost());
            ps.setString(3,supplier.getOwer());
            ps.setString(5,supplier.getPhone());
            ps.setString(6,supplier.getMobilePhone());
            ps.setString(7,supplier.getSupplierAddress());
            ps.setDate(8,supplier.getLastPurchaseDate());
            ps.executeUpdate();
        } catch (SQLException ex) {
            ex.printStackTrace();
        }
        try {
            ps.close();
        } catch (SQLException ex) {
            ex.printStackTrace();
        }
        dbsession.connClose();
    }
     //修改供应商资料
     public void update(Supplier supplier){
         PreparedStatement ps = null;
        try {
            String sql = PropertiesUtil.getSql_resource().getString("updatesupplier").trim();
            ps = dbsession.DPreparedStatement(sql);
            ps.setString(1,supplier.getSupplierName());
            ps.setString(2,supplier.getOwerPost());
            ps.setString(3,supplier.getOwer());
            ps.setString(4,supplier.getPhone());
            ps.setString(5,supplier.getMobilePhone());
            ps.setString(6,supplier.getSupplierAddress());
            ps.setDate(7,supplier.getLastPurchaseDate());
            ps.setString(8,supplier.getSupplierID());
            ps.executeUpdate();
        } catch (SQLException ex) {
            ex.printStackTrace();
        }
         try {
            ps.close();
        } catch (SQLException ex) {
            ex.printStackTrace();
        }
        dbsession.connClose();
    }
       public Supplier selectsupplier(Supplier supplier){
        int result = 0;
        PreparedStatement ps = null;
        ResultSet rs = null;
        Supplier s=new Supplier();
        try{
            String sql = PropertiesUtil.getSql_resource().getString("selecsupplier").trim();
            ps = dbsession.DPreparedStatement(sql);
            ps.setString(1,supplier.getSupplierID());
            ps.setString(2,supplier.getSupplierName());
            rs = ps.executeQuery();
            if(rs.next()){
               s.setSupplierID(rs.getString("SupplierID"));
                s.setSupplierName(rs.getString("SupplierName"));
                s.setOwerPost(rs.getString("OwerPost"));
                s.setOwer(rs.getString("Ower"));
                s.setPhone(rs.getString("Phone"));
                s.setMobilePhone(rs.getString("MobilePhone"));
                s.setSupplierAddress(rs.getString("SupplierAddress"));
                s.setLastPurchaseDate(rs.getDate("LastPurchaseDate"));
            }
            
        }catch(SQLException e){
            e.printStackTrace();
        }finally{
            try{
                ps.close();   
                dbsession.connClose();
            }catch(SQLException sqe){
                sqe.printStackTrace();
            }
        }
        return s;
    } 
     public void delete(Supplier supplier){
         PreparedStatement ps = null;
        try {
            String sql = PropertiesUtil.getSql_resource().getString("deletesupplier").trim();
            ps = dbsession.DPreparedStatement(sql);
            ps.setString(1,supplier.getSupplierID());
            //ps.setString(2,supplier.getSupplierName());
            ps.executeUpdate();
        } catch (SQLException ex) {
            ex.printStackTrace();
        }
         try {
            ps.close();
        } catch (SQLException ex) {
            ex.printStackTrace();
        }
        dbsession.connClose();
    }
      public boolean isDelete(Supplier supplier){
          PreparedStatement ps = null;
          ResultSet rs = null;
        try {
            String sql = PropertiesUtil.getSql_resource().getString("selsupplier").trim();
            ps = dbsession.DPreparedStatement(sql);
            ps.setString(1,supplier.getSupplierID());
            rs = ps.executeQuery();
        } catch (SQLException ex) {
            ex.printStackTrace();
        }
        try {
            while(rs.next()){
                if(rs.getString("LastDeliveryDate")!=null){
                    dbsession.closedALL(rs);
                    return false; 
                }                       
            }
        } catch (SQLException ex) {
            ex.printStackTrace();
        }
        dbsession.closedALL(rs);
        return true;
    }
}