sqlite3的常见操作

# -*- coding=utf-8 -*-
import sqlite3


def create_table():
    connect = sqlite3.connect('./data.db')
    cursor = connect.cursor()
    # 数据类型 TEXT -> 文本
    # REAL -> 类似浮点数
    # BIT ->
    sql = "CREATE TABLE IF NOT EXISTS data(username TEXT, password BIT)"
    cursor.execute(sql)
    connect.commit()
    connect.close()


def insert_tabel(username, password):
    connect = sqlite3.connect('./data.db')
    cursor = connect.cursor()
    sql = 'INSERT INTO data (username, password) VALUES(?, ?)'
    cursor.execute(sql, (username, password))
    connect.commit()
    connect.close()


def read_tabel():
    connect = sqlite3.connect('./data.db')
    cursor = connect.cursor()
    s3 = 'SELECT * FROM data LIMIT 2'  # 可以限制
    s4 = 'SELECT * FROM data'

    sql = 'SELECT * FROM data WHERE username="admin"'
    # 多个条件
    s = "SELECT * FROM data WHERE username='admin' AND password='password'"
    # 改变顺序
    s2 = "SELECT password, username FROM data WHERE username ='admin' AND password='password'"
    result = cursor.execute(s4)
    data = result.fetchall()
    connect.commit()
    connect.close()
    print(data)


def update_tabel():
    connect = sqlite3.connect('./data.db')
    cursor = connect.cursor()
    sql = 'UPDATE data SET username = "Cyberist" WHERE password="password" '
    cursor.execute(sql)
    connect.commit()
    connect.close()


def delete_table(username):
    connect = sqlite3.connect('./data.db')
    cursor = connect.cursor()
    sql = 'DELETE FROM data WHERE  username="Cyberist" '
    cursor.execute(sql)
    connect.commit()
    connect.close()


if __name__ == '__main__':
    create_table()
    insert_tabel('admin', 'password')
    insert_tabel('What', 'hello')
    read_tabel()
    update_tabel()
    delete_table('admin')
    read_tabel()

以后终于可以将数据保存到数据库中间了