python操作数据库，批量插入数据库数据

#coding=utf8
from pymysql import connect,cursors
from pymysql.err import  OperationalError
import sys,time


class DataBase():   #类名和模块名一致，robot导入时不用写类名@@@@@
    def __init__(self,mysql_name):
        try:
            self.conn = connect(host='123.。。。',
                                port=3306,
                                user='mys。。。',
                                password='。。。',
                                db=mysql_name,
                                charset ='utf8mb4',
                                cursorclass = cursors.DictCursor
                                )

        except OperationalError as e:
            print e

    #查询数据库
    def select(self,table_name):

        #sql语句之间应该有空格
        sql = 'select * from '+table_name+';'
       cursor = self.conn.cursor()   #创建游标

        cursor.execute(sql) #执行sql
        self.conn.commit() #提交

        #将查询的数据打印出来
        results = cursor.fetchall()
        for row in results:
            print row

    #批量插入数据
    def insert_inspection_list(self,table_name):

        for i in range(1,100):

            id = str(i)
            inspection_num = 'NJ'+ str(100000+i)
            car_id =  i+1
            
            create_time = time.strftime('%Y-%m-%d %H:%M:%S',time.localtime())
            update_time = time.strftime('%Y-%m-%d %H:%M:%S',time.localtime())

            #@@@@@字符串用双引号加单引号"''",三种sql语句
            sql1 = 'insert into car (id,inspection_num,car_id, create_uid) values 

('+id+',"' + inspection_num + '",' + car_id + ',238);           
           

           sql2 = 'insert into car (id,inspection_num,car_id,create_uid，create_time,

update_time)values({},{},{},{},{},{})'.format(id,inspection_num,car_id,238,create_time,

update_time)

           sql3 = 'insert into car (id,inspection_num,car_id,create_uid，create_time,

update_time)values (%s,%s,%d,%s,%s,%s)' % (id, inspection_num, car_id, 238, create_time,

 update_time)

            print sql

            cursor = self.conn.cursor()

            cursor.execute(sql)
            self.conn.commit()


    # 关闭数据库
    def close(self):
        self.conn.close()

if  __name__ == '__main__':
    tb = DataBase('manager')
    tb.insert_inspection_list('inspection_list')