Using Java and Eclipse please write a new code and not use an existing Chegg ans

ID: 3746446 • Letter: U

Question

Using Java and Eclipse please write a new code and not use an existing Chegg answer:

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. The grade for this assignment will be based both on the functionality of the servlet and the appearance of the form post results. Name your servlet <yourName>FormPost and name the random access data file c: emp<yourname>week4.dat. You must locate the file in the c: emp directory to receive credit. This is so I can run and grade it on my computer without modifying your source code. Attach your servlet source code file and random access data file to this assignment in one zipped file. Do not copy (cut and paste) any example code, create your own code and use the examples as a guide.

Explanation / Answer

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();
}

}

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();

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

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

while (rset.next()) {

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();
}

}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();

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

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

while (rset.next()) {

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();
}

}

Navigate

Using Java add the specified methods to the letterPuzzle class and add tester co

Using Java and Eclipse: Create a Servlet that displays a form when the doGet met

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.

Using Java and Eclipse please write a new code and not use an existing Chegg ans

Question

Explanation / Answer

Related Questions

Navigate