<%
String pcode = request.getParameter("id");
String res = request.getParameter("res");
Config c = new Config();
Connection con = c.getcon();
Statement st = con.createStatement();
String qry = "SELECT * FROM "+res+" WHERE problemcode='"+pcode+"'";
ResultSet rs = st.executeQuery(qry);
if(rs.next())
{
out.println("");
out.println("Problem Name: "+rs.getString("problemname")+"
"); out.println(rs.getString("problemdescription")+"
"); %>
<%
out.println("");
out.println("Problem Name: "+rs.getString("problemname")+"
");
out.println("Problem Code: " + rs.getString("problemcode"));
out.println("
"); out.println(rs.getString("problemdescription")+"
"); %>
Uploaded By : "+rs.getString("author")+" "+rs.getString("time")+"
"); } %> View Source
<% qry = "SELECT * FROM commentproblem WHERE problemcode='"+pcode+"' ORDER BY Sno DESC"; rs = st.executeQuery(qry); while(rs.next()) { %>
<%=rs.getString("username")%>
<%=rs.getString("time")%>
<%=rs.getString("comment")%>
<%} if(User!=null) { %>