try {
DBF dbf = new DBF("rechnung.dbf", DBF.READ_ONLY );
} catch (xBaseJException e) {
// TODO Auto-generated catch block
e.printStackTrace();
} catch (IOException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
private void showTable(String dns, String table) {
try {
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
cwscon = DriverManager.getConnection("jdbc:odbc:" + dns);
PreparedStatement st = cwscon.prepareStatement("SELECT * FROM " + table);
ResultSet rs = st.executeQuery();
int rowcount = 0;
while (rs.next()) {
rowcount++;
System.out.println("--- DATENSATZ NR. " + rowcount + "---");
for (int i = 1; i <= rs.getMetaData().getColumnCount(); i++) {
System.out.print(rs.getMetaData().getColumnName(i) + ": ");
Object obj = rs.getObject(i);
if (obj == null) {
System.out.println("NULL");
} else {
System.out.println(obj);
}
}
}
} catch (ClassNotFoundException ex) {
Logger.getLogger(Main.class.getName()).log(Level.SEVERE, null, ex);
} catch (SQLException ex) {
Logger.getLogger(Main.class.getName()).log(Level.SEVERE, null, ex);
}
}