pymysql模块之增删改、在python中调用存储过程、视图、触发器、事务、存储过程、sql注入问题

pymysql模块

 首先安装pymysql模块：cmd窗口中输入pip3 install pymysql进行安装

import pymysql

client=pymysql.connect(   #发起连接(ip,port,user,password,database,charset)，拿到套接字对象
    host='127.0.0.1',
    port=3306,
    user='root',
    password='123',
    database='db10',
    charset='utf8'
)

cursor=client.cursor()    #产生游标

sql='inser into t1 values(1,"egon");'    #给一条sql语句提交给服务端执行
try:
    res=cursor.execute(sql)    #执行数据处理
    print(res)    #结果显示的是行数（记录条目数）
    #cursor.execute(sql1)    #执行
    #cursor.execute(sql2)    #执行
    #cursor.execute(sql3)    #执行
    client.commit()    #事务知识点，客户端提交sql语句，通过cursor实现
except Exception:
    client.rollback()    #如果执行游标途中出现，可进行回滚操作

cursor.close()    #关闭游标，等同于关闭cmd窗口中输入的quit,断开连接并关闭cmd窗口
client.close()    #关闭客户端连接

基于pymysql模块的增、删、改

增： 

import pymysql

client=pymysql.connect(
    host='127.0.0.1',
    port=3306,
    user='root',
    password='123',
    database='db4',
    charset='utf8'
)

cursor=client.cursor()

userinfo=[
    (9,"alex"),
    (10,"lxx"),
    (11,"yxx")
]

sql='insert into t1 values(%s,%s);'
cursor.executemany(sql,userinfo)

client.commit()

cursor.close()
client.close()

删： 

import pymysql

client=pymysql.connect(
    host='127.0.0.1',
    port=3306,
    user='root',
    password='123',
    database='db4',
    charset='utf8'
)

cursor=client.cursor()

cursor.execute('delete from t1 where id=3;')

client.commit()

cursor.close()
client.close()

改： 

import pymysql

client=pymysql.connect(
    host='127.0.0.1',
    port=3306,
    user='root',
    password='123',
    database='db4',
    charset='utf8'
)

cursor=client.cursor()

cursor.execute('update t1 set name="egon_dsb" where id=2;')

client.commit()

cursor.close()
client.close()

基于pymysql模块的查询

用户登陆功能：

import pymysql

client=pymysql.connect(
    host='127.0.0.1',