java ODBC链接 JDBC链接

 ODBC链接   

  SQL 2000数据库：

       private String url = "jdbc:odbc:localServer";

        private static Properties prop = new Properties();
        prop.put("user", "sa");
        prop.put("password", "sql2000");
        prop.put("charSet", "GB2312"); //或者UTF-8// GBK//GB2312

       Connection cn = DriverManager.getConnection(url, prop);

 

    Oracle11g数据库

             String url = "jdbc:odbc:oracle11oracle";
            Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
            cn = DriverManager.getConnection(url, "oracle", "oracle");

 JDBC链接  

 SQL 2000数据库：

            Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");
            String url = "jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=dataname;";
            Properties prop = new Properties();
            prop.put("user", "sa");
            prop.put("password", "sql2000");
            prop.put("charSet", "GB2312"); //或者UTF-8// GBK//GB2312
            jdbccone = DriverManager.getConnection(url, prop);

    Oracle11g数据库

            Class.forName("oracle.jdbc.driver.OracleDriver");
            String url = "jdbc:oracle:thin:localhost:1527:orac";
            Properties prop = new Properties();
            prop.put("user", "oracle");
            prop.put("password", "oracle");
            prop.put("charSet", "GB2312"); //或者UTF-8// GBK//GB2312
            jdbccone = DriverManager.getConnection(url, prop);