如何在asp中用select case 语句表示不同分数档的评介

Question

比如
0 ~ ~ 60 不及格
60 ~ ~ 70 及格
70 ~ ~80 良好
80 ~ ~优秀

Answer 1

dim s as string 's为学生成绩分数情况
dim g as double 'g学生成绩
g=60
select g
case 0 to 59
s="不及格"
case 60 to 70
s="及格"
case 71 to 80
s="良好"
case else
s="优秀"
end select

Answer 2

g=60
temp=int((g-60)/10)
select temp
case 0
s="及格"
case 1
s="良好"
case 2
s="优秀"
case else
s="不及格"
end select

Answer 3

WHERE 分数 Between 0 And 60

0-60的区间