db query Servlet: Converting SQL results to HTML

public void loadProjData(String projNumber, HttpServletResponse res, ServletOutputStream out) {

ResultSet rs = null;

STRING sql = "SELECT proj_desc, proj_status " +

" FROM projdb.proj_master WHERE proj_nmbr = '" + projNumber + "';";

try {

stmt = con.createStatement();

if (stmt.execute(sql)) {

out.println("Project Number <EM>" + projNumber +

"</EM><CENTER><TABLE BORDER>");

rs = stmt.getResultSet();

rs.next();

out.println("<TR><TD>Description" + rs.getString(1) +

"</TD><TD>Status" + rs.getString(2) + "</TD></TR>");

}

}

out.println("</TABLE></BODY></HTML>");

} // try

catch (SQLException ex){printException(ex);}

catch (java.lang.Exception ex){ex.printStackTrace();}

} // loadProjData

Previous slide

Next slide

Back to first slide

View graphic version

Send email to Interex or to the Webmaster
©Copyright 1999 Interex. All rights reserved.