Basics of jdbc programming Tutorial-12(ResultSetMetaData interface)

this video deals with the overall idea of how the jdbc program is connected to the database so as to retrieve the properties of the columns present inside the table.

[learnitbyfun]

import java.sql.*;
import java.io.*;
class Jdbc
{
public static void main(String[] args) throws Exception
{

Connection con=null;
Statement st=null;
ResultSet rs=null;
try
{

"student", "shubham123");
if(con!=null)
{
established");
st=con.createStatement();
}
if(st!=null)
{
System.out.println("statement object created");
rs=st.executeQuery("select * from emp026");
ResultSetMetaData rsmd=rs.getMetaData();
int n=rsmd.getColumnCount();
System.out.println("no of columns:"+n);
for(int i=1;i<=n;i++)
{
System.out.println("column no:"+i);

System.out.println("column
System.out.println("column
System.out.println("column
System.out.println("column
System.out.println("Is
System.out.println("Is read only"+rsmd.isReadOnly(i));
System.out.println("is
System.out.println("is
System.out.println("is signed="+rsmd.isSigned(i));
}
}
}
catch(SQLException e)
{
e.printStackTrace();
}
catch(ClassNotFoundException e)
{
e.printStackTrace();
}
catch(Exception e)
{
e.printStackTrace();
}
finally
{
st.close();
con.close();
}

}
}