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（）;	//創建SQL語句向量
????	StringBuilder?sba?=?new?StringBuilder（）;	//創建用于記錄插入成功學生學號的字符串
????	StringBuilder?sbb?=?new?StringBuilder（）;	//記錄已經在該課程下的學生學號
????	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））{							//如果該生已經在該課程下
????				sbb.append（no+“;“）;
????			}
????			else{
????				sba.append（no+“;“）;							//該生符合添加條件
????				v.add（“insert?into?DY_TU（UIDTGID）?values?（“
????					+no+““+course+“）“）;//將存在的學號插入數據庫的SQL語句
????			}
????		}
????		else{												//學號不存在的記錄
????			sbc.append（no+“;“）;
????		}
????	}
????	if（dbu.update（v））{										//執行更新插入數據庫
????		message?=?sba.length（）>0?“學號[“+sba.toString（）+“]的學生插入成功
“:““;
????	}
????	message?+=?sbb.length（）>0?“學號[“+sbb.toString（）+“]的學生已經在該課程下
“:““;
????	message?+=?sbc.length（）>0?“學號[“+sbc.toString（）+“]的學生不存在，請核對輸入
“:““;
????	return?SUCCESS;
????}
}

?屬性????????????大小?????日期????時間???名稱
-----------?---------??----------?-----??----
?????目錄???????????0??2010-08-01?16:03??chap03\
?????目錄???????????0??2010-08-01?16:03??chap03\build\
?????目錄???????????0??2010-08-01?16:03??chap03\build\zxdy\
?????文件????????2032??2009-03-17?13:58??chap03\build\zxdy\addCourse.jsp
?????文件????????2015??2009-01-01?21:44??chap03\build\zxdy\addManage.jsp
?????文件????????2664??2009-03-16?23:53??chap03\build\zxdy\addStu.jsp
?????文件????????1641??2009-01-01?21:42??chap03\build\zxdy\adminChangePwd.jsp
?????文件?????????892??2009-03-16?15:10??chap03\build\zxdy\adminIndex.jsp
?????文件????????2712??2008-12-16?21:01??chap03\build\zxdy\adminList.jsp
?????文件????????2770??2009-03-16?13:58??chap03\build\zxdy\adminLogin.jsp
?????文件????????1134??2008-12-15?10:43??chap03\build\zxdy\adminMessage.jsp
?????文件?????????342??2008-12-15?10:10??chap03\build\zxdy\adminTop.jsp
?????文件????????2105??2008-12-12?23:01??chap03\build\zxdy\apply.jsp
?????文件????????2373??2008-12-14?00:51??chap03\build\zxdy\applyCourse.jsp
?????文件????????2416??2009-03-16?13:52??chap03\build\zxdy\changeInfo.jsp
?????文件????????2313??2008-12-15?17:07??chap03\build\zxdy\changePwd.jsp
?????文件????????3272??2008-12-16?20:54??chap03\build\zxdy\courseList.jsp
?????目錄???????????0??2010-08-01?16:03??chap03\build\zxdy\css\
?????文件????????5670??2008-12-16?16:43??chap03\build\zxdy\css\style1.css
?????文件????????6432??2009-03-05?09:37??chap03\build\zxdy\css\style2.css
?????文件?????????695??2008-12-15?13:48??chap03\build\zxdy\css\tree.css
?????目錄???????????0??2010-08-01?16:03??chap03\build\zxdy\dbconf\
?????文件????????6858??2009-03-16?14:21??chap03\build\zxdy\dbconf\db.sql
?????文件?????????792??2008-11-18?01:11??chap03\build\zxdy\dbconf\dbconfig.txt
?????文件???????10843??2009-03-17?15:23??chap03\build\zxdy\dbconf\zxdy.sql
?????文件?????????789??2008-12-17?23:51??chap03\build\zxdy\detail.jsp
?????文件????????2534??2009-01-01?18:52??chap03\build\zxdy\editCourse.jsp
?????文件?????????121??2008-11-16?15:44??chap03\build\zxdy\flag.jsp
?????文件??????????68??2008-12-25?22:34??chap03\build\zxdy\forward.jsp
?????目錄???????????0??2010-08-01?16:03??chap03\build\zxdy\images\
?????文件???????35745??2008-11-14?21:43??chap03\build\zxdy\images\bottom.jpg
............此處省略302個文件信息