dealdish.java

简单的餐厅管理系统

package util;

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

import beans.Dish;

public class DealDish {
	Vector dishes = new Vector();
	public String getDishes(){
		BaseSQL b = new BaseSQL();
		try{
			b.connect("eatery","root","123456");

			ResultSet rs = b.statement.executeQuery("select * from dish");
			dishes = new Vector();
			while(rs.next()){
				Dish dish = new Dish();
				dish.getDetailInfo(rs.getString(1));
				dishes.add(dish);
			}
		} 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 boolean isIn(int i){
		if(i < dishes.size()&&i >= 0){
			return true;
		}
		return false;
	}
	
	public Dish getDish(int i){
		if(isIn(i)){
			return (Dish)dishes.get(i);
		}
		return null;
	}
	
	public String getDishesBySort(String dishSort){
		BaseSQL b = new BaseSQL();
		try{
			b.connect("eatery","root","123456");
			ResultSet rs = b.statement.executeQuery("select * from dish where dishSort = '"+dishSort+"'");
			dishes = new Vector();
			while(rs.next()){
				Dish dish = new Dish();
				dish.getDetailInfo(rs.getString(1));
				dishes.add(dish);
			}
		} 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 String getDisherByMain(String materialName){
		BaseSQL b = new BaseSQL();
		try{
			b.connect("eatery","root","123456");

			ResultSet rs = b.statement.executeQuery(
					"select * from dish_material,material where dish_material.materialID = material.materialID " +
					"and materialName = '"+materialName+"'");
			dishes = new Vector();
			while(rs.next()){
				Dish dish = new Dish();
				dish.getDetailInfo(rs.getString(1));
				dishes.add(dish);
			}

		} 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 String getDishes(String dishSort,String materialName){
		BaseSQL b = new BaseSQL();
		try{
			b.connect("eatery","root","123456");

			ResultSet rs = b.statement.executeQuery(
					"select * from dish,dish_material,material " +
					"where materialName = '"+materialName+"' and dishSort = '"+dishSort+"' and"+
					"dish.dishID = dish_material.dishID and dish_material.materialID = material.materialID");
			dishes = new Vector();
			while(rs.next()){
				Dish dish = new Dish();
				dish.getDetailInfo(rs.getString(1));
				dishes.add(dish);
			}

		} 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 getVector() {
		return dishes;
	}

	public void setDishes(Vector dishes) {
		this.dishes = dishes;
	}
}