handlepurchasemaster.java

基于mvc的java进销存系统

/*
 * HandlePurchaseMaster.java
 *
 * Created on 2007年4月23日, 下午7:41
 *
 * 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.PurchaseMaster;
import util.DBSession;
import util.PropertiesUtil;

/**
 *
 * @author s
 */
public class HandlePurchaseMaster {
    private PreparedStatement ps = null;
    private ResultSet rs = null;
    private DBSession dbsession=new DBSession();   
    /** Creates a new instance of HandlePurchaseMaster */
    public HandlePurchaseMaster() {
    }
    //查找所有的销售
    public Boolean find(String str){
        ArrayList arraylist=new ArrayList();
        try {
            String sql = PropertiesUtil.getSql_resource().getString("selpurchaseMaster").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 findout(){
        ArrayList arraylist=new ArrayList();
        try {
            String sql = PropertiesUtil.getSql_resource().getString("findoutpurchaseMaster").trim();
            ps = dbsession.DPreparedStatement(sql);
            rs = ps.executeQuery();
        } catch (SQLException ex) {
            ex.printStackTrace();
        }
      try {
            while(rs.next()){
                PurchaseMaster purchaseMaster=new PurchaseMaster();           
                purchaseMaster.setPurchaseID(rs.getString("PurchaseID"));
                purchaseMaster.setPurchaseProperty(rs.getString("PurchaseProperty"));
                purchaseMaster.setPurchaseDate(rs.getString("PurchaseDate"));
                purchaseMaster.setSupplierID(rs.getString("SupplierID"));
                arraylist.add(purchaseMaster);
            }
        } catch (SQLException ex) {
            ex.printStackTrace();
        }
        dbsession.closedALL(rs);
        return arraylist;
    }
     public ArrayList findAll(){
          ArrayList arraylist=new ArrayList();
        try {
            String sql = PropertiesUtil.getSql_resource().getString("selectpurchaseMaster").trim();
            ps = dbsession.DPreparedStatement(sql);
            rs = ps.executeQuery();
        } catch (SQLException ex) {
            ex.printStackTrace();
        }
      try {
            while(rs.next()){
                PurchaseMaster purchaseMaster=new PurchaseMaster();           
                purchaseMaster.setPurchaseID(rs.getString("PurchaseID"));
                purchaseMaster.setPurchaseProperty(rs.getString("PurchaseProperty"));
                purchaseMaster.setPurchaseDate(rs.getString("PurchaseDate"));
                purchaseMaster.setSupplierID(rs.getString("SupplierID"));
                arraylist.add(purchaseMaster);
            }
        } catch (SQLException ex) {
            ex.printStackTrace();
        }
        dbsession.closedALL(rs);
        return arraylist;
    }
     //保存
      public void save(PurchaseMaster purchaseMaster ){
        try {
            String sql = PropertiesUtil.getSql_resource().getString("insertpurchaseMaster").trim();
            ps = dbsession.DPreparedStatement(sql);
            ps.setString(1,purchaseMaster.getPurchaseID());
            ps.setString(2,purchaseMaster.getPurchaseProperty());
            ps.setString(3,purchaseMaster.getPurchaseDate());
            ps.setString(4,purchaseMaster.getSupplierID());
            ps.executeUpdate();
        } catch (SQLException ex) {
            ex.printStackTrace();
        }
    }
      //修改
       public void update(PurchaseMaster purchaseMaster){
        try {
            String sql = PropertiesUtil.getSql_resource().getString("updatepurchaseMaster").trim();
            ps = dbsession.DPreparedStatement(sql);
            ps.setString(1,purchaseMaster.getPurchaseID());
            ps.setString(2,purchaseMaster.getPurchaseProperty());
            ps.setString(3,purchaseMaster.getPurchaseDate());
            ps.setString(4,purchaseMaster.getSupplierID());
            ps.executeUpdate();
        } catch (SQLException ex) {
            ex.printStackTrace();
        }
    }
       //删除
        public void delete(PurchaseMaster purchaseMaster){
        try {
            String sql = PropertiesUtil.getSql_resource().getString("deletepurchaseMaster").trim();
            ps = dbsession.DPreparedStatement(sql);
            ps.setString(1,purchaseMaster.getPurchaseID());
            ps.executeUpdate();
        } catch (SQLException ex) {
            ex.printStackTrace();
        }
    }
    
}