python连接mysql,oracle,sqlserver

时间:2019-12-12 10:09:44   收藏:0   阅读:104

sqlserver、mysql、oracle各自的默认端口号

 

sqlserver默认端口号为:1433

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

DRIVERNAME:"com.microsoft.jdbc.sqlserver.SQLServerDriver";

mysql      默认端口号为:3306

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

DRIVERNAME:"com.mysql.jdbc.Driver";

oracle    默认端口号为:1521

URL:"jdbc:oracle:thin:@localhost :1521:orcl";

DRIVERNAME:"oracle.jdbc.driver.OracleDriver";

 

原文:https://www.cnblogs.com/yoyowin/p/12027363.html

评论(0
© 2014 bubuko.com 版权所有 - 联系我们:wmxa8@hotmail.com
打开技术之扣,分享程序人生!