《JAVA 程序设计》实验报告学期:2016-2017-2
String sql="select id,name,frctionJava,fractionMath,fractionOS from
studentTbl";
Statement stmt;
try {
stmt = conn.createStatement();
ResultSet rs=stmt.executeQuery(sql);
List<Student> list=new ArrayList<Student>();
//遍历操作
while(rs.next()){
int id=rs.getInt(1);
String name=rs.getString(2);
double a=rs.getDouble(3);
double b=rs.getDouble(4);
double c=rs.getDouble(5);
Student u=new Student();
u.setId(id);
u.setName(name);
u.setFractionJava(a);
u.setFractionMath(b);
u.setFractionOS(c);
list.add(u);
}
Collections.sort(list,new Comparator<Student>()
{
public int compare(Student o1, Student o2)
{
int i = 1 ;
if(index==1)
{i= (int) (o2.getFractionJava()
o1.getFractionJava()); }
if(index==2){
i = (int) (o2.getFractionMath()
o1.getFractionMath());
}
if(index==3){
i = (int) (o2.getFractionOS()
o1.getFractionOS());
}
return i;
}
});
String s=listToString(list, '\n');
ta.setText(s);
-
-
-
7