Python批量插入数据

Python批量插入数据到mysql中，相较于jdbc，简化了长度。

占位符使用的%s而不是?

import mysql.connector as conn

def __getConn():
    db = conn.connect(
        host="localhost",
        user="root",
        passwd="root",
        database="test"
    )
    return db


def insertBatch(db):
    cur = db.cursor()
    # 不需要像jdbc那样在value后面写多个
    sql = "insert into t_dict2 (parent_code,code) values (%s,%s)"
    val = [("zhangsan11","test11"),("zhangsan21","test21"),("zhangsan31","test31")]
    cur.executemany(sql, val)
    pass


if __name__ == "__main__":
    db = __getConn()
    insertBatch(db)
    db.commit()