title: how to add null values wherever there is a nan value using jdbc
body: <p>I am trying to read the csv file through java as <code>attributes[17]</code> here have some nan values so when i read those <strong>NaN</strong> values i want those rows to also have <strong>NULL</strong> values how to do that.   As i am adding 0 whenever it has the exception of <strong>Nan</strong> so i wanted to add <strong>NULL</strong> values in such case.How to do that</p>
  <pre><code> try
      {
          double vb=Double.parseDouble(attributes[17]);
  
          invoice_id=(long) vb;
          invoice_no.add(invoice_id);
      }
      catch(NullPointerException e)
      {
      //e.printStackTrace();
          long b=0;
          invoice_no.add(b);
      }
      catch(NumberFormatException e) {
          long b=0;
          invoice_no.add(b);
          //e.printStackTrace();
      }
  </code></pre>