数据库--查询

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

# 1.连接数据库文件

connect = sqlite3.connect('datebase.db')

# 2.获取游标

cursor = connect.cursor()

# 3.准备sql语句
# *表示查询所有字段，可以查询指定字段数据
# N%查找以N开头的  %N查找以N结尾的 %N% 包含N的
# _表示一个字符

# sql = "SELECT name,id,age FROM Student WHERE name LIKE '张%'"
# sql = "SELECT name,id,age FROM Student WHERE name LIKE '张_'"

# ASC 升序 DESC降序

 sql = "SELECT * FROM Student order by age DESC"

sql = 'SELECT COUNT(*) From Student'

# 4.执行sql语句，接收查询结果

rs = cursor.execute(sql)
# for循环遍历查询结果
for x in rs:
    print(x)

完整代码：

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

import sqlite3
# 1.连接数据库文件
connect = sqlite3.connect('datebase.db')
# 2.获取游标
cursor = connect.cursor()
# 3.准备sql语句
# *表示查询所有字段，可以查询指定字段数据
# N%查找以N开头的  %N查找以N结尾的 %N% 包含N的
# _表示一个字符
# sql = "SELECT name,id,age FROM Student WHERE name LIKE '张%'"
# sql = "SELECT name,id,age FROM Student WHERE name LIKE '张_'"

# ASC 升序 DESC降序
# sql = "SELECT * FROM Student order by age DESC"

sql = 'SELECT COUNT(*) From Student'
# 4.执行sql语句，接收查询结果
rs = cursor.execute(sql)
# for循环遍历查询结果
for x in rs:
    print(x)

执行结果：

(6,)