dealwaiter.java

来自「简单的餐厅管理系统」· Java 代码 · 共 66 行

package util;

import beans.User;

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


public class DealWaiter {
	private Vector waiters = new Vector();
	
	public String getWaiters() {
		BaseSQL b = new BaseSQL();
		ResultSet rs = null;
		try {
			b.connect("eatery", "root", "123456");
			
	
			rs = b.statement.executeQuery("select * from user where type = '2'");
			while(rs.next()){
				User waiter = new User();
				waiter.setUserName(rs.getString("userName"));
				waiter.setRealName(rs.getString("realName"));
				//this.password = rs.getString("password");
				waiter.setType(rs.getInt("type"));
				waiters.add(waiter);
			}
			
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
			return "连接数据库失败";
		}catch(Exception e){
			return "连接数据库失败";
		}
		finally{
			try {
				if(rs != null){
					rs.close();
				}
				b.close();
			} catch (SQLException e) {
				// TODO Auto-generated catch block
				e.printStackTrace();
			}
			
		}
		
		return null;
	}
	
	public boolean hasMore(int i){
		if(waiters.size()>i){
			return true;
		}
		return false;
		
	}
	
	public User getWaiter(int i){
		User user = (User)waiters.get(i);
		return user;
	}
}