<%@page contentType="text/html"%>
<%@ page import="DBWeb.*" %>
<%@ page import="java.util.*" %>
<%
EntityModel profEM
= new EntityModel("profs=n:id:last,first,middles,vons,suffix,dob=d");
SqlAccess s = null;
try{
s = new SqlAccess("jdbc/demo");
ArrayList cls = s.retrieveAll("select * from classes order by id");
ArrayList pfs = s.retrieveAll(profEM);
%>
Listing of Classes
Add new
Edit Classes
| Number | Title |
|---|
<%
Iterator it = cls.iterator();
while (it.hasNext()) {
Entity c = (Entity)it.next();
String theId = c.getS("id");
%>
| <%=theId%> | <%=c.getH("title")%> |
<%
}
%>
Edit Professors
<%
it = pfs.iterator();
while (it.hasNext()) {
Entity p = (Entity)it.next();
%>
"><%=p.getH("fullname")%>
<%
}
%>
<%
}
finally {
if (s!=null) s.close();
}
%>