几种常见数据库的driverClassName和url

 

　　DB2:

　　driverClassName:com.ibm.db2.jcc.DB2Driver

　　url:jdbc:db2://localhost:50000/sample

　　Oracle:

　　driverClassName:oracle.jdbc.driver.OracleDriver

　　url:jdbc:oracle:thin:@localhost:1521:orcl

　　MySql:

　　driverClassName:com.mysql.jdbc.Driver

　　url:jdbc:mysql://localhost:3306/test

　　Mssql:

　  driverName = "com.microsoft.sqlserver.jdbc.SQLServerDriver"; //加载JDBC驱动
　  URL = "jdbc:sqlserver://localhost:1433; DatabaseName=sample"; //连接服务器和数据库sample