Yes, here is some example code from one of our happy customers:
// QuickBooks variables Connection con =null; Statement stmt = null; ResultSet rs = null;
// parameters for QuickBooks database static final String url = "jdbc:odbc:quickbooks"; // quickbooks is a System DSN that is the name of the QODBC driver // On WindowsXP it can be set up at Control Panel > Administrative Tools > // Data Sources (ODBC)
static final String driver = "sun.jdbc.odbc.JdbcOdbcDriver";
public static void main(String[] args) throws Exception { InsertCustomers t = new InsertCustomers(); }
public InsertCustomers() throws Exception { try { Class.forName(driver); con = DriverManager.getConnection(url); stmt = con.createStatement(); System.out.println("Querying QB customer table"); rs = stmt.executeQuery("SELECT * FROM customer"); // rest of code deleted |