Advance Programming in JAVA Lab Experiment List JDBC

yoinkscreechedInternet και Εφαρμογές Web

13 Νοε 2013 (πριν από 3 χρόνια και 7 μήνες)

156 εμφανίσεις

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
.