Here, you will learn how to retrieve all rows from a database table. You know that table contains the data in rows and columns format. If you want to access the data from a table then you need to use some APIs and methods. See brief descriptions for retrieving all rows from a database table as below:
Description of program:
Program establishes the connection between MySQL database and java file so that the we can retrieve all data from a specific database table. If any exception occurs then shows a message "SQL code does not execute.".
Description of code:
This method executes the SQL statement and returns a single ResultSet object. It takes string type parameter for executing the SQL statement.
SELECT * FROM table_name:
Above code retrieves all data from specific database table.
This method is of java.sql.ResultSet interface that takes string type parameter and returns an integer type values.
This method is same as getInt() method but it returns the string type values.
Here is the code of program:
Output of program:
Getting All Rows from a table!
Posted on: April 13, 2007 If you enjoyed this post then why not add us on Google+? Add us to your Circles