|
<% leftColumn.createLeftColumn(out,request,conn,sc); %>
|
 |
| <% catMediaDisp.createCatMediaDisp(catalogId,"NA","NA","NA",out,conn,"","BODY",sc); %> |
<% String currQtr = utilities.getCurrentQtr(conn, out);
/* comment out before transfer */ /* currQtr = "2002-4"; */
StringTokenizer st = new StringTokenizer(currQtr, "-");
String year = st.nextToken();
char qtr = st.nextToken().charAt(0);
String qtrLong = null;
switch (qtr){
case '1' : qtrLong = "Spring"; break;
case '2' : qtrLong = "Summer"; break;
case '3' : qtrLong = "Fall"; break;
case '4' : qtrLong = "Winter"; break;
}
if (qtrLong!=null){
out.write("| ");
out.write(qtrLong + " " + year);
out.write(" | ");
}
String sql = "select * from live.waunitv8t " +
"where " +
"qtr_cd = ? and " +
"audience_cd = 'ADU' " +
"order by unit_seq";
PreparedStatement stmt = conn.prepareStatement(sql);
stmt.setString(1, utilities.pad(currQtr,7));
ResultSet rs = stmt.executeQuery();
while (rs.next()) {
String r_title = rs.getString("title");
String r_obj = rs.getString("objective") == null ? "" : rs.getString("objective");
String r_unitSeq = rs.getString("unit_seq");
out.write("| ");
out.write("Unit " + r_unitSeq + ": ");
out.write(r_title);
out.write(" | ");
out.write("| ");
out.write(r_obj);
out.write(" | ");
out.write("| | ");
}
rs.close();
stmt.close();
%>
|
| <% catMediaDisp.createCatMediaDisp(catalogId,"NA","NA","NA",out,conn,"","BODY1",sc); %> |
|
|