echo -n 'input student no: '
read no
echo $no
grep $no scores.csv
echo -n 'input course no(c[3],pytho[4],ds[5]): '//因为原表中为 学号 姓名 c成绩 py成绩
ds成绩
read col//读取想要的课程
echo $col
grep $no scores.csv | awk -F ',' -v n=$col '{print $n}' | sed 's/\"//g'//打印no学
号的col成绩并去双引号
showMenu() {
clear
echo -e "\t[1] 查询学生成绩"
echo -e "\t[2] 添加学生成绩"
echo -e "\t[3] 修改学生成绩"
echo -e "\t[4] 删除学生成绩"
echo -e "\t[0] 退出\n"
echo -ne "\t请输入操作编号："; read menu
}
showMenu
while [ $menu -eq $menu ];
do
case $menu in
1) # 查询学生成绩
echo -ne "\n请输入学生编号："; read no
echo -ne '[3] c\n[4] python\n[5] ds\n请输入课程编号：'; read col
grep $no scores.csv | sed 's/\"//g' | awk -F ',' -v n=$col '{print $n}' |
xargs -I{} echo 'score:' {}
echo -n '按任意键继续...'; read
showMenu
;;
2) # 添加学生成绩
echo -e "\n输入格式：\"学号\",\"姓名\",\"c-score\",\"python-score\",\"ds-
score\""
read row
echo $row >> scores.csv
echo -n '按任意键继续...'; read
showMenu
;;
3) # 修改学生成绩
echo -ne "\n请输入学生编号："; read no
