handledeliverydetail.java

基于mvc的java进销存系统

/*
 * HandleDeliveryDetail.java
 *
 * Created on 2007年4月25日, 下午7:42
 *
 * 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.DeliveryDetail;
import util.DBSession;
import util.PropertiesUtil;

/**
 *
 * @author 下雪天
 */
public class HandleDeliveryDetail {
    private DBSession dbsession=new DBSession();  
    
    /** Creates a new instance of HandleDeliveryDetail */
    public HandleDeliveryDetail() {
    }
    
    public ArrayList find(String str){
        PreparedStatement ps = null;
          ResultSet rs = null;
          ArrayList arraylist=new ArrayList();
        try {
            String sql = PropertiesUtil.getSql_resource().getString("seldeliveryDetail").trim();
            ps = dbsession.DPreparedStatement(sql);
            ps.setString(1,str);
            rs = ps.executeQuery();
        } catch (SQLException ex) {
            ex.printStackTrace();
        }
      try {
            while(rs.next()){
                DeliveryDetail  deliveryDetail =new DeliveryDetail();       
                deliveryDetail.setDeliveryID(rs.getString("DeliveryID"));
                deliveryDetail.setAmount(rs.getDouble("Amount"));
                deliveryDetail.setPrice(rs.getDouble("Price"));
                deliveryDetail.setProductID(rs.getString("ProductID"));
                deliveryDetail.setQuantity(rs.getDouble("Quantity"));
                arraylist.add(deliveryDetail);
            }
        } 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("selectdeliveryDetail").trim();
            ps = dbsession.DPreparedStatement(sql);
            rs = ps.executeQuery();
        } catch (SQLException ex) {
            ex.printStackTrace();
        }
      try {
            while(rs.next()){
                DeliveryDetail  deliveryDetail =new DeliveryDetail();       
                deliveryDetail.setDeliveryID(rs.getString("DeliveryID"));
                deliveryDetail.setAmount(rs.getDouble("Amount"));
                deliveryDetail.setPrice(rs.getDouble("Price"));
                deliveryDetail.setProductID(rs.getString("ProductID"));
                deliveryDetail.setQuantity(rs.getDouble("Quantity"));
                arraylist.add(deliveryDetail);
            }
        } catch (SQLException ex) {
            ex.printStackTrace();
        }
        dbsession.closedALL(rs);
        return arraylist;
    }
    //保存
     public void save(DeliveryDetail deliveryDetail ){
        PreparedStatement ps = null;
        ResultSet rs = null;
        try {
            String sql = PropertiesUtil.getSql_resource().getString("insertdeliveryDetail").trim();
            ps = dbsession.DPreparedStatement(sql);
            ps.setString(1,deliveryDetail.getDeliveryID());
            ps.setString(2,deliveryDetail.getProductID());
            ps.setDouble(3,deliveryDetail.getQuantity());
            ps.setDouble(4,deliveryDetail.getPrice());
            ps.setDouble(5,deliveryDetail.getAmount());
            ps.executeUpdate();
        } catch (SQLException ex) {
            ex.printStackTrace();
        }
        try {
            ps.close();
        } catch (SQLException ex) {
            ex.printStackTrace();
        }
        dbsession.connClose();
    }
      public void update(DeliveryDetail deliveryDetail ){
          PreparedStatement ps = null;
          ResultSet rs = null;
        try {
            String sql = PropertiesUtil.getSql_resource().getString("updatedeliveryDetail").trim();
            ps = dbsession.DPreparedStatement(sql);
            ps.setString(1,deliveryDetail.getDeliveryID());
            ps.setString(2,deliveryDetail.getProductID());
            ps.setDouble(3,deliveryDetail.getQuantity());
            ps.setDouble(4,deliveryDetail.getPrice());
            ps.setDouble(5,deliveryDetail.getAmount());
            ps.executeUpdate();
        } catch (SQLException ex) {
            ex.printStackTrace();
        }
        try {
            rs.close();
        } catch (SQLException ex) {
            ex.printStackTrace();
        }
          dbsession.connClose();
    }
     public void delete(DeliveryDetail deliveryDetail){
        PreparedStatement ps = null;
        ResultSet rs = null;
        try {
            String sql = PropertiesUtil.getSql_resource().getString("deletedeliveryDetail").trim();
            ps = dbsession.DPreparedStatement(sql);
            ps.setString(1,deliveryDetail.getDeliveryID());
            ps.executeUpdate();
        } catch (SQLException ex) {
            ex.printStackTrace();
        }
        try {
            ps.close();
        } catch (SQLException ex) {
            ex.printStackTrace();
        }
    }   
}