private void insertData(HttpServletRequest request) throws IOException {
		p("<big><b>Student Directory<b></big>");
		try {
			Class.forName("com.mysql.jdbc.Driver");
			Connection cn = DriverManager
					.getConnection("jdbc:mysql://stef.cs.uwec.edu/STUDENT",
							"STUDENT", "S5333");
			// create the query statement
			Statement stmt = cn.createStatement(ResultSet.TYPE_FORWARD_ONLY,
					ResultSet.CONCUR_READ_ONLY);
			String whereClause = "";

			// retrieve parameters (if any) sent from the previous page
			String lower = request.getParameter("lower");
			String upper = request.getParameter("upper");
			if (lower == null)
				lower = "";
			if (upper == null)
				upper = "";

			if (!lower.equals("") && !upper.equals("")) {
				whereClause = "WHERE studentlastname >= \"" + lower
						+ "\" AND studentlastname <= \"" + upper + "\"";
			} else if (!lower.equals("")) {
				whereClause = "WHERE studentlastname >= \"" + lower + "\"";
			} else if (!upper.equals("")) {
				whereClause = "WHERE studentlastname <= \"" + upper + "\"";
			}

			String sqlQuery = "SELECT studentlastname, studentfirstname, studentmi, studentphonenumber "
					+ "FROM universitystudent "
					+ whereClause
					+ " "
					+ "ORDER BY studentlastname, studentfirstname;";

			// create the recordset and execute the query
			ResultSet rs = stmt.executeQuery(sqlQuery);
			String lastStu = "";
			String currentStu = "";
			String bgcolor = "#DDDCBF";
			p("<table id=\"dataTable\">");
			p("<tr>");
			p("    <th align=LEFT>Last Name</th>");
			p("    <th align=LEFT>First</th>");
			p("    <th align=LEFT>MI</th>");
			p("    <th align=LEFT>Phone</th>");
			p("</tr>");
			while (rs.next()) {
				currentStu = rs.getString("studentlastname");
				// alternate the row background color when a department changes
				if (!currentStu.equals(lastStu)) {
					if (bgcolor.equalsIgnoreCase("#DDDCBF")) {
						bgcolor = "#FFFFFF";
					} else {
						bgcolor = "#DDDCBF";
					}
				}
				p("<tr bgcolor=" + bgcolor + ">");

				String mi = rs.getString("studentmi");
				p("    <td align=LEFT>&nbsp;&nbsp"
						+ rs.getString("studentlastname") + "</td>");
				p("    <td align=LEFT>&nbsp;&nbsp"
						+ rs.getString("studentfirstname") + "</td>");
				p("    <td align=LEFT>&nbsp;&nbsp"
						+ ((mi == null) ? "&nbsp;" : mi) + "</td>");
				p("    <td align=LEFT>&nbsp;&nbsp"
						+ rs.getString("studentphonenumber") + "</td>");
				p("</tr>");
			}
			p("</table>");
			// Clean up resources
			cn.close();
		} catch (Exception e) {
			p(e.getMessage() + "<br>");
		}