update_dialog.java

用java写的固定资产管理系统原代码 这可是自己小组做的哦

                        .add(20, 20, 20)
                        .add(layout.createParallelGroup(org.jdesktop.layout.GroupLayout.BASELINE)
                            .add(jLabel5)
                            .add(merittext, org.jdesktop.layout.GroupLayout.PREFERRED_SIZE, org.jdesktop.layout.GroupLayout.DEFAULT_SIZE, org.jdesktop.layout.GroupLayout.PREFERRED_SIZE))
                        .add(21, 21, 21)
                        .add(layout.createParallelGroup(org.jdesktop.layout.GroupLayout.BASELINE)
                            .add(jLabel6)
                            .add(buydatetext, org.jdesktop.layout.GroupLayout.PREFERRED_SIZE, org.jdesktop.layout.GroupLayout.DEFAULT_SIZE, org.jdesktop.layout.GroupLayout.PREFERRED_SIZE))
                        .add(16, 16, 16)
                        .add(layout.createParallelGroup(org.jdesktop.layout.GroupLayout.BASELINE)
                            .add(jLabel7)
                            .add(statetext, org.jdesktop.layout.GroupLayout.PREFERRED_SIZE, org.jdesktop.layout.GroupLayout.DEFAULT_SIZE, org.jdesktop.layout.GroupLayout.PREFERRED_SIZE))))
                .addPreferredGap(org.jdesktop.layout.LayoutStyle.RELATED, 14, Short.MAX_VALUE)
                .add(layout.createParallelGroup(org.jdesktop.layout.GroupLayout.LEADING)
                    .add(layout.createSequentialGroup()
                        .add(42, 42, 42)
                        .add(jLabel9))
                    .add(layout.createSequentialGroup()
                        .add(layout.createParallelGroup(org.jdesktop.layout.GroupLayout.BASELINE)
                            .add(jLabel8)
                            .add(usernametext, org.jdesktop.layout.GroupLayout.PREFERRED_SIZE, org.jdesktop.layout.GroupLayout.DEFAULT_SIZE, org.jdesktop.layout.GroupLayout.PREFERRED_SIZE))
                        .addPreferredGap(org.jdesktop.layout.LayoutStyle.RELATED)
                        .add(jScrollPane1, org.jdesktop.layout.GroupLayout.PREFERRED_SIZE, 50, org.jdesktop.layout.GroupLayout.PREFERRED_SIZE)))
                .add(28, 28, 28)
                .add(layout.createParallelGroup(org.jdesktop.layout.GroupLayout.BASELINE)
                    .add(jButton1)
                    .add(jButton2))
                .add(24, 24, 24))
        );
        pack();
    }// </editor-fold>//GEN-END:initComponents

    private void jButton2ActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_jButton2ActionPerformed
        this.dispose();
    }//GEN-LAST:event_jButton2ActionPerformed

    private void jButton1ActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_jButton1ActionPerformed
        update();
        this.dispose();
    }//GEN-LAST:event_jButton1ActionPerformed

    private void NametextActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_NametextActionPerformed
        acquire();
    }//GEN-LAST:event_NametextActionPerformed

    private void sorttextActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_sorttextActionPerformed
        acquire_name();
    }//GEN-LAST:event_sorttextActionPerformed
    
    public void acquire_sort(){
        OpendatabaseClass open = new OpendatabaseClass(sill.getconnection().transmitConnection());
        ResultSet resultset;
        try {
            resultset = open.lookup_sort();
             while(resultset.next()){
                sorttext.addItem(resultset.getString("sort"));
             }
        } catch (SQLException ex) {
            ex.printStackTrace();
            JOptionPane.showMessageDialog(this, ex.getMessage(), "错误提示", JOptionPane.ERROR_MESSAGE);
        }
    }
    
    public void acquire_name(){
        Nametext.removeAllItems();
        
        String sort = (String) sorttext.getSelectedItem();
        
        OpendatabaseClass open = new OpendatabaseClass(sill.getconnection().transmitConnection());
        ResultSet resultset;
        try {
            resultset = open.lookup_name2(sort);
            while(resultset.next()){
                Nametext.addItem(resultset.getString("Name"));
            }
        } catch (SQLException ex) {
            ex.printStackTrace();
            JOptionPane.showMessageDialog(this, ex.getMessage(), "错误提示", JOptionPane.ERROR_MESSAGE);
        }
    }
    
    public void acquire(){
        String sort = (String)sorttext.getSelectedItem();
        String Name = (String)Nametext.getSelectedItem();
        
        OpendatabaseClass open = new OpendatabaseClass(sill.getconnection().transmitConnection());
        ResultSet resultset;
        String state = "";
        try {
            resultset = open.lookup_state(sort,Name);
            while(resultset.next()){
                codetext.setText(resultset.getString("code"));
                modeltext.setText(resultset.getString("model"));
                merittext.setText(resultset.getString("merit"));
                buydatetext.setText(resultset.getString("buydate"));
                state = resultset.getString("state");
                usernametext.setText(resultset.getString("username"));
                annotationtext.setText(resultset.getString("remark"));
            }
            if(state.equalsIgnoreCase("0")){
                statetext.setSelectedIndex(0);
            }else if(state.equalsIgnoreCase("1")){
                statetext.setSelectedIndex(1);
            }else if(state.equalsIgnoreCase("2")){
                statetext.setSelectedIndex(2);
            }else if(state.equalsIgnoreCase("3")){
                statetext.setSelectedIndex(3);
            }
        } catch (SQLException ex) {
            ex.printStackTrace();
            JOptionPane.showMessageDialog(this, ex.getMessage(), "错误提示", JOptionPane.ERROR_MESSAGE);
        }  
    }
    
    public void update(){
        String sort = (String)sorttext.getSelectedItem();
        String Name = (String)Nametext.getSelectedItem();
        String model = modeltext.getText();
        double merit = 0;
        try{
            merit = Double.parseDouble(merittext.getText());
        }catch(NumberFormatException e){
            JOptionPane.showMessageDialog(this, "请正确输入设备价值，价值必须为数字！！！", "错误提示", JOptionPane.ERROR_MESSAGE);
            merittext.grabFocus();
            return;
        }
        String buydate = buydatetext.getText();
        String state1 = (String)statetext.getSelectedItem();
        String state = "";
        String username = usernametext.getText();
        
        OpendatabaseClass open = new OpendatabaseClass(sill.getconnection().transmitConnection());
        if(Name.equalsIgnoreCase("") || sort.equalsIgnoreCase("") ||
                model.equalsIgnoreCase("") || buydate.equalsIgnoreCase("")){
            JOptionPane.showMessageDialog(this,"请正确完整输入！！！","错误提示",JOptionPane.ERROR_MESSAGE);
        }else{
            try {
                open.update_record(Name,sort);
                if(statetext.getSelectedIndex() == 0){
                    state = "0";
                }else if(statetext.getSelectedIndex() == 1){
                    state = "1";
                }else if(statetext.getSelectedIndex() == 2){
                    state = "2";
                }else if(statetext.getSelectedIndex() == 3){
                    state = "3";
                }
                open.accretion_record(Name,sort,model,merit,buydate,state,username);
                JOptionPane.showMessageDialog(this, "修改成功！感谢您的使用！！", "修改提示", JOptionPane.INFORMATION_MESSAGE);
                DatabaseConnection dbc = new DatabaseConnection();
                MainFrame.rm.setResult(dbc.getRs());
                this.dispose();
            } catch (SQLException ex) {
                ex.printStackTrace();
                JOptionPane.showMessageDialog(this, ex.getMessage(), "错误提示", JOptionPane.ERROR_MESSAGE);
            }
        }
    }
    
    // 变量声明 - 不进行修改//GEN-BEGIN:variables
    private javax.swing.JComboBox Nametext;
    private javax.swing.JTextArea annotationtext;
    private javax.swing.JTextField buydatetext;
    private javax.swing.JTextField codetext;
    private javax.swing.JButton jButton1;
    private javax.swing.JButton jButton2;
    private javax.swing.JLabel jLabel1;
    private javax.swing.JLabel jLabel2;
    private javax.swing.JLabel jLabel3;
    private javax.swing.JLabel jLabel4;
    private javax.swing.JLabel jLabel5;
    private javax.swing.JLabel jLabel6;
    private javax.swing.JLabel jLabel7;
    private javax.swing.JLabel jLabel8;
    private javax.swing.JLabel jLabel9;
    private javax.swing.JScrollPane jScrollPane1;
    private javax.swing.JTextField merittext;
    private javax.swing.JTextField modeltext;
    private javax.swing.JComboBox sorttext;
    private javax.swing.JComboBox statetext;
    private javax.swing.JTextField usernametext;
    // 变量声明结束//GEN-END:variables
    
}