各种数据库连接代码（java）

SqlServer2000

 

Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");

   URL = "jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=tempdb";

 

 

SqlServer2005

 

   Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");

   URL = "jdbc:sqlserver://localhost:1433;DatabaseName=tempdb";

 

 

oracle

 

String myDriver="oracle.jdbc.driver.OracleDriver";

   String url="jdbc:oracle:thin:@localhost:1521:dba";

   Class.forName(myDriver);

   System.out.print("驱动加载成功！");

   conn=DriverManager.getConnection(url, "scott", "tiger");

   System.out.println("连接成功！");

    stmt=conn.createStatement();

 

 

mySQL

 

   String myDriver="com.mysql.jdbc.Driver";

    String myDriver="org.git.mm.mysql.Driver";

   String url="jdbc:mysql://127.0.0.1:3306/game";

   conn= DriverManager.getConnection(url,"root","root");

 

 

之前所写，迁移至此

原文链接：http://user.qzone.qq.com/372806800/blog/1336200699