package?wyy;
import?java.util.Vector;
import?com.opensymphony.xwork2.*;

public?class?AddStuAction?extends?TipAndFenYeAction{
	private?String?course;	//課程號
	private?String?stuNO;	//學生學號
	public?String?getCourse（）?{
		return?course;
	}
	public?void?setCourse（String?course）?{
		this.course?=?course;
	}
	public?String?getStuNO（）?{
		return?stuNO;
	}
	public?void?setStuNO（String?stuNO）?{
		this.stuNO?=?stuNO;
	}
	@Override
????public?String?execute（）throws?Exception{
????	Vector?v?=?new?Vector（）;	//創(chuàng)建SQL語句向量
????	StringBuilder?sba?=?new?StringBuilder（）;	//創(chuàng)建用于記錄插入成功學生學號的字符串
????	StringBuilder?sbb?=?new?StringBuilder（）;	//記錄已經(jīng)在該課程下的學生學號
????	StringBuilder?sbc?=?new?StringBuilder（）;	//記錄學號不存在的字符串
????	String?sno[]?=?stuNO.split（“;“）;			//將學號按分號分開
????	int?size?=?sno.length;
????	for（int?i=0;i????		String?no?=?sno[i].trim（）;
????		String?sql?=?“select?1?from?DY_User?where?UID=“+no;//查詢該學號對應學生是否存在
????		if（dbu.isExist（sql））{
????			sql?=?“select?1?from?DY_TU?where?UID=“+no+“?and?TGID=“+course;
????			if（dbu.isExist（sql））{							//如果該生已經(jīng)在該課程下
????				sbb.append（no+“;“）;
????			}
????			else{
????				sba.append（no+“;“）;							//該生符合添加條件
????				v.add（“insert?into?DY_TU（UIDTGID）?values?（“
????					+no+““+course+“）“）;//將存在的學號插入數(shù)據(jù)庫的SQL語句
????			}
????		}
????		else{												//學號不存在的記錄
????			sbc.append（no+“;“）;
????		}
????	}
????	if（dbu.update（v））{										//執(zhí)行更新插入數(shù)據(jù)庫
????		message?=?sba.length（）>0?“學號[“+sba.toString（）+“]的學生插入成功
“:““;
????	}
????	message?+=?sbb.length（）>0?“學號[“+sbb.toString（）+“]的學生已經(jīng)在該課程下
“:““;
????	message?+=?sbc.length（）>0?“學號[“+sbc.toString（）+“]的學生不存在，請核對輸入
“:““;
????	return?SUCCESS;
????}
}

?屬性????????????大小?????日期????時間???名稱
-----------?---------??----------?-----??----

?????文件????????434??2011-06-26?15:18??03\zxdy\.classpath

?????文件????????286??2011-07-21?10:33??03\zxdy\.mymetadata

?????文件???????1277??2011-06-26?15:28??03\zxdy\.project

?????文件????????105??2011-07-21?10:37??03\zxdy\.settings\com.genuitec.eclipse.core.prefs

?????文件???????1040??2011-06-26?15:41??03\zxdy\.settings\com.genuitec.eclipse.j2eedt.core.prefs

?????文件?????????76??2011-07-23?09:29??03\zxdy\src\.struts.mex

?????文件????????191??2011-07-18?20:55??03\zxdy\src\struts.properties

?????文件???????7458??2011-07-23?09:29??03\zxdy\src\struts.xml

?????文件????????126??2011-07-18?20:48??03\zxdy\src\textMsg\change.bat

?????文件???????1079??2011-07-18?20:48??03\zxdy\src\textMsg\myApplication.properties

?????文件????????591??2011-07-18?20:48??03\zxdy\src\textMsg\myApplication.txt

?????文件???????1883??2011-07-18?20:55??03\zxdy\src\wyy\AddStuAction.java

?????文件???????1353??2011-07-18?20:55??03\zxdy\src\wyy\AdminLoginAction.java

?????文件???????2805??2011-07-18?20:55??03\zxdy\src\wyy\AdminManageAction.java

?????文件???????1844??2011-07-18?20:55??03\zxdy\src\wyy\ApplyAction.java

?????文件???????1140??2011-07-18?20:55??03\zxdy\src\wyy\ApplyItem.java

?????文件???????3121??2011-07-18?20:55??03\zxdy\src\wyy\ChangeInfoAction.java

?????文件???????1258??2011-07-18?20:55??03\zxdy\src\wyy\ChangePwdAction.java

?????文件????????744??2011-07-18?20:55??03\zxdy\src\wyy\CourseItem.java

?????文件??????18736??2011-07-18?20:55??03\zxdy\src\wyy\DBUtil.java

?????文件???????1615??2011-07-22?21:30??03\zxdy\src\wyy\DYbaseAction.java

?????文件???????2573??2011-07-18?20:55??03\zxdy\src\wyy\EditCourseAction.java

?????文件???????2270??2011-07-18?20:55??03\zxdy\src\wyy\EmitAction.java

?????文件???????1832??2011-07-18?20:55??03\zxdy\src\wyy\FenYeAction.java

?????文件????????501??2011-07-18?20:55??03\zxdy\src\wyy\GetMyCourseAction.java

?????文件????????574??2011-07-18?20:55??03\zxdy\src\wyy\GetMyInfo.java

?????文件???????1271??2011-07-18?20:55??03\zxdy\src\wyy\GetTipAction.java

?????文件???????1754??2011-07-18?20:55??03\zxdy\src\wyy\GroupItem.java

?????文件???????2570??2011-07-18?20:55??03\zxdy\src\wyy\IndexAction.java

?????文件???????1539??2011-07-18?20:55??03\zxdy\src\wyy\LoginAction.java

............此處省略183個文件信息