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;
}
public void alterar(Veiculo v) {
{
try {
Connection con = DatabaseConnection.getConnection();
StringBuffer sb = new StringBuffer();
sb.append(
"UPDATE tb_veiculo SET chassi = ?, marca = ?, modelo = ?, anofabricacao = ?, anomodelo = ?, carroceria = ?, ");
sb.append("capacidadecarga = ?, status = ? ");
sb.append("WHERE placa = ?");
PreparedStatement st = con.prepareStatement(sb.toString());
st.setString(1, v.getChassi());
st.setString(2, v.getMarca());
st.setString(3, v.getModelo());
st.setInt(4, v.getAnoFabricacao());
st.setInt(5, v.getAnoModelo());
st.setString(6, v.getCarroceria());
st.setInt(7, v.getCapacidadeCarga());
st.setString(8, v.getStatus());
st.setString(9, v.getPlaca());
st.executeUpdate();
con.close();
} catch (ClassNotFoundException e) {
e.printStackTrace();
} catch (SQLException e) {
e.printStackTrace();
}
}
}
public void adicionar(Veiculo v) {
try {
Connection con = DatabaseConnection.getConnection();
StringBuffer sb = new StringBuffer();
sb.append(
"INSERT INTO tb_veiculo (placa, chassi, marca, modelo, anofabricacao, anomodelo, carroceria, ");
sb.append("capacidadecarga, status )");
sb.append("VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?)");
PreparedStatement st = con.prepareStatement(sb.toString());
st.setString(1, v.getPlaca());
st.setString(2, v.getChassi());
st.setString(3, v.getMarca());
st.setString(4, v.getModelo());
st.setInt(5, v.getAnoFabricacao());
st.setInt(6, v.getAnoModelo());
st.setString(7, v.getCarroceria());
st.setInt(8, v.getCapacidadeCarga());
st.setString(9, v.getStatus());
st.executeUpdate();
con.close();
} catch (ClassNotFoundException e) {
e.printStackTrace();
} catch (SQLException e) {
e.printStackTrace();
}
}
public void remover(Veiculo v) {
try {
Connection con = DatabaseConnection.getConnection();
String sql = "DELETE FROM tb_veiculo WHERE placa = ?";
PreparedStatement st = con.prepareStatement(sql);
st.setString(1, v.getPlaca());
st.executeUpdate();
con.close();
} catch (ClassNotFoundException e) {
e.printStackTrace();
} catch (SQLException e) {
e.printStackTrace();
}
}