常用数据库连接描述符

来源：互联网发布：360解压软件下载编辑：程序博客网时间：2024/06/05 08:59

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 );

阅读全文

0 0