气密原始记录负压1 表格数据插入 SQL 语句

columns = ['序号', '试验编号', '检测日期', 'zfj10up1', '样品编号1', '样品编号2', '样品编号3', 'zfj10up2', 'zfj10up3', 'zfj10down1', 'zfj10down2', 'zfj10down3', 'zfj30up1', 'zfj30up2', 'zfj30up3', 'zfj30down1', 'zfj30down2', 'zfj30down3', 'zfj50up1', 'zfj50up2', 'zfj50up3', 'zfj50down1', 'zfj50down2', 'zfj50down3', 'zfj70up1', 'zfj70up2', 'zfj70up3', 'zfj70down1', 'zfj70down2', 'zfj70down3', 'zfj100up1', 'zfj100up2', 'zfj100up3', 'zfj100down1', 'zfj100down2', 'zfj100down3', 'zfj1501', 'zfj1502', 'zfj1503', 'zfj10avg1', 'zfj10avg2', 'zfj10avg3', 'zfj30avg1', 'zfj30avg2', 'zfj30avg3', 'zfj50avg1', 'zfj50avg2', 'zfj50avg3', 'zfj70avg1', 'zfj70avg2', 'zfj70avg3', 'zfj100avg1', 'zfj100avg2', 'zfj100avg3', 'zfj150avg1', 'zfj150avg2', 'zfj150avg3', 'zz10up1', 'zz10up2', 'zz10up3', 'zz10down1', 'zz10down2', 'zz10down3', 'zz30up1', 'zz30up2', 'zz30up3', 'zz30down1', 'zz30down2', 'zz30down3', 'zz50up1', 'zz50up2', 'zz50up3', 'zz50down1', 'zz50down2', 'zz50down3', 'zz70up1', 'zz70up2', 'zz70up3', 'zz70down1', 'zz70down2', 'zz70down3', 'zz100up1', 'zz100up2', 'zz100up3', 'zz100down1', 'zz100down2', 'zz100down3', 'zz1501', 'zz1502', 'zz1503', 'zz10avg1', 'zz10avg2', 'zz10avg3', 'zz30avg1', 'zz30avg2', 'zz30avg3', 'zz50avg1', 'zz50avg2', 'zz50avg3', 'zz70avg1', 'zz70avg2', 'zz70avg3', 'zz100avg1', 'zz100avg2', 'zz100avg3', 'zz150avg1', 'zz150avg2', 'zz150avg3', 'z10qt1', 'z10qt2', 'z10qt3', 'z30qt1', 'z30qt2', 'z30qt3', 'z50qt1', 'z50qt2', 'z50qt3', 'z70qt1', 'z70qt2', 'z70qt3', 'z100qt1', 'z100qt2', 'z100qt3', 'z150qt1', 'z150qt2', 'z150qt3', 'z10qp1', 'z10qp2', 'z10qp3', 'z30qp1', 'z30qp2', 'z30qp3', 'z50qp1', 'z50qp2', 'z50qp3', 'z70qp1', 'z70qp2', 'z70qp3', 'z100qp1', 'z100qp2', 'z100qp3', 'z150qp1', 'z150qp2', 'z150qp3', 'zq'1', 'zq11', 'zq21', 'zq'2', 'zq12', 'zq22', 'zq'3', 'zq13', 'zq23', '缝长', '面积', '气压1', '气压2', '气压3', '温度1', '温度2', '温度3', '正压缝长平均', '正压面积平均', '正压缝长等级', '正压面积等级', '检验类别']
placeholders = ['?' for _ in range(len(columns))]
sql = 'INSERT INTO 气密原始记录负压1 ({}) VALUES ({})'.format(', '.join(columns), ', '.join(placeholders))

cmd.CommandText = sql

该代码创建了一个名为 columns 的列表，其中包含所有列的名称，以及一个名为 placeholders 的列表，其中包含与列数量相同的问号。最后，它使用 format() 方法将这些列表组合成一个 SQL 插入语句，并将该语句赋值给 cmd.CommandText。

该代码将帮助您将数据插入到名为 '气密原始记录负压1' 的表格中。您需要将每个问号替换为相应的数据值。

请注意，cmd 是一个数据库连接对象，您需要在执行此代码之前对其进行初始化。