QuestionQuestion

Create a new Web application. Next, create a JSP 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 JSP, which in the doPost method will save the form data to a database. Use your Oracle account to make the DB connection. After the form data has been saved to the database, respond back with a query from the database displaying all the current records contained in the database, in an appealing format. The form must contain a minimum of three input fields.

Solution PreviewSolution Preview

This material may consist of step-by-step explanations on how to solve a problem or examples of proper writing, including the use of citations, references, bibliographies, and formatting. This material is made available for the sole purpose of studying and learning - misuse is strictly forbidden.

protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
       // TODO Auto-generated constructor stub
String fn = request.getParameter("FirstName");
String dob = request.getParameter("DOB");
String sn = request.getParameter("LastName");
response.setContentType("text/html");

PrintWriter out = response.getWriter();
try{
// we decalare the link to connecting lib
Class.forName("oracle.jdbc.driver.OracleDriver");

// connect
// we willl change the connection here
Connection con=DriverManager.getConnection(
"jdbc:oracle:thin:@localhost:1521:xe","student1","pass");

// query
String sql="insert into data(sname,fname,dob)values(?,?,?)";...
$35.00 for this solution

PayPal, G Pay, ApplePay, Amazon Pay, and all major credit cards accepted.

Find A Tutor

View available Java Programming Tutors

Get College Homework Help.

Are you sure you don't want to upload any files?

Fast tutor response requires as much info as possible.

Decision:
Upload a file
Continue without uploading

SUBMIT YOUR HOMEWORK
We couldn't find that subject.
Please select the best match from the list below.

We'll send you an email right away. If it's not in your inbox, check your spam folder.

  • 1
  • 2
  • 3
Live Chats