public static void main(String[] args) {
ResultUtil util = new ResultUtil();
List list = util.getGradeDesc();
System.out.println("将留学生表按音序排序：");
for (int i = 0; i < list.size(); i++) {
Abroad abrod = (Abroad) list.get(i); // 创建于学生成绩表对应的Grade对象
System.out.println(
"编号为："
+ abrod.getId()
+ " 名字为："
+ abrod.getName()
+ " 姓为："
+ abrod.getSurname()
+ " 国籍为："
+ abrod.getNationality());
}
}
public List getGradeDesc() {
List list = new ArrayList(); // 定义用于保存返回值的List集合
conn = getConn(); // 获取数据库连接
try {
Statement staement = conn.createStatement();
// 定义将图书表中信息进行排序的SQL语句
String sql = "select * from tb_abroad order by substring(name,1,1)";
ResultSet set = staement.executeQuery(sql); // 执行查询语句返回查询结果集
while (set.next()) { // 循环遍历查询结果集
Abroad abrod = new Abroad(); // 创建于学生成绩表对应的Grade对象
abrod.setId(set.getInt(1)); // 设置对象属性
abrod.setName(set.getString(2));
abrod.setSurname(set.getString(3));
abrod.setNationality(set.getString(4));
list.add(abrod);
}
} catch (Exception e) {
e.printStackTrace();
}
return list; // 返回查询集合
}
