第2个回答 2009-11-20
假设数据来源数据库:
student表:
number name class score
=》实体类 Student
取出所有:Map<Integer,Student>
1. select * from student where number=?
2. select score,number from student where score=(select min(score) from student)
select score,number from student where score=(select max(score) from student)
3. select avg(score) from student