order.java

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

package com.haizi.struts.order;

import java.sql.ResultSet;
import java.util.Vector;
import com.haizi.struts.businessobjects.ContentBO;
import com.haizi.struts.datebase.DBConnect;

public class Order extends ContentBO {
	public ResultSet rs;
	public  Vector allContent(){
		DBConnect dbc = null;
		Vector allApplyVector = new Vector();
		try{
			dbc  = new DBConnect();
			dbc.prepareStatement("SELECT * FROM con_info where state='0' order by con_no");
			rs = dbc.executeQuery();
				while(rs.next()){
				ContentBO contentBO = new ContentBO();
				contentBO.setCon_no(rs.getInt("con_no"));
				contentBO.setSup_name(rs.getString("sup_name"));
				contentBO.setDep_name(rs.getString("dep_name"));
				contentBO.setPerson(rs.getString("person"));
				contentBO.setCon_memo(rs.getString("con_memo"));
				contentBO.setSpare_name(rs.getString("spare_name"));
				contentBO.setPrice(rs.getFloat("price"));
				contentBO.setQuan(rs.getFloat("quan"));
				contentBO.setUnits(rs.getString("units"));
				contentBO.setDate(rs.getDate("date"));
				contentBO.setSpare_no(rs.getInt("spare_no"));
				allApplyVector.add(contentBO);
			}
		}catch(Exception e){
			System.err.println(e);
		}finally{
			try{
				dbc.close();
			}catch(Exception e){
				e.printStackTrace();
			}
		}
		return allApplyVector;
	}
 public void delorder(){
	 
	 DBConnect dbc = null;
		try{
			dbc = new DBConnect();
			dbc.prepareStatement("update con_info set state=1 WHERE con_no=?");
			dbc.setInt(1,getCon_no());
			dbc.executeUpdate();
		}catch(Exception e){
			e.printStackTrace();
		}
		finally{
		try{
			dbc.close();
		}catch(Exception e){
			e.printStackTrace();
			}
		}
	}
 }