public List<Veiculo> listarPorPlaca(String placa) {
List<Veiculo> listaVeiculos = new ArrayList<Veiculo>();
try {
Connection con = DatabaseConnection.getConnection();
StringBuffer sb = new StringBuffer();
sb.append("SELECT * ");
sb.append("FROM veiculo WHERE placa like ?");
PreparedStatement st = con.prepareStatement(sb.toString());
st.setString(1, "%" + placa + "%");
ResultSet rs = st.executeQuery();
while (rs.next()) {
Veiculo v = new Veiculo();
v.setPlaca(rs.getString("placa"));
v.setChassi(rs.getString("chassi"));
v.setMarca(rs.getString("marca"));
v.setModelo(rs.getString("modelo"));
v.setAnoFabricacao(rs.getInt("anofabricacao"));
v.setAnoModelo(rs.getInt("anomododelo"));
v.setCarroceria(rs.getString("carroceria"));
v.setCapacidadeCarga(rs.getInt("cap_carga"));
v.setStatus(rs.getString("status"));
listaVeiculos.add(v);
}
con.close();
} catch (ClassNotFoundException e) {
e.printStackTrace();
} catch (SQLException e) {
e.printStackTrace();
}
return listaVeiculos;
}
