Excersise: 16 Simple Data Base | Java | Tamizhan Goals

Excersise: 16

    

Program

import java.io.*;
import java.sql.*;
public class jdbc
{
public static void main(String[] arg)
{
try
{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
Connection con=DriverManager.getConnection("jdbc:odbc:123","","");
Statement st=con.createStatement();
ResultSet rs=st.executeQuery("Select *From aa");
ResultSetMetaData rsmd=rs.getMetaData();
int numberOfColumns=rsmd.getColumnCount();
while(rs.next())
{
for(int i=1;i<=numberOfColumns;i++)
{
if(i>1)
System.out.println(",");
String columnValue=rs.getString(i);
System.out.print(columnValue);
}
System.out.println(" ");
}
st.close();
con.close();
}
catch(Exception ex)
{
System.err.print("Exception:");
System.err.println(ex.getMessage());
}
}
}

Output