这段代码通过MySQLdb模块连接mysql数据库,然后查询employee表中income字段大于1000的数据输出
- #!/usr/bin/python
- import MySQLdb
- # Open database connection
- db = MySQLdb.connect("localhost","testuser","test123","TESTDB" )
- # prepare a cursor object using cursor() method
- cursor = db.cursor()
- # Prepare SQL query to INSERT a record into the database.
- sql = "SELECT * FROM EMPLOYEE \
- WHERE INCOME > '%d'" % (1000)
- try:
- # Execute the SQL command
- cursor.execute(sql)
- # Fetch all the rows in a list of lists.
- results = cursor.fetchall()
- for row in results:
- fname = row[0]
- lname = row[1]
- age = row[2]
- sex = row[3]
- income = row[4]
- # Now print fetched result
- print "fname=%s,lname=%s,age=%d,sex=%s,income=%d" % \
- (fname, lname, age, sex, income )
- except:
- print "Error: unable to fecth data"
- # disconnect from server
- db.close()
来源: http://www.phpxs.com/code/1005087/