[Gnumed-devel] appointments in oscar

[Syan Tan]

oscar in the cvs still looks a little messy, but it works I suppose.

the rschedule and appointments stuff is thinly wrapped sql  queries and updates in jsp pages

and java beans ( basically java server pages abstraction of stateful data referencing).

AppointmentMainBean.java is found in oscar_mcmaster/WEB-INF/classes/src/oscar  directory.

This is the global reference used to store a lot of the session state data.

e.g.   the jsp page,  providercontrol.jsp  is  the main initialization page for the AppointmentMainBean.

It hardcodes sets an associative array , for name -> sql statements in setDBOperations() on the

bean, which is later used in other pages like scheduletemplateapply.jsp in the oscar_mcmaster/web/schedule

directory. Basically this page has all the validation and persistence code embedded as java in jsp,

and it uses AppointmentMainBean which has the sql update and query overloaded methods ,

such as  and executeQueryUpdate(... and queryResults(...   which combines various forms of parameter types,

with looking up the named query array in AppointMainBean set by the providercontrol jsp.

Not very satisfying , intellectually I suppose, but it works.