Learn essays--python connect to Oracle Database

#coding =utf-8import cx_oracle                                     #引用模块cx_Oracleimport osos.environ[' nls_lang '] = ' simplified Chinese_china. UTF8 ' #编码问题conn =cx_oracle.connect (' xho ', ' sys ', ' LOCALHOST:1521/ORCL ')    #连接数据库c =conn.cursor ()                                           #获取cursor游标x =c.execute (' select * from weight ')                   #使用cursor进行各种操作a =x.fetchone ()            #查询时获取结果集的第一行数据, returns a tuple of print Ab=x.fetchall ()               #所有行, a row forms a tuple, and then returns those tuples (that is, nested tuples print b# bound variable sql = ' INSERT into weight (Bs,jsej,jgej) VALUES (: Bs,:jsej,:jgej) ' x= C.execute (SQL, (' AAA ', +)) Conn.commit (); C.close ()                                                 #关闭cursorconn. Close ()                                              #关闭连接

　　

Learn essays--python connect to Oracle Database