this is my insertion query in the database, my problem is that when i insert decimal values like 15464545454.32, it displays like 1.54645E7..plz do something...i want to display as the same decimal values as i eneterd....
PreparedStatement pstmt = conn.prepareStatement("INSERT INTO GL_MAST VALUES (?, ?, ?, ?, ?, ?)");
---
---
float Dr_Amt =Float.parseFloat(request.getParameter("DrAmount" ));
pstmt.setFloat(3,Dr_Amt );
float Cr_Amt =Float.parseFloat(request.getParameter("CrAmount" ));
pstmt.setFloat(4,Cr_Amt);
----
----
sql = conn.prepareStatement("SELECT * FROM GL_MAST ");
results = sql.executeQuery();
while(results.next())
{
db_amt = results.getFloat("db_amt");
cr_amt = results.getFloat("cr_amt");
out.println("<td><INPUT TYPE='TEXT' NAME='db_amt' size='12' value='" + db_amt + "' readonly </td>");
out.println("<td><INPUT TYPE='TEXT' NAME='db_amt' size='12' value='" + cr_amt + "' readonly </td>");
}