I have the number 654987. Its an ID in a database. I want to convert it to a string. The regular Double.ToString(value) makes it into scientific form, 6.54987E5. Something I dont want.
Other formatting functions Ive found checks the current locale and adds appropriate thousand separators and such. Since its an ID, I cant accept any formatting at all.
How to do it?
[Edit] To clarify: Im working on a special database that treats all numeric columns as doubles. Double is the only (numeric) type I can retrieve from the database.
How about
String.valueOf((long)value);
Use Long:
If it's an integer id in the database, use an Integer instead. Then it will format as an integer.
If what you are storing is an ID (i.e. something used only to identify another entity, whose actual numeric value has no significance) then you shouldn't be using Double to store it. Precision will almost certainly screw you.
If your database doesn't allow integer values then you should stored IDs as strings. If necessary make the string the string representation of the integer you want to use. With appropriate use of leading zeros you can make the alphabetic order of the string the same as the numeric order of the ints.
That should get you round the issue.
Use a fixed
NumberFormat
(specifically aDecimalFormat
):alternatively simply cast to
int
(orlong
if the range of values it too big):But then again: why do you have an integer value (i.e. a "whole" number) in a
double
variable in the first place?What about:
or