学生管理系统代码.docx

import java.awt.*;import javax.swing.*;import java.awt.Font;import javax.swing.ButtonGroup;import javax.swing.JButton;import javax.swing.JFrame;import javax.swing.JLabel;import javax.swing.JRadioButton;import javax.swing.JScrollPane;import javax.swing.JTextArea;import javax.swing.JTextField;import javax.swing.JPasswordField;import java.awt.event.ActionEvent;import java.awt.event.ActionListener;import java.awt.event.WindowAdapter;import java.awt.event.WindowEvent;import java.sql.Connection;import java.sql.DriverManager;import java.sql.ResultSet;import java.sql.Statement;import javax.swing.JOptionPane;class LoginCheckprivate String user;private String passWord;public LoginCheck(String user,String passWord)this.user=user;this.passWord=passWord;public boolean check()if(zhouzhiqiang.equals(user)&123456.equals(passWord)return true;elsereturn false;class ActionHandle1 private JFrame frame=new JFrame(登录界面);private JButton submit=new JButton(登录);private JButton exit=new JButton(退出);private JLabel user=new JLabel(用户名：);private JLabel passWord=new JLabel(密 码：);private JLabel info=new JLabel(学生管理系统);private JTextField userText=new JTextField();private JPasswordField passText=new JPasswordField();public ActionHandle1()Font fnt=new Font(Serief,Font.BOLD,20);info.setFont(fnt);submit.addActionListener(new ActionListener()public void actionPerformed(ActionEvent arg0)if(arg0.getSource()=submit)String user=userText.getText(); String password=new String(passText.getPassword(); LoginCheck log=new LoginCheck(user,password); if(log.check() new ActionHandle2().setMenuBar(); else JOptionPane.showMessageDialog(null, 输入的用户名或密码有误！, 警告, JOptionPane.WARNING_MESSAGE); userText.setText(); passText.setText(); );exit.addActionListener(new ActionListener()public void actionPerformed(ActionEvent arg0)if(arg0.getSource()=exit)System.exit(1););frame.addWindowListener(new WindowAdapter()public void windowClosing(WindowEvent arg0)frame.dispose(););frame.setLayout(null);user.setBounds(45, 45, 60, 20);passWord.setBounds(45, 75, 60, 20);info.setBounds(75, 5, 220, 30);userText.setBounds(105, 45, 100, 20);passText.setBounds(105, 75, 100, 20);submit.setBounds(45, 120, 60, 20);exit.setBounds(145, 120, 60, 20);frame.getContentPane().setBackground(Color.GREEN);frame.add(user);frame.add(passWord);frame.add(info);frame.add(userText);frame.add(passText);frame.add(submit);frame.add(exit);frame.setSize(300,200);frame.setVisible(true);frame.setResizable(false);class ActionHandle4 private JFrame frame=new JFrame(录入界面-课程基本表);private JButton ensure=new JButton(确定);private JButton quit=new JButton(取消);private JLabel cno=new JLabel(课程号：);private JLabel cname=new JLabel(课程名：);private JLabel cpno=new JLabel(先修课：);private JLabel ccredit=new JLabel(学 分：);private JTextField cnoText=new JTextField();private JTextField cnameText=new JTextField();private JTextField cpnoText=new JTextField();private JTextField ccreditText=new JTextField();public ActionHandle4()/*ensure.addActionListener(new ActionListener()public void actionPerformed(ActionEvent arg0)if(arg0.getSource()=ensure)String sno=snoText.getText(); String sname=snameText.getText(); String sage=snoText.getText(); String sdept=snameText.getText(); LoginCheck log=new LoginCheck(user,password); if(log.check() else JOptionPane.showMessageDialog(null, 输入的用户名或密码有误！, 警告, JOptionPane.WARNING_MESSAGE); userText.setText(); passText.setText(); );*/quit.addActionListener(new ActionListener()public void actionPerformed(ActionEvent arg0)if(arg0.getSource()=quit)frame.dispose(););frame.addWindowListener(new WindowAdapter()public void windowClosing(WindowEvent arg0)System.exit(0););frame.setLayout(null);cno.setBounds(45, 45, 60, 20);cname.setBounds(45, 75, 60, 20);cpno.setBounds(45, 105, 60, 20);ccredit.setBounds(45, 135, 60, 20);cnoText.setBounds(105, 45, 100, 20);cnameText.setBounds(105, 75, 100, 20);cpnoText.setBounds(105, 105, 100, 20);ccreditText.setBounds(105, 135, 100, 20);ensure.setBounds(45, 195, 60, 20);quit.setBounds(145, 195, 60, 20);frame.getContentPane().setBackground(Color.GREEN);frame.add(cno);frame.add(cname);frame.add(cpno);frame.add(ccredit);frame.add(cnoText);frame.add(cnameText);frame.add(cpnoText);frame.add(ccreditText);frame.add(ensure);frame.add(quit);frame.setSize(300,300);frame.setVisible(true);frame.setResizable(false);class ActionHandle5 private JFrame frame=new JFrame(录入界面-成绩基本表);private JButton ensure=new JButton(确定);private JButton quit=new JButton(取消);private JLabel sno=new JLabel(学 号：);private JLabel cno=new JLabel(课程号：);private JLabel grade=new JLabel(成 绩：);private JTextField snoText=new JTextField();private JTextField cnoText=new JTextField();private JTextField gradeText=new JTextField();public ActionHandle5()/*ensure.addActionListener(new ActionListener()public void actionPerformed(ActionEvent arg0)if(arg0.getSource()=ensure)String sno=snoText.getText(); String sname=snameText.getText(); String sage=snoText.getText(); String sdept=snameText.getText(); LoginCheck log=new LoginCheck(user,password); if(log.check() else JOptionPane.showMessageDialog(null, 输入的用户名或密码有误！, 警告, JOptionPane.WARNING_MESSAGE); userText.setText(); passText.setText(); );*/quit.addActionListener(new ActionListener()public void actionPerformed(ActionEvent arg0)if(arg0.getSource()=quit)frame.dispose(););frame.addWindowListener(new WindowAdapter()public void windowClosing(WindowEvent arg0)System.exit(0););frame.setLayout(null);sno.setBounds(45, 45, 60, 20);cno.setBounds(45, 75, 60, 20);grade.setBounds(45, 105, 60, 20);snoText.setBounds(105, 45, 100, 20);cnoText.setBounds(105, 75, 100, 20);gradeText.setBounds(105, 105, 100, 20);ensure.setBounds(45, 195, 60, 20);quit.setBounds(145, 195, 60, 20);frame.getContentPane().setBackground(Color.GREEN);frame.add(sno);frame.add(cno);frame.add(grade);frame.add(snoText);frame.add(cnoText);frame.add(gradeText);frame.add(ensure);frame.add(quit);frame.setSize(300,300);frame.setVisible(true);frame.setResizable(false);class ActionHandle6 private JFrame frame=new JFrame(更改界面);private JButton ensure=new JButton(确定);private JButton quit=new JButton(取消);private JLabel sno1=new JLabel(请输入学号：);private JLabel sno=new JLabel(学 号：);private JLabel sname=new JLabel(姓 名：);private JLabel sage=new JLabel(年 龄：);private JLabel sdept=new JLabel(院 系：);private JLabel ssex=new JLabel(性 别：);private JRadioButton boy=new JRadioButton(男);private JRadioButton girl=new JRadioButton(女);private ButtonGroup sex=new ButtonGroup();private JTextField sno1Text=new JTextField();private JTextField snoText=new JTextField();private JTextField snameText=new JTextField();private JTextField sageText=new JTextField();private JTextField sdeptText=new JTextField();public ActionHandle6()/*ensure.addActionListener(new ActionListener()public void actionPerformed(ActionEvent arg0)if(arg0.getSource()=ensure)String sno=snoText.getText(); String sname=snameText.getText(); String sage=snoText.getText(); String sdept=snameText.getText(); LoginCheck log=new LoginCheck(user,password); if(log.check() else JOptionPane.showMessageDialog(null, 输入的用户名或密码有误！, 警告, JOptionPane.WARNING_MESSAGE); userText.setText(); passText.setText(); );*/quit.addActionListener(new ActionListener()public void actionPerformed(ActionEvent arg0)if(arg0.getSource()=quit)frame.dispose(););frame.addWindowListener(new WindowAdapter()public void windowClosing(WindowEvent arg0)System.exit(0););frame.setLayout(null);sno1.setBounds(15, 15, 100, 20);sno.setBounds(45, 45, 60, 20);sname.setBounds(45, 75, 60, 20);sage.setBounds(45, 105, 60, 20);sdept.setBounds(45, 135, 60, 20);ssex.setBounds(45, 165, 60, 20);sno1Text.setBounds(105, 15, 100, 20);snoText.setBounds(105, 45, 100, 20);snameText.setBounds(105, 75, 100, 20);sageText.setBounds(105, 105, 100, 20);sdeptText.setBounds(105, 135, 100, 20);ensure.setBounds(45, 195, 60, 20);quit.setBounds(145, 195, 60, 20);boy.setBounds(105,165,40,20);girl.setBounds(155,165,40,20);boy.setSelected(true);boy.setBackground(Color.GREEN);girl.setBackground(Color.GREEN);sex.add(this.boy);sex.add(girl);frame.getContentPane().setBackground(Color.GREEN);frame.add(sno1);frame.add(sno);frame.add(sname);frame.add(sage);frame.add(sdept);frame.add(ssex);frame.add(sno1Text);frame.add(snoText);frame.add(snameText);frame.add(sageText);frame.add(sdeptText);frame.add(ensure);frame.add(quit);frame.add(boy);frame.add(girl);frame.setSize(300,300);frame.setVisible(true);frame.setResizable(false);class ActionHandle7 private JFrame frame=new JFrame(删除界面);private JButton ensure=new JButton(确定);private JButton quit=new JButton(取消);private JLabel sno=new JLabel(请输入学号：);private JTextField snoText=new JTextField();public ActionHandle7()/*ensure.addActionListener(new ActionListener()public void actionPerformed(ActionEvent arg0)if(arg0.getSource()=ensure)String sno=snoText.getText(); String sname=snameText.getText(); String sage=snoText.getText(); String sdept=snameText.getText(); LoginCheck log=new LoginCheck(user,password); if(log.check() else JOptionPane.showMessageDialog(null, 输入的用户名或密码有误！, 警告, JOptionPane.WARNING_MESSAGE); userText.setText(); passText.setText(); );*/quit.addActionListener(new ActionListener()public void actionPerformed(ActionEvent arg0)if(arg0.getSource()=quit)frame.dispose(););frame.addWindowListener(new WindowAdapter()public void windowClosing(WindowEvent arg0)System.exit(0););frame.setLayout(null);sno.setBounds(25, 105, 100, 20);snoText.setBounds(125, 105, 100, 20);ensure.setBounds(45, 195, 60, 20);quit.setBounds(145, 195, 60, 20);frame.getContentPane().setBackground(Color.GREEN);frame.add(sno);frame.add(snoText);frame.add(ensure);frame.add(quit);frame.setSize(300,300);frame.setVisible(true);frame.setResizable(false);class Action01 private JFrame frame=new JFrame(按性别查询);private JButton ensure=new JButton(确定);private JButton quit=new JButton(取消);private JLabel ssex=new JLabel(性 别：);private JRadioButton boy=new JRadioButton(男);private JRadioButton girl=new JRadioButton(女);private ButtonGroup sex=new ButtonGroup();public Action01()/*ensure.addActionListener(new ActionListener()public void actionPerformed(ActionEvent arg0)if(arg0.getSource()=ensure)String sno=snoText.getText(); String sname=snameText.getText(); String sage=snoText.getText(); String sdept=snameText.getText(); LoginCheck log=new LoginCheck(user,password); if(log.check() else JOptionPane.showMessageDialog(null, 输入的用户名或密码有误！, 警告, JOptionPane.WARNING_MESSAGE); userText.setText(); passText.setText(); );*/quit.addActionListener(new ActionListener()public void actionPerformed(ActionEvent arg0)if(arg0.getSource()=quit)frame.dispose(););frame.addWindowListener(new WindowAdapter()public void windowClosing(WindowEvent arg0)System.exit(0););frame.setLayout(null);ssex.setBounds(45, 45, 60, 20);ensure.setBounds(45, 85, 60, 20);quit.setBounds(145, 85, 60, 20);boy.setBounds(115,45,40,20);girl.setBounds(165,45,40,20);boy.setSelected(true);boy.setBackground(Color.GREEN);girl.setBackground(Color.GREEN);sex.add(this.boy);sex.add(girl);frame.getContentPane().setBackground(Color.GREEN);frame.add(ssex);frame.add(ensure);frame.add(quit);frame.add(boy);frame.add(girl);frame.setSize(300,300);frame.setVisible(true);frame.setResizable(false);class Action02 private JFrame frame=new JFrame(按学号查询);private JButton student=new JButton(学生基本表);private JButton course=new JButton(课程表);private JButton score=new JButton(成绩表);private JLabel sno=new JLabel(请输入学号：);private JTextField snoText=new JTextField();public Action02()/*ensure.addActionListener(new ActionListener()public void actionPerformed(ActionEvent arg0)if(arg0.getSource()=ensure)String sno=snoText.getText(); String sname=snameText.getText(); String sage=snoText.getText(); String sdept=snameText.getText(); LoginCheck log=new LoginCheck(user,password); if(log.check() else JOptionPane.showMessageDialog(null, 输入的用户名或密码有误！, 警告, JOptionPane.WARNING_MESSAGE); userText.setText(); passText.setText(); );*/score.addActionListener(new ActionListener()public void actionPerformed(ActionEvent arg0)if(arg0.getSource()=score)frame.dispose(););frame.addWindowListener(new WindowAdapter()public void windowClosing(WindowEvent arg0)System.exit(0););frame.setLayout(null);sno.setBounds(25, 35, 100, 20);snoText.setBounds(125, 35, 100, 20);student.setBounds(25, 65, 120, 20);course.setBounds(25, 95, 120, 20);score.setBounds(25, 125, 120, 20);frame.getContentPane().setBackground(Color.GREEN);frame.add(sno);frame.add(snoText);frame.add(student);frame.add(course);frame.add(score);frame.setSize(300,300);frame.setVisible(true);frame.setResizable(false);class Action03 private JFrame frame=new JFrame(按课程号查询);private JButton student=new JButton(学生基本表);private JButton score=new JButton(成绩表);private JLabel sno=new JLabel(请输入课程号：);private JTextField snoText=new JTextField();public Action03()/*ensure.addActionListener(new ActionListener()public void actionPerformed(ActionEvent arg0)if(arg0.getSource()=ensure)String sno=snoText.getText(); String sname=snameText.getText(); String sage=snoText.getText(); String sdept=snameText.getText(); LoginCheck log=new LoginCheck(user,password); if(log.check() else JOptionPane.showMessageDialog(null, 输入的用户名或密码有误！, 警告, JOptionPane.WARNING_MESSAGE); userText.setText(); passText.setText(); );*/score.addActionListener(new ActionListener()public void actionPerformed(ActionEvent arg0)if(arg0.getSource()=score)frame.dispose(););frame.addWindowListener(new WindowAdapter()public void windowClosing(WindowEvent arg0)System.exit(0););frame.setLayout(null);sno.setBounds(25, 35, 100, 20);snoText.setBounds(125, 35, 100, 20);student.setBounds(25, 65, 120, 20);score.setBounds(25, 95, 120, 20);frame.getContentPane().setBackground(Color.GREEN);frame.add(sno);frame.add(snoText);frame.add(student);frame.add(score);frame.setSize(300,300);frame.setVisible(true);frame.setResizable(false);class Action05 private JFrame frame=new JFrame(显示界面);private JLabel sno=new JLabel(所有学生的选课信息：);private JTextArea jta=new JTextArea(3,20);private JScrollPane scr=new JScrollPane(jta,JScrollPane.VERTICAL_SCROLLBAR_ALWAYS,JScrollPane.HORIZONTAL_SCROLLBAR_ALWAYS);public Action05()frame.addWindowListener(new WindowAdapter()public void windowClosing(WindowEvent arg0)System.exit(0););jta.setLineWrap(true);scr.setSize(200,100);scr.setBounds(45, 75, 400, 180);scr.setPreferredSize(new Dimension(200,400);scr.setEnabled(false);frame.add(scr);frame.setLayout(null);sno.setBounds(45, 35, 150, 20);frame.getContentPane().setBackground(Color.GREEN);frame.add(