Web Application With JSP

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.

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...