python通过参数方式向mysql中添加数据，pythonmysql,#!/usr/bin/p

python通过参数方式向mysql中添加数据，pythonmysql,#!/usr/bin/p

#!/usr/bin/pythonimport MySQLdb# Open database connectiondb = MySQLdb.connect("localhost","testuser","test123","TESTDB" )# prepare a cursor object using cursor() methodcursor = db.cursor()# Prepare SQL query to INSERT a record into the database.sql = "INSERT INTO EMPLOYEE(FIRST_NAME, \       LAST_NAME, AGE, SEX, INCOME) \       VALUES ('%s', '%s', '%d', '%c', '%d' )" % \       ('Mac', 'Mohan', 20, 'M', 2000)try:   # Execute the SQL command   cursor.execute(sql)   # Commit your changes in the database   db.commit()except:   # Rollback in case there is any error   db.rollback()# disconnect from serverdb.close()