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個文件信息