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 using a Java Bean and a Custom Tag. 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.

// the connection
            Connection conn = null;
            Class.forName("oracle.jdbc.driver.OracleDriver");
            // you may want to chage some infor to meet your setting
            conn=DriverManager.getConnection("jdbc:oracle:thin:@localhost:1521:xe","app","app");
            // some usual statemant
            PreparedStatement psSelectRecord=null;
            ResultSet rsSelectRecord=null;
            String sqlSelectRecord=null;

            sqlSelectRecord ="SELECT * FROM datatable";
            // get all record in this object
            psSelectRecord=conn.prepareStatement(sqlSelectRecord);
            rsSelectRecord=psSelectRecord.executeQuery();
            // we have got the data from database here
            // let's put it in to an array
            
            ArrayList<bean> rs = new ArrayList<bean>();
            while(rsSelectRecord.next()){
             // add new bean to array...
$40.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