創(chuàng)建數(shù)據(jù)庫

            
              import sqlite3

# 連接數(shù)據(jù)庫(如果不存在則創(chuàng)建)
conn = sqlite3.connect('test.db')
print("Opened database successfully")

# 創(chuàng)建游標(biāo)
c = conn.cursor()

# SQL語句
sql = """
        CREATE TABLE STUDENTS(
            ID INT PRIMARY KEY NOT NULL,
            NAME TEXT NOT NULL,
            AGE INT NOT NULL,
            ADDRESS CHAR(50)
        );
    """
# 創(chuàng)建表
c.execute(sql)

print("Table created successfully")

# 關(guān)閉游標(biāo)
c.close()

# 提交事物
conn.commit()

# 關(guān)閉連接
conn.close()
            
          

插入數(shù)據(jù)

            
              import sqlite3

# 連接數(shù)據(jù)庫(如果不存在則創(chuàng)建)
conn = sqlite3.connect('test.db')
print("Opened database successfully")

# 創(chuàng)建游標(biāo)
c = conn.cursor()

# 插入數(shù)據(jù)
c.execute("INSERT INTO STUDENTS (ID,NAME,AGE,ADDRESS) VALUES (0, 'Paul', 32, 'California')")
c.execute("INSERT INTO STUDENTS (ID,NAME,AGE,ADDRESS) VALUES (0, 'Allen', 25, 'Texas')")
c.execute("INSERT INTO STUDENTS (ID,NAME,AGE,ADDRESS) VALUES (0, 'Teddy', 23, 'Norway')")
c.execute("INSERT INTO STUDENTS (ID,NAME,AGE,ADDRESS) VALUES (0, 'Mark', 25, 'Rich-Mond')")

print("Records created successfully")

# 關(guān)閉游標(biāo)
c.close()

# 提交事物
conn.commit()

# 關(guān)閉連接
conn.close()
            
          

刪除數(shù)據(jù)

            
              import sqlite3

# 連接數(shù)據(jù)庫(如果不存在則創(chuàng)建)
conn = sqlite3.connect('test.db')
print("Opened database successfully")

# 創(chuàng)建游標(biāo)
c = conn.cursor()

# 刪除數(shù)據(jù)
c.execute("DELETE FROM STUDENTS WHERE ID=2;")

# 關(guān)閉游標(biāo)
c.close()

# 提交事物
conn.commit()

print("Total number of rows deleted :", conn.total_changes)

print("Operation done successfully")

# 關(guān)閉連接
conn.close()
            
          

修改數(shù)據(jù)

            
              import sqlite3

# 連接數(shù)據(jù)庫(如果不存在則創(chuàng)建)
conn = sqlite3.connect('test.db')
print("Opened database successfully")

# 創(chuàng)建游標(biāo)
c = conn.cursor()

# 修改數(shù)據(jù)
c.execute("UPDATE STUDENTS SET age = 25 WHERE ID=1")

# 關(guān)閉游標(biāo)
c.close()

# 提交事物
conn.commit()

print("Total number of rows updated :", conn.total_changes)

print("Operation done successfully")

# 關(guān)閉連接
conn.close()
            
          

查找數(shù)據(jù)

            
              import sqlite3

# 連接數(shù)據(jù)庫(如果不存在則創(chuàng)建)
conn = sqlite3.connect('test.db')
print("Opened database successfully")

# 創(chuàng)建游標(biāo)
c = conn.cursor()

# 查找數(shù)據(jù)
cursor = c.execute("SELECT id, name, age, address FROM STUDENTS")
for i in cursor:
    print('id:', i[0])
    print('name:', i[1])
    print('age:', i[2])

# 關(guān)閉游標(biāo)
c.close()

print("Operation done successfully")

# 關(guān)閉連接
conn.close()