sqlserver、mysql、oracle、神通数据库(oscar)、达梦(dm)的JDBC连接格式

sqlserver默认端口号为:1433


URL=jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=dbname


DriverClasses = com.microsoft.jdbc.sqlserver.SQLServerDriver


mysql      默认端口号为:3306


URL=jdbc:mysql://localhost:3306/test? user=root&password=&useUnicode=true&characterEncoding=gbk


DriverClasses = com.mysql.jdbc.Driver


oracle    默认端口号为:1521


URL=jdbc:oracle:thin:@localhost :1521:orcl


DriverClasses = oracle.jdbc.driver.OracleDriver


神通数据库(oscar)默认端口号为:2003


url = jdbc:oscar://localhost:2003/osrdb


DriverClasses = com.oscar.Driver


达梦(dm)   默认端口号为:5236


url = jdbc:dm://localhost:5236


DriverClasses = dm.jdbc.driver.DmDriver