RBF Concept

RBFConcept:

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

class RBFConcept {

    public static void main(String[] args) {
        try {
            FileInputStream fis = new FileInputStream("rbfdb.prop");
            Properties p = new Properties();
            p.load(fis);
            String dname = (String) p.get("Dname");
            String url = (String) p.get("URL");
            String username = (String) p.get("Uname");
            String password = (String) p.get("Pwd");
            String tablename = (String) p.get("Tablename");
// loading drivers and obtaining connection
            Class.forName(dname);
            System.out.println("DRIVERS LOADED...");
            Connection con = DriverManager.getConnection(url, username, password);
            System.out.println("CONNECTION CREATED...");
// executing query
            Statement st = con.createStatement();
            ResultSet rs = st.executeQuery("select * from" + tablename);
            ResultSetMetaData rsmd = rs.getMetaData();
// printing column names
            System.out.println("=================================");
            for (int i = 1; i <= rsmd.getColumnCount(); i++) {

                System.out.print(rsmd.getColumnName(i) + "	");
            }
            System.out.println("");
            System.out.println("=================================");
// printing the data while (rs.next ())
            {
                for (int j = 1; j <= rsmd.getColumnCount(); j++) {
                    System.out.print(rs.getString(j) + "	");
                }
            }
            con.close();
        } catch (Exception e) {
            e.printStackTrace();
        }
    }// main
};