sql = 'INSERT INTO course(class_name, credit, properties, teacher_name, college_given, classroom) ' \
'VALUES ("%s", "%d", "%s", "%s", "%s", "%s")' % \
(class_name, credit, properties, teacher_name, college_given, classroom)
cursor.execute(sql)
conn.commit()