Python连接MYSQL

导入pymysql，
PyMySQL是在 Python3.x 版本中用于连接 MySQL 服务器的一个库。

Python操作MYSQL数据库的增删改查

1. 单条数据添加

import pymysql
#连接MYSQL
conn = pymysql.connect(host='localhost',port=3306,user='root',password='12345678',db='demo') 
#建立游标操作
cur = conn.cursor()
#调用游标函数执行操作
cur.execute("insert into stud(name,age,NameID) values('ssssaaaa',21,'dada21')")
conn.commit()
# 关闭游标
# cur.close()
# #关闭连接
# conn.close()

2. 多条数据添加

import pymysql
conn = pymysql.connect(host='localhost',port=3306,user='root',password='12345678',db='demo') 
cur = conn.cursor()
#cur.executemany(query,arg)
#先建立一个插入语句
sql_insert = 'insert into stud(name,age,NameID) values(%s,%s,%s)'
#插入的数据集（列表）
list_insert = [('dadada',31,'dasdwwe3r'),('dsadasdasc',22,'dsadaca22112'),('dsadac',12,'dsa1213')]
cur.executemany(sql_insert,list_insert)
conn.commit()
cur.close()

import pymysql

insert_query_1='insert into stud (name,age,NameID) values(%s,%s,%s)'
list_insert_1=[('dadada',31,'dasdwwe3r'),('dsadasdasc',22,'dsadaca22112'),('dsadac',12,'dsa1213')]

class PYSQL(object):
    #类方法，连接MYSQL数据库，建立游标操作
    def __init__(self,dbname):
        self.dbname = dbname
        self.conn = pymysql.connect(
        host='localhost',port=3306,user='root',
        passwd='12345678',db='{}'.format(self.dbname),charset='utf8')
        
    #实例方法，插入数据操作，关闭游标    
    def cur_insert(self,insert_query,insert_list):
        cur = self.conn.cursor()
        try:
            cur.executemany(insert_query,insert_list)
            self.conn.commit()
        except:
            self.conn.rollback()
            traceback.print_exc()
        finally:
            cur.close()
                        
M = PYSQL('demo')
M.cur_insert(insert_query_1,list_insert_1)