#!/usr/bin/env python3
import sqlite3

def clear_asrenddt(rowid):
    """将指定记录的 asrenddt 设置为空"""
    conn = sqlite3.connect(r'\\ll\D\xtrssvjj\db\dpd.db')
    try:
        cursor = conn.execute('UPDATE ads SET asrenddt ="" WHERE rowid = ?', (rowid,))
        conn.commit()
        print(f'已成功将 rowid={rowid} 的 asrenddt 设置为空，受影响行数: {cursor.rowcount}')
    except Exception as e:
        print(f'操作失败: {e}')
        conn.rollback()
    finally:
        conn.close()

if __name__ == '__main__':
    clear_asrenddt(281763)