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
} // RSFConcept
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
} // RSFConcept
|
No comments:
Post a Comment