@Override
public int registrarVehiculo(VehiculoDTO v) {
int estado = -1;
Connection cn = null;
PreparedStatement pstm = null;
String sql = "";
try {
cn = MySqlDBConexion.getConexion();
sql = "insert into vehiculo values(null,?,?,?,?,?)";
pstm = cn.prepareStatement(sql);
pstm.setString(1, v.getPlacaVehiculo());
pstm.setString(2, v.getMarcaVehiculo());
pstm.setString(3, v.getModeloVehiculo());
pstm.setInt(4, v.getAnioFabricacionVehiculo());
pstm.setString(5, v.getColorVehiculo());
estado = pstm.executeUpdate();
} catch (Exception e) {
e.printStackTrace();
} finally {
try {
if (pstm != null) {
pstm.close();
}
if (cn != null) {
cn.close();
}
} catch (Exception e2) {
e2.printStackTrace();
}
}
return estado;
}
@Override
public int modificarVehiculo(VehiculoDTO v) {
int estado = -1;
Connection cn = null;
PreparedStatement pstm = null;
String sql = "";
try {
cn = MySqlDBConexion.getConexion();
sql =
"update vehiculo "
+ "set placaVehiculo = ?, marcaVehiculo=?, modeloVehiculo=?, anioFabricacionVehiculo=?, colorVehiculo=? "
+ "where idVehiculo = ?";
pstm = cn.prepareStatement(sql);
pstm.setString(1, v.getPlacaVehiculo());
pstm.setString(2, v.getMarcaVehiculo());
pstm.setString(3, v.getModeloVehiculo());
pstm.setInt(4, v.getAnioFabricacionVehiculo());
pstm.setString(5, v.getColorVehiculo());
pstm.setInt(6, v.getIdVehiculo());
estado = pstm.executeUpdate();
} catch (Exception e) {
e.printStackTrace();
} finally {
try {
if (pstm != null) {
pstm.close();
}
if (cn != null) {
cn.close();
}
} catch (Exception e2) {
e2.printStackTrace();
}
}
return estado;
}