supply.java

来自「利用当前管理信息系统科学的、实用的理论」· Java 代码 · 共 45 行

package com.haizi.struts.order;

import java.sql.ResultSet;
import java.util.Vector;

import com.haizi.struts.businessobjects.SpareBO;
import com.haizi.struts.businessobjects.SupplyBO;
import com.haizi.struts.datebase.DBConnect;

public class Supply {
	public ResultSet rs;
	public Supply (){};
	
	public Vector allSupply(){
		DBConnect dbc = null;
        Vector allsupplyVector = new Vector();
        try{
                dbc  = new DBConnect();
                dbc.prepareStatement("SELECT * FROM sup_info order by sup_no");
                rs = dbc.executeQuery();
                       while(rs.next()){
                       SupplyBO supply = new SupplyBO();
                       supply.setSup_no(rs.getInt("sup_no"));
                       supply.setSup_name(rs.getString("sup_name"));
                       supply.setAddress(rs.getString("address"));
                       supply.setCredit(rs.getString("credit"));
                       supply.setEmail(rs.getString("email"));
                       supply.setPhone(rs.getString("phone"));
                        allsupplyVector.add(supply);
                }
        }catch(Exception e){
                System.err.println(e);
        }finally{
                try{
                        dbc.close();
                }catch(Exception e){
                        e.printStackTrace();
                }
        }
        return allsupplyVector;
		
	}

}