JDBC-ODBC(JDBC)连接数据库的方法简要说明...

Posted on 2006-03-19 13:59  CQIT-CS  阅读(711)  评论(0编辑  收藏  举报

       1.连接MSSQLSERVER
       Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");    //首先要下载JDBC-ODBC桥驱动
       连接串为:jdbc:odbc:odbcName                               //odbcName为在ODBC中配置的名称
       取得连接:Connection myConn=DriverManager.getConnection("jdbc:odbc:odbcName",userName,pwd);   
                                                                                                            //userName,pwd为MSSQLSERVER用户名和密码

        2.连接ORACLE
        Class.forName("oracle.jdbc.driver.OracleDriver");  //首先要下载JDBC for ORACLE的驱动
        连接串为: jdbc:oracle:thin:@serverName:port(1521):serviceName
        取得连接:Connection conn = DriverManager.getConnection("jdbc:oracle:thin:@serverName:port(1521):serviceName",username,password);   //username,password为数据库的用户名和密码

Copyright © 2024 CQIT-CS
Powered by .NET 8.0 on Kubernetes