基于Java swing带GUI界面的学生成绩管理系统源码+数据库（95分以上）.zip

package com.lichungang.view.studentClass; import java.awt.BorderLayout; import java.awt.Color; import java.awt.EventQueue; import java.awt.Font; import java.util.List; import java.util.Vector; import javax.swing.JFrame; import javax.swing.JInternalFrame; import javax.swing.JPanel; import javax.swing.border.EmptyBorder; import javax.swing.JScrollPane; import javax.swing.JTable; import javax.swing.table.DefaultTableCellRenderer; import javax.swing.table.DefaultTableModel; import com.lichungang.dao.ClassDao; import com.lichungang.model.StudentClass; import com.lichungang.util.StrUtil; import javax.swing.JLabel; import javax.swing.JOptionPane; import javax.swing.JTextField; import javax.swing.JButton; import javax.swing.ImageIcon; import java.awt.Toolkit; import java.awt.event.ActionListener; import java.awt.event.ActionEvent; import java.awt.event.MouseAdapter; import java.awt.event.MouseEvent; public class ClassListFrame extends JInternalFrame { private JPanel contentPane; private JTable classListTable; private JTable table_1; private JTable table_2; private JTextField className; private JTextField classSecondary; private JTextField classGrade; private JTextField classMajor; private JButton editButton; private JButton deleteButton; private DefaultTableModel dtm = null; /** * Launch the application. */ /** * Create the frame. */ public ClassListFrame() { setTitle("班级管理-班级列表"); setClosable(true); setIconifiable(true); getContentPane().setFont(new Font("微软雅黑",Font.PLAIN,13)); getContentPane().setBackground(new Color(245,245,245)); setBounds(100, 100, 901, 562); getContentPane().setLayout(null); JScrollPane scrollPane = new JScrollPane(); scrollPane.setBounds(24, 51, 851, 283); getContentPane().add(scrollPane); classListTable = new JTable(); classListTable.addMouseListener(new MouseAdapter() { @Override public void mouseClicked(MouseEvent e) { selectRow(e); } }); classListTable.setFont(new Font("微软雅黑", Font.PLAIN, 12)); classListTable.setForeground(Color.BLACK); //设置用户不可拖动 classListTable.getTableHeader().setReorderingAllowed(false); //设置表格高度 classListTable.setRowHeight(25); //设置表格居中显示 DefaultTableCellRenderer r = new DefaultTableCellRenderer(); r.setHorizontalAlignment(JLabel.CENTER); classListTable.setDefaultRenderer(Object.class, r); classListTable.setModel(new DefaultTableModel( new Object[][] { }, new String[] { "\u73ED\u7EA7\u7F16\u53F7", "\u73ED\u7EA7\u540D\u79F0", "\u6240\u5C5E\u4E13\u4E1A", "\u6240\u5C5E\u5E74\u7EA7", "\u6240\u5C5E\u5B66\u9662", "\u73ED\u7EA7\u4FE1\u606F" } )); classListTable.getColumnModel().getColumn(0).setPreferredWidth(100); classListTable.getColumnModel().getColumn(0).setMinWidth(100); classListTable.getColumnModel().getColumn(0).setMaxWidth(100); classListTable.getColumnModel().getColumn(1).setPreferredWidth(150); classListTable.getColumnModel().getColumn(1).setMinWidth(150); classListTable.getColumnModel().getColumn(1).setMaxWidth(150); classListTable.getColumnModel().getColumn(2).setPreferredWidth(160); classListTable.getColumnModel().getColumn(2).setMinWidth(160); classListTable.getColumnModel().getColumn(2).setMaxWidth(160); classListTable.getColumnModel().getColumn(3).setPreferredWidth(100); classListTable.getColumnModel().getColumn(3).setMinWidth(100); classListTable.getColumnModel().getColumn(3).setMaxWidth(100); classListTable.getColumnModel().getColumn(4).setPreferredWidth(130); classListTable.getColumnModel().getColumn(4).setMinWidth(130); classListTable.getColumnModel().getColumn(4).setMaxWidth(130); classListTable.getColumnModel().getColumn(5).setPreferredWidth(210); classListTable.getColumnModel().getColumn(5).setMinWidth(210); classListTable.getColumnModel().getColumn(5).setMaxWidth(210); scrollPane.setViewportView(classListTable); JLabel lblNewLabel = new JLabel("\u73ED\u7EA7\u540D\u79F0"); lblNewLabel.setFont(new Font("微软雅黑", Font.PLAIN, 13)); lblNewLabel.setBounds(51, 386, 52, 23); getContentPane().add(lblNewLabel); JLabel lblNewLabel_1 = new JLabel("\u6240\u5C5E\u5B66\u9662"); lblNewLabel_1.setFont(new Font("微软雅黑", Font.PLAIN, 13)); lblNewLabel_1.setBounds(51, 453, 52, 23); getContentPane().add(lblNewLabel_1); JLabel lblNewLabel_2 = new JLabel("\u6240\u5C5E\u5E74\u7EA7"); lblNewLabel_2.setFont(new Font("微软雅黑", Font.PLAIN, 13)); lblNewLabel_2.setBounds(218, 386, 52, 23); getContentPane().add(lblNewLabel_2); JLabel lblNewLabel_3 = new JLabel("\u6240\u5C5E\u4E13\u4E1A"); lblNewLabel_3.setFont(new Font("微软雅黑", Font.PLAIN, 13)); lblNewLabel_3.setBounds(218, 453, 52, 23); getContentPane().add(lblNewLabel_3); className = new JTextField(); className.setFont(new Font("微软雅黑", Font.PLAIN, 13)); className.setBounds(109, 388, 99, 21); getContentPane().add(className); className.setColumns(10); classSecondary = new JTextField(); classSecondary.setFont(new Font("微软雅黑", Font.PLAIN, 13)); classSecondary.setColumns(10); classSecondary.setBounds(109, 453, 99, 21); getContentPane().add(classSecondary); classGrade = new JTextField(); classGrade.setFont(new Font("微软雅黑", Font.PLAIN, 13)); classGrade.setColumns(10); classGrade.setBounds(281, 388, 99, 21); getContentPane().add(classGrade); classMajor = new JTextField(); classMajor.setFont(new Font("微软雅黑", Font.PLAIN, 13)); classMajor.setColumns(10); classMajor.setBounds(280, 455, 99, 21); getContentPane().add(classMajor); JButton btnNewButton = new JButton("\u641C\u7D22"); btnNewButton.addActionListener(new ActionListener() { public void actionPerformed(ActionEvent e) { selectSomeClass(e); } }); btnNewButton.setIcon(new ImageIcon(ClassListFrame.class.getResource("/images/\u641C\u7D22.png"))); btnNewButton.setFont(new Font("微软雅黑", Font.PLAIN, 13)); btnNewButton.setBounds(475, 387, 93, 23); getContentPane().add(btnNewButton); deleteButton = new JButton("删除"); deleteButton.addActionListener(new ActionListener() { public void actionPerformed(ActionEvent e) { deleteButton(e); } }); deleteButton.setIcon(new ImageIcon(ClassListFrame.class.getResource("/images/\u5220 \u9664 .png"))); deleteButton.setFont(new Font("微软雅黑", Font.PLAIN, 13)); deleteButton.setBounds(625, 387, 93, 23); getContentPane().add(deleteButton); JButton btnNewButton_2 = new JButton("重置"); btnNewButton_2.addActionListener(new ActionListener() { public void actionPerformed(ActionEvent e) { resetButton(); } }); btnNewButton_2.setIcon(new ImageIcon(ClassListFrame.class.getResource("/images/\u65CB\u8F6C.png"))); btnNewButton_2.setFont(new Font("微软雅黑", Font.PLAIN, 13)); btnNewButton_2.setBounds(475, 454, 93, 23); getContentPane().add(btnNewButton_2); editButton = new JButton("编辑"); editButton.setIcon(new ImageIcon(ClassListFrame.class.getResource("/images/\u7F16\u8F91.png"))); editButton.setFont(new Font("微软雅黑", Font.PLAIN, 13)); editButton.setBounds(625, 454, 93, 23); getContentPane().add(editButton); this.dtm = (DefaultTableModel)classListTable.getModel(); queryAllClass(); } //删除按钮动作-删除班级 protected void deleteButton(ActionEvent e) { // TODO Auto-generated method stub if(JOptionPane.showConfirmDialog(this, "是否删除此班级？","正在删除班级。。。",JOptionPane.YES_NO_OPTION) == JOptionPane.OK_OPTION) { String id = dtm.getValueAt(this.classListTable.getSelectedRow(),0).toString(); ClassDao classDao = new ClassDao(); JOptionPane.showMessageDialog(this, classDao.deleteStudentClass(id)); queryAllClass(); } } //table-具体点击事件 protected void selectRow(MouseEvent e) { // TODO Auto-generated method stub this.className.setText(dtm.getValueAt(this.classListTable.getSelectedRow(),1).toString()); this.classGrade.setText(dtm.getValueAt(this.class