python3使用SQLite插入操作，插入信息由键盘输入时，如何定义values()

[oblivion1234]

主要代码为：

self.lineEdit.setText("")
self.lineEdit_2.setText("")

register_keyword = self.lineEdit_2.text()
register_user = self.lineEdit.text()

conn = sqlite3.connect('test.db')
c = conn.cursor()
print("Opened database successfully");
c.execute("insert into user(id, keyword)\
values(?, ?)"\
('register_user', 'register_keyword'));
conn.commit()
print("Records created successfully");

cursor = conn.execute("select id, keyword from user")
for row in cursor:
print("id = ", row[0])
print("keyword = ", row[1])
print("Operation done successfully");

values()函数内容改了好几次，目前这个报错在这一行，typeerror: 'str' object is not callable.

[tianfang]

excute参数是sql，直接把值写进value的括号中就是了 insert into user(id, keyword) values ('register_user', 'register_keyword')

[oblivion1234]

引用 1 楼 tianfang 的回复:

excute参数是sql，直接把值写进value的括号中就是了 insert into user(id, keyword) values ('register_user', 'register_keyword')

我试过了，程序会识别为插入这两个字符串，键盘输入的文本完全没有作用。 最后插入记录为： id = register_user keyword = register_keyword.