Create a Servlet that displays a form when the doGet method is invoked. The form will contain a post action that directs the form post back to the same servlet, which in the doPost method will append the form data to a random access file. After the form data has been appended to the file, respond back with the complete contents of the data file. The form must contain a minimum of three input fields. Attach your servlet source code file and random access data file to this assignment in one zipped file.

Here is the code:

import java.io.*;
import java.util.Scanner;
import javax.servlet.*;
import javax.servlet.http.*;
import java.sql.*;
import oracle.jdbc.OracleResultSetMetaData;

public class FormPost2 extends HttpServlet {

Connection con = null;

public FormPost2() {

init();
}

public void init() {

try {

Class.forName ("oracle.jdbc.driver.OracleDriver");

con = DriverManager.getConnection("jdbc:oracle:thin:@localhost:1521:XE", "student1", "pass");

Statement stmt = con.createStatement();
stmt.executeUpdate("CREATE TABLE MYTABLE (FNAME VARCHAR2(20), LNAME VARCHAR2(40), PHONE VARCHAR2(20))");
stmt.close();
}

catch (Exception e) {

}
}

public void doGet(HttpServletRequest request, HttpServletResponse response)

throws ServletException, IOException {

response.setContentType("text/html");
PrintWriter out = response.getWriter();
out.println("<html><body>");

out.println("<form action='" + request.getRequestURL() + "' method='post' >");

out.println("First Name:");
out.println("<input type='text' name='FNAME' />");
out.println("<br>");

out.println("Last Name:");
out.println("<input type='text' name='LNAME' />");
out.println("<br>");

out.println("Phone:");
out.println("<input type='text' name='PHONE' />");
out.println("<input type='submit' value='Submit' />");
out.println("</form>");

out.println("</body></html>");
out.close();
}

public void doPost(HttpServletRequest request, HttpServletResponse response)

throws ServletException, IOException {

try {

if (con != null)

init();

String fname = request.getParameter("FNAME");
String lname = request.getParameter("LNAME");
String phone = request.getParameter("PHONE");
Statement stmt = con.createStatement();
stmt.executeUpdate("INSERT INTO MYTABLE VALUES ('" + fname + "', '" + lname + "', '" + phone + "')");

response.setContentType("text/html");
PrintWriter out = response.getWriter();
out.println("<html><body>");

ResultSet rset = stmt.executeQuery("SELECT * FROM MYTABLE");

while (rset.next()) {

out.print("<pre>");
out.print("First Name: " + rset.getString(1));
out.print("</pre>");
out.println();
out.print("<pre>");
out.print("Last Name: " + rset.getString(2));
out.print("</pre>");
out.println();
out.print("<pre>");
out.print("Phone: " + rset.getString(3));
out.print("</pre><br>");
out.println();
out.println();
}

out.println("</body></html>");
out.close();
stmt.close();

}

catch (Exception e) {

response.setContentType("text/html");
PrintWriter out = response.getWriter();
out.println("<html><body>");
out.println(e.getMessage());
out.println("</body></html>");
out.close();
}

}

Create a Servlet that displays a form when the doGet method is invo...