package?com.webAction;

import?javax.servlet.*;
import?javax.servlet.http.*;
import?java.util.*;
import?java.io.*;
import?com.tools.ConnectServer;
import?com.tools.toChinese;
import?com.entityBean.SystemBean;
import?com.entityBean.GradeBean;
import?com.entityBean.SpecialityBean;
import?com.entityBean.ClassBean;
import?com.entityBean.AlumniBean;
import?com.means.handleSystem;
import?com.means.handleGrade;
import?com.means.handleSpeciality;
import?com.means.handleClass;
import?com.means.handleAlumni;

//校友信息設置的servlet
public?class?alumniSVT?extends?HttpServlet{
????private?toChinese?toc=new?toChinese（）;
????private?SystemBean?syb=null;
????private?GradeBean?gb=null;
????private?SpecialityBean?spb=null;
????private?ClassBean?cb=null;
????private?AlumniBean?alb=null;
????private?handleSystem?hsy=null;
????private?handleGrade?hg=null;
????private?handleSpeciality?hsp=null;
????private?handleClass?hc=null;
????private?handleAlumni?hal=null;
????private?int?method;

????public?void?doGet（HttpServletRequest?requestHttpServletResponse?response）throws?ServletExceptionIOException{
???????request.setCharacterEncoding（“gb2312“）;
???????method=Integer.parseInt（request.getParameter（“method“））;
???????switch（method）{
?????????case?0:{
???????????this.sendIn（requestresponse）;
???????????break;
?????????}
?????????case?1:{
???????????this.selectAlumni（requestresponse）;
???????????break;
?????????}
?????????case?2:{
???????????this.selectOneAlumni（requestresponse）;
???????????break;
?????????}
?????????case?3:{
???????????this.updateAlumni（requestresponse）;
???????????break;
?????????}
?????????case?4:{
???????????this.deleteAlumni（requestresponse）;
???????????break;
?????????}
?????????case?5:{
???????????this.addAlumni（requestresponse）;
???????????break;
?????????}
???????}
????}

//添加校友信息
????public?void?addAlumni（HttpServletRequest?requestHttpServletResponse?response）throws?ServletExceptionIOException{
???????String?id=request.getParameter（“do“）;
???????alb=new?AlumniBean（）;
???????hal=new?handleAlumni（）;
???????List?li=hal.fetchAluByGC（request.getParameter（“grade“）request.getParameter（“speciality“））;
???????String?url=null;
???????if（id==null）{
?????????request.setAttribute（“list“li）;
?????????url=“alumni/alumniAdd.jsp“;
???????}
???????else{
?????????for（int?i=0;i???????????alb=（AlumniBean）li.get（i）;
???????????if（alb.getA_number（）.equals（request.getParameter（“num“）））{
?????????????request.setAttribute（“error““您添加的校友學號已存在請重新添加！！！“）;
?????????????url=“alumni/alUpdateFail.jsp“;
?????????????break;
???????????}
???????????if（i==（li.size（）-1））{
?????????????Integer?id1=Integer.valueOf（request.getParameter（“do“））;
?????????????alb.setA_id（id1）;
?????????????alb.setA_number（request.getParameter（“num“））;
?????????????alb.setA_name（request.getParameter（“name“））;
?????????????alb.setA_sex（request.getParameter（“sex“））;
?????????????alb.setA_nowwork（r

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

?????文件???????7435??2009-05-25?11:48??學年論文-校友信息管理系統\schoolfellow\alumni\alumniAdd.jsp

?????文件???????5431??2009-05-25?10:56??學年論文-校友信息管理系統\schoolfellow\alumni\alumniSelect.jsp

?????文件???????7832??2009-05-26?16:42??學年論文-校友信息管理系統\schoolfellow\alumni\alumniUpdate.jsp

?????文件???????1061??2009-05-25?11:54??學年論文-校友信息管理系統\schoolfellow\alumni\alUpdateFail.jsp

?????文件???????1052??2009-05-24?21:03??學年論文-校友信息管理系統\schoolfellow\alumni\alUpdateSuccess.jsp

?????文件???????3479??2009-05-23?10:16??學年論文-校友信息管理系統\schoolfellow\alumni\into.jsp

?????文件????????990??2009-05-22?09:00??學年論文-校友信息管理系統\schoolfellow\bcl.jsp

?????文件???????4670??2009-05-22?11:05??學年論文-校友信息管理系統\schoolfellow\class\classAdd.jsp

?????文件???????3852??2009-05-15?21:46??學年論文-校友信息管理系統\schoolfellow\class\classSelect.jsp

?????文件???????4762??2009-05-18?15:52??學年論文-校友信息管理系統\schoolfellow\class\classUpdate.jsp

?????文件????????969??2009-05-18?19:36??學年論文-校友信息管理系統\schoolfellow\class\clUpdateFail.jsp

?????文件????????971??2009-05-15?10:35??學年論文-校友信息管理系統\schoolfellow\class\clUpdateSuccess.jsp

?????文件????????335??2009-04-30?21:21??學年論文-校友信息管理系統\schoolfellow\connectFail.jsp

?????文件????????605??2009-05-26?13:00??學年論文-校友信息管理系統\schoolfellow\fcl.jsp

?????文件???????4378??2009-06-01?11:38??學年論文-校友信息管理系統\schoolfellow\getAccount.jsp

?????文件???????2825??2009-05-23?21:30??學年論文-校友信息管理系統\schoolfellow\grade\gradeAdd.jsp

?????文件???????3181??2009-05-23?21:24??學年論文-校友信息管理系統\schoolfellow\grade\gradeSelect.jsp

?????文件???????2966??2009-05-23?21:28??學年論文-校友信息管理系統\schoolfellow\grade\gradeUpdate.jsp

?????文件????????967??2009-05-11?15:44??學年論文-校友信息管理系統\schoolfellow\grade\gUpdateSuccess.jsp

?????文件???????1516??2009-04-30?15:57??學年論文-校友信息管理系統\schoolfellow\index.jsp

?????文件???????1001??2009-05-01?11:24??學年論文-校友信息管理系統\schoolfellow\login.jsp

?????文件????????550??2009-05-01?16:49??學年論文-校友信息管理系統\schoolfellow\manager\addSuccess.jsp

?????文件???????2619??2009-05-01?17:03??學年論文-校友信息管理系統\schoolfellow\manager\managerIn.jsp

?????文件???????2993??2009-05-07?18:09??學年論文-校友信息管理系統\schoolfellow\manager\maUpdatePassword.jsp

?????文件???????1082??2009-05-08?20:47??學年論文-校友信息管理系統\schoolfellow\manager\maUpdateSuccess.jsp

?????文件???????2974??2009-05-08?21:12??學年論文-校友信息管理系統\schoolfellow\manager\maUpdateUser.jsp

?????文件???????4002??2009-05-05?22:42??學年論文-校友信息管理系統\schoolfellow\manager\powerUpdate.jsp

?????文件???????1040??2009-05-05?13:03??學年論文-校友信息管理系統\schoolfellow\manager\powerUpdateSuccess.jsp

?????文件???????3266??2009-05-05?11:03??學年論文-校友信息管理系統\schoolfellow\manager\rightControl.jsp

?????文件???????3374??2009-05-17?22:52??學年論文-校友信息管理系統\schoolfellow\manager\userControl.jsp

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