Example #1
0
 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());
   }
 }
Example #2
0
 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; // 返回查询集合
 }