学生管理系统(图形界面)——java.doc
学生管理系统(图形界面)JAVA源代码PACKAGEEXP10IMPORTJAVAXSWINGJFRAMEPUBLICCLASSMAINCLASS{/PARAMARGS/PUBLICSTATICVOIDMAINSTRINGARGS{//TODOAUTOGENERATEDSTUBJFRAMEMYFRAMENEWJFRAME“学生成绩管理系统“MYFRAMESETLOCATION300,100//MYFRAMESETCONTENTPANENEWLOGINPANEMYFRAMEMYFRAMEPACKMYFRAMESETVISIBLETRUE}}PACKAGEEXP10IMPORTJAVASQLCONNECTIONIMPORTJAVASQLDRIVERMANAGERIMPORTJAVASQLRESULTSETIMPORTJAVASQLSQLEXCEPTIONIMPORTJAVASQLSTATEMENTPUBLICCLASSDATABASE{CONNECTIONCONNNULLPUBLICCONNECTIONGETCONN{RETURNTHISCONN}PUBLICVOIDSETCONNCONNECTIONCONN{THISCONNCONN}PUBLICBOOLEANGETCONNECTION{STRINGURL“JDBCMYSQL//LOCALHOST3306/SCOREMANAGEMENTUSERROOTTRY{CLASSFORNAME“ORGGJTMMMYSQLDRIVER“CONNDRIVERMANAGERGETCONNECTIONURLRETURNTRUE}CATCHSQLEXCEPTIONE{SYSTEMOUTPRINTLNEGETMESSAGERETURNFALSE}CATCHCLASSNOTFOUNDEXCEPTIONE{//TODOAUTOGENERATEDCATCHBLOCKEPRINTSTACKTRACERETURNFALSE}}PUBLICRESULTSETCUTEQUERYSTRINGSQL{RESULTSETRSNULLSTATEMENTSTMTNULLIFCONNNULL{THISGETCONNECTION}TRY{STMTCONNCREATESTATEMENTRSSTMTCUTEQUERYSQLRETURNRS}CATCHSQLEXCEPTIONE{RETURNNULL}}PUBLICINTCUTEUPDATESTRINGSQL{STATEMENTSTMTNULLINTLINECOUNT0IFCONNNULL{THISGETCONNECTION}TRY{STMTCONNCREATESTATEMENTLINECOUNTSTMTCUTEUPDATESQL}CATCHSQLEXCEPTIONE{}RETURNLINECOUNT}}PACKAGEEXP10IMPORTJAVAAWTEVENTACTIONEVENTIMPORTJAVAAWTEVENTACTIONLISTENERIMPORTJAVASQLRESULTSETIMPORTJAVASQLSQLEXCEPTIONIMPORTJAVAXSWINGBOXIMPORTJAVAXSWINGBUTTONGROUPIMPORTJAVAXSWINGJBUTTONIMPORTJAVAXSWINGJFRAMEIMPORTJAVAXSWINGJLABELIMPORTJAVAXSWINGJPANELIMPORTJAVAXSWINGJPASSWORDFIELDIMPORTJAVAXSWINGJRADIOBUTTONIMPORTJAVAXSWINGJTEXTFIELDPUBLICCLASSLOGINPANEEXTENDSJPANELIMPLEMENTSACTIONLISTENER{//PRIVATESTATICFINALLONGSERIALVERSIONUID1LJFRAMEMYFRAMEJLABELLAB_USERNAMENEWJLABEL“用户名“JTEXTFIELDJT_USERNAMENEWJTEXTFIELD20JLABELLAB_PASSWORDNEWJLABEL“密码“JPASSWORDFIELDJT_PWDNEWJPASSWORDFIELD20JRADIOBUTTONJRB_MANAGERNEWJRADIOBUTTON“管理员“JRADIOBUTTONJRB_TEACHERNEWJRADIOBUTTON“教师“JRADIOBUTTONJRB_STUDENTNEWJRADIOBUTTON“学生“PUBLICLOGINPANEJFRAMEMYFRAME{THISMYFRAMEMYFRAMETHISINIT}PUBLICVOIDINIT{BOXBOX_USERBOXCREATEHORIZONTALBOXBOX_USERADDLAB_USERNAMEBOX_USERADDBOXCREATEHORIZONTALSTRUT20BOX_USERADDJT_USERNAMEJT_PWDSETECHOCHAR BOXBOX_PWDBOXCREATEHORIZONTALBOXBOX_PWDADDLAB_PASSWORDBOX_PWDADDBOXCREATEHORIZONTALSTRUT20BOX_PWDADDJT_PWDBUTTONGROUPBGNEWBUTTONGROUPBGADDJRB_MANAGERBGADDJRB_TEACHERBGADDJRB_STUDENTBOXBOX_ROLEBOXCREATEHORIZONTALBOXBOX_ROLEADDJRB_MANAGERBOX_ROLEADDBOXCREATEHORIZONTALSTRUT5BOX_ROLEADDJRB_TEACHERBOX_ROLEADDBOXCREATEHORIZONTALSTRUT5BOX_ROLEADDJRB_STUDENTJBUTTONJB_LOGINNEWJBUTTON“登陆“JBUTTONJB_EXITNEWJBUTTON“退出“BOXBOX_BUTTONBOXCREATEHORIZONTALBOXBOX_BUTTONADDJB_LOGINBOX_BUTTONADDBOXCREATEHORIZONTALSTRUT30BOX_BUTTONADDJB_EXITJB_LOGINADDACTIONLISTENERTHISJB_EXITADDACTIONLISTENERTHISJB_LOGINSETACTIONCOMMAND“LOGIN“JB_EXITSETACTIONCOMMAND“EXIT“BOXBOX_LOGINBOXCREATEVERTICALBOXBOX_LOGINADDBOX_USERBOX_LOGINADDBOXCREATEHORIZONTALSTRUT10BOX_LOGINADDBOX_PWDBOX_LOGINADDBOXCREATEHORIZONTALSTRUT10BOX_LOGINADDBOX_ROLEBOX_LOGINADDBOXCREATEHORIZONTALSTRUT10BOX_LOGINADDBOX_BUTT