python连接数据库:
import MySQLdb
DATABASE = {
'HOST' : '127.0.0.1',
'DATABASE' : '数据库名字',
'user' : 'root',
'password' : 'mima',
'charset' : 'utf8mb4'
}
db=MySQLdb.connect(host='localhost',user='root',password='mima',db='数据库名字')
#等价于
db = MySQLdb.connect(**DATABASE)
#db就代表数据库
一些操作:
查询
cursor = db.cursor()
sql = "select * from class"
cursor.execute(sql) #执行sql语句
results = cursor.fetchall() #获取
for row in results:
print(row)
插入
sql = "insert into 'class'('name') values('高一5班');)"
cursor = db.sursor()
sursor.execute(sql)
db.commit() #提交给数据库
异常
try:
sql = "insert into 'class'('name') values('高一5班');)"
cursor = db.sursor()
sursor.execute(sql)
db.commit() #提交给数据库
except Exception as e:
print(e)
db.rollback()