aspose file tools*
The moose likes JDBC 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
Bookmark "statistics in percentage -jsp mysql" Watch "statistics in percentage -jsp mysql" New topic
Author

statistics in percentage -jsp mysql

laura xhaferaj
Greenhorn

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
Marshal

Joined: Jan 10, 2002
Posts: 60980
    
  65

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] [Bear's FrontMan] [About Bear] [Books by Bear]
laura xhaferaj
Greenhorn

Joined: May 17, 2013
Posts: 19
Ok. Thank you!
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: statistics in percentage -jsp mysql