SQuirreL SQL Client是否与QODBC兼容?(Is SQuirreL SQL Client compatible with QODBC?)
有谁知道SQuirreL SQL Client是否与QODBC兼容? 如果没有,SQuirreL有一个插件可以启用吗?
任何见解都会受到赞赏,因为我从来没有使用过。
Does anyone know if the SQuirreL SQL Client is compatible with QODBC? If not is there a plugin for SQuirreL to enable so?
Any insight would be appreciated as I have never used either.
最满意答案
使用Java ODBC Bridge产品的QODBC驱动程序示例
注意:以下是我们一位满意客户的示例代码:
// 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");An Example of QODBC Driver working with the Java ODBC Bridge Product
Note: Below are 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");更多推荐
发布评论