JSP+MYSQL学生成绩管理系统

用jsp实现学生成绩管理系统,有管理员,教师和学生登录界面,管理员可以对其进行管理操作,学生可以查询相关信息。

package faasfa;

import java.sql.ResultSet;
import java.sql.SQLException;

public class Afa {
	public static void main（String[] args） throws SQLException {
		Dbc db=new Dbc（）;
		ResultSet rs;
		String sno=“20085109“;
		String sql4=“select cno  from selcourse where （cnocxuhao） in （ select distinct cnocxuhao from selcourse where sno= ‘“+sno+“‘ order by cno ） order by cnozgrade DESC“;
		db.setSql（sql4）;
		rs=db.getRs（）;
		while（rs.next（））{
			String ss=rs.getString（“cno“）;
		//	int as=rs.getInt（“count（zgrade）“）;
			System.out.println（ss+“    “）;
		}
	}
}

 属性            大小     日期    时间   名称
----------- ---------  ---------- -----  ----

     文件    1030034  2009-12-11 10:57  ccgsprin9\.metadata\.bak_0.log

     文件          0  2009-11-07 17:16  ccgsprin9\.metadata\.lock

     文件     973537  2008-12-26 09:52  ccgsprin9\.metadata\.log

     文件         80  2008-12-26 10:58  ccgsprin9\.metadata\.plugins\com.genuitec.eclipse.desktop\dialog_settings.xml

     文件        840  2009-11-07 18:18  ccgsprin9\.metadata\.plugins\com.genuitec.eclipse.sqlexplorer\ConnectionProfiles.xml

     文件      16262  2009-11-07 18:18  ccgsprin9\.metadata\.plugins\com.genuitec.eclipse.sqlexplorer\SQLDrivers.xml

     文件       3720  2009-12-26 00:45  ccgsprin9\.metadata\.plugins\com.genuitec.eclipse.templates\velocity.log

     文件       5784  2009-12-08 17:54  ccgsprin9\.metadata\.plugins\com.genuitec.eclipse.webdesigner3\MyHtml_2009984641_preview.html

     文件      19775  2008-12-26 09:46  ccgsprin9\.metadata\.plugins\com.genuitec.eclipse.webdesigner3\staticbindings_5.5.0.css

     文件          0  2009-11-07 17:16  ccgsprin9\.metadata\.plugins\com.genuitec.org.hibernate.eclipse\hibernate-tools.log

     文件       1860  2009-12-25 10:40  ccgsprin9\.metadata\.plugins\org.eclipse.core.resources\.history\0\301544f6fef0001e1d16ad66c9048f66

     文件       8374  2009-12-24 18:32  ccgsprin9\.metadata\.plugins\org.eclipse.core.resources\.history\0\e0cf32de77f0001e12f781296c001aa4

     文件       3253  2009-12-23 10:51  ccgsprin9\.metadata\.plugins\org.eclipse.core.resources\.history\1\10fc6d8d6eef001e1d3ccb85ba7cd29e

     文件        776  2009-12-25 11:23  ccgsprin9\.metadata\.plugins\org.eclipse.core.resources\.history\1\a05f4fe805f1001e1161d3cc82aa7120

     文件       1282  2009-12-19 13:08  ccgsprin9\.metadata\.plugins\org.eclipse.core.resources\.history\10\20d9c3b95cec001e1253f1a2d6a75bc3

     文件        565  2009-11-21 16:07  ccgsprin9\.metadata\.plugins\org.eclipse.core.resources\.history\11\303b251675d6001e1c1391d20b4a5d4b

     文件        947  2009-11-21 13:28  ccgsprin9\.metadata\.plugins\org.eclipse.core.resources\.history\11\f091b0cb5ed6001e1c1391d20b4a5d4b

     文件       2575  2009-12-26 00:06  ccgsprin9\.metadata\.plugins\org.eclipse.core.resources\.history\12\1009a69a6ff1001e10d192573f2e557b

     文件       3387  2009-12-23 11:13  ccgsprin9\.metadata\.plugins\org.eclipse.core.resources\.history\12\7008dd4571ef001e1d3ccb85ba7cd29e

     文件        869  2009-11-21 11:40  ccgsprin9\.metadata\.plugins\org.eclipse.core.resources\.history\12\80ed35a14fd6001e1c1391d20b4a5d4b

     文件       4053  2009-12-23 11:46  ccgsprin9\.metadata\.plugins\org.eclipse.core.resources\.history\12\9018514776ef001e1d3ccb85ba7cd29e

     文件       3405  2009-12-23 11:14  ccgsprin9\.metadata\.plugins\org.eclipse.core.resources\.history\13\3011645f71ef001e1d3ccb85ba7cd29e

     文件       1057  2009-11-21 15:10  ccgsprin9\.metadata\.plugins\org.eclipse.core.resources\.history\13\f04a220771d6001e1c1391d20b4a5d4b

     文件       2969  2009-12-19 14:23  ccgsprin9\.metadata\.plugins\org.eclipse.core.resources\.history\13\f0a92e0367ec001e1253f1a2d6a75bc3

     文件       2535  2009-12-19 17:45  ccgsprin9\.metadata\.plugins\org.eclipse.core.resources\.history\14\10a8311077ef001e19fcb1d18b82bc37

     文件        254  2009-12-21 11:26  ccgsprin9\.metadata\.plugins\org.eclipse.core.resources\.history\14\a08882a0e0ed001e1d5f95aa73e1d900

     文件       4703  2009-12-21 11:44  ccgsprin9\.metadata\.plugins\org.eclipse.core.resources\.history\14\b0a56b23e3ed001e1f9bd811c5ff8d96

     文件       1588  2009-12-19 13:17  ccgsprin9\.metadata\.plugins\org.eclipse.core.resources\.history\15\6057fdd45dec001e1253f1a2d6a75bc3

     文件        781  2009-11-21 16:29  ccgsprin9\.metadata\.plugins\org.eclipse.core.resources\.history\15\e0a1ebb278d6001e1c1391d20b4a5d4b

     文件        767  2009-12-25 11:31  ccgsprin9\.metadata\.plugins\org.eclipse.core.resources\.history\16\90287bef05f1001e1161d3cc82aa7120

............此处省略1306个文件信息