就业数据资源平台
当前位置:首页 > 数据库技术
2012年计算机三级数据库技术上机指导:考试内容(4)

 分析:根据题意分析得出:本题主要考查考生的运用数组和排序的能力,要求考生仅编写函数jsSort实现此功能。其中输出函数给出且已调用,考生不必自己编写。

  编写函数jsSort的程序如下:


  void jsSort()


  {


  int i, j, m ;


  for(i=0 ; i<199 ; i++)


  for(j=i + 1 ; j<200 ; j++) {


  if((aa[i] % 1000)>(aa[j] % 1000)) {


  m=aa[i] ;


  aa[i]=aa[j] ;


  aa[j]=m ;


  }


  else if((aa[i] % 1000)= =(aa[j] % 1000)) {


  if(aa[i]


  m=aa[i] ;


  aa[i]=aa[j] ;


  aa[j]=m ;


  }


  }


  }


  for(i=0 ; i<10 ; i++) bb[i]=aa[i] ;


  }


  数据文件IN.DAT内容如下:


  1862,8281,6183,5180,1217


  8215,8865,7110,1870,4373


  7447,8420,8252,8809,7968


  7331,3472,4126,8101,5576


  7397,2066,5940,9779,7947


  2912,1226,2238,4122,6210


  2020,3721,1646,8324,2351


  2345,1862,5186,7573,8949


  3211,2103,6695,7968,6157


  9956,2998,4063,6096,9432


  6452,2422,1382,5813,8138


  7486,1178,7650,1687,5012


  4845,1428,3197,6077,4650


  6641,2695,5758,8855,5321


  1337,5323,9154,6419,8044


  3654,2246,1890,3250,5542


  1976,5986,5051,8053,7377


  3726,6189,9483,5874,9246


  2522,1020,3492,4032,4367


  9784,4746,3130,8521,7837


  6521,7917,6240,1225,4092


  8022,6893,2075,8043,7409


  3316,5688,4600,6016,2953


  6206,4100,8947,6264,1986


  4933,6105,7054,9121,5318


  3164,9609,5784,4178,4906


  3731,2996,4218,3498,3849


  3835,5491,3890,3531,1475


  8219,3720,8585,9616,6539


  4961,8850,5822,2769,1269


  2171,2104,3681,9291,5768


  3582,3035,7212,8313,5669


  4782,7545,7917,8561,5447


  4912,7624,1343,8579,5639


  5745,1833,7948,4321,3090


  9389,2796,8073,7806,4910


  7970,2808,8109,8664,5963


  3660,1396,1380,5705,7269


  7417,5590,2823,6308,1754


  5467,8126,9822,6737,1023


  结果文件OUT.DAT的内容如下:


  5012


  6016


  2020


  1020


  8022


  1023


  4032


  3035


  8043


  8044

就业数据资源平台