コード例 #1
0
  @Override
  public List<VehiculoDTO> listarVehiculos() {
    List<VehiculoDTO> data = new ArrayList<VehiculoDTO>();
    VehiculoDTO v = null;
    Connection cn = null;
    PreparedStatement pstm = null;
    String sql = "";
    ResultSet rs = null;

    try {
      cn = MySqlDBConexion.getConexion();
      sql = "select * from vehiculo";
      pstm = cn.prepareStatement(sql);
      rs = pstm.executeQuery();

      while (rs.next()) {
        v = new VehiculoDTO();
        v.setIdVehiculo(rs.getInt(1));
        v.setPlacaVehiculo(rs.getString(2));
        v.setMarcaVehiculo(rs.getString(3));
        v.setModeloVehiculo(rs.getString(4));
        v.setAnioFabricacionVehiculo(rs.getInt(5));
        v.setColorVehiculo(rs.getString(6));

        data.add(v);
      }
    } catch (Exception e) {
      e.printStackTrace();
    } finally {
      try {
        if (rs != null) {
          rs.close();
        }
        if (pstm != null) {
          pstm.close();
        }
        if (cn != null) {
          cn.close();
        }
      } catch (Exception e2) {
        e2.printStackTrace();
      }
    }
    return data;
  }
コード例 #2
0
  @Override
  public VehiculoDTO buscarVehiculo(int idVehiculo) {
    VehiculoDTO v = null;
    Connection cn = null;
    PreparedStatement pstm = null;
    String sql = "";
    ResultSet rs = null;

    try {
      cn = MySqlDBConexion.getConexion();
      sql = "select * from vehiculo where idVehiculo = ?";
      pstm = cn.prepareStatement(sql);
      pstm.setInt(1, idVehiculo);
      rs = pstm.executeQuery();

      if (rs.next()) {
        v = new VehiculoDTO();
        v.setIdVehiculo(rs.getInt(1));
        v.setPlacaVehiculo(rs.getString(2));
        v.setMarcaVehiculo(rs.getString(3));
        v.setModeloVehiculo(rs.getString(4));
        v.setAnioFabricacionVehiculo(rs.getInt(5));
        v.setColorVehiculo(rs.getString(6));
      }
    } catch (Exception e) {
      e.printStackTrace();
    } finally {
      try {
        if (rs != null) {
          rs.close();
        }
        if (pstm != null) {
          pstm.close();
        }
        if (cn != null) {
          cn.close();
        }
      } catch (Exception e2) {
        e2.printStackTrace();
      }
    }
    return v;
  }