73 Advanced Java Tutorial |JDBC | ResultSetMetaData to print records given database | adv java

#Advanced Java Tutorial: adv java - Example Java JDBC application on ResultSetMetaData to print the records of given database table along with columns names & column datatype.

import java.sql.*;
import java.util.*;

public class ResultSetMetaDataWithDataTypes
{
public static void main(String[] args) throws Exception
{
Scanner sc=new Scanner(System.in);
System.out.println("enter the table name");
String tab=sc.next();

//create jdbc connection
Class.forName("oracle.jdbc.driver.OracleDriver");
Connection con=DriverManager.getConnection("jdbc:oracle:thin:@localhost:1521:orcl", "scott", "boss");

//create peristant logic
Statement st=con.createStatement();

ResultSet rs=st.executeQuery("select * from "+tab);

ResultSetMetaData rsmd=rs.getMetaData();
int colCount=rsmd.getColumnCount();

-------------------------------------------------------
-----------------------------------
//close
rs.close();
st.close();
con.close();

}
}