spare.java

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

package com.haizi.struts.order;

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

import org.apache.struts.action.ActionForm;

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

public class Spare {

	public ResultSet rs;
	public Spare (){};
	
	public Vector allSpare(){
		DBConnect dbc = null;
        Vector allspareVector = new Vector();
        try{
                dbc  = new DBConnect();
                dbc.prepareStatement("SELECT * FROM spare_info order by spare_no");
                rs = dbc.executeQuery();
                while(rs.next()){
                	SpareBO spare = new SpareBO();
                    spare.setSpare_no(rs.getInt("spare_no"));
                    spare.setSpare_name(rs.getString("spare_name"));
                    spare.setSpare_spec(rs.getString("spare_spec"));
                    spare.setUnits(rs.getString("units"));
                    allspareVector.add(spare);
                }
        }catch(Exception e){
                System.err.println(e);
        }finally{
                try{
                        dbc.close();
                }catch(Exception e){
                        e.printStackTrace();
                }
        }
        return allspareVector;
		
	}
}