数据库连接大全
1. MySQL(http://www.mysql.com)mm.mysql-2.0.2-bin.jar
Class.forName( "com.mysql.jdbc.Driver" );
cn = DriverManager.getConnection("jdbc:mysql://MyDbComputerNameOrIP:3306/myDatabaseName?useUnicode=true&characterEncoding=GBK", 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. Microsoft SQLServer(http://www.microsoft.com)
Class.forName( "com.microsoft.jdbc.sqlserver.SQLServerDriver" );
cn = DriverManager.getConnection("jdbc:microsoft:sqlserver://MyDbComputerNameOrIP:1433;DatabaseName=master", sUsr, sPwd );