** SET-A**
Q1. Assume a table "login" with username and password in mysql database "userdetails". Create a Dynamic web project for login page using Servlet.
Instructions for index.html
Create a form in index.html with following tag
action="LoginServelt" method="Post"
index.html page should have following text filds and button
for first textfield : input type="text"
for second textfield : input type="password"
for button : input type=submit
Creats Servlet class LoginServlet. Define doPost method in LoginServlet.
Function of doPost() method:
- Fetch username and password from index.html page.
- Establish JDBC connection with database "userdetails"
- Fetch records from "login" table
- If the entered Username and password matches with "login" table username and password, print valid user else invalid user. Q2. Create two files one.txt and two.txt. Write 5 lines in both files. Now merge the contents of both files into third file three.txt. Print the content of three.txt.
Q3. Create a table "Employee" in mysql database "db1" with following fields. 1. Name : varchar 2. id : int (Enter ids beetween 101 to 121) 3. salary: double
Write a JDBC program. Ask a user to enter details using Scanner class. Insert these details in the Employee table using PreparedStatement.
1. Valid id lies between 101 to 121.
2. You have to enter 5 employees details of valid ids.
2. if a user entered wrong id then throw user define exception invalid id.
For example:->
Valid input:
Name : JK
id : 102
salary: 5000
InValid input:
Name: JK
id: 500 (Invalid throw exception)
salary: 5000
**SET - B**
Q1. Assume a table "customer" with name, address and phone number in mysql database "customerdetails". Create a Dynamic web project for Reservation using Servlet.
Instructions for index.html
Create a form in index.html with following tag
action="LoginServelt" method="Post"
index.html page should have following text filds and button
for first textfield : input type="text"
for second textfield : input type="text"
for third textfield : input type="text"
for button : input type=submit
Creats Servlet class ReservationServlet. Define doGet method in ReservationServlet.
Function of doGet() method:
- Fetch name, address and phone numberfrom index.html page.
- Establish JDBC connection with database "customerdetails"
- insert record in "customerdetails" table
- Print Record saved in database
Q2. Create two files one.txt and two.txt. Write 100 to 150 intgeres in one.txt. For example: one.txt 100 102 103 . . 150 Read content from one.txt. And reverse each number and write into two.txt
Q3. Create a table "Student" in mysql database "db1" with following fields. 1. Name : varchar 2. Roll number : int (valid range is 1 to 63) 3. percentage: double
Write a JDBC program. Ask a user to enter roll number using Scanner class. Fetch record of specified roll number.
1. if a entered roll number is not valid then trow userdefine exception invalid student roll number
For example:->
Valid input:
Name : JK
Roll Number : 10
percentage: 50
InValid input:
Name: JK
Roll Number : 70(Invalid throw exception)
percentage: 50