import javax.servlet.*; import javax.servlet.http.*; import java.io.*; import java.sql.*; import com.brainysoftware.java.StringUtil; public class DataViewerServlet extends HttpServlet { /**Load JDBC driver*/ public void init() { try { Class.forName("sun.jdbc.odbc.JdbcOdbcDriver"); System.out.println("JDBC driver loaded"); } catch (ClassNotFoundException e) { System.out.println(e.toString()); } } /**Process the HTTP Get request*/ public void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException { response.setContentType("text/html"); PrintWriter out = response.getWriter(); out.println(""); out.println("
"); out.println("First Name | "); out.println("Last Name | "); out.println("User Name | "); out.println("Password | "); out.println("
---|---|---|---|
" + StringUtil.encodeHtmlTag(rs.getString(1)) + " | "); out.println("" + StringUtil.encodeHtmlTag(rs.getString(2)) + " | "); out.println("" + StringUtil.encodeHtmlTag(rs.getString(3)) + " | "); out.println("" + StringUtil.encodeHtmlTag(rs.getString(4)) + " | "); out.println("