Display full double values

[Aravind Prasad]

Dear Ranchers

I have a table structure and the values in the table which are in trillions. Please see the below information for your better understanding.

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql> use projects;
Database changed
mysql> desc project_main;
+---------------------+--------------+------+-----+---------------------+-------
+
| Field               | Type         | Null | Key | Default             | Extra
|
+---------------------+--------------+------+-----+---------------------+-------
+
| project_id          | varchar(10)  | NO   | PRI | NULL                |
|
| project_name        | varchar(100) | NO   |     | NULL                |
|
| client_id           | varchar(20)  | NO   |     | NULL                |
|
| country             | varchar(10)  | NO   |     | NULL                |
|
| project_sector      | varchar(10)  | NO   |     | NULL                |
|
| project_type        | varchar(10)  | NO   |     | NULL                |
|
| project_description | varchar(512) | NO   |     | NULL                |
|
| project_cost        | double       | NO   |     | 0                   |
|
| project_currency    | varchar(10)  | NO   |     | NULL                |
|
| exchange_rate       | double       | NO   |     | 0                   |
|
| project_cost_usd    | double       | NO   |     | 0                   |
|
| created_by          | varchar(45)  | NO   |     | NULL                |
|
| created_on          | varchar(45)  | NO   |     | 0000-00-00 00:00:00 |
|
+---------------------+--------------+------+-----+---------------------+-------
+
13 rows in set (0.01 sec)

mysql> use projects;
Database changed
mysql> select project_cost from project_main;
+--------------+
| project_cost |
+--------------+
|    800000000 |
|     39860000 |
| 150000000000 |
| 220000000000 |
| 270000000000 |
| 260000000000 |
| 140000000000 |
|  85000000000 |
| 182000000000 |
| 110000000000 |
| 120000000000 |
| 320000307686 |
| 200000000000 |
| 200000000000 |
|    200000000 |
|    200000000 |
|    200000000 |
|    200000000 |
|    200000000 |
|    200000000 |
|    200000000 |
|    200000000 |
|     12000000 |
|    200000000 |
|     12000000 |
|    200000000 |
|    200000000 |
|    200000000 |
|    200000000 |
|    200000000 |
|    200000000 |
|    200000000 |
|    200000000 |
|     18000000 |
|      1000000 |
|    160000000 |
|    200000000 |
|    200000000 |
|     15000000 |
|     14000000 |
|    200000000 |
|    200000000 |
|    200000000 |
|    200000000 |

In the table the values are displaying properly. But when I call the Double value using query and display in the JSP Page, I get the values like

8.0E8 

for

 800000000 

Please advise, how can i solve this issue..

Thanks/ Regards

Aravind

[Claudiu Chelemen]

Hi Aravind,

You may format the output using jstl fmt library.
Example here, check out the number tags.

Cheers,
Claudiu

[Bear Bibeault]

To be more explicit, you can provide a pattern for the output using the <c:formatNumber> tag.