Win a copy of Android Programming: The Big Nerd Ranch Guide this week in the Android forum!
  • Post Reply Bookmark Topic Watch Topic
  • New Topic

statistics in percentage -jsp mysql  RSS feed

 
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
Posts: 65983
140
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
Boost this thread!