#!/usr/bin/python # -*- coding: UTF-8 -*- # pip install MySQL-python import MySQLdb, os try: conn = MySQLdb.connect(host='172.17.42.1', user='数据库访问用户', passwd='数据库访问密码', db='数据库名', port=3306) cur = conn.cursor() cur.execute('SELECT `id`, `name`, `path`, FROM `doc_file`') # 获取全部记录 results=cur.fetchall() for r in results: id, name, path = r[0], r[1], r[2] if path and not os.path.exists(path): print 'file not exist: ', id, name, path, flashpath cur.close() conn.close() except MySQLdb.Error,e: print "Mysql Error %d: %s" % (e.args[0], e.args[1])