@Override
public List<Exposicao> consultaNomeExposicao(String data) throws SQLException {
String sql =
"SELECT titulo, CONVERT(varchar(5), horario, 108) as hora from exposicao "
+ "where ? >= dataInicio and ? <= dataFim";
PreparedStatement ps = c.prepareStatement(sql);
ps.setString(1, data);
ps.setString(2, data);
ResultSet rs = ps.executeQuery();
List<Exposicao> lista = new ArrayList<Exposicao>();
while (rs.next()) {
Exposicao expo = new Exposicao();
expo.setTituloExibicao(rs.getString("titulo"));
SimpleDateFormat formatador = new SimpleDateFormat("HH:mm");
Date horario;
try {
horario = formatador.parse(rs.getString("hora"));
Time time = new Time(horario.getTime());
expo.setHora(time);
} catch (ParseException e1) {
e1.printStackTrace();
}
lista.add(expo);
}
return lista;
}
