Monday, August 31, 2009

TO Get Any Table
=================
import java.sql.*;
import java.util.*;
class Anytable_Retrieval
{
public static void main(String[] args) throws SQLException
{
Connection con;
Statement st;
ResultSet rs;
ResultSetMetaData rsmd;
Scanner sc=new Scanner(System.in);
try{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
con=DriverManager.getConnection("jdbc:odbc:sagar","system","bvrice");
while(true)
{

System.out.println("Enter which table details you want :");
String str=sc.next();

st=con.createStatement();
rs=st.executeQuery("select * from "+str);
rsmd=rs.getMetaData();

int cc=rsmd.getColumnCount();
for(int i=1;i<=cc;i++)
System.out.print(rsmd.getColumnName(i)+" ");
System.out.println();
while(rs.next())
{

for(int i=1;i<=cc;i++)
{
System.out.print(rs.getString(i)+" ");
}
System.out.println();
} // end inner while
System.out.println("Do you want another table details(false/true) :");
boolean choice=sc.nextBoolean();
if(!choice) // false
break;

}// end outter while
rs.close();
st.close();
con.close();
} // try
catch(Exception e)
{
System.out.println(e);
}
}
}

No comments:

Post a Comment