1,获取连接
self.con=pymysql.connect('localhost','root','123456','test',charset='utf8')
2,获取游标
cursor=self.con.cursor()
3.1,增删改
cursor.execute('insert into student values (1,"诸葛",18,"男")')
cursor.execute('delete from student where id=3')
cursor.execute('update student set sex="女" where id=2')
self.con.commit()
3.2,查询
cursor.execute('select * from student')
resultset =cursor.fetchall()
for item in resultset:
print(item)
4.关闭连接
self.con.close()
连接实例
import pymysql
class mysqlconnect():
def __init__(self):
self.con=pymysql.connect('localhost','root','123456','test',charset='utf8')
print(self.con)
def creattable(self):
try:
cursor=self.con.cursor()
cursor.execute('drop table if exists student')
cursor.execute('create table student (id int (4),name char(10),age int(4),sex char(2))')
self.con.commit()
except:
raise
finally:
self.con.close()
def insertdata(self):
try:
cursor=self.con.cursor()
cursor.execute('insert into student values (1,"诸葛",18,"男")')
cursor.execute('insert into student values (2,"赵云",20,"男")')
cursor.execute('insert into student values (3,"貂蝉",22,"女")')
self.con.commit()
except:
raise
finally:
self.con.close()
def deldata(self):
try:
cursor=self.con.cursor()
cursor.execute('delete from student where id=3')
self.con.commit()
except:
raise
finally:
self.con.close()
def upddata(self):
try:
cursor= self.con.cursor()
cursor.execute('update student set sex="女" where id=2')
self.con.commit()
except:
raise
finally:
self.con.close()
def selectdata(self):
try:
cursor= self.con.cursor()
cursor.execute('select * from student')
resultset =cursor.fetchall()
for item in resultset:
print(item)
except:
raise
finally:
self.con.close()
if __name__=='__main__':
mysqlcon=mysqlconnect()
# mysqlcon.creattable()
#mysqlcon.insertdata()
# mysqlcon.deldata()
# mysqlcon.upddata()
mysqlcon.selectdata()