python mysql s_Python操作Mysql

import pymysql

import configparser

def login_mysql():

#获取配MySQL的用户置文件并连接

config=configparser.ConfigParser()

config.read('config.ini')

host=config.get('MYSQL','host')

port=config.get('MYSQL','port')

user = config.get('MYSQL', 'user')

password = config.get('MYSQL', 'password')

database = config.get('MYSQL', 'database')

db = pymysql.connect(host=host,port=int(port),user=user,password=password,database=database)

cursor=db.cursor()

#新建表51job

sql1='drop table if exists 51job'

sql2='''create table 51job(job_name varchar(50),company_name varchar(50),salary varchar(30),address varchar(50),experience varchar(30),level varchar(20),info varchar(9999),welfare varchar(999),url varchar(999))'''

try:

cursor.execute(sql1)

cursor.execute(sql2)

db.commit()

except Exception as e:

print(e)

db.rollback()

return db,cursor

写入数据

sql="insert into job_data values('%s','%s','%s','%s','%s','%s','%s','%s','%s')" %(job_name,company_name,salary,address,experience,level,job_info,welfare,href)

try:

cursor.execute(sql)

db.commit()

print('成功')

except Exception as e:

print(e)

db.rollback()

cursor.close()

db.close()版权声明：本文为原创文章，版权归 Helo 所有。

商业转载请联系作者获得授权，非商业转载请注明出处。