Skip to main content

Posts

Showing posts with the label ResultSetMetaData

ResultSetMetaData in java

 ResultSetMetaData in java code:; import java.sql.Connection; import java.sql.DriverManager; import java.sql.ResultSet; import java.sql.ResultSetMetaData; import java.sql.SQLException; import java.sql.Statement; class Test{ public static void main(String arg[]){ try(Connection con = DriverManager.getConnection("jdbc:oracle:thin:@localhost:1521:orcl","system","tiger"); Statement st = con.createStatement(); ResultSet rs = st.executeQuery("select * from stu");){ //create ResultSetMetaData obj ResultSetMetaData rsmd = rs.getMetaData(); //get column count int colCount = rsmd.getColumnCount();//3 //print column name for(int i=1;i<=colCount;i++) { System.out.print(rsmd.getColumnName(i)+" "); } System.out.println(); //for column type for(int i=1;i<=colCount;i++) { System.out.print(rsmd.getColumnTypeName(i)+" "); } System.out.println(); }catch(SQL