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";
2. python连接oracle数据库
2.1 安装模块,使用第三方模块cx_Oracle
pip install cx_Oracle
2.2 三种连接方式
1 importcx_Oracle as cx2
3 #第一种
4 con = cx.connect('root', 'root123', '127.0.0.1:1521/orcl')5 #第二种
6 con = cx.connect('root/root123@127.0.0.1:1521/orcl')7 #第三种
8 dsn &