如何在QlineEdit pyqt4 python中显示数据库中的值

from PyQt4.QtGui import QApplication, QLineEdit
from PyQt4.QtSql import QSqlDatabase, QSqlQuery

db = QSqlDatabase.addDatabase("QSQLITE")
db.setDatabaseName("your_database_name.db")
if not db.open():
    print("Failed to connect to database.")
    exit(1)

query = QSqlQuery()
query.exec_("SELECT column_name FROM table_name WHERE condition")

line_edit = QLineEdit()
if query.next():
    value = query.value(0)
    line_edit.setText(str(value))

app = QApplication([])
line_edit.show()
app.exec_()