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

public?class?AddStuAction?extends?TipAndFenYeAction{
	private?String?course;	//課程號(hào)
	private?String?stuNO;	//學(xué)生學(xué)號(hào)
	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)建用于記錄插入成功學(xué)生學(xué)號(hào)的字符串
????	StringBuilder?sbb?=?new?StringBuilder（）;	//記錄已經(jīng)在該課程下的學(xué)生學(xué)號(hào)
????	StringBuilder?sbc?=?new?StringBuilder（）;	//記錄學(xué)號(hào)不存在的字符串
????	String?sno[]?=?stuNO.split（“;“）;			//將學(xué)號(hào)按分號(hào)分開
????	int?size?=?sno.length;
????	for（int?i=0;i????		String?no?=?sno[i].trim（）;
????		String?sql?=?“select?1?from?DY_User?where?UID=“+no;//查詢?cè)搶W(xué)號(hào)對(duì)應(yīng)學(xué)生是否存在
????		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+“）“）;//將存在的學(xué)號(hào)插入數(shù)據(jù)庫的SQL語句
????			}
????		}
????		else{												//學(xué)號(hào)不存在的記錄
????			sbc.append（no+“;“）;
????		}
????	}
????	if（dbu.update（v））{										//執(zhí)行更新插入數(shù)據(jù)庫
????		message?=?sba.length（）>0?“學(xué)號(hào)[“+sba.toString（）+“]的學(xué)生插入成功
“:““;
????	}
????	message?+=?sbb.length（）>0?“學(xué)號(hào)[“+sbb.toString（）+“]的學(xué)生已經(jīng)在該課程下
“:““;
????	message?+=?sbc.length（）>0?“學(xué)號(hào)[“+sbc.toString（）+“]的學(xué)生不存在，請(qǐng)核對(duì)輸入
“:““;
????	return?SUCCESS;
????}
}

?屬性????????????大小?????日期????時(shí)間???名稱
-----------?---------??----------?-----??----
?????目錄???????????0??2013-02-20?22:13??03\
?????目錄???????????0??2013-02-20?22:13??03\zxdy\
?????文件?????????434??2011-06-26?15:18??03\zxdy\.classpath
?????目錄???????????0??2012-06-29?13:44??03\zxdy\.myeclipse\
?????文件?????????286??2011-07-21?10:33??03\zxdy\.mymetadata
?????文件????????1277??2011-06-26?15:28??03\zxdy\.project
?????目錄???????????0??2013-02-20?22:13??03\zxdy\.settings\
?????文件?????????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
?????目錄???????????0??2013-02-20?22:13??03\zxdy\src\
?????文件??????????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
?????目錄???????????0??2013-02-20?22:13??03\zxdy\src\textMsg\
?????文件?????????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
?????目錄???????????0??2013-02-20?22:13??03\zxdy\src\wyy\
?????文件????????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
............此處省略179個(gè)文件信息