1.mysql连接:
import pymysql
if __name__=='__main__':
conn=pymysql.connect(
host='localhost',
user='root',
password='shuo123456',
database='china',
port=3306,
charset='utf8'
)
# 连接数据库
cursor=conn.cursor()
# sql语句
sql=''
# 执行sql语句
cursor.execute(sql)
# 提交
conn.commit()
# 关闭连接
conn.close()
2.redis连接:
import redis
client=redis.StrictRedis(
host='localhost',#本机id
port=6379,#端口
db=6,#表示redis下的几号数据库0-15(默认0)
password='shuo123456'#自己设置的密码
)
ret=client.set('name','bill')
client.hset('p1','name','xiaoming')
client.lpush('mlist','2222')
client.sadd('mset','235433')
3.mogodb连接:
import pymongo
# 建立连接
conn=pymongo.MongoClient(
host='localhost',port=27017
)
db=conn.mydb
db.teacher.update()
ret=db.teacher.find()
print(ret,type(ret))
for i in ret:
print(i)
conn.close()
pass