首页 文章

Python GUI登录数据库

提问于
浏览
0

我在python登录表单中遇到有关数据库的问题 . 我无法通过 SQL 查询获取数据我导入sqlite3

  • 创建表列,用户名和密码

  • 成功将值插入表中

  • 当我获取它时会给我一个语法错误

d1 = c1.execute("Select username form table where username = variable")

它在我在上面的查询中使用 username = 'Abhishek' 时有效 .

1 回答

  • 0

    试试这样:

    #import sqlite3 module
    import sqlite3
    
    #Db connection
    db = sqlite3.connect('database.db')
    cursor = db.cursor()
    
    #Create table
    cursor.execute(
                '''
                CREATE TABLE IF NOT EXISTS username (
                id INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT,
                name TEXT NOT NULL,
                age TEXT NOT NULL,
                phone TEXT);
                '''
            )
    
     #Insert your name
     cursor.execute(
            '''
            INSERT INTO username (name, age, phone)
            VALUES ("Abhishek", "18", "+123456789")
            '''
        )
    
    
    #Commit previous table creation
    db.commit()
    
    #Select all from username table where name column is like 'Abhishek'
    myname = 'Abhishek'
    sql = f"SELECT * FROM username WHERE name='{myname}'"
    #Alternative you can prepare sql like this, attention in quotes('var') aroud myname variable
    sql = "SELECT * FROM username WHERE name='{}'".format(myname)
    cursor.execute(sql)
    #Get all results
    result = cursor.fetchall()
    for i in result:
        print(i)
    

相关问题