资源描述:
《netbeans实现学生信息管理系统源码》由会员上传分享,免费在线阅读,更多相关内容在教育资源-天天文库。
1、DevelopedbyGroupName:WaterStarReg.No:R3P3000005SylviaReg.No:R3P3000045JuneReg.No:R3P3000050NIITPROJECTIONStudentInformationManagementSystemDevelopedbyGroupName:WaterStarReg.No:R3P3000005SylviaReg.No:R3P3000045JuneReg.No:R3P3000050NIITPROJECTIONStudentInformationManage
2、mentSystemStudentManagementSystemSoftwareBatchCode:StartDate:08/03/2013NameoftheCoordinator:ShahnawazAhmadKhanNameoftheDeveloper:Ms.WaterEnglishName:WaterName(Chinese&Ponyin):水(water)EndDate:14/03/2013DateofSubmission:18/03/2013NIITCERTIFICATEThisistocertifythatthisre
3、port,titled"_StudentInformationManagementSystem___",embodiestheoriginalworkdonebyPeterInpartialfulfillmentofhiscourserequirementatNIIT.Coordinator:ShahnawazAhmadKhanAssociateCoordinator:AcknowledgementIwouldliketothankourFacultyMr.ShahnawazandChineseassociateFacultyMs
4、.LiFanfanforalltheirguidanceandsupportduringtheentirephaseofthisprojectdevelopmentwithoutwhichtheprojectwouldnothavebeencompleted.SystemAnalysisSystemSummary:Itisconvenientfortheuserstomanagestudentinformation.forexample:add,delete,updateandoverviewstudentinformation.
5、BusinessRules:1,createdatabase,tablesandconstraints.2,interfacedesign3,implementthesourcecode4,debugandtestDataQuery:createdatabaseSIMSuseSIMScreatetableuseinfo(uidintprimarykeyidentity(101,1),unamenchar(20)notnull,upasswordnchar(10)default'00000',urealnamenchar(20),u
6、mobilnchar(15))createtablestudentinfor(sidintprimarykeyidentity(10001,1),snamenchar(20)notnull,sgenderchar(4),sbirthdaynchar(15),smobilnchar(15),semilnchar(20),sacademynchar(20),smajornchar(20),)altertableuseinfoaddconstraintuniqunique(uname)altertablestudentinforaddc
7、onstraintununique(sname)altertablestudentinforaltercolumnsmobilchar(11)altertableuseinfodropconstraintDF__useinfo__upasswo__108B795B//HowtoUseUpdate、Insert、Select、deleteinCode1)stat=con.prepareStatement("updatestudentinforsetsgender=?,sbirthday=?,smobil=?,semil=?,saca
8、demy=?,smajor=?wheresid=?");2)stat=con.prepareStatement("insertintouseinfovalues(?,?,?,?)");3)ResultSetrs=stmt.executeQuery(