File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
The moose likes JDBC and Relational Databases and the fly likes statistics in percentage -jsp mysql Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC and Relational Databases
Bookmark "statistics in percentage -jsp mysql" Watch "statistics in percentage -jsp mysql" New topic

statistics in percentage -jsp mysql

laura xhaferaj

Joined: May 17, 2013
Posts: 19
i am working for e school project about a parking car system. Im using jsp and mysql database. I already have made the code but missing statistics.
Its the first time i have to make query about statistics so i need some help. I have this tables: Street(ID,Name,Sides) free_slots(ID, street_ID) invalid_slots(ID,slots_ID,Street_ID) and occupied_slots(ID,slots_ID,Street_ID).
I have to compute statistics about the parking slots in a specified street (% of free slots, % of occupied slots, % invalid slots).
I really need some help! Thank you
Bear Bibeault
Author and ninkuma

Joined: Jan 10, 2002
Posts: 63865

That sounds like a job for JDBC, so I'll move this to that forum.

Be sure to not put code into the JSP pages and to perform JDBC access in Java classes, not JSPs.

[Asking smart questions] [About Bear] [Books by Bear]
laura xhaferaj

Joined: May 17, 2013
Posts: 19
Ok. Thank you!
I agree. Here's the link:
subject: statistics in percentage -jsp mysql
It's not a secret anymore!