changebaseinfo.java

学生档案管理系统

        labSHomeTown.setFont(new java.awt.Font("Dialog", 0, 15));
        labSHomeTown.setText("籍      贯 ");
        txtSHomeTown.setText(strHomeTown);
        
        labSJob.setFont(new java.awt.Font("Dialog", 0, 15));
        labSJob.setText("职      务 ");
        txtSJob.setText(strJob);
        
        labSMinzu.setFont(new java.awt.Font("Dialog", 0, 15));
        labSMinzu.setText("民      族 ");
        txtSMinzu.setText(strMinzu);
        
        labSID.setFont(new java.awt.Font("Dialog", 0, 15));
        labSID.setText("身份证 ");
        txtSID.setText(strID);
        
        labSComeTime.setFont(new java.awt.Font("Dialog", 0, 15));
        labSComeTime.setText("入学时间 ");
        txtSComeTime.setText(strComeTime);
        
        labSAddress.setFont(new java.awt.Font("Dialog", 0, 15));
        labSAddress.setText("家庭住址 ");        
        txtSAddress.setText(strAddress);
        
        sure.setText("确定");
        sure.addActionListener(new changeBaseInfo_sure_actionAdapter(this));
        cancel.setText("取消");
        cancel.addActionListener(new changeBaseInfo_cancel_actionAdapter(this));

        panel.setBorder(BorderFactory.createLoweredBevelBorder());
        panel.setLayout(new GridBagLayout());
        LayoutUtil.add(panel,GridBagConstraints.NONE,GridBagConstraints.CENTER,0,0,0,0,1,1,labSNum);
        LayoutUtil.add(panel,GridBagConstraints.HORIZONTAL,GridBagConstraints.CENTER,1,0,1,0,1,1,txtSNum);
        LayoutUtil.add(panel,GridBagConstraints.NONE,GridBagConstraints.CENTER,0,0,2,0,1,1,labSName);
        LayoutUtil.add(panel,GridBagConstraints.HORIZONTAL,GridBagConstraints.CENTER,1,0,3,0,1,1,txtSName);
        
        LayoutUtil.add(panel,GridBagConstraints.NONE,GridBagConstraints.CENTER,0,0,0,1,1,1,labSDept);
        LayoutUtil.add(panel,GridBagConstraints.HORIZONTAL,GridBagConstraints.CENTER,1,0,1,1,1,1,txtSDept);
        LayoutUtil.add(panel,GridBagConstraints.NONE,GridBagConstraints.CENTER,0,0,2,1,1,1,labSBirth);
        LayoutUtil.add(panel,GridBagConstraints.HORIZONTAL,GridBagConstraints.CENTER,1,0,3,1,1,1,txtSBirth);
        
        LayoutUtil.add(panel,GridBagConstraints.NONE,GridBagConstraints.CENTER,0,0,0,2,1,1,labSState);
        LayoutUtil.add(panel,GridBagConstraints.HORIZONTAL,GridBagConstraints.CENTER,1,0,1,2,1,1,txtSState);
        LayoutUtil.add(panel,GridBagConstraints.NONE,GridBagConstraints.CENTER,0,0,2,2,1,1,labSHomeTown);
        LayoutUtil.add(panel,GridBagConstraints.HORIZONTAL,GridBagConstraints.CENTER,1,0,3,2,1,1,txtSHomeTown);
        
        LayoutUtil.add(panel,GridBagConstraints.NONE,GridBagConstraints.CENTER,0,0,0,3,1,1,labSSex);
        LayoutUtil.add(panel,GridBagConstraints.HORIZONTAL,GridBagConstraints.CENTER,1,0,1,3,1,1,txtSSex);
        LayoutUtil.add(panel,GridBagConstraints.NONE,GridBagConstraints.CENTER,0,0,2,3,1,1,labSMaj);
        LayoutUtil.add(panel,GridBagConstraints.HORIZONTAL,GridBagConstraints.CENTER,1,0,3,3,1,1,txtSMaj);
        
        LayoutUtil.add(panel,GridBagConstraints.NONE,GridBagConstraints.CENTER,0,0,0,4,1,1,labSClass);
        LayoutUtil.add(panel,GridBagConstraints.HORIZONTAL,GridBagConstraints.CENTER,1,0,1,4,1,1,txtSClass);
        LayoutUtil.add(panel,GridBagConstraints.NONE,GridBagConstraints.CENTER,0,0,2,4,1,1,labSJob);
        LayoutUtil.add(panel,GridBagConstraints.HORIZONTAL,GridBagConstraints.CENTER,1,0,3,4,1,1,txtSJob);
        
        LayoutUtil.add(panel,GridBagConstraints.NONE,GridBagConstraints.CENTER,0,0,0,5,1,1,labSMinzu);
        LayoutUtil.add(panel,GridBagConstraints.HORIZONTAL,GridBagConstraints.CENTER,1,0,1,5,1,1,txtSMinzu);
        LayoutUtil.add(panel,GridBagConstraints.NONE,GridBagConstraints.CENTER,0,0,2,5,1,1,labSComeTime);
        LayoutUtil.add(panel,GridBagConstraints.HORIZONTAL,GridBagConstraints.CENTER,1,0,3,5,1,1,txtSComeTime);
        
        LayoutUtil.add(panel,GridBagConstraints.NONE,GridBagConstraints.CENTER,0,0,0,6,1,1,labSID);
        LayoutUtil.add(panel,GridBagConstraints.HORIZONTAL,GridBagConstraints.CENTER,1,0,1,6,1,1,txtSID);
        LayoutUtil.add(panel,GridBagConstraints.NONE,GridBagConstraints.CENTER,0,0,2,6,1,1,labSGadute);
        LayoutUtil.add(panel,GridBagConstraints.HORIZONTAL,GridBagConstraints.CENTER,1,0,3,6,1,1,txtSGradute);
        
        LayoutUtil.add(panel,GridBagConstraints.NONE,GridBagConstraints.CENTER,0,0,0,7,1,1,labSAddress);
        LayoutUtil.add(panel,GridBagConstraints.HORIZONTAL,GridBagConstraints.CENTER,1,0,1,7,1,1,txtSAddress);
        
        panelb.setLayout(new GridBagLayout());
        LayoutUtil.add(panelb,GridBagConstraints.NONE,GridBagConstraints.CENTER,0,0,0,0,1,1,sure);
        LayoutUtil.add(panelb,GridBagConstraints.HORIZONTAL,GridBagConstraints.CENTER,0,0,1,0,1,1,cancel);
       
        this.getContentPane().add(panel,BorderLayout.CENTER);
        this.getContentPane().add(panelb,BorderLayout.SOUTH);
        this.setBounds(100, 100, 400, 300);
        this.setVisible(true);
    }
