Java连接数据库的配置(附带jar包)

     Oracle 

url = jdbc:oracle:thin:@ip(host):1521(port):orcl(instance) driver = oracle.jdbc.OracleDriver user = scott password = password

     MySQL

url = jdbc:mysql://ip(host):3306/(database) driver = com.mysql.jdbc.Driver user = root password = root

      jar包

     

SQLServer

url = jdbc:sqlserver://localhost:1433;databaseName=dbname driver = com.microsoft.sqlserver.jdbc.SQLServerDriver user = root password = root

mysql                 https://repo1.maven.org/maven2/mysql/mysql-connector-java/5.1.47/mysql-connector-java-5.1.47.jar oracle                http://www.datanucleus.org/downloads/maven2/oracle/ojdbc6/11.2.0.3/ojdbc6-11.2.0.3.jar sqlserver           https://repo1.maven.org/maven2/com/microsoft/sqlserver/mssql-jdbc/6.1.0.jre8/mssql-jdbc-6.1.0.jre8.jar

      PS:MySQLjar包最高支持MySQL5.5.x版本 Oraclejar包最高支持Oracle 11g最新版 SQLServer为版本为2008R2

            driver(驱动类)根据jar包中的实际的类的路径填写，本文的驱动类路径仅限于使用上面的jar包