import java.io.BufferedReader;
import java.io.File;
import java.io.FileNotFoundException;
import java.io.FileReader;
import java.util.ArrayList;
import java.util.Collections;
import java.util.List;
import common.IoUtils;
/*1,读取score.csv文件
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("score.csv")));// 从csv文件中读取信息
String str = bReader.readLine();//第一列是表头信息要先读出来
List<Student> list = new ArrayList<>();// 数组列表只是定义了列表的形式,对象放前面,
while ((str = bReader.readLine()) != null) {
String[] strArr = str.split(",");
Student student = new Student();
int i = 0;
student.setsNo(strArr[i++]);
student.setsName(strArr[i++]);
student.setcScore(IoUtils.parseInt(strArr[i++], 0));
student.setJavaScore(IoUtils.parseInt(strArr[i++], 0));
student.setcSharpScore(IoUtils.parseInt(strArr[i++], 0));
list.add(student);// 将学生信息存放在数组里面
}
Collections.sort(list, (Student s1, Student s2) -> {
if (s1.getAvg() == s2.getAvg()) {
return 0;
} else if (s1.getAvg() <= s2.getAvg()) {
return 1;
} else {
return -1;
}
});// 比较器比较这一块没写完会报错误,是系统的原因
for (int i = 0; i < list.size(); i++) {
list.get(i).setAvgSort(i + 1);
System.out.println(list.get(i));
list.get(i).restore();
}
} catch (Exception e) {
// TODO Auto-generated catch block
e.printStackTrace();
} finally {
IoUtils.close(bReader);
}
}
}
import java.io.BufferedWriter;
import java.io.File;
import java.io.FileWriter;
import java.io.IOException;
import com.wh.demo11.BufferWriter;
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) {
this.avgSort = avgSort;
}
public String getsNo() {
return sNo;
}
public void setsNo(String sNo) {
this.sNo = sNo;
}
public String getsName() {
return sName;
}
public void setsName(String sName) {
this.sName = sName;
}
public int getcScore() {
return cScore;
}
public void setcScore(int cScore) {
this.cScore = cScore;
}
public int getJavaScore() {
return javaScore;
}
public void setJavaScore(int javaScore) {
this.javaScore = javaScore;
}
public int getcSharpScore() {
return cSharpScore;
}
public void setcSharpScore(int cSharpScore) {
this.cSharpScore = cSharpScore;
}
// 平均分
public int getAvg() {
return (getcScore() + getJavaScore() + getcSharpScore()) / 3;
}
// 最高分科目
public String getMax() {
int max = Math.max(cSharpScore, Math.max(cScore, javaScore));
if (max == cSharpScore) {
return "c#";
} else if (max == javaScore) {
return "java";
} else {
return "c";
}
}
// 创建对应学生的文件
public void restore() {
StringBuffer fileName = new StringBuffer();
fileName.append("D:/test/").append(getsNo()).append("_").append(getAvgSort()).append(".csv");
File file = new File(fileName.toString());
BufferedWriter bWriter = null;// bufferedWriter和bufferWrite要注意
try {
if (!file.exists()) {
file.createNewFile();
}
bWriter = new BufferedWriter(new FileWriter(file));
bWriter.write(this.toString());
bWriter.flush();
} catch (Exception e) {
// TODO Auto-generated catch block
e.printStackTrace();
}finally {
try {
bWriter.close();
} catch (IOException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
}
}