数据库连接大全

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

posted @ 2013-07-30 16:53  Java Hello world  阅读(106)  评论(0)    收藏  举报