plan.java

利用当前管理信息系统科学的、实用的理论

package com.haizi.struts.order;

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


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

public class Plan {
	
	public ResultSet rs;
	public  Vector allPlan(){
	DBConnect dbc = null;
	Vector allPlanVector = new Vector();
	try{
		dbc  = new DBConnect();
		dbc.prepareStatement("SELECT * FROM plan_info where state='0' order by plan_no");
		rs = dbc.executeQuery();
			while(rs.next()){
			PlanBO planBO = new PlanBO();
			planBO.setPlan_no(rs.getInt("plan_no"));
			planBO.setPerson(rs.getString("person"));
			planBO.setSpare_no(rs.getInt("spare_no"));
			planBO.setSpare_spec(rs.getString("spare_spec"));
			planBO.setSpare_name(rs.getString("spare_name"));
			planBO.setQuan(rs.getFloat("quan"));
			planBO.setUnits(rs.getString("units"));
			planBO.setDate(rs.getDate("date"));
			allPlanVector.add(planBO);
		}
	}catch(Exception e){
		System.err.println(e);
	}finally{
		try{
			dbc.close();
		}catch(Exception e){
			e.printStackTrace();
		}
	}
	return allPlanVector;
}

}