Create, Insert, Update, Select, Delete in MS Access using JAVA

In this post I will discuss about how to create table into the database, How to Insert, Update and delete  data from table.
If you haven’t created the DSN to create a bridge between database and program, Please click here and setup the connection.

Creating Table:
Before executing the program MS Access is:

Databse Creation
This picture holds copyright of qsoln.com

Create statement is used to create a table.

Insert statement is used to insert a new record into a table.

UPDATE statement is used to update existing records in a table.

Select statement is used to display existing records from a table.

Delete statement is used to delete records from a table.

Full code:

Output:

After executing this program a table studentdata with three records is created

Database ceartion
This picture holds copyright of qsoln.com

Leave a Reply