<%@ page import="DBWeb.*" %> <%@ page import="java.util.*" %> CWS Experimentation

CWS Database

<% SqlAccess s = null; try { s = new SqlAccess("jdbc/cws"); List people = s.retrieveAll("select pat_num,last_name,first_name,title as mid_initl from pat_demograph order by last_name,first_name,mid_initl"); Iterator it=people.iterator(); while (it.hasNext()) { Entity b = (Entity)it.next(); EnglishName n = new EnglishName(b.getS("last_name"), b.getS("first_name"), b.getS("mid_initl")); out.write("\n"); } } finally { if (s!=null) s.close(); } %>

#	Patient
" + b.getS("pat_num") + "	" + n.toString() + "