L. Laboratory Manuals

Write a Java Application using concept of JDBC for user login. User will enter username and password. Application will match for the same in table in database. If match is found the display message "Successful Login" and if not found display message "Invalid Username and password ".

Write an Menu driven java application for student information which will create the table with appropriate columns. Menu will contain the options like insert, update and delete. Based on the option, data will be inserted or updated or deleted from table based on student id (student_id will be primary key). And appropriate message will be displayed for each operation.

Write an application using GUI for registration. In first form user will enter the data for registration like (Name, Birthdate, Email_id, Phone_No). On clicking on submit button data will be inserted into database and user will be redirected to another form. In this form data will be selected from database and displayed in proper format.

Write a servlet application for user authentication (use JDBC). Also display various contents using request object and response object.

Write a servlet application for implementing student grading system. In this system on first page student will enter his data (name, id and department).By clicking on next button he will be redirected to another page. On the second page he will enter marks of all 6 subjects. By clicking on "Generate result" he will be redirected to next page. On this page all information of student will be displayed along with the result pass or fail in appropriate colour. Also display the name of student on each page he visits. (Use session management)

Write an application for the following:

User should be redirected to the URL entered in location text box.

Develop a JSP application for user authentication (use JDBC).

Write an application for Bank Account information using Bean. This application will perform various operation on bank account like withdraw , deposit and displaying the information.

Write an JSP application using custom tag which takes 10 numbers from user and sorts them.

Write an application that will allow maximum 3 users to access the application. If number of users exceeds than limit then user will be redirected to the error page.

Develop a simple JAX-RS service that provides currency conversion.

Develop a RESTful service to accept student registration data sent from a web form.

Create JAX-RS service that provides CRUD database operation interface for a phonebook. Call appropriate service from servlet/jsp pages to perform data oriented operations.

Create a JAX-RS client that consumes RESTful service developed in Program-11. Utilize the client in UI layer (JSP pages).

Create RESTful service to perform authentication of the user. The JAX-RS client will be implemented in servlet and provide interface between jsp page and web service to perform authentication.

Develop a struts 2 application that accepts user name and password from user. If both values are valid then user will be redirected to home page otherwise on error page.

Develop a data driven Struts 2 application that accepts registration details from user, i.e. name, contact number, address, user id and password. After successful registration, application redirects user to log in page. If user provides valid authentication details then application will redirect user to home page and will display welcome message, otherwise user will be redirected to error page.

Develop a phone book using struts 2. Application accepts data of contacts like name, address, contact number and email id. The application should provide features to update, delete and list data of contacts into/from database.

Create a logging service using struts 2 to monitor log in and log out timestamp of the users. (Hint: utilize interceptors)

Develop an application using struts 2 that provides insert, update, delete and list operations for Student data like, name, roll number, semester, course, result (%). The data oriented operations must be performed through hibernate.