《软件编程（Java方向）》课件 单元四 学生信息管理系统.ppt

*任务实施任务1：编写学生实体类StudentpublicclassStudent{ privateintid; privateStrings_name; privateStrings_no; privateStrings_class; privateStrings_major; privateints_age; privateStrings_sex; publicintgetId(){ returnid; } publicvoidsetId(intid){ this.id=id; } publicStringgetS_name(){ returns_name; }任务实施任务1：编写学生实体类Student publicStringgetS_no(){ returns_no;} publicvoidsetS_no(StringsNo){ s_no=sNo;} publicStringgetS_class(){ returns_class;} publicvoidsetS_class(StringsClass){ s_class=sClass;} publicStringgetS_major(){ returns_major;} publicvoidsetS_major(StringsMajor){ s_major=sMajor;} publicintgetS_age(){ returns_age;} publicvoidsetS_age(intsAge){ s_age=sAge;} publicStringgetS_sex(){ returns_sex;} publicvoidsetS_sex(StringsSex){ s_sex=sSex; }}任务实施任务2：编写学生管理类StudentManagerimportjava.sql.ResultSet;importjava.util.ArrayList;import.model.Student;import.pub.DBUtil;publicclassStudentManager{publicbooleanaddStudent(Students){ DBUtildb=newDBUtil(); booleanflag=false; try{ Stringsql=insertintostudent(s_name,s_no,s_class,s_major,s_age,s_sex)values(++s.getS_name()+,++s.getS_no()+,++s.getS_class()+,++s.getS_major()+,+s.getS_age()+,++s.getS_sex()+);db.insert(sql);flag=true;}catch(Exceptione){ e.printStackTrace(); }finally{ db.closeConn(); } returnflag;}任务实施任务2：编写学生管理类StudentManagerpublicbooleandeleteByNO(Stringsno){booleanflag=false; DBUtildb=newDBUtil(); try{ Stringsql=deletefromstudentwheres_no=+sno+; flag=db.executeUpdate(sql); }catch(Exceptione){ //TODOAuto-generatedcatchblock e.printStackTrace(); }finally{ db.closeConn(); } returnflag;}任务实施任务2：编写学生管理类StudentManagerpublicbooleanmodify