pythonpymysql操作数据库一、下载pymysql1dos命令下下载pip install pymysql2pycharm 中setting点击解释器点击“”下载输入下载pymysql选择版本install下载二、pymysql连接1vmware中打开服务器安装数据库开启数据库关闭防火墙2pymysql.connect如Connect connect Connection connections.Connection连接方式3连接参数ljpymysql.connect(host, 主机 ip地址 如192.168.150.128user, 用户名 如rootpasswd 或password 密码123456database 或db, 库名 如hhport, 端口号 3306charsetutf-8 编码字符utf-8)4创建游标通过游标执行sql语句,并查看语句的内容有三种a.fetchone() 查询一行数据b.fetchmany(行数)查询一行数据c.fetchall()查询所有的数据import pymysqlljpymysql.connect(host192.168.150.128,userroot,passwd123456,databasehh,port3306,charsetutf8)yblj.cursor() #创建游标yb.execute(select * from dept) #执行sql语句# print(yb.fetchone()) #fetchone()查询一行数据# print(yb.fetchmany(2)) #fetmany# 查询指定行数据print(yb.fetchall()) #fetchall() 查询所有的数据三、pymysql的运用1、查询import pymysqlljpymysql.connect(host192.168.150.128,userroot,passwd123456,databasehh,port3306,charsetutf8)yblj.cursor() #创建游标yb.execute(select * from dept) #执行sql语句print(yb.fetchone()) #fetchone()查询一行数据2、删除语句import pymysqlljpymysql.connect(host192.168.150.128,userroot,passwd123456,databasehh,port3306,charsetutf8)yblj.cursor() #创建游标yb.execute(delete from dept where dept1101) #执行sql语句3、插入数据import pymysqlljpymysql.connect(host192.168.150.128,userroot,passwd123456,databasehh,port3306,charsetutf8)yblj.cursor() #创建游标yb.execute(insert into dept values(101,xiaoshou)) #执行sql语句4、改数据import pymysqlljpymysql.connect(host192.168.150.128,userroot,passwd123456,databasehh,port3306,charsetutf8)yblj.cursor() #创建游标yb.execute(update dept set dept_namexs where dept1101) #执行sql语句四、封装查询语句三种方方式import pymysqlclass Dcs_mysql():def __init__(self,host,user,passwd,database,port):self.hosthostself.useruserself.passwdpasswdself.databasedatabaseself.portportdef lj(self):ljdxpymysql.connect(hostself.host,userself.user,passwdself.passwd,database self.database,portself.port,charsetutf8 )self.ybljdx.cursor()def one(self,mysql): # 查询一行数据self.yb.execute(mysql)print(self.yb.fetchone())def many(self,mysql,x): #查询指定行数数据self.yb.execute(mysql)print(self.yb.fetchmany(x))def all(self,mysql): #查询所有的数据self.yb.execute(mysql)print(self.yb.fetchall())if __name__ __main__:dxDcs_mysql(host192.168.150.128,userroot,passwd123456,databasehh,port3306)dx.lj()# dx.one(select * from dept)# dx.many(select * from dept,3)dx.all(select * from dept)