PY数据库的连接

Mysql：

import MySQLdb
db = MySQLdb.connect("host", "userName", "password", database="erp_core", charset='utf8')
cursor = db.cursor()
sql = "select * from selection"
cursor.execute(sql)
num = cursor.fetchone()
print(num)
db.close()

MongoDb:

import pymongo

client = pymongo.MongoClient('dev.mongodb.i.sixi.com', 27017)
db = client.test
person = {
    "sex": "男",
    "age": 25
}
db.col.insert_one(person)  # 插入单个文档

# 打印集合第1条记录
print(db.col.find_one())