import?java.io.*;
import?java.util.*;
import?jxl.*;
import?jxl.write.*;

public?class?Scms?{
	public?static?void?main（String[]?args）?throws?Exception?{
		System.out.println（“====Score?Manager啟動(dòng)====“）;
		System.out.println（“請(qǐng)輸入Command：“）;
		System.out.println（“insert:學(xué)生成績插入“）;
		System.out.println（“search:通過名字查詢“）;
		System.out.println（“l(fā)ist?course:顯示各科成績排名列表“）;
		System.out.println（“l(fā)ist?ID:顯示各科成績通過學(xué)生學(xué)號(hào)的排名列表“）;
		System.out.println（“exit:退出系統(tǒng)“）;
		while?（true）?{
			@SuppressWarnings（“resource“）
			Scanner?s?=?new?Scanner（System.in）;
			String?key?=?null;
			String?key2?=?null;
			key?=?s.next（）;
			if?（“insert“.equalsIgnoreCase（key））?{
				insert.main（）;
			}?else?if?（“search“.equalsIgnoreCase（key））?{
				search.main（）;
			}?else?if?（“l(fā)ist“.equalsIgnoreCase（key））?{
				key2?=?s.next（）;
				if?（“course“.equalsIgnoreCase（key2））?{
					list.listByCourse（）;
				}?else?if?（“ID“.equalsIgnoreCase（key2））?{
					list.listByID（）;
				}?else?{
					System.out.println（“不存在“?+?key2?+?“同學(xué)或著課程“）;
				}
			}?else?if?（“exit“.equalsIgnoreCase（key））?{
				System.out.println（“感謝使用ScoreManager再見!“）;
				break;
			}?else?{
				System.out.println（“本系統(tǒng)不支持?“?+?key?+?“?這種操作“）;
			}
		}
	}
}

class?insert?{
	static?String?name?=?null;
	static?String?ID?=?null;
	static?double?java?=?0.0;
	static?double?php?=?0.0;
	static?double?web?=?0.0;
	static?double?linux?=?0.0;
	static?int?rsRows;
	static?int?rsCols;

	static?boolean?main（）?{
		@SuppressWarnings（“resource“）
		Scanner?s?=?new?Scanner（System.in）;

		System.out.println（“請(qǐng)輸入要插入的學(xué)生ID、姓名（如‘20115261?/n?s67‘）:“）;
		ID?=?s.next（）;
		name?=?s.next（）;
		System.out
				.println（“請(qǐng)輸入該學(xué)生的java、php、web、linux分?jǐn)?shù)（如‘?67?/n?67?/n?67?/n?67?/n‘）:“）;
		java?=?s.nextDouble（）;
		php?=?s.nextDouble（）;
		web?=?s.nextDouble（）;
		linux?=?s.nextDouble（）;
		try?{
			InputStream?is?=?new?FileInputStream（“C:\\homework\\test.xls“）;
			Workbook?rwb?=?Workbook.getWorkbook（is）;
			Sheet?rs?=?rwb.getSheet（0）;
			rsRows?=?rs.getRows（）;
			rsCols?=?rs.getColumns（）;
			String[][]?readfile?=?new?String[rsCols][rsRows];
			for?（int?j?=?0;?j?				for?（int?i?=?0;?i?					Cell?cell?=?rs.getCell（i?j）;//?（列，行）
					String?str?=?cell.getContents（）;
					readfile[i][j]?=?str;
				}
			OutputStream?os?=?new?FileOutputStream（“C:\\homework\\test.xls“）;
			WritableWorkbook?wwb?=?Workbook.createWorkbook（os）;
			//?創(chuàng)建Excel工作表
			WritableSheet?sheet?=?wwb.createSheet（“testsheet“?0）;
			//?原表格中數(shù)據(jù)重新寫入
			for?（int?j?=?0;?j?				for?（int?i?=?0;?i?					sheet.addCell（new?Label（i?j?readfile[i][j]））;
				}

			for?（int?j?=?0;?j?				if?（ID.equals（readfile[1][j]））?{
					System.out.println（ID?+?“已存在請(qǐng)問要覆蓋信息嗎？（Y/N）“）;
					String?answer?=?s.next（）;
					if?（answer.equalsIgnoreCase（“N“））?{
						System.out.println（“insert操作已取消，請(qǐng)重新輸入操作符：“）;
						//?寫入Excel工作表
						wwb.write（）;
						//?關(guān)閉Excel工作薄對(duì)象
						wwb.cl

?屬性????????????大小?????日期????時(shí)間???名稱
-----------?---------??----------?-----??----
?????目錄???????????0??2013-10-21?23:48??P2_StudentScoreManager\
?????文件?????????466??2013-10-20?10:42??P2_StudentScoreManager\.classpath
?????文件?????????388??2013-10-18?17:02??P2_StudentScoreManager\.project
?????目錄???????????0??2013-10-21?23:48??P2_StudentScoreManager\.settings\
?????文件?????????598??2013-10-18?17:02??P2_StudentScoreManager\.settings\org.eclipse.jdt.core.prefs
?????目錄???????????0??2013-10-21?23:48??P2_StudentScoreManager\bin\
?????文件????????1877??2013-10-21?23:19??P2_StudentScoreManager\bin\Scms.class
?????文件????????4377??2013-10-21?23:19??P2_StudentScoreManager\bin\insert.class
?????文件????????3058??2013-10-21?23:19??P2_StudentScoreManager\bin\list.class
?????文件????????2260??2013-10-21?23:19??P2_StudentScoreManager\bin\search.class
?????目錄???????????0??2013-10-21?23:48??P2_StudentScoreManager\src\
?????文件????????7223??2013-10-21?23:19??P2_StudentScoreManager\src\Scms.java
?????文件??????285880??2013-11-26?23:06??實(shí)驗(yàn)報(bào)告.doc