python3 oracle数据库操作_python 操作Oracle数据库

不念不忘少年蓝@ 2023-01-08 08:19 297阅读 0赞

1.安装oracle驱动：

pip install cx\_Oracle

2.数据库连接操作：conn = cx\_Oracle.connect('xzt/xzt@localhost/testdb')\#这里的顺序是用户名/密码@oracleserver的ip地址/数据库名字

cur = conn.cursor()

sql = "SELECT \* FROM DUAL"

cur.execute(sql)

rows = cursor.fetchall()\#得到所有数据集

for row in rows:

print("%d, %s, %s, %s" % (row\[0\], row\[1\], row\[2\], row\[3\]))\#python3以上版本中print()要加括号用了

print(f"Number of rows returned: \{cursor.rowcount\}")

while (True):

row = cursor.fetchone() \#逐行得到数据集

cur.close()

conn.commit()conn.close()

5.数据库查询：

import cx\_Oracle

conn = cx\_Oracle.connect('xzt/xzt@localhost/testdb')

cursor = conn.cursor ()

cursor.execute ("SELECT \* FROM STUDENT\_TB")

rows = cursor.fetchall() \#得到所有数据集

for row in rows:

print("%d, %s, %s, %s" % (row\[0\], row\[1\], row\[2\], row\[3\]))\#python3以上版本中print()要加括号用了

print("Number of rows returned: %d" % cursor.rowcount)

cursor.execute ("SELECT \* FROM STUDENT\_TB")

while (True):

row = cursor.fetchone() \#逐行得到数据集

if row == None:

break

print("%d, %s, %s, %s" % (row\[0\], row\[1\], row\[2\], row\[3\]))

print("Number of rows returned: %d" % cursor.rowcount)

cursor.close ()

conn.close ()

6.数据库插入：

import cx\_Oracle

conn = cx\_Oracle.connect('xzp/xzp@localhost/testdb')

cursor = conn.cursor()

cursor.execute ("CREATE TABLE INSERTTEST(ID INT, C1 VARCHAR(50), C2 VARCHAR(50), C3 VARCHAR(50))")

cursor.execute ("INSERT INTO INSERTTEST (ID, COL1, COL2, COL3)VALUES(1213412, 'asdfa', 'ewewe', 'sfjgsfg')")

cursor.execute ("INSERT INTO INSERTTEST (ID, COL1, COL2, COL3)VALUES(12341, 'ashdfh', 'shhsdfh', 'sghs')")

cursor.execute ("INSERT INTO INSERTTEST (ID, COL1, COL2, COL3)VALUES(123451235, 'werwerw', 'asdfaf', 'awew')")

conn.commit() \#这里一定要commit才行，要不然数据是不会插入的

cursor.close()

conn.close()

7案例：从某网站上面爬取彩票号码

import re

import urllib

import cx\_Oracle

import urllib.request

def getHtml(url):

page = urllib.request.urlopen(url)

html= page.read()

return html

def getNumber(html):

reg = r'

(\\d\{2\})'

reg2 = r'

(\\d\{2\})'

regqnumber = r'第 **(\\d\*)**'

number = re.compile(reg)

numberblue = re.compile(reg2)

qnumber = re.compile(regqnumber)

numberlist = re.findall(number,html.decode('gbk'))

numberblue = re.findall(numberblue,html.decode('gbk'))

qnum = re.findall(qnumber,html.decode('gbk'))

for number in numberblue:

numberlist.append(number)

for n in qnum:

numberlist.append(n)

print(numberlist)

return numberlist

\#将查询到的号码入库

def RecodeToOracle(list):

conn = cx\_Oracle.connect('xzp/xzp@localhost/testdb.domain')

cur = conn.cursor()

sql = "INSERT INTO SSQ (REDNUM1,REDNUM2,REDNUM3,REDNUM4,REDNUM5,REDNUM6,BLUENUM,QNUMBER) VALUES ('%s','%s','%s','%s','%s','%s','%s','%s')"%(list\[0\],list\[1\],list\[2\],list\[3\],list\[4\],list\[5\],list\[6\],list\[7\])

cur.execute(sql)

cur.close()

conn.commit()\#这里一定要提交，要不然是没有办法将数据入库的

conn.close()\#记得要关闭会话

def Geturl(html):

reg = r'上一期：'

url = re.compile(reg)

urllist = re.findall(url,html.decode('gbk'))

if len(urllist)!=0:

print(urllist\[0\])

if urllist\[0\].index('http:')<0:

urllist\[0\]='http:'+urllist\[0\]

htmlbefore = getHtml(urllist\[0\])

\# print(htmlbefore)

numberlist = getNumber(htmlbefore)

print(len(numberlist))

RecodeToOracle(numberlist)

print(numberlist)

Geturl(htmlbefore)

else:

return

str1 = '网站地址'

html1 = getHtml(str1)

RecodeToOracle(getNumber(html1))

Geturl(html1)

\---------------------

作者：浅颜半夏

来源：CSDN

原文：https://blog.csdn.net/xiazhipeng1000/article/details/78987036

python3 oracle数据库操作_python 操作Oracle数据库

发表评论取消回复

还没有评论，来说两句吧...

相关阅读

相关 Python3操作MySQL数据库

相关 Python SQLite3数据库操作

相关 python3 oracle数据库操作_python 操作Oracle数据库

相关 oracle mysql操作_oracle数据库操作记录

相关 python3 MongoDB数据库操作

相关 python3 MySQL数据库操作

相关 python对Oracle数据库的操作

相关 Python3 操作MongoDB数据库

相关 Python3操作MySQL数据库

相关 Python3 MySQL数据库操作