Advance Programming in JAVA Lab Experiment List JDBC

yoinkscreechedInternet and Web Development

Nov 13, 2013 (4 years and 11 months ago)

190 views

Advance Programming in JAVA

Lab


Experiment List

JDBC

Consider the following database

Database Name: mydb

Table Name: students

id

first_name

last_name

course

semester

sem_registration_date


1.

Write a program
in Java to create a connection to MS
-
Access/MySQL and
create the ‘
students


table.

2.

Write a program to insert student details in the given table.

3.

Write a program
to
retrieve the students’ detail and display in tabular form.

4.

Write a program
to update the
sem
ester when registration date changes.

5.

Write a program to delete the
students whose
sem_registration_date

is 6 months old from the
current date.


SOCKET PROGRAMING


6.

Write a program to create a server which can accept a client at port no. 2222.

7.

Write a
program to create a client which can read from and write

to a Socket

at port no. 2222.

8.

Write a program to create a server which can accept multiple clients and broadcast a massage to
all.

9.

Write a program to create
a Datagram Client and
a
Server
.

10.

Write a
program to create a registration from

(form fields are as in mydb.students table)

using
AWT components.


SERVLET


11.

Write
a servlet that counts and displays the number of times it has been accessed.

12.

Write a servlet to generate a registration form (form field
s are as in mydb.students table).

13.

Write a servlet to process the registration form.

14.

Write a servlet to store the form data in mydb.students table.

15.

Write a servlet to display the data from mydb.students table

16.

Write a program to save

the State of the Current
ly Loaded Servlets
.


JSP


17.

Write a
program of adding two numbers in JSP
.

18.

Write a
program
to create JSP to generate a registration form (form fields are as in mydb.students
table).

19.

Write a
program
to demonstrate
JSP Error Handling
.

20.

Write a
program
to create a
set of pages that put a user's name in the session, and display it
elsewhere
.