<%@page contentType="text/html"%>
<%@ page import="DBWeb.*" %>
<%@ page import="java.util.*" %>
<%
/*
create table classes(
id integer not null primary key auto_increment default 0,
num varchar(25) not null,
title varchar(255) not null,
offered char(2) default '');
*/
EntityModel profEM
= new EntityModel("profs=n:id:last,first,middles,vons,suffix,dob=d");
EntityModel classEM
= new EntityModel("classes:id:num,title,offered",
new String[] {"teach:cid:pid:teacher"});
SqlAccess s = null;
try {
s = new SqlAccess("jdbc/demo");
Entity b = s.process(classEM, request);
ArrayList profs = s.retrieveAll(profEM);
HtmlSelector profsChooser = new HtmlSelector(profs,"id","fullname");
%>
<%=b.getH("head-msg")%>
<%=b.getH("head-msg")%>
<%=b.toErrHtml()%>
Return to Introduction
<%
}
finally {
if (s != null) s.close();
}
%>