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("Display All Users"); out.println(""); out.println(""); out.println("
"); out.println("

Displaying All Users

"); out.println("
"); out.println("
"); out.println(""); out.println(""); out.println(""); out.println(""); out.println(""); out.println(""); out.println(""); String sql = "SELECT FirstName, LastName, UserName, Password" + " FROM Users"; try { Connection con = DriverManager.getConnection("jdbc:odbc:JavaWeb"); System.out.println("got connection"); Statement s = con.createStatement(); ResultSet rs = s.executeQuery(sql); while (rs.next()) { out.println(""); out.println(""); out.println(""); out.println(""); out.println(""); out.println(""); } rs.close(); s.close(); con.close(); } catch (SQLException e) { } catch (Exception e) { } out.println("
First NameLast NameUser NamePassword
" + StringUtil.encodeHtmlTag(rs.getString(1)) + "" + StringUtil.encodeHtmlTag(rs.getString(2)) + "" + StringUtil.encodeHtmlTag(rs.getString(3)) + "" + StringUtil.encodeHtmlTag(rs.getString(4)) + "
"); out.println("
"); out.println(""); out.println(""); } public void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException { doGet(request, response); } }