常用数据库连接描述符

1.Microsoft SQLServer(http://www.microsoft.com)

        (SqlServer 2000)
            Class.forName( "com.microsoft.jdbc.sqlserver.SQLServerDriver" );
            cn = DriverManager.getConnection( "jdbc:microsoft:sqlserver://localhost:1433;databaseName=pubs", sUsr, sPwd );

        (SqlServer 2005)
            Class.forName( "com.microsoft.sqlserver.jdbc.SQLServerDriver" );
            cn = DriverManager.getConnection( "jdbc:sqlserver://localhost:1433;databaseName=pubs", sUsr, sPwd );

2. Oracle(http://www.oracle.com/ip/deploy/database/oracle9i/)classes12.zip
        Class.forName( "oracle.jdbc.driver.OracleDriver" );
        cn = DriverManager.getConnection( "jdbc:oracle:thin:@MyDbComputerNameOrIP:1521:ORCL", sUsr, sPwd );
        
3. MySQL(http://www.mysql.com)mm.mysql-2.0.2-bin.jar
        Class.forName( "org.gjt.mm.mysql.Driver" );
        cn = DriverManager.getConnection( "jdbc:mysql://MyDbComputerNameOrIP:3306/myDatabaseName", sUsr, sPwd );