Several ways Python connects to a database ___ database

The recent use of Python to connect to an Oracle database has encountered some connectivity problems and found that there are two main ways to connect: method1

Import cx_oracle
con = cx_oracle.connect (DataBase urser Name, password,ip)
cursor = con.cursor ()
Sql_ Select= ' SELECT * FROM tablename where condition1 and condition2 the ORDER by Attr1 Desc '
#读取TableName表中满足Condition1 and Cond Ition2 all field data and arranges in descending order of Attr1 fields. In ascending order, by Attr1 ASC Cur.execute (
sql_select) cursor.close ()
con.close ()

Method2

Import cx_oracle
DSN = Cx_oracle.makedsn (IP, ' 1521 ', SID)
conn = Cx_oracle.connect (DataBase urser Name, Password, DSN)
cur = conn.cursor ()
sql_select= ' Select * from TableName where Condition1 and Condition2 Attr1 desc '
#读取TableName表中满足Condition1 and Condition2 all field data, sorted in descending order by Attr1 field. In ascending order, by Attr1 ASC Cur.execute (
sql_select) cursor.close ()
con.close ()