在django的模型中一般自定义的SQL语句,在执行查询后每条记录的结果以列表(list)表示,
如果要返回字典(dict)要设置cursorclass参数为MySQLdb.cursors.DictCursor类
设置方法:
1.cur = conn.cursor(cursorclass=MySQLdb.cursors.DictCursor)
2.在建立连接时指定,conn = MySQLdb.connect(host='192.168.1.103', port=3306, user='testacc', passwd='test1234', db='1dcq', cursorclass=MySQLdb.cursors.DictCursor)
例子:
cursor = connection.cursor() cursor.execute("select * from student") cursor.close() 结果: ('张三',12 , '化学一班')
db = MySQLdb.connect(host='localhost', user='root', passwd='123456',db='dev2',cursorclass=MySQLdb.cursors.DictCursor) cursor = db.cursor() cursor.execute("SELECT * from student") 结果: {'name':' 张三', 'age': 12, 'classname': '化学一班'}