基于python GUI实现的学生管理系统-课程设计 完整代码可直接运行

import javax.swing.*; import javax.swing.table.DefaultTableModel; import java.awt.*; import java.awt.event.ActionEvent; import java.awt.event.ActionListener; import java.sql.Connection; import java.sql.ResultSet; import java.sql.ResultSetMetaData; import java.sql.SQLException; import java.util.Vector; public class Mark_scan extends JFrame implements ActionListener { JTextField Text_Name=new JTextField(); JTextField Text_Phone=new JTextField(); //设置按钮 JButton Button_scan=new JButton("查询"); JButton Button_delete=new JButton("清除"); JTextField Text_id=new JTextField(); JTextField Text_name=new JTextField(); JComboBox Text_sex=new JComboBox(); JTextField Text_birthday=new JTextField(); JTextField Text_phone=new JTextField(); //按钮整合 JButton Button_reserve=new JButton("保存数据"); JButton Button_clear=new JButton("重置数据"); //按钮整合 JButton Button_add=new JButton("新增数据"); JButton Button_alter=new JButton("修改数据"); JButton Button_distro=new JButton("删除数据"); //设置中间部分的内容 Vector head=new Vector();//定义表头 { head.add("成绩编号"); head.add("学生编号"); head.add("学生姓名"); head.add("性别"); head.add("联系电话"); head.add("科目名称"); head.add("成绩"); } Vector data=new Vector(); DefaultTableModel dtm=new DefaultTableModel(data,head); JTable Table_scan=new JTable(dtm); //定义表格 JScrollPane Scroll=new JScrollPane(Table_scan); //设置标签 JLabel Label_id=new JLabel("id"); JLabel Label_name=new JLabel("姓名"); JLabel Label_sex=new JLabel("性别"); JLabel Label_birthday=new JLabel("生日"); JLabel Label_phone=new JLabel("电话号码"); //标签和文本进行整合 JPanel South_par_norther=new JPanel(); JPanel South_par_center=new JPanel(); public Mark_scan(){ this.setTitle("成绩浏览页面"); this.setSize(400,400); this.setLocationRelativeTo(null); //设置上标签 JLabel Label_Name=new JLabel("科目名称"); JLabel Label_Phone=new JLabel("学生姓名"); //整合上部分的标签和按钮 JPanel North_par=new JPanel(); North_par.setLayout(new GridLayout(1,6)); North_par.add(Label_Name); North_par.add(Text_Name); North_par.add(Label_Phone); North_par.add(Text_Phone); North_par.add(Button_scan); North_par.add(Button_delete); South_par_norther.setLayout(new GridLayout(5,2)); South_par_norther.add(Label_id); South_par_norther.add(Text_id); South_par_norther.add(Label_name); South_par_norther.add(Text_name); South_par_norther.add(Label_sex); South_par_norther.add(Text_sex); South_par_norther.add(Label_birthday); South_par_norther.add(Text_birthday); South_par_norther.add(Label_phone); South_par_norther.add(Text_phone); South_par_norther.setVisible(false); //隐藏数据 //下面部分的上面部分 //设置文本框 Text_sex.addItem("男"); Text_sex.addItem("女"); //下面部分的中间部分 South_par_center.setLayout(new GridLayout(1,2)); South_par_center.add(Button_reserve); South_par_center.add(Button_clear); South_par_center.setVisible(false); //下面部分的下面部分 JPanel South_par_south=new JPanel(); South_par_south.setLayout(new GridLayout(1,3)); South_par_south.add(Button_add); South_par_south.add(Button_alter); South_par_south.add(Button_distro); //整体汇总 //下部分汇总 JPanel South_sum=new JPanel(); South_sum.setLayout(new BorderLayout()); South_sum.add(South_par_norther,BorderLayout.NORTH); South_sum.add(South_par_center,BorderLayout.CENTER); South_sum.add(South_par_south,BorderLayout.SOUTH); //进行整体汇总 this.setLayout(new BorderLayout()); this.add(North_par,BorderLayout.NORTH); this.add(Scroll,BorderLayout.CENTER); this.add(South_sum,BorderLayout.SOUTH); //设置监听 getText_Name().addActionListener(this); getText_Phone().addActionListener(this); getButton_scan().addActionListener(this); getButton_delete().addActionListener(this); getButton_add().addActionListener(this); getButton_alter().addActionListener(this); getButton_distro().addActionListener(this); getButton_reserve().addActionListener(this); getButton_clear().addActionListener(this); } public JTextField getText_Name() { return Text_Name; } public JTextField getText_Phone() { return Text_Phone; } public JButton getButton_scan() { return Button_scan; } public JButton getButton_delete() { return Button_delete; } public JTextField getText_id() { return Text_id; } public JTextField getText_name() { return Text_name; } public JComboBox getText_sex() { return Text_sex; } public JTextField getText_birthday() { return Text_birthday; } public JTextField getText_phone() { return Text_phone; } public JButton getButton_reserve() { return Button_reserve; } public JButton getButton_clear() { return Button_clear; } public JButton getButton_add() { return Button_add; } public JButton getButton_alter() { return Button_alter; } public JButton getButton_distro() { return Button_distro; } public Vector getHead() { return head; } public Vector getData() { return data; } public DefaultTableModel getDtm() { return dtm; } public JTable getTable_scan() { return Table_scan; } public JScrollPane getScroll() { return Scroll; } public JLabel getLabel_id() { return Label_id; } public JLabel getLabel_name() { return Label_name; } public JLabel getLabel_sex() { return Label_sex; } public JLabel getLabel_birthday() { return Label_birthday; } public JLabel getLabel_phone() { return Label_phone; } public JPanel getSouth_par_norther() { return South_par_norther; } public JPanel getSouth_par_center() { return South_par_center; } @Override public void actionPerformed(ActionEvent e) { String Name=getText_Name().getText().trim(); String Phone=getText_Phone().getText().trim(); String name=getText_name().getText().trim(); String sex=getText_sex().getSelectedItem().toString(); String birthday=getText_birthday().getText().trim(); String phone=getText_phone().getText().trim(); String id=getText_id().getText().trim(); if(e.getSource().equals(getButton_scan())){ String sql="select m.id,s.id,s.name,s.sex,s.phone,m.kname,m.score " +"from student as s,mark as m " +"where s.id=m.sid " +" and s.name like ? and m.kname like ? order by s.id asc"; Vector vc=new Vector(); vc.add("%"+Phone+"%"); vc.add("%"+Name+"%"); try { Connection cn=Util.getConnection(); ResultSet rs=Util.select(sql,vc); this.setTable(rs); } catch (Exception ex) { ex.printStackTrace(); } }if(e.getSource().equals(getButton_delete())){ getText_Name().setText(""); getText_Phone().setText(""); JOptionPane.showMessageDialog(null,"已清空"); }if(e.getSo