handledeliverymaster.java

基于mvc的java进销存系统

/*
 * HandleDeliveryMaster.java
 *
 * Created on 2007年5月6日, 下午4:39
 *
 * 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.DeliveryMaster;
import util.DBSession;
import util.PropertiesUtil;

/**
 *
 * @author 下雪天
 */
public class HandleDeliveryMaster {
    private DBSession dbsession=new DBSession();
    /** Creates a new instance of HandleDeliveryMaster */
    public HandleDeliveryMaster() {
    }
    
    public Boolean find(String str){
        ArrayList arraylist=new ArrayList();
        PreparedStatement ps = null;
        ResultSet rs = null;
        try {
            String sql = PropertiesUtil.getSql_resource().getString("seldeliveryMaster").trim();
            ps = dbsession.DPreparedStatement(sql);
            ps.setString(1,str);
            rs = ps.executeQuery();
        } catch (SQLException ex) {
            ex.printStackTrace();
        }
      try {
            while(rs.next()){
                return true;
            }
        } catch (SQLException ex) {
            ex.printStackTrace();
        }
        //dbsession.closedALL(rs);
        return false; 
    }
    
    public ArrayList findAll(){
          PreparedStatement ps = null;
          ResultSet rs = null;
          ArrayList arraylist=new ArrayList();
        try {
            String sql = PropertiesUtil.getSql_resource().getString("selectdeliveryMaster").trim();
            ps = dbsession.DPreparedStatement(sql);
            rs = ps.executeQuery();
        } catch (SQLException ex) {
            ex.printStackTrace();
        }
      try {
            while(rs.next()){
                DeliveryMaster  deliveryMaster =new DeliveryMaster();       
                deliveryMaster.setDeliveryID(rs.getString("DeliveryID"));
                deliveryMaster.setDeliveryProperty(rs.getString("DeliveryProperty"));
                deliveryMaster.setDeliveryDate(rs.getString("DeliveryDate"));
                deliveryMaster.setCustomerID(rs.getString("CustomerID"));
                deliveryMaster.setDeliveryAddress(rs.getString("DeliveryAddress"));
                arraylist.add(deliveryMaster);
            }
        } catch (SQLException ex) {
            ex.printStackTrace();
        }
        dbsession.closedALL(rs);
        return arraylist;
    }
    //保存
     public void save(DeliveryMaster deliveryMaster ){
        PreparedStatement ps = null;
        ResultSet rs = null;
        try {
            String sql = PropertiesUtil.getSql_resource().getString("insertdeliveryMaster").trim();
            ps = dbsession.DPreparedStatement(sql);
            ps.setString(1,deliveryMaster.getDeliveryID());
            ps.setString(2,deliveryMaster.getDeliveryProperty());
            ps.setString(3,deliveryMaster.getDeliveryDate());
            ps.setString(4,deliveryMaster.getCustomerID());
            ps.setString(5,deliveryMaster.getDeliveryAddress());
            ps.executeUpdate();
        } catch (SQLException ex) {
            ex.printStackTrace();
        }
        try {
            ps.close();
        } catch (SQLException ex) {
            ex.printStackTrace();
        }
        dbsession.connClose();
    }
      public void update(DeliveryMaster deliveryMaster ){
          PreparedStatement ps = null;
          ResultSet rs = null;
        try {
            String sql = PropertiesUtil.getSql_resource().getString("updatedeliveryMaster").trim();
            ps = dbsession.DPreparedStatement(sql);
            ps.setString(1,deliveryMaster.getDeliveryID());
            ps.setString(2,deliveryMaster.getDeliveryProperty());
            ps.setString(3,deliveryMaster.getDeliveryDate());
            ps.setString(4,deliveryMaster.getCustomerID());
            ps.setString(5,deliveryMaster.getDeliveryAddress());
            ps.executeUpdate();
        } catch (SQLException ex) {
            ex.printStackTrace();
        }
        try {
            rs.close();
        } catch (SQLException ex) {
            ex.printStackTrace();
        }
          dbsession.connClose();
    }
     public void delete(DeliveryMaster deliveryMaster){
        PreparedStatement ps = null;
        ResultSet rs = null;
        try {
            String sql = PropertiesUtil.getSql_resource().getString("deletedeliveryMaster").trim();
            ps = dbsession.DPreparedStatement(sql);
            ps.setString(1,deliveryMaster.getDeliveryID());
            ps.executeUpdate();
        } catch (SQLException ex) {
            ex.printStackTrace();
        }
        try {
            ps.close();
        } catch (SQLException ex) {
            ex.printStackTrace();
        }
    }
}