dealorder.java

简单的餐厅管理系统

package util;

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

import beans.Dish;
import beans.Order;

public class DealOrder {
	Vector orders = new Vector();
	
	public String generateOrders(){
		BaseSQL b = new BaseSQL();
		try{
			b.connect("eatery","root","123456");

			ResultSet rs = b.statement.executeQuery("select * from `order`");
			while(rs.next()){
				Order addOrder = new Order();
				addOrder.getData(rs.getString(1));
				orders.add(addOrder);
			}
		} catch (SQLException e) {
			// TODO Auto-generated catch block

			return "数据库操作出错！";
		} catch (Exception e) {
			// TODO Auto-generated catch block

			return "出现未知错误！";
		} finally {
			try {
				b.close();
			} catch (SQLException e) {
				// TODO Auto-generated catch block
				
			}
		}
		return null;
	}

	public Vector getOrders() {
		return orders;
	}

	public void setOrders(Vector orders) {
		this.orders = orders;
	}
}