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

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

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

?????文件???????2032??2009-03-17?13:58??3java在線答疑系統(tǒng)\build\zxdy\addCourse.jsp

?????文件???????2015??2009-01-01?21:44??3java在線答疑系統(tǒng)\build\zxdy\addManage.jsp

?????文件???????2664??2009-03-16?23:53??3java在線答疑系統(tǒng)\build\zxdy\addStu.jsp

?????文件???????1641??2009-01-01?21:42??3java在線答疑系統(tǒng)\build\zxdy\adminChangePwd.jsp

?????文件????????892??2009-03-16?15:10??3java在線答疑系統(tǒng)\build\zxdy\adminIndex.jsp

?????文件???????2712??2008-12-16?21:01??3java在線答疑系統(tǒng)\build\zxdy\adminList.jsp

?????文件???????2770??2009-03-16?13:58??3java在線答疑系統(tǒng)\build\zxdy\adminLogin.jsp

?????文件???????1134??2008-12-15?10:43??3java在線答疑系統(tǒng)\build\zxdy\adminMessage.jsp

?????文件????????342??2008-12-15?10:10??3java在線答疑系統(tǒng)\build\zxdy\adminTop.jsp

?????文件???????2105??2008-12-12?23:01??3java在線答疑系統(tǒng)\build\zxdy\apply.jsp

?????文件???????2373??2008-12-14?00:51??3java在線答疑系統(tǒng)\build\zxdy\applyCourse.jsp

?????文件???????2416??2009-03-16?13:52??3java在線答疑系統(tǒng)\build\zxdy\changeInfo.jsp

?????文件???????2313??2008-12-15?17:07??3java在線答疑系統(tǒng)\build\zxdy\changePwd.jsp

?????文件???????3272??2008-12-16?20:54??3java在線答疑系統(tǒng)\build\zxdy\courseList.jsp

?????文件???????5670??2008-12-16?16:43??3java在線答疑系統(tǒng)\build\zxdy\css\style1.css

?????文件???????6432??2009-03-05?09:37??3java在線答疑系統(tǒng)\build\zxdy\css\style2.css

?????文件????????695??2008-12-15?13:48??3java在線答疑系統(tǒng)\build\zxdy\css\tree.css

?????文件???????6858??2009-03-16?14:21??3java在線答疑系統(tǒng)\build\zxdy\dbconf\db.sql

?????文件????????792??2008-11-18?01:11??3java在線答疑系統(tǒng)\build\zxdy\dbconf\dbconfig.txt

?????文件??????10843??2009-03-17?15:23??3java在線答疑系統(tǒng)\build\zxdy\dbconf\zxdy.sql

?????文件????????789??2008-12-17?23:51??3java在線答疑系統(tǒng)\build\zxdy\detail.jsp

?????文件???????2534??2009-01-01?18:52??3java在線答疑系統(tǒng)\build\zxdy\editCourse.jsp

?????文件????????121??2008-11-16?15:44??3java在線答疑系統(tǒng)\build\zxdy\flag.jsp

?????文件?????????68??2008-12-25?22:34??3java在線答疑系統(tǒng)\build\zxdy\forward.jsp

?????文件??????35745??2008-11-14?21:43??3java在線答疑系統(tǒng)\build\zxdy\images\bottom.jpg

?????文件????????348??2005-11-09?17:39??3java在線答疑系統(tǒng)\build\zxdy\images\cancel.gif

?????文件????????148??2008-11-14?14:45??3java在線答疑系統(tǒng)\build\zxdy\images\check_error.gif

?????文件????????634??2008-11-17?16:37??3java在線答疑系統(tǒng)\build\zxdy\images\check_right.gif

?????文件??????14504??2006-08-01?10:43??3java在線答疑系統(tǒng)\build\zxdy\images\closed.png

?????文件????????988??2008-01-23?02:08??3java在線答疑系統(tǒng)\build\zxdy\images\cmp.gif

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