title: When reading data from database it shows decimal value?
body: <p>I am trying to read data from data from database it shows as decimal value.</p>
  <p>The projectno field in database is varchar and the value is 10637.</p>
  <p>But when i retrieve it shows the output as <code>10637.0 project no</code></p>
  <pre><code>myConn = dataSource.getConnection();
  
  String sql = &quot;Select * FROM jtc_list  where jtcno='&quot;+jtcnum+&quot;' and materialclass='&quot;+matclass+&quot;'&quot;;
  
  // create sql statement
  myStmt = myConn.createStatement();
  
  // execute query
  myRs = myStmt.executeQuery(sql);
  
  while(myRs.next()){
     projectno = myRs.getString(&quot;projectno&quot;);
     System.out.println(myRs.getString(&quot;projectno&quot;)+&quot; project no&quot;);
  }
  </code></pre>
  <p>How can I solve this issue? Thank you in advance.</p>