import ;
import ;
import ;
import ;
import ;
import ;
import ;
import ;
/*1,读取文件
2,计算各学员平均分,将各学员信息按照平均分从高到低进行排序。
3,为每个学员的生成分数文件,文件名(学号_平均分排名.csv)
4,csv文件包含内容(学号、姓名、平均分、平均分排名、最高分课程)
*/
public class ScoreDemo {
public static void main(String[] args) {
BufferedReader bReader = null;
try {
bReader = new BufferedReader(new FileReader(new File("")));// 从csv文件中读取信息
String str = ();//第一列是表头信息要先读出来
List<Student> list = new ArrayList<>();// 数组列表只是定义了列表的形式,对象放前面,
while ((str = ()) != null) {
String[] strArr = (",");
Student student = new Student();
int i = 0;
(strArr[i++]);
(strArr[i++]);
((strArr[i++], 0));
((strArr[i++], 0));
((strArr[i++], 0));
(student);// 将学生信息存放在数组里面
}
(list, (Student s1, Student s2) -> {
if (() == ()) {
return 0;
} else if (() <= ()) {
return 1;
} else {
return -1;
}
});// 比较器比较这一块没写完会报错误,是系统的原因
for (int i = 0; i < (); i++) {
(i).setAvgSort(i + 1);
((i));
(i).restore();
}
} catch (Exception e) {
// TODO Auto-generated catch block
();
} finally {
(bReader);
}
}
}
import ;
import ;
import ;
import ;
import .;
public class Student {
private String sNo;
private String sName;
private int cScore;
private int javaScore;
private int cSharpScore;
private int avgSort;
@Override
public String toString() {
return "Student [sNo=" + sNo + ", sName=" + sName + ", cScore=" + cScore + ", javaScore=" + javaScore
+ ", cSharpScore=" + cSharpScore + ", avgSort=" + avgSort + "]";
}
public int getAvgSort() {
return avgSort;
}
public void setAvgSort(int avgSort) {
= avgSort;
}
public String getsNo() {
return sNo;
}
public void setsNo(String sNo) {
= sNo;
}
public String getsName() {
return sName;
}
public void setsName(String sName) {
= sName;
}
public int getcScore() {
return cScore;
}
public void setcScore(int cScore) {
= cScore;
}
public int getJavaScore() {
return javaScore;
}
public void setJavaScore(int javaScore) {
= javaScore;
}
public int getcSharpScore() {
return cSharpScore;
}
public void setcSharpScore(int cSharpScore) {
= cSharpScore;
}
// 平均分
public int getAvg() {
return (getcScore() + getJavaScore() + getcSharpScore()) / 3;
}
// 最高分科目
public String getMax() {
int max = (cSharpScore, (cScore, javaScore));
if (max == cSharpScore) {
return "c#";
} else if (max == javaScore) {
return "java";
} else {
return "c";
}
}
// 创建对应学生的文件
public void restore() {
StringBuffer fileName = new StringBuffer();
("D:/test/").append(getsNo()).append("_").append(getAvgSort()).append(".csv");
File file = new File(());
BufferedWriter bWriter = null;// bufferedWriter和bufferWrite要注意
try {
if (!()) {
();
}
bWriter = new BufferedWriter(new FileWriter(file));
(());
();
} catch (Exception e) {
// TODO Auto-generated catch block
();
}finally {
try {
();
} catch (IOException e) {
// TODO Auto-generated catch block
();
}
}
}
}