python练习题_20200813

1、现在有如下流程：A->B->C->D->E->F，要求根据输入的参数从制定的流程执行下去

# 现在有如下流程：A->B->C->D->E->F，要求根据输入的参数从制定的流程执行下去


def process_a():
    pass


def process_b():
    pass


def process_c():
    pass


def process_d():
    pass


def process_e():
    pass


def process_f():
    pass


if __name__ == '__main__':
    var = 1
    while var:
        print('请输入当前流程阶段（A,B,C,D,E,F）中的任意字符：')
        str_input = str(input())
        process_lst = ['A', 'B', 'C', 'D', 'E', 'F', 'a', 'b', 'c', 'e', 'f']
        if str_input not in process_lst:
            print('输入字符不合法，请重新输入！')
        else:
            str_input = str_input.upper()
            break
    if str_input == 'A':
        process_a()
        process_b()
        process_c()
        process_d()
        process_e()
        process_f()
        print('经过流程A->B->C->D->E->F后结束！')
    elif str_input == 'B':
        process_b()
        process_c()
        process_d()
        process_e()
        process_f()
        print('经过流程B->C->D->E->F后结束！')
    elif str_input == 'C':
        process_c()
        process_d()
        process_e()
        process_f()
        print('经过流程C->D->E->F后结束！')
    elif str_input == 'D':
        process_d()
        process_e()
        process_f()
        print('经过流程D->E->F后结束！')
    elif str_input == 'E':
        process_e()
        process_f()
        print('经过流程E->F后结束！')
    else:
        process_f()
        print('经过流程F后结束！')

运行结果：

2、数据库题目：数据库记录行转列

use zwjtest;
DROP TABLE IF EXISTS name_score;
CREATE TABLE name_score (
NAME VARCHAR(50) NOT NULL,
SUBJECT VARCHAR(50) NOT NULL,
SCORE INT NOT NULL)
DEFAULT CHARSET=utf8;
INSERT INTO name_score VALUES
('NICK','语文',80),
('NICK','数学',90),
('NICK','英语',70),
('NICK','生物',85),
('KENT','语文',80),
('KENT','数学',90),
('KENT','英语',70),
('KENT','生物',85);
SELECT 
NAME,
MAX(CASE `SUBJECT` WHEN '语文' THEN SCORE ELSE 0 END) AS '语文',
MAX(CASE `SUBJECT` WHEN '数学' THEN SCORE ELSE 0 END) AS '数学',
MAX(CASE `SUBJECT` WHEN '英语' THEN SCORE ELSE 0 END) AS '英语',
MAX(CASE `SUBJECT` WHEN '生物' THEN SCORE ELSE 0 END) AS '生物'
FROM name_score
GROUP BY NAME;

运行结果：