dealalldishsort.java

简单的餐厅管理系统

package util;

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

import beans.Dish;

public class DealAllDishSort {
	Vector dishesSort = new Vector();//String 类型
	
	public String generateDish(){
		BaseSQL b = new BaseSQL();
		try{
			b.connect("eatery","root","123456");
			ResultSet rs = b.statement.executeQuery("select distinct dishSort from dish");
			dishesSort = new Vector();
			while(rs.next()){
				String dishSort = rs.getString(1);
				dishesSort.add(dishSort);
			}

		} 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 getDishesSort(){
		return dishesSort;
	}
	
	public void setDishesSort(Vector dishesSort) {
		this.dishesSort = dishesSort;
	}
	
	public boolean isIn(int i){
		if(i < dishesSort.size()&&i >= 0){
			return true;
		}
		return false;
	}
	
	public String getSort(int i){
		if(isIn(i)){
			return (String)dishesSort.get(i);
		}
		return null;
	}
}