void cancel_actionPerformed(ActionEvent e) {
        this.dispose();
    }
   void sure_actionPerformed(ActionEvent e) {
            JOptionPane.showConfirmDialog(null,"确定修改？", "修改基本信息", JOptionPane.YES_NO_OPTION);
            try {
                try {
                    Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
                    Connection con = DriverManager.getConnection("jdbc:odbc:学生档案","", "");
                    ps = con.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_READ_ONLY);
                }
                catch (Exception err) {
                    String error = err.getMessage();
                    JOptionPane.showMessageDialog(null, "连接数据库错误!");
                }
                try {
                    /*String strSNum = "'"+txtSNum.getText().trim()+"'";
                    String strSName = "'"+txtSName.getText().trim()+"'";
                    String strSSex = "'"+txtSSex.getText().trim()+"'";
                    String strSClass = "'"+txtSClass.getText().trim()+"'";
                    String strSMaj = "'"+txtSMaj.getText().trim()+"'";
                    String strSDept = "'"+txtSDept.getText().trim()+"'";
                    String strSID = "'"+txtSID.getText().trim()+"'";
                    String strSBirth = "'"+txtSBirth.getText().trim()+"'";
                    String strSJob = "'"+txtSJob.getText().trim()+"'";
                    String strSComeTime = "'"+txtSComeTime.getText().trim()+"'";
                    String strSGradute = "'"+txtSGradute.getText().trim()+"'";
                    String strSAddress = "'"+txtSAddress.getText().trim()+"'";
                    String strSState = "'"+txtSState.getText().trim()+"'";
                    String strSMinzu = "'"+txtSMinzu.getText().trim()+"'";
                    String strSHomeTown = "'"+txtSHomeTown.getText().trim()+"'";  
                     * */   
                    strNum = "'"+txtSNum.getText().trim()+"'";
                    strName = "'"+txtSName.getText().trim()+"'";
                    strSex = "'"+txtSSex.getText().trim()+"'";
                    strClass = "'"+txtSClass.getText().trim()+"'";
                    strMaj = "'"+txtSMaj.getText().trim()+"'";
                    strDept = "'"+txtSDept.getText().trim()+"'";
                    strID = "'"+txtSID.getText().trim()+"'";
                    strBirth = "'"+txtSBirth.getText().trim()+"'";
                    strJob = "'"+txtSJob.getText().trim()+"'";
                    strComeTime = "'"+txtSComeTime.getText().trim()+"'";
                    strGradute = "'"+txtSGradute.getText().trim()+"'";
                    strAddress = "'"+txtSAddress.getText().trim()+"'";
                    strState = "'"+txtSState.getText().trim()+"'";
                    strMinzu = "'"+txtSMinzu.getText().trim()+"'";
                    strHomeTown = "'"+txtSHomeTown.getText().trim()+"'";  
                    String sqlStr = "Update 基本档案信息表 set 学号 =" +strNum +",姓名=" +strName+ ",出生日期=" +strBirth+ ",政治面貌=" +strState+ ",民族=" +strMinzu+ ",性别=" +strSex+ ",学院=" +strDept+ ",专业=" +strMaj+ ",班级=" +strClass+ ",毕业高中=" +strGradute+ ",籍贯="+strHomeTown+ ",职务=" +strJob+ ",身份证=" +strID+ ",入学时间=" +strComeTime+ ",家庭住址 =" +strAddress+ "where 学号=" +"'"+MainFrame.strSNum+"'";       
                    ps.execute(sqlStr); 
                    ps.close();                   
                    JOptionPane.showMessageDialog(null, "修改成功");
                    this.dispose();
                }
                catch (SQLException sqle) {
                    String error = sqle.getMessage();
                    JOptionPane.showMessageDialog(null, error);
                    sqle.printStackTrace();
                }

            }
            catch (Exception ex) {
                ex.getMessage();
                String error = ex.getMessage();
                JOptionPane.showMessageDialog(null, error);
                ex.printStackTrace();
            }
        }
    }
class changeBaseInfo_cancel_actionAdapter
    implements java.awt.event.ActionListener {
    ChangeBaseInfo adaptee;

    changeBaseInfo_cancel_actionAdapter(ChangeBaseInfo adaptee) {
        this.adaptee = adaptee;
    }
    public void actionPerformed(ActionEvent e) {
        adaptee.cancel_actionPerformed(e);
    }
}

class changeBaseInfo_sure_actionAdapter
    implements java.awt.event.ActionListener {
    ChangeBaseInfo adaptee;

    changeBaseInfo_sure_actionAdapter(ChangeBaseInfo adaptee) {
        this.adaptee = adaptee;
    }

    public void actionPerformed(ActionEvent e) {
        adaptee.sure_actionPerformed(e);
    }
}