学步园

       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为数据库的用户名和密码