Python_用pymysql与数据库创建连接

# Author : Xuefeng
import pymysql

# create the conn
# 连接本机localhost，用户名为root，密码为123456，用到的数据库为mysql
conn = pymysql.connect(host="localhost", user="root", passwd="123456",db="mysql")

# create the cursor
cursor = conn.cursor()

# execute the SQL, and return the columns for change
effect_row = cursor.execute("select * from student")

# fstch the result one by one
print(cursor.fetchone())
# fetch all result
print(cursor.fetchall())

data = {
    ("N1", 22, "F"),
    ("N2", 22, "F"),
    ("N3", 22, "F")
}

cursor.executemany("insert into student (name,age,gender) values(%s,%s,%s)", data)
conn.commit()

print(cursor.fetchall())

cursor.close()
conn.close()

上面的程序，首先与数据库创建连接，
然后查看数据库中student 表单的内容，
之后，向student表单中插入数据并提交，
最后在查看表单中的所有数据并关闭连接。