清华大佬耗费三个月吐血整理的几百G的资源,免费分享!....>>>
这段代码通过MySQLdb模块连接mysql数据库,然后查询employee表中income字段大于1000的数据输出
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 | #!/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() |