学生社团管理系统源代码

package学生社团管理系统;unportjavax.swing.*;unportjava.awt.*;unportjava.awt.event.ActionEvent;unportjava.awt.event.ActionListener;unportjava.awt.event.MouseEvent;unportjava.awt.event.MouseListener;unportjava.awt.event.MouseMotionListener;unportjava.sql.*;publicclassLeagueextendsJFramemiplementsActioiiListenerFPanelfp;JLabeljib,jlb2,jlb_alter,jlb_backgroundjlb_X;JTextFieldjtf;JPasswordFieldjpf;JButtonjb_iii.jb_register.fpclose;Fontfl=newFont(M宋体冷Font.PLAIN.20);staticStringsi;staticStrings2;publicstaticvoidniain(Strmgaigs)Leaguele=newLeagueQ;publicLeagueQfp=newFPanel();fpsetLayout(null);jlb_background=newJLabel(newIiiiageIcon(Hbackground.jpgH);jlb_background.setBounds(0,0,300,400);jlb_X=newJLabel(newIuiagelcoiX.gif1);jlb_X.setBounds(280,0,20,20);jib=newJLabel(H账号J;jlb.setBounds(10,200,50、40);jlb.setFont(fl);jlb2=newJLabel(H密码”);jlb2.setFont(fl);jlb2.setBounds(10,260.50.40);/用户输入区jtf=newJTextField(15);jtf.setFont(fl);jtf.setBounds(70,200,200,40);jpf=newJPasswordField(S);jpf.setFont(fl);jpf.setBounds(70,260,200,40);/按钮区jb_in=newJButton(H登录”)；jb_m.setContentAieaFilled(false);jb_in.setBounds(30,340,100,40);/jb_in.setBackground(Colof.white);jb_m.addActionListener(this);jb_register=newJButton(n注册用户n);jb_iegister.setContentAieaFilled(false);jb_register.setBouiids(l70,340,100,40);/jb_iegister.setBackgiound(Color.blue);jb_iegister.addActioiiListener(tliis);/关闭按钮如_close=newJButtonQ;fjp_close.setBouiids(280,0,20,20);fp_close.setContentAieaFilled(false);/fp_close.setlcon();/fp_close.setOpaque(false);fp_close.addActioiiListener(newActioiiListenerQpublicvoidactioiiPerfbnned(ActioiiEvente)System.exit(0););fp.addQlb);fp.add(jlb2);fp.add(jb_register);fp.add(jtf);fp.add(jpf)；fp.add(jb_in);fp.add(fp_close);fp.add(jlb_X);fp.add(jlb_background);tlus.add(fp);tlus.setTitle(LLL学生社团管理系统”)；tliis.setSize(300,400);tins.setLocatioiiRelativeTo(null);tlus.setDefaultCloseOperation(JFiame.EXIT_ON_CLOSE);tlus.setUndecoiated(tme);tinssetVisible(tine);OvemdepublicvoidactioiiPeiibrmed(ActioiiEventaigO)Coimectioncon=null;Statementstatement=null;ResultSetrs=null;sljtf.getTextQ;s2jpf.getText();if(aigO.getSouiceQ=jbregistei)newregisteipage();tliis.disposeQ;elseif(aigO.getSourceQ=jb_in)tryClass.fbrName(Mcom.nucrosoft.sqlsenTer.jdbc.SQLSen-eiDriverM);catch(ClassNotFoundExceptioneee)Svstem.out.priiitln(eee);con=DriveiManage匚getConnection(Mjdbc:sqlserx-er:/locaHiost:1433;DatabaseName=LeagueM,sa,Hqsqlll7H);statement=con.cieateStatementQ;is=statement.executeQueiy(nSELECTm_id,m_passwoidFROMmemberswherem_id=slandm_passwoid-s2,M);if(ts!=null)newniainpageQ;this.disposeQ;catch(SQLExceptioneee)System.out.println(eee);elseJOptionPane.showMessageDialog(tliis,”账户密码错误，请重新输入！”)；classFPanelextendsJPanelunplementsMouseListener,MouseMotioiiListenerprivateintoffsetX.offsetY;publicFPanelQaddMouseListener(this);addMouseMotioiiListener(this);publicvoidmouseDragged(MouseEvente)SwmgUtilities.getRoot(Component)e.getSource().setLocation(e.getXOnScreen()-offsetX,e.getYOnScreenQ-offsetY);OvemdepublicvoidmouseMoved(MouseEventargO)OvemdepublicvoidmouseClicked(MouseEventargO)OvemdepublicvoidmouseEntered(MouseEventargO)OvemdepublicvoidmouseExited(MouseEventaigO)OvemdepublicvoidmousePressed(MouseEventargO)offsetX=argO.getXQ;offsetY=aigO.getYQ;OvemdepublicvoidmouseReleased(MouseEventaigO)publicclassalterpageextendsJFrameimplementsActioiiListenerFPanelfp;JLabeljl_id,jLnaine,jl5,jLage,jl_department,jl_class,jLnumbei;jLmail,jlb_backgroundjlb_X;JTextFieldjt_id,jt_name,jt_age,jt_department,jt_class,jt_number,jCmail;JPasswordFieldjpf_passwordpfLpasswoid2;JButtonjbljb2,fp_closejb_back;StringsO,si,s2,s3,s4、s5,s6;publicalterpageQ/Fontfl=newFont(n宋体駡Font.PLAIN,20);fp=newFPanelQ;fjpsetLayout(null);jlb_background=newJLabel(newIinageIcon(Hbackground.jpgH);jlb_background.setBornids(0,0,300,400);jlb_X=newJLabel(newImag亡Icon(”X.gF);jlb_X.setBounds(280,0,20,20);jLid=newJLabel(H账户：”)；jLid.setBounds(10,140,70,20);jLname=newJLabel(H姓名:”)；jl_name.setBounds(10,170.70,20);jLage=newJLabelf1年龄:M);jl_age.setBounds(10,200,70,20);jLdepailment=newJLabel(M院系:jLdepaitment.setBounds(10,230,70、20);jLclass=newJLabel(H班级：J;jLclass.setBounds(10,260,70,20);jLnumber=newJLabel(H手机号：”)；jLnumber.setBounds(10,290.70,20);jLniail=newJLabel(邮箱:);jLmail.setBounds(10,320、70,20);jt_id=newJTextField(lO);jt_id.setBounds(80,140,200,20);jt_name=newJTextField(15);jt_name.setBounds(80.170,200、20);jt_age=newJTextField(ll);jt_age.setBounds(805200,200,20);jCdepartment=newJTextField();jt_department.setBounds(80,230,200,20);jt_class=newJTextField(15);jt_class.setBounds(801260,200.20);jt_number=newJTextFi亡ld();jt_number.serBounds(80,290.200.20);jt_mail=newJTextFieldQ;jt_mail.setBounds(80,320,200,20);/关闭按钮fp_close=newJButton();fjp_close.setBounds(280,0,20,20);fp_close.setContentAieaFilled(false);/fp_close.setlcon();/fp_close.setOpaque(folse);fp_close.addActioiiListener(newActioiiListenerQpublicvoidactioiiPerfbnned(ActioiiEvente)System.exit(O););jbl=newJButton(M提交”)；jbl.setContentAieaFilled(false);jbl.setBounds(20,360.80、30);jbl.addActioiiListener(this);jb2=newJButton(M重置”)；jb2.setContentAieaFllled(false);jb2.setBounds(110.360、80、30);jb2.addActioiiListener(this);jb_back=newJButton(n返回”)；jb_back.setContentAieaFilled(false);jb_back.setBounds(200,360,80、30);jb_back.addActioiiListener(this);/添加组件fp.addQbl);fjp.add(jb2);fp.add(jb_back);fp.add(jl_id);fp.addQLname);fp.add(jl_age);fpadd(jLdepanment);fp.add(jl_class);fp.addQLnumber);fp.addQLinail);/fp.add(jpf_password);/fp.add(jpf_password2);fp.add(jt_id);fp.add(jt_name);fp.add(jt_age);fpadd(jt_depaitment);fp.add(jt_class);fpadd(jt_number);fp.add(jt_inail);fp.add(fp_close);fp.add(jlb_X);fpadd(jlb_background);tlus.add(fp);tliis.setSize(300,400);tlus.setLocatioiiRelativeTo(null);tlus.setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);tlus.setUndecoiated(tRie);tlus.setVisible(tme);OvemdepublicvoidactioiiPeiibrmed(ActioiiEvente)Coimectioncon=null;Statementstatement=null;ResultSetrs=null;sO=jt_id.getTextQ.triin();si=jt_name.getText().tiimQ;s2=jt_department.getTextQ.trim();s3=jt_class.getTextQ.tiun();s4=jt_age.getText().trmi();s5=jt_number.getText().tiimQ;s6=jt_niail.getTextQ.tnm();if(e.getSourceQ=jbl)if(jt_name!=null&jcdepartment!=null&jt_class!=null)if(sO.equals(League.sl)tryClass.fbrName(ncom.niiciosoft.sqlsen-er.jdbc.SQLServreiDriveiH);catch(ClassNotFoundExceptioneee)System.out.pimtlii(eee);trycon=DriveiMaiiagergetCoiinection(njdbc:sqlseive匸/localhost:1433;DatabaseNanie=Lagu亡”，Hsa*nqsqlll7M);statement=con.cieateStatement();statement.executeUpdate(HUpdatememberssetm_name=,M+sl+,m_depai-tment=H,+s2+m_class=”+s3+nm_age=M,+s4+Hnunumber=H,+s5+s6+mwhereLTRIM(m.id)=M,+sO+);catch(SQLExceptioneee)System.out.piiiitlii(eee);trystatement.closeQ;con.closeQ;catch(SQLExceptionel)/TODO自动生成的catch块e1.priiitStackTiaceQ;newLeagueQ;this.disposeQ;elseJOptioiiPane.showMessageDialog(tliis,H账号不能为空或者被改变”);elseJOptioiiPane.showMessageDialog(this名字，学院，班级不能为空”)；elseif(e.getSourceQ=jb2)newalteipageQ;this.disposeQ;elseif(e.getSouiceQ=jb.back)newmampage();this.disposeQ;publicclassniainpageextendsJFrameuuplementsActioiiListenerFPanelfp;JLabeljlbl,jlb2,jlb3,jlb_backg】oimd,jlb_X;JTextFieldjtlJt2Jt3;JPasswordFieldjpf;JButtonjb_seaich,fp_close,jb_alterjb_delete;JTextFieldjtfLuiput;JTextAreajta_show;Strings;publicmainpage()fp=newFPanel();fpsetLayout(null);jlb_background=newJLabel(newIinageIcon(Hbackground.jpgH);jib_background.setBomids(0,0,300,400);jlb_X=newJLabel(newIinageIcon(HX.gifr);jlb_X.setBounds(280.0.20,20);jb_search=newJButtoi1喳找”)；jb_search.setContentAreaFilled(false);jb_search.setBounds(75,160,150,40);jb_search.addActionListener(this);jb_alter=newJButton(M修改个人信息”)；jb_alter.setContentAieaFilled(false);jb_alter.setBounds(75,240,150,40);jb_alter.addActionListener(this);jbdelete=newJButton(n注销J;jb_delete.setContentAieaFilled(false);jb_delete.setBounds(75,320,150,40);jb_delete.addActioiiListener(this);/关闭按钮fp_close=newJButton();fjp_close.setBounds(280,0,20.20);fp_close.setContentAieaFilled(false);fp_close.addActioiiListener(newActioiiListenerQpublicvoidactioiiPerfonned(ActioiiEvente)Svstem.exit(O););jta_show=newJTextAiea(6,43);fp.add(jb_search);fp.add(fp_close);fp.add(jlb_X);fp.add(jb_delete);fp.add(jb_alter);fp.add(jlb_background5-1);tlus.add(fp);tliis.setSize(300,400);tlus.setLocatioiiRelativeTo(null);tlus.setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);tlus.setUndecorated(tme);tinssetVisible(tine);OvemdepublicvoidactioiiPeiibrmed(ActioiiEvente)Connectioncon;Statementstatement;ResultSetrs;booleandeletesuccess=false;if(e.getSourceQ=jb_seaich)newsearchpage();this.dispose();elseif(e.getSouice()=jb_alter)newalteipageQ;this.dispose();elseif(e.getSouice()=jb.delete)Class.fbrName(Mcom.niiciosoft.sqlsenTer.jdbc.SQLSenTerDriverH);catch(ClassNotFoundExceptioneee)Svstem.out.println(eee);con=DriveiManage匚getConnection(Mjdbc:sqlseiver:/localliost:1433;DatabaseName=LeagueM,MsaH,Hqsqlll7H);statement=con.createStatementQ;is=statement.executeQuery(MSELECT*FROMmembers);while(rs.nextQ)if(rs.getStiing(l).tiim().equals(League.sl)deletesuccess=tme;statement.executeUpdate(HDeletememberswherem_id=H,+League.sl+,HH);rs.closeQ;statement.close();con.close();if(deletesuccess)JOptioiiPaiie.showMessageDialog(tliis,”删除成功”);catch(SQLExceptioneee)System.out.println(eee);publicclassregisteipageextendsJFrameunplementsActioiiListenerFPanelfp;JLabeljl_id,jLpassword.jl_password2,jLname,jl5,jLage,jLdepaitment,jl_class?jlb.backgroundJlb_X;JTextFieldjt_id,jt_name,jt_age,jt_department,jt_class;JPasswordFieldjpf_password.jpf_password2;JButtonjbljb2.fp_closejb_back;Stringsi,s2,s3,s4,s5,s6;/Fontfl=newFont(”宋体二Font.PLAIN,20);publiclegisteipageQfp=newFPanel();fpsetLayout(null);jlb_background=newJLabel(newIiiiageIcon(Hbackground.jpgH);jlb_background.setBounds(0,0,300,400);jlb_X=newJLabel(newIuiagelcoiX.gif1);jlb_X.setBounds(280,0,20,20);jljd=newJLabel(n账号:n);jLid.setBounds(10,140,70,20);jLpassword=newJLabel(H密码:jLpasswoid.setBounds(10,170,70、20);jLpassword2=newJLabel(M再次密码:H);jLpassxvoid2.setBounds(10,200.70.20);jLname=newJLabel(H姓名:”)；jLname.setBounds(10.230,70,20);jl_age=newJLabel(M年龄：”)；jl_age.setBounds(10,260,70,20);jLdepaitment=newJLabel(H院系:);jl_depaitment.setBounds(10,290,70,20);jl_class=newJLabel(H班级：J;jLclass.setBounds(10,320,70、20);jt_id=newJTextFieldQ;jt_id.setBounds(80,140,200,20);jpf_password=newJPasswordField(8);jpf_password.setBounds(80,170,200,20);jpf_password2=newJPasswoidF代ld(8);jpf_password2.setBounds(80,200,200.20);jt_name=newJTextField(15);jt_name.setBouiids(80,230,200,20);jt_age=newJTextField(ll);jt_age.setBounds(80,260,200,20);jCdepaitment=newJTextField();jt_depaitment.setBounds(80,290,200,20);jt_class=newJTextField(15);jt_class.setBounds(80,320,200,20);/关闭按钮如_close=newJButton();fp_close.setBounds(280,0,20，20);fp_close.setContentAieaFilled(false);/fp_close.setlcon();/fp_close.setOpaque(false);fp_close.addActioiiListener(newActioiiListenerQpublicvoidactioiiPerfonned(ActioiiEvente)System.exit(O););jbl=newJButton(M提交”)；jb1.setContentAieaFilled(false);jbl.setBounds(20,360.80、30);jbl.addActioiiListener(this);jb2=newJButton(M重置”)；jb2.setContentAieaFllled(false);jb2.setBounds(110.360、80、30);jb2.addActioiiListener(this);jb_back=newJButton(n返回”)；jb_back.setContentAieaFilled(false);jb_back.setBounds(200,360,80、30);jb_back.addActioiiListener(this);/添加组件fp.add(jl_id);fp.add(jLpassword);fp.add(jLpassword2);fp.add(jLname);fp.add(jl_age);fp.add(jLdepanment);fp.add(jLclass);fp.add(jbl);fp.add(jb2);fp.add(jb_back);fp.add(jpf_password);fp.add(jpf_password2);fp.add(jt_id);fp.add(jt_name);fp.add(jt_age);fp.add(jt_depaitment);fp.add(jt_class);fp.add(fp_close);fp.add(jlb_X);fp.add(jlb_background);tlus.add(fp);tliis.setSize(300,400);tlus.setLocatioiiRelativeTo(null);tlus.setDefaultCloseOperation(JFiame.EXIT_ON_CLOSE);tlus.setUndecorated(tRie);tinssetVisible(tine);OvemdepublicvoidactioiiPeiibrmed(ActioiiEvente)Coimectioncon=null;Statementstatement=null;ResultSetrs=null;si=jt_name.getText();s2=jt_department.getTextQ;s3=jt_class.getTextQ;s4=jt_age.getText()；s5=jt_id.getTextQ;s6=jpf_password.getText();if(e.getSourceQ=jbl)if(jt_id!=null&jCnaine!=null&jt_age!=null&jt_department!=null&jt_class!=null)if(jpf_password.getText().equals(jpf_passwoid2.getText()tryClass.fbiName(ncom.niiciosoft.sqlsen-er.jdbc.SQLServreiDiiverM);catch(ClassNotFoundExceptioneee)System.out.prmtlii(eee);trycon=DriveiMaiiagergetCoiinection(,jdbc:sqlseiver:/localhost:1433;DatabaseName=LeagueH,sa1；Hqsqlll7,r);statement=con.createStatement();rs=statement.executeQueiy(nSELECT*FROMmembers”)；wlule(rs.nextQ)Strings=rs.getStriiig(l).triin();if(s.equals(s5)JOptionPaiie.showMessageDialog(this5”账户己存在”)；newregisteipageQ;tlus.dispose();statement.executeUpdate(nInsertIntomembers(m_id4n_passwoidaii_namejii_depaitmentjn-class,ni_age)values(nt+s5+”J”+s6+”T”+s1+s3+”；”+s4+”y);catch(SQLExceptioneee)System.out.prmtlii(eee);trystatement.closeQ;con.closeQ;catch(SQLExceptionel)/TODO自动生成的catch块e1.priiitStackTiaceQ;newLeagueQ;this.disposeQ;elseJOptioiiPane.showMessageDialog(tliis,1俩次密码输入不匹配”)；elseJOptioiiPane.showMessageDialog(this,”注册不了”)；elseif(e.getSourceQ=jb2)newregisteipage();this.disposeQ;elseif(e.getSouiceQ=jb_back)newLeagueQ;this.disposeQ;publicclassseaichpageextendsJFrameimplementsActionListenerFPanelfp;JLabeljlbl,jlb2,jlb3,jlb_backg】oimd,jlb_X;JTextFieldjtl,jt2Jt3;JPasswordFieldjpf;JButtonjb_search.fp_closejb_back;JTextFieldjtfLuiput;JTextAreajta_show;Strings;JScrollPanejsp;JTabletable;intkJ=0;Objecta;Objectheader=“编号“，”社团名”，”负责人”，”社团活动”;booleanjb_alter_islive=tnie;publicseaichpageQfp=newFPanel();fpsetLayout(null);jlb_background=newJLabel(newImageIcon(Mbackground.jpgH);jlb_background.setBounds(0,0,300,400);jlb_X=newJLabel(newImagelcoiX.gif1);jlb_X.setBounds(280,0,20,20);jlbl=newJLabel(M输入社团名J;jlbl.setBounds(20,140,80,30);jtfLmput=newJTextField();jtf_input.setBomids(100,140,100,30);jb_search=newJButtoi1喳找”)；jb_search.setContentAreaFilled(false);jb_search.setBounds(220,140,60,30);jb_search.addActionListener(this);jb_back=newJButton(M返回”)；jb_back.setContentAieaFilled(false);jb_back.setBounds(100,190,100,30);jb_back.addActioiiListener(this);/关闭按钮fp_close=newJButtonQ;fp_close.setBounds(280,0,20,20);fp_close.setContentAieaFilled(false);fp_close.addActioiiListener(newActioiiListenerQpublicvoidactioiiPerfonned(ActioiiEvente)System.exit(0););jta_show=newJTextAiea(6,43);fp.add(jlbl);fp.add(jtfLuiput);fp.add(jb_search);fp.add(fp_close);fp.add(jb_back);fp.add(jlb_X);fp.add(jlb_background,-1);tlus.add(fp);tliis.setSize(300,400);tlus.setLocatioiiRelativeTo(null);tlus.setDefaultCloseOperation(JFiame.EXIT_ON_CLOSE);tlus.setUndecorated(tRie);tinssetVisible(tine);OvemdepublicvoidactioiiPeiibrmed(ActioiiEvente)booleannotfhid=tme;s=jtfLHiput.getTextQ;a=newObject64;Connectioncon;Statementstatement;ResultSetrs;if(e.getSourceQ=jb_seaich)jb_alter_islive=false;tryClass.fbrName(Mcom.niicrosoft.sqlsenrer.jdbc.SQLSenTeiDriverH);catch(ClassNotFoundExceptioneee)Svstem.out.println(eee);con=DriveiManage匚getConnection(Mjdbc:sqlseiver:/localliost:1433;DatabaseName=League,sa,qsqlll7H);statement=con.createStatementQ;is=statement.executeQueiy(MSELECT*FROMleagueActivities*);while(rs.nextQ)if(s.equals(,IH)System,out.prmtlii(s);aiO=is.getInt(l);ail=rs.getStnng(2);ai2=rs.getSuing(3);ai3=rs.getSuing(4);i+;elseif(rs.getString(2).equals(s)notfind=false;aiO=is.getInt(l);ail=rs.getStnng(2);ai2=rs.getSuing(3);ai习=rs.getStnng(4);break;rs.closeQ;statement.close();con.close();if(notfiiid)JOptionPane.showMessageDialog(this,H你输入社团不存在”);catch(SQLExceptioneee)System.out.println(eee);table=newJTable(aJieader);table.setAutoResizeMode(WTDTH);/table.setBackgromid(newColor(168,228,232);table.setPreferredScrollableVievvportSize(newDuiiension(280,220);jsp=newJScrollPane(table);jsp.setBounds(10,250,280,122);fp.add(jsp);elseif(e.getSouice()=jb_back)newinampage();this,dispose。；