• Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

statistics in percentage -jsp mysql

 
laura xhaferaj
Greenhorn
Posts: 19
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Pie
Posts: 65128
92
IntelliJ IDE Java jQuery Mac Mac OS X
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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.
 
laura xhaferaj
Greenhorn
Posts: 19
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Ok. Thank you!
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic