python 连接三大数据库

1. mysql 数据库连接

import pymysql

conn = pymysql.connect(host=127.0.0.1, port=3306, user=root, password=1234, db=数据库名称, autocommit=True)

cursor = conn.cursor()

# 添加语句
sql = ‘’‘insert into Z_SQL (record, title, sqldata) values ("%s","%s","%s") ‘’’ % (insert_record, inputtext, inputsqldata)
cursor.execute(sql)

# 删除语句
sql = 'DELETE FROM Z_SQL WHERE record =%s ’
cursor.execute(sql, delete_no)

# 查找
sql = ‘SELECT* FROM Z_SQL’
cursor.execute(sql)
# 处理结果集
for line in cursor.fetchall():
print(line)

# 更新
sql = ‘’‘update Z_SQL set title ="%s",sqldata ="%s" where record ="%s" ‘’’ % (update_title, update_sqldata, update_no)
cursor.execute(sql)

2. Oracle 数据库连接

import cx_Oracle

conn=cx_Oracle.connect(user,password,ip+":"+port)
cursor=conn.cursor()

# 删除语句
sql = f’’‘DELETE FROM Z_SQL WHERE record =’{delete_no}’ ‘’’
cursor.execute(sql)

# 添加语句
sql = f’’’ INSERT INTO Z_SQL(record, title, sqldata) values (’{insert_record}’,’{inputtext}’,’{inputsqldata} ‘) ‘’’
cursor.execute(sql)

conn.commit()

# 更新
sql = f’’‘update Z_SQL set title =’ {update_title} ‘, sqldata =’ {update_sqldata} ’ where record =’{update_no}’ ‘’’
cursor.execute(sql)
conn.commit()

# 查找
sql = ‘SELECT* FROM Z_SQL’
cursor.execute(sql)
# 处理结果集
for line in cursor.fetchall():

3. Sqlserver 数据库连接

mport pymssql

conn=pymssql.connect(ip,user,password,db,autocommit=True)
cursor=conn.cursor()

# 添加语句
sql =’’‘insert into Z_SQL (record, title, sqldata) values (’%s’,’%s’,’%s’) ‘’’ % (insert_record, inputtext, inputsqldata)
cursor.execute(sql)

# 删除语句
sql = 'DELETE FROM Z_SQL WHERE record =%s ’
cursor.execute(sql, delete_no)

# 更新
sql = ‘’‘update Z_SQL set title =’%s’,sqldata =’%s’ where record =’%s’ ‘’’ % (update_title, update_sqldata, update_no)
cursor.execute(sql)

# 查找
sql = ‘SELECT* FROM Z_SQL’
cursor.execute(sql)

# 处理结果集
for line in cursor.fetchall():
print(line)

了解更多分析及数据抓取可查看：
http://cloud.yisurvey.com:9081/html/529942a8-212c-4c85-9c92-9c56beb4a299.html?ly=csdn
特别说明：本文旨在技术交流，请勿将涉及的技术用于非法用途，否则一切后果自负。如果您觉得我们侵犯了您的合法权益，请联系我们予以处理。