Java.sql sample programs

Before you proceed, I shall assume that you are familiar with Java Programming and have installed the followings:. Do it otherwise. This step is important; otherwise, you will be out-of-sync with this article and may not be able to find your files later.

JDK 9 removes this extension mechanism. We have to set up a database before embarking on our database programming. We shall call our database " ebookshop " which contains a table called " books ", with 5 columns, as below:. I shall assume that MySQL server is running on the default port number of Python Design Patterns. Python Pillow. Python Turtle.

Verbal Ability. Interview Questions. Company Questions. Artificial Intelligence. Cloud Computing. Data Science. Angular 7. Machine Learning. This sample example can serve as a template when you need to create your own JDBC application in the future.

This sample code has been written based on the environment and database setup done in the previous chapter. Malhar Lathkar. Anadi Sharma. Tushar Kale. The ResultSet object rs now contains the results from the database query. Now we can work with those results. After you execute the SQL query, how do you read the results?

Well, JDBC makes this pretty easy also. In many cases, you can just use the next method of the ResultSet object. After the previous two lines, you might add a loop like this to read the results:. This loop reads the last name returned in each record, and prints it to the screen using the normal System. In the case of our sample database, the printed results look like this:.