<%-- doViewComments.jsp ------------------ View peer comments for professional development modules. Includes: oerlWebViewCon.jsp Created by zaz@sri.com. Last modified by zaz@sri.com, 3/24/03. --%> <%@ page language="java" import="java.sql.*" %> <%-- Make connection to database using oerl_webview login --%> <%@ include file="../jspcode/oerlWebViewCon.jsp" %> <% // Get required parameters String moduleNum = request.getParameter("Module"); if (moduleNum == null) moduleNum = ""; String pageNum = request.getParameter("Page"); if (pageNum == null) pageNum = ""; String questionNum = request.getParameter("Question"); if (questionNum == null) questionNum = ""; // Get module name and subname StringBuffer queryBuf = new StringBuffer(); queryBuf.append("SELECT ModuleName, ModuleSubName FROM Modules"); queryBuf.append(" WHERE ModuleNum=" + moduleNum); ResultSet moduleRS = con.createStatement().executeQuery(queryBuf.toString()); String moduleName = ""; String moduleSubName = ""; if (moduleRS != null && moduleRS.next()) { moduleName = moduleRS.getString("ModuleName"); moduleSubName = moduleRS.getString("ModuleSubName"); if (moduleSubName != null && !moduleSubName.equals("")) { moduleName += ": "; } if (moduleName == null) { %><% } } else { %><% } %> OERL : PD Modules : Peer Comments

OERL Peer Comments

<%= moduleName %> <% if (moduleSubName != null && !moduleSubName.equals("")) { %>
<%= moduleSubName %> <% } %>

Page <%= pageNum %>, Question <%= questionNum %>

<% queryBuf = new StringBuffer(); queryBuf.append("SELECT m.ModuleName, m.ModuleSubName, mc.Name, mc.Email, mc.CommentText\n"); queryBuf.append(" FROM Modules AS m, ModuleComments AS mc, ModuleQuestions AS mq\n"); queryBuf.append(" WHERE m.ModuleID=mq.ModuleID AND mc.QuestionID=mq.QuestionID"); queryBuf.append(" AND m.ModuleNum=" + moduleNum + " AND mq.QuestionNum=" + questionNum); queryBuf.append(" AND mq.PageNum=\"" + pageNum + "\" AND mc.Publish=\"Y\"\n"); ResultSet commentRS = con.createStatement().executeQuery(queryBuf.toString()); if (commentRS != null && commentRS.next()) { commentRS.beforeFirst(); while (commentRS.next()) { String name = commentRS.getString("mc.Name"); if (name == null) name = ""; String email = commentRS.getString("mc.Email"); if (email == null) email = ""; String text = commentRS.getString("mc.CommentText"); %> <% if (commentRS.isFirst()) { %>
<% } %>
Peer: <% if (!name.equals("") || !email.equals("")) { %> <%= name %> <% if (!email.equals("")) { %> (<%= email %>) <% } } else { %> Anonymous <% } %>
Comment: <%= text %>

<% } /* close while */ } else { %>

There are no peer comments for this question yet.

<% } /* close if */ // close database connection con.close(); %>
Close Window