Concept explainers
Explanation of Solution
The Java method to display “ResultSet” as a table is given below,
“ResultSetTable()” method:
ResultSetTable(ResultSet rt) throws SQLException
{
//Declare the variable for JDBC meta data
ResultSetMetaData meta_data;
//Declare the variable for number of columns in result
int columns;
//Get the meta data
meta_data=rt.getMetaData();
//Get the columns count
columns=meta_data.getColumnCount();
//Create "for" loop
for (int i; i<=columns; i++)
{
//Get the column header and outputs them
System.out.print(meta_data.getColumnName(i)+" ");
}
//Print new line
System.out.println();
//Execute "while" loop for current record
while(rt...
Trending nowThis is a popular solution!
Chapter 5 Solutions
DATABASE SYSTEM CONCEPTS (LOOSELEAF)
- Database System ConceptsComputer ScienceISBN:9780078022159Author:Abraham Silberschatz Professor, Henry F. Korth, S. SudarshanPublisher:McGraw-Hill EducationStarting Out with Python (4th Edition)Computer ScienceISBN:9780134444321Author:Tony GaddisPublisher:PEARSONDigital Fundamentals (11th Edition)Computer ScienceISBN:9780132737968Author:Thomas L. FloydPublisher:PEARSON
- C How to Program (8th Edition)Computer ScienceISBN:9780133976892Author:Paul J. Deitel, Harvey DeitelPublisher:PEARSONDatabase Systems: Design, Implementation, & Manag...Computer ScienceISBN:9781337627900Author:Carlos Coronel, Steven MorrisPublisher:Cengage LearningProgrammable Logic ControllersComputer ScienceISBN:9780073373843Author:Frank D. PetruzellaPublisher:McGraw-Hill Education