package conn;

import java.sql.*;
import java.util.*;

public class ConsultaBd{
	private Conecta con = new Conecta();
	private String sql;
	public Vector cliente;
	
	public ConsultaBd(){
		sql = "";
		cliente = new Vector();
	}
	
	public Vector getConsulta(){
		try{
			con.setCon();
			sql = "select cliente from tbavaliacao;";
			PreparedStatement ps = con.getCon().prepareStatement(sql);
			ResultSet rs = ps.executeQuery();
			while(rs.next()){
				cliente.add(rs.getString("cliente"));
			}
		}catch(SQLException sqlexcp){
			sqlexcp.getMessage();
		}
		con.setDescon();
		return cliente;
	}
}