pymysql和数据库建立连接
创建一个表:
导入模块
import pymysql
建立连接
coon=pymysql.connet("127.0.0.1","root(用户名)","19930309ss(密码)","shcool(数据库名字)")
得到curcor对象
mycursor=coon.cursor()
执行sql语句
sqlstr="
create table text(
id int primary key auto_increment,
name varchar(20) not null,
sex char(5)
)
"
使用execute方法执行sql语句
mycursor.execute(sqlstr)
获取执行结果 如果是增删改的话就要改成commit()提交
mycursor.fetchaone()
关闭
mycursor.close()
增删改能写成一个函数然后传递参数进去
每次需要的时候就调用函数吧吧sql语句作为函数传进去
def table(sqlstr):
coon = pymysql.connect("127.0.0.1", "root", "19930309ss", "shcool", charset="utf8")
# 得到sursor对象
mysursor = coon.cursor()
try:
print(mysursor.execute(sqlstr))
coon.commit()
except:
print("失败")
coon.rollback()
coon.close()
sqlstr='''
update svs_user set Uname="曙光" where uid=9
'''
table(sqlstr)
用类方法查询数据库:
def getcoon():
coon = pymysql.connect("127.0.0.1", "root", "19930309ss", "shcool", charset="utf8")
mysursor = coon.cursor()
return [coon,mysursor]
class Text():
def __init__(self,id=None,name=None,pw=None):
self.id=id
self.name=name
self.pw=pw
def __str__(self):
return "姓名:"+self.name+"id:"+str(self.id)+"密码"+self.pw
def selecttable():
list=[]
conn=getcoon()
str='''select uid,uname,upassword from svs_user'''
conn[1].execute(str)
ss=conn[1].fetchall()
for i in ss:
text=Text(i[0],i[1],i[2])
list.append(text)
conn[0].close()
return list
m1=selecttable()
for j in m1:
print(j)
创建一个表:
导入模块
import pymysql
建立连接
coon=pymysql.connet("127.0.0.1","root(用户名)","19930309ss(密码)","shcool(数据库名字)")
得到curcor对象
mycursor=coon.cursor()
执行sql语句
sqlstr="
create table text(
id int primary key auto_increment,
name varchar(20) not null,
sex char(5)
)
"
使用execute方法执行sql语句
mycursor.execute(sqlstr)
获取执行结果 如果是增删改的话就要改成commit()提交
mycursor.fetchaone()
关闭
mycursor.close()
增删改能写成一个函数然后传递参数进去
每次需要的时候就调用函数吧吧sql语句作为函数传进去
def table(sqlstr):
coon = pymysql.connect("127.0.0.1", "root", "19930309ss", "shcool", charset="utf8")
# 得到sursor对象
mysursor = coon.cursor()
try:
print(mysursor.execute(sqlstr))
coon.commit()
except:
print("失败")
coon.rollback()
coon.close()
sqlstr='''
update svs_user set Uname="曙光" where uid=9
'''
table(sqlstr)
用类方法查询数据库:
def getcoon():
coon = pymysql.connect("127.0.0.1", "root", "19930309ss", "shcool", charset="utf8")
mysursor = coon.cursor()
return [coon,mysursor]
class Text():
def __init__(self,id=None,name=None,pw=None):
self.id=id
self.name=name
self.pw=pw
def __str__(self):
return "姓名:"+self.name+"id:"+str(self.id)+"密码"+self.pw
def selecttable():
list=[]
conn=getcoon()
str='''select uid,uname,upassword from svs_user'''
conn[1].execute(str)
ss=conn[1].fetchall()
for i in ss:
text=Text(i[0],i[1],i[2])
list.append(text)
conn[0].close()
return list
m1=selecttable()
for j in m1:
print(j)