1,读取文件 2,计算各学员平均分,将各学员信息按照平均分从高到低进行排序。 3,为每个学员的生成分数文件,文件名(学号_平均分排名.csv) 4,csv文件包含内容(学号、姓名、平

时间:2025-04-15 18:07:26
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
				();
			}
		}

	}

}