Performing CRUD operations using JDBC

In this recipe, you will learn how to populate, read, change, and delete data in the using JDBC.

Getting ready

We have already seen examples of SQL statements that create (populate) data in the database:

INSERT INTO table_name (column1,column2,column3,...)
VALUES (value1,value2,value3,...);

We've also seen examples of instances where several table records have to be added:

INSERT INTO table_name (column1,column2,column3,...)
VALUES (value1,value2,value3, ... ), 
       (value21,value22,value23, ...), 
       ( ...                       );

If a column has a default value specified, there is no need to list it in the INSERT INTO statement, unless a different value has to be inserted.

...