Practice from Advanced Java Programming with detailed solutions and model answers from past Tribhuvan University exams.
How do you execute SQL statements using JDBC? Explain with an example.
Compare result set with row set. Explain a prepared statement with an example.
How the data can be accessed through a resultset object? Explain forward only, scroll-insensitive and scroll-sensitive resultsets.
What is the use of RowSet interface? Explain connected and disconnected rowsets.
Explain JDBC architecture. Write a program to insert three records into a table Item which is in the database Shop and contains the columns ItemID, Name, UnitPrice, Units and ExpiryDate.
What is the use of PreparedStatement? Differentiate between Statement and PreparedStatement.
Why do we need to use layout managers in GUI programming? Write a program to create a GUI form that takes data about a customer including cid, name, address, email and age and insert these data into the Customer table of the Shop database.