FilesExpand file tree

 master

/

do_sqlite.py

Copy path

Blame

More file actions

Blame

More file actions

Latest commit

 

History

History

History

executable file

·

34 lines (31 loc) · 921 Bytes

 master

/

do_sqlite.py

Copy path

Top

File metadata and controls

• Code
• Blame

executable file

·

34 lines (31 loc) · 921 Bytes

Raw

Copy raw file

Download raw file

Open symbols panel

Edit and raw actions

1

2

3

4

5

6

7

8

9

10

11

12

13

14

15

16

17

18

19

20

21

22

23

24

25

26

27

28

29

30

31

32

33

34

#!/usr/bin/env python3

# -*- coding: utf-8 -*-

import sqlite3

# 连接到SQLite数据库

# 数据库文件是test.db

# 如果文件不存在，会自动在当前目录创建:

conn = sqlite3.connect('test.db')

# 创建一个Cursor:

cursor = conn.cursor()

# 执行一条SQL语句，创建user表:

cursor.execute('create table user (id varchar(20) primary key, name varchar(20))')

# 继续执行一条SQL语句，插入一条记录:

cursor.execute('insert into user (id, name) values (\'1\', \'Michael\')')

# 通过rowcount获得插入的行数:

print('rowcount =', cursor.rowcount)

# 关闭Cursor:

cursor.close()

# 提交事务:

conn.commit()

# 关闭Connection:

conn.close()

# 查询记录：

conn = sqlite3.connect('test.db')

cursor = conn.cursor()

# 执行查询语句:

cursor.execute('select * from user where id=?', '1')

# 获得查询结果集:

values = cursor.fetchall()

print(values)

cursor.close()

conn.close()