kingframe1.java

学生信息管理系统

        jLabel25.setText("Html");
        jLabel25.setBounds(new Rectangle(210, 140, 31, 24));
        jLabel26.setText("Sql");
        jLabel26.setBounds(new Rectangle(49, 185, 26, 25));
        jLabel27.setText("Java");
        jLabel27.setBounds(new Rectangle(210, 190, 34, 15));
        jMenuItem3.setText("删除学生信息");
        jMenuItem3.addActionListener(new kingFrame1_jMenuItem3_actionAdapter(this));
        jMenuItem13.setText("修改密码");
        jMenuItem13.addActionListener(new kingFrame1_jMenuItem13_actionAdapter(this));
        jPanel9.setLayout(null);
        jLabel28.setFont(new java.awt.Font("宋体", Font.PLAIN, 25));
        jLabel28.setText("密码修改");
        jLabel28.setBounds(new Rectangle(135, 19, 108, 32));
        jLabel29.setText("请输入帐号");
        jLabel29.setBounds(new Rectangle(32, 61, 80, 15));
        jLabel30.setText("请输入原始密码");
        jLabel30.setBounds(new Rectangle(29, 99, 88, 15));
        jLabel31.setText("请输入新密码");
        jLabel31.setBounds(new Rectangle(33, 143, 80, 15));
        jLabel32.setText("请确认新密码");
        jLabel32.setBounds(new Rectangle(30, 181, 80, 15));
        jTextField12.setBounds(new Rectangle(146, 58, 139, 20));
        jPasswordField4.setBounds(new Rectangle(146, 97, 141, 24));
        jPasswordField5.setBounds(new Rectangle(147, 136, 141, 24));
        jPasswordField6.setBounds(new Rectangle(146, 177, 141, 24));
        jButton18.setBounds(new Rectangle(146, 253, 87, 23));
        jButton18.setText("重置");
        jButton18.addActionListener(new kingFrame1_jButton18_actionAdapter(this));
        jButton19.setBounds(new Rectangle(267, 253, 87, 23));
        jButton19.setText("退出");
        jButton19.addActionListener(new kingFrame1_jButton19_actionAdapter(this));
        jButton20.setBounds(new Rectangle(43, 252, 87, 23));
        jButton20.setText("确认");
        jButton20.addActionListener(new kingFrame1_jButton20_actionAdapter(this));
        jScrollPane2.setBounds(new Rectangle(149, 66, 138, 28));
        jScrollPane3.setBounds(new Rectangle(182, 121, 167, 29));
        contentPane.add(jPanel2, "jPanel2");
        jPanel2.add(jLabel4);
        jPanel2.add(jLabel5);
        contentPane.add(jPanel1, "jPanel1");
        jPanel1.add(jLabel1);
        jPanel1.add(jLabel3);
        jPanel1.add(jButton2);
        jPanel1.add(jButton1);
        jPanel1.add(jLabel2);
        jPanel1.add(jPasswordField1);
        jPanel1.add(jTextField1);
        jMenuBar1.add(jMenu1);
        jMenuBar1.add(jMenu2);
        jMenuBar1.add(jMenu3);
        jMenuBar1.add(jMenu4);
        jMenu1.add(jMenuItem10);
        jMenu1.add(jMenuItem1);
        jMenu1.add(jMenuItem2);
        jMenu1.add(jMenuItem3);
        jMenu1.add(jMenuItem12);
        jMenu2.add(jMenuItem11);
        jMenu2.add(jMenuItem4);
        jMenu2.add(jMenuItem5);
        jMenu2.add(jMenuItem6);
        jMenu2.add(jMenuItem13);
        jMenu3.add(jMenuItem7);
        jMenu3.add(jMenuItem8);
        jMenu4.add(jMenuItem9);
        contentPane.add(jPanel3, "jPanel3");
        jPanel3.add(jScrollPane1, java.awt.BorderLayout.CENTER);
        contentPane.add(jPanel4, "jPanel4");
        jPanel4.add(jButton4);
        jPanel4.add(jButton3);
        jPanel4.add(jButton5);
        jPanel4.add(jLabel6);
        jPanel4.add(jLabel8);
        jPanel4.add(jComboBox1);
        jPanel4.add(jLabel9);
        jPanel4.add(jComboBox3);
        jPanel4.add(jTextField2);
        jPanel4.add(jLabel7);
        jPanel4.add(jScrollPane2);
        contentPane.add(jPanel5, "jPanel5");
        jPanel5.add(jButton6);
        jPanel5.add(jButton7);
        jPanel5.add(jButton8);
        jPanel5.add(jLabel12);
        jPanel5.add(jLabel11);
        jPanel5.add(jLabel10);
        jPanel5.add(jScrollPane3);
        jPanel6.add(jLabel15);
        jPanel6.add(jTextField3);
        jPanel6.add(jLabel13);
        jPanel6.add(jLabel14);
        jPanel6.add(jButton9);
        jPanel6.add(jButton10);
        jPanel6.add(jButton11);
        jPanel6.add(jPasswordField2);
        jPanel7.add(jLabel16);
        jPanel7.add(jTextField4);
        jPanel7.add(jLabel17);
        jPanel7.add(jTextField5);
        jPanel7.add(jPasswordField3);
        jPanel7.add(jButton12);
        jPanel7.add(jButton13);
        jPanel7.add(jButton14);
        jPanel7.add(jLabel18);
        jPanel7.add(jLabel19);
        contentPane.add(jPanel6, "jPanel6");
        contentPane.add(jPanel7, "jPanel7");
        contentPane.add(jPanel8, "jPanel8");
        jPanel8.add(jLabel21);
        jPanel8.add(jTextField6);
        jPanel8.add(jLabel23);
        jPanel8.add(jTextField9);
        jPanel8.add(jButton15);
        jPanel8.add(jLabel25);
        jPanel8.add(jTextField8);
        jPanel8.add(jLabel24);
        jPanel8.add(jTextField10);
        jPanel8.add(jLabel26);
        jPanel8.add(jLabel27);
        jPanel8.add(jTextField11);
        jPanel8.add(jLabel22);
        jPanel8.add(jTextField7);
        jPanel8.add(jLabel20);
        jPanel8.add(jButton16);
        jPanel8.add(jButton17);
        contentPane.add(jPanel9, "jPanel9");
        jPanel9.add(jLabel28);
        jPanel9.add(jLabel29);
        jPanel9.add(jLabel32);
        jPanel9.add(jLabel31);
        jPanel9.add(jTextField12);
        jPanel9.add(jPasswordField6);
        jPanel9.add(jLabel30);
        jPanel9.add(jPasswordField4);
        jPanel9.add(jPasswordField5);
        jPanel9.add(jButton20);
        jPanel9.add(jButton18);
        jPanel9.add(jButton19);
    }

    //退出 (完成)
    public void jMenuItem9_actionPerformed(ActionEvent actionEvent) {
        System.exit(0);
        try {
            con.close();
        } catch (SQLException ex) {
        }
    }

    //帮助中的版本信息 (完成)
    public void jMenuItem7_actionPerformed(ActionEvent actionEvent) {
        JOptionPane.showMessageDialog(JF, " 学生管理系统  1.0版", "消息",
                                      JOptionPane.CLOSED_OPTION);
    }

    //登陆 (完成)
    public void jMenuItem10_actionPerformed(ActionEvent e) {
        jTextField1.setText("");
        jPasswordField1.setText("");
        cardLayout1.show(contentPane, "jPanel1");
    }

    //查询信息 (完成)
    public void jMenuItem1_actionPerformed(ActionEvent e) {

        if (kingFrame1obj) {
            JTable jTable2 = null;
            jTable2 = jtbobj();
            JTableHeader jtobj1 = jTable2.getTableHeader();
            jPanel3.add(jtobj1,BorderLayout.NORTH);
            jScrollPane1.getViewport().add(jTable2);
            cardLayout1.show(contentPane, "jPanel3");
        } else {
            mm();
        }
    }

    public JTable jtbobj(){
        Object selsctxs[][] = getTableData();
        JTable jTableobj = new JTable(selsctxs, strobj3);
                return jTableobj;
    }

    //查询并将数据库结果转换成二维数组
    public Object[][] getTableData() {
        ArrayList lstData = new ArrayList();
        ArrayList lstRow = null;
        Object[][] data = null;
        try {
            String strSQL = "SELECT * FROM xuesheng";
            ResultSet rs = this.con.createStatement().executeQuery(strSQL);
            int colCount = rs.getMetaData().getColumnCount();
            int rowCount = 0;
            while (rs.next()) {
                lstRow = new ArrayList();
                for (int i = 2; i <= colCount; i++) {
                    lstRow.add(rs.getObject(i));
                }
                rowCount++;
                lstData.add(lstRow);
            }
            rs.close();
            int maxColCount = 0;
            for (int i = 0; i < lstData.size(); i++) {
                int s = ((ArrayList) (lstData.get(i))).size();
                if (s > maxColCount)
                    maxColCount = s;
            }
            data = new Object[lstData.size()][maxColCount];
            for (int i = 0; i < lstData.size(); i++) {
                ArrayList lstTemp = (ArrayList) (lstData.get(i));
                for (int j = 0; j < lstTemp.size(); j++) {
                    data[i][j] = (lstTemp.get(j) == null ? ("<null>") :
                                  (lstTemp.get(j)));
                }
            }
        } catch (SQLException e) {
            e.printStackTrace();
        }
        return data;
    }

    //更改信息(完成)
    public void jMenuItem2_actionPerformed(ActionEvent e) {
        if (kingFrame1obj) {
            if (kks) {
                jTextField2.setText("");
                jComboBox1.setSelectedIndex(0);
                jComboBox2.setSelectedIndex(0);
                jComboBox3.setSelectedIndex(0);
            } else {
                jComboBox2 = null;
                JComboBox jComboBoxobj = null;
                jComboBoxobj = jComboBox2_getjComboBox();
                jScrollPane2.getViewport().add(jComboBoxobj);
                JComboBox2_Public(jComboBoxobj);
            }
            cardLayout1.show(contentPane, "jPanel4");
        } else {
            mm();
        }
    }
    //让jComboBox2变成全局变量
    void JComboBox2_Public(JComboBox obj){
        jComboBox2 = obj;
    }
    //一个返回JComboBox的方法！对jComboBox2添加元素
    JComboBox jComboBox2_getjComboBox(){
        JComboBox jcbobj = new JComboBox();
        try {
            jcbobj.addItem("请选择要更改的用户");
            ss = con.createStatement();
            strsql = "select * from xuesheng";
            select();
            while (result.next()) {
                jcbobj.addItem(result.getObject(2));
            }
            result.close();
            ss.close();
            return jcbobj;
        } catch (SQLException ex) {
            ex.printStackTrace();
        }
        return jcbobj;
    }
    //删除信息
    public void jMenuItem3_actionPerformed(ActionEvent e) {
        if (kingFrame1obj) {
            if (kkb) {
                jComboBox4.setSelectedIndex(0);
            } else {
                jComboBox4 = null;
                JComboBox jComboBoxobj1 = null;
                jComboBoxobj1 = jComboBox4_getjComboBox();
                jScrollPane3.getViewport().add(jComboBoxobj1);
                JComboBox4_Public(jComboBoxobj1);
            }
            cardLayout1.show(contentPane, "jPanel5");
        } else {
            mm();
        }
    }
    //返回一个JComboBox4的内容
    JComboBox jComboBox4_getjComboBox(){
        JComboBox jcbobj = new JComboBox();
        try {
            jcbobj.addItem("请选择要删除的用户");
            ss = con.createStatement();
            strsql = "select * from xuesheng";
            select();
            while (result.next()) {
                jcbobj.addItem(result.getObject(2));
            }
            result.close();
            ss.close();
            return jcbobj;
        } catch (SQLException ex) {
            ex.printStackTrace();
        }
        return jcbobj;
    }
    //让JComboBox4变成共有
    void JComboBox4_Public(JComboBox obj){
        jComboBox4 = obj;
    }

    //添加用户
    public void jMenuItem4_actionPerformed(ActionEvent e) {
        if (kingFrame1obj) {
            jTextField6.setText("");
            jTextField7.setText("");
            jTextField8.setText("");
            jTextField9.setText("");
            jTextField10.setText("");
            jTextField11.setText("");
            cardLayout1.show(contentPane, "jPanel6");
        } else {
            mm();
        }
    }

    //删除用户
    public void jMenuItem5_actionPerformed(ActionEvent e) {
        if (kingFrame1obj) {
            JOptionPane.showMessageDialog(JF, "本功能仅对超级管理员开放！请确认您是超级管理员", "消息",
                                          JOptionPane.CLOSED_OPTION);
            cardLayout1.show(contentPane, "jPanel7");
        } else {
            mm();
        }
    }