基于Java+JDBC+Mysql实现的教务管理系统（完整源代码）

package operation; import java.awt.Color; import java.awt.Component; import java.awt.Dimension; import java.awt.Font; import java.awt.SystemColor; import java.awt.Toolkit; import java.awt.event.ActionEvent; import java.awt.event.ActionListener; import java.util.Vector; import javax.swing.JButton; import javax.swing.JCheckBox; import javax.swing.JFrame; import javax.swing.JLabel; import javax.swing.JOptionPane; import javax.swing.JPanel; import javax.swing.JScrollPane; import javax.swing.JTable; import javax.swing.ListSelectionModel; import javax.swing.SwingConstants; import javax.swing.table.DefaultTableModel; import javax.swing.table.TableCellRenderer; import DAO.Stu_DAO; import Infomation.All_info; public class S_InfoFrame extends JFrame{ private static String user; //����ʶ�����ĸ��û���½ //��ʾѧ����Ϣ�ı�ǩ private static JLabel s_numInfo; private static JLabel s_nameInfo; private static JLabel s_genderInfo; private static JLabel s_classInfo; private static JLabel s_brithdayInfo; // private JPanel stuInfo_Pane; //ѧ����Ϣ��� private static JTable table; //ѡ���б��� private JScrollPane courseList_Pane;//ѡ���б���� private JScrollPane selectedCourse_Pane; //��ѡ�γ���� private DefaultTableModel tableModel; //���ģ�� private Vector<Vector<Object>> rowData; //ѡ���б������� private Vector<String> columNames; //ѡ���б����� private static Stu_DAO info_dao; //��ѡ�γ� private JTable selectedTable; private DefaultTableModel seleTabModel; private Vector<Vector<Object>> sele_rowData; private Vector<String> sele_columNames; private int MAX_COURSE_NUM = 3; //����ѡ������γ��� public void init() { setTitle("����ϵͳ"); setSize(629, 512); setDefaultCloseOperation(JFrame.DISPOSE_ON_CLOSE); Toolkit tk=getToolkit(); Dimension dim=tk.getScreenSize(); int x,y; x=(int)(dim.getWidth()-500)/2; y=(int)(dim.getHeight()-500)/2; setLocation(x, y); } public S_InfoFrame(String user) { super(); this.user = user; info_dao = new Stu_DAO(this.user); getContentPane().setLayout(null); JLabel lblNewLabel = new JLabel("\u5B66\u751F\u9009\u8BFE\u7CFB\u7EDF"); lblNewLabel.setBounds(172, 10, 256, 76); lblNewLabel.setFont(new Font("���IJ���", Font.PLAIN, 30)); lblNewLabel.setHorizontalAlignment(SwingConstants.CENTER); getContentPane().add(lblNewLabel); JButton personal_info = new JButton("\u4E2A\u4EBA\u4FE1\u606F"); personal_info.setBounds(107, 90, 121, 32); getContentPane().add(personal_info); personal_info.addActionListener(new Action()); JButton course_list = new JButton("\u8BFE\u7A0B\u5217\u8868"); course_list.setBounds(238, 90, 121, 32); getContentPane().add(course_list); course_list.addActionListener(new Action()); JButton selected_course = new JButton("\u5DF2\u9009\u8BFE\u7A0B"); selected_course.setBounds(369, 90, 121, 32); getContentPane().add(selected_course); selected_course.addActionListener(new Action()); stuInfo_Pane = new JPanel(); stuInfo_Pane.setBounds(47, 151, 478, 312); stuInfo_Pane.setBackground(SystemColor.menu); stuInfo_Pane.setForeground(Color.BLACK); stuInfo_Pane.setToolTipText(""); getContentPane().add(stuInfo_Pane); stuInfo_Pane.setLayout(null); JLabel s_name = new JLabel("\u5B66\u751F\u59D3\u540D\uFF1A"); s_name.setBounds(21, 57, 85, 26); s_name.setFont(new Font("����", Font.BOLD, 12)); stuInfo_Pane.add(s_name); JLabel s_gender = new JLabel("\u5B66\u751F\u6027\u522B\uFF1A"); s_gender.setBounds(21, 105, 85, 26); s_gender.setFont(new Font("����", Font.BOLD, 12)); stuInfo_Pane.add(s_gender); JLabel s_brithday = new JLabel("\u5B66\u751F\u751F\u65E5\uFF1A"); s_brithday.setBounds(21, 151, 85, 26); s_brithday.setFont(new Font("����", Font.BOLD, 12)); stuInfo_Pane.add(s_brithday); JLabel s_class = new JLabel("\u5B66\u751F\u73ED\u7EA7\uFF1A"); s_class.setBounds(21, 194, 85, 26); s_class.setFont(new Font("����", Font.BOLD, 12)); stuInfo_Pane.add(s_class); s_numInfo = new JLabel(""); s_numInfo.setBounds(116, 10, 244, 37); s_numInfo.setHorizontalAlignment(SwingConstants.CENTER); stuInfo_Pane.add(s_numInfo); s_nameInfo = new JLabel(""); s_nameInfo.setBounds(116, 58, 235, 37); s_nameInfo.setHorizontalAlignment(SwingConstants.CENTER); stuInfo_Pane.add(s_nameInfo); s_genderInfo = new JLabel(""); s_genderInfo.setBounds(116, 104, 235, 37); s_genderInfo.setHorizontalAlignment(SwingConstants.CENTER); stuInfo_Pane.add(s_genderInfo); s_brithdayInfo = new JLabel(""); s_brithdayInfo.setBounds(116, 140, 235, 37); s_brithdayInfo.setHorizontalAlignment(SwingConstants.CENTER); stuInfo_Pane.add(s_brithdayInfo); s_classInfo = new JLabel(""); s_classInfo.setBounds(116, 194, 235, 37); s_classInfo.setHorizontalAlignment(SwingConstants.CENTER); stuInfo_Pane.add(s_classInfo); JLabel s_num = new JLabel("\u5B66\u751F\u5B66\u53F7\uFF1A"); s_num.setBounds(21, 20, 578, 15); stuInfo_Pane.add(s_num); s_num.setFont(new Font("����", Font.BOLD, 12)); JButton modify_pwd = new JButton("\u4FEE\u6539\u5BC6\u7801"); modify_pwd.setBounds(210, 256, 93, 34); modify_pwd.addActionListener(new Action()); stuInfo_Pane.add(modify_pwd); courseList_Pane = new JScrollPane(); courseList_Pane.setBounds(19, 151, 580, 253); courseList_Pane.setVisible(false); getContentPane().add(courseList_Pane); columNames = new Vector<>(); columNames.add(""); columNames.add("�γ̱��"); columNames.add("�γ�����"); columNames.add("ѧ��"); columNames.add("�ον�ʦ"); columNames.add("��ʦְ��"); columNames.add("�Ͽεص�"); columNames.add("��ѡ����"); rowData = info_dao.getCLVector(); tableModel = new DefaultTableModel(rowData, columNames); table = new JTable(tableModel); table.setSelectionMode(ListSelectionModel.MULTIPLE_INTERVAL_SELECTION); courseList_Pane.setViewportView(table); table.setSelectionMode(ListSelectionModel.MULTIPLE_INTERVAL_SELECTION); table.getColumnModel().getColumn(0).setCellRenderer(new TableCellRenderer(){ /*(non-Javadoc) * �˷�������ijһ��Ԫ�����Ⱦ��������ʾ���ݵ��齨--��ؼ��� * ����ΪJCheckBox JComboBox JTextArea �� * @see javax.swing.table.TableCellRenderer#getTableCellRendererComponent(javax.swing.JTable, java.lang.Object, boolean, boolean, int, int) */ @Override public Component getTableCellRendererComponent(JTable table, Object value, boolean isSelected, boolean hasFocus, int row, int column) { // �������ڷ��ص���Ⱦ��� JCheckBox ck = new JCheckBox(); // ʹ���н�����ж�Ӧ�ĸ�ѡ��ѡ�� ck.setSelected(isSelected); ck.setSelected(hasFocus); // table.findComponentAt(); // ʹ��ѡ���ڵ�Ԫ���ھ�����ʾ ck.setHorizontalAlignment((int) 0.5f); return ck; }}); table.setSelectionMode(ListSelectionModel.MULTIPLE_INTERVAL_SELECTION); //��ѡ�γ���� selectedCourse_Pane = new JScrollPane(); selectedCourse_Pane.setBounds(19, 150, 584, 313); getContentPane().add(selectedCourse_Pane); selectedTable = new JTable(); //��ѡ�γ̱�� sele_columNames = new Vector<