addmoney.java

java netbeans 学习程序合集

                    .add(jPanel1Layout.createSequentialGroup()
                        .add(jPanel1Layout.createParallelGroup(org.jdesktop.layout.GroupLayout.BASELINE)
                            .add(jLabel2)
                            .add(jTextFieldClass, org.jdesktop.layout.GroupLayout.PREFERRED_SIZE, org.jdesktop.layout.GroupLayout.DEFAULT_SIZE, org.jdesktop.layout.GroupLayout.PREFERRED_SIZE)
                            .add(jLabel3)
                            .add(jTextFieldID, org.jdesktop.layout.GroupLayout.PREFERRED_SIZE, org.jdesktop.layout.GroupLayout.DEFAULT_SIZE, org.jdesktop.layout.GroupLayout.PREFERRED_SIZE))
                        .add(23, 23, 23)
                        .add(jPanel1Layout.createParallelGroup(org.jdesktop.layout.GroupLayout.BASELINE)
                            .add(jLabel4)
                            .add(jTextFieldName, org.jdesktop.layout.GroupLayout.PREFERRED_SIZE, org.jdesktop.layout.GroupLayout.DEFAULT_SIZE, org.jdesktop.layout.GroupLayout.PREFERRED_SIZE))
                        .add(3, 3, 3))
                    .add(jPanel1Layout.createSequentialGroup()
                        .add(jPanel1Layout.createParallelGroup(org.jdesktop.layout.GroupLayout.BASELINE)
                            .add(jTextFieldGrade, org.jdesktop.layout.GroupLayout.PREFERRED_SIZE, org.jdesktop.layout.GroupLayout.DEFAULT_SIZE, org.jdesktop.layout.GroupLayout.PREFERRED_SIZE)
                            .add(jLabel1))
                        .addPreferredGap(org.jdesktop.layout.LayoutStyle.RELATED)))
                .add(26, 26, 26)
                .add(jPanel2, 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(jPanel3, 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(jPanel1Layout.createParallelGroup(org.jdesktop.layout.GroupLayout.BASELINE)
                    .add(jButton1)
                    .add(jButton2))
                .addContainerGap(org.jdesktop.layout.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE))
        );

        org.jdesktop.layout.GroupLayout layout = new org.jdesktop.layout.GroupLayout(getContentPane());
        getContentPane().setLayout(layout);
        layout.setHorizontalGroup(
            layout.createParallelGroup(org.jdesktop.layout.GroupLayout.LEADING)
            .add(layout.createSequentialGroup()
                .addContainerGap()
                .add(jPanel1, org.jdesktop.layout.GroupLayout.DEFAULT_SIZE, org.jdesktop.layout.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE)
                .addContainerGap())
        );
        layout.setVerticalGroup(
            layout.createParallelGroup(org.jdesktop.layout.GroupLayout.LEADING)
            .add(layout.createSequentialGroup()
                .addContainerGap()
                .add(jPanel1, org.jdesktop.layout.GroupLayout.DEFAULT_SIZE, 383, Short.MAX_VALUE)
                .addContainerGap())
        );
        pack();
    }// </editor-fold>//GEN-END:initComponents

    private void jButton1ActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_jButton1ActionPerformed
// TODO 将在此处添加您的处理代码：
        String RealAdd=this.jTextFieldRealAdd.getText();
        String HaveNotAdd=this.jTextFieldHaveNotAdd.getText();
        String ThisNotAdd=this.jTextFieldThisNotAdd.getText();
        String ID=this.jTextFieldID.getText();        
        String AllHaveNot=this.jTextFieldAllHaveNot.getText();
        int studymoney=Integer.parseInt(this.jTextFieldStudyMoney.getText());
        int sushemoney=Integer.parseInt(this.jTextFieldRoomMoney.getText());
        int Allmoney=(int)studymoney+(int)sushemoney;
       // System.out.println(Allmoney);
       // String allmoney= Allmoney;
        //this.jTextFieldThisNotAdd.setText(ThisNotAdd);
       // AllHaveNot=(String)AllHaveNot+(String)ThisNotAdd;
        String sql="update 学生档案 set 实际交费='"+RealAdd+"',欠费='"+HaveNotAdd+"',本次欠费='"+ThisNotAdd+"',累计欠费='"+AllHaveNot+"',全部费用='"+Allmoney+"'  where 学号 ='"+ID+"'";
       /* String sql1="update 学生档案 set 欠费='"+HaveNotAdd+"' where 学号 ='"+ID+"'";
        String sql2="update 学生档案 set 本次欠费='"+ThisNotAdd+"' where 学号 ='"+ID+"'";
        String sql3="update 学生档案 set 累计欠费='"+AllHaveNot+"' where 学号 ='"+ID+"'";
        String sql4="update 学生档案 set 全部费用='"+Allmoney+"' where 学号='"+ID+"'";*/
        DB dB=new DB();
        dB.ChangeInformation(sql);
        /*dB.AddMoneySet(sql1);
        dB.AddMoneySet(sql2);
        dB.AddMoneySet(sql3);
        dB.AddMoneySet(sql4);*/
        dB.closeAccessConnection();
        this.jTextFieldAllHaveNot.setText("");
        this.jTextFieldClass.setText("");
        this.jTextFieldGrade.setText("");
        this.jTextFieldHaveNotAdd.setText("");
        this.jTextFieldID.setText("");
        this.jTextFieldName.setText("");
       this.jTextFieldStudyMoney.setText("");
       this.jTextFieldRoomMoney.setText("");
        this.jTextFieldRealAdd.setText("");
        this.jTextFieldThisNotAdd.setText("");
         this.jTextFieldID.requestFocus(true);
        
    }//GEN-LAST:event_jButton1ActionPerformed

    private void jButton2ActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_jButton2ActionPerformed
// TODO 将在此处添加您的处理代码：
        this.dispose();
    }//GEN-LAST:event_jButton2ActionPerformed

    private void jTextFieldIDActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_jTextFieldIDActionPerformed
// TODO 将在此处添加您的处理代码：
        String Grade=new String();
        String Class=new String();
        String Name=new String();
        String HavaNotAdd=new String();
        String AllHaveNot=new String();
        String StudyMoney=new String();
        String RoomMoney=new String();
        String ID=this.jTextFieldID.getText();
        String sql="select e.年级,e.班级,e.姓名,e.欠费,e.累计欠费,e.寝费,k.学费,e.实际交费 from 学生档案 e,班级信息 k where 学号='"+ID+"' and e.年级=k.年级 and e.班级=k.班级 ";
        
        DB dB=new DB();
        rs=dB.GetInformation(sql);               
        try {
            rs.next();
            Grade=rs.getString("年级");
            this.jTextFieldGrade.setText(Grade);
            } catch (SQLException ex) {
            ex.printStackTrace();
        }
        rs=dB.GetInformation(sql);
        try {
            rs.next();
            Class=rs.getString("班级");               
           this.jTextFieldClass.setText(Class);
             } catch (SQLException ex) {
            ex.printStackTrace();
        }
        rs=dB.GetInformation(sql);
        try {
            rs.next();
            Name=rs.getString("姓名");
            this.jTextFieldName.setText(Name);
        } catch (SQLException ex) {
            ex.printStackTrace();
        }
         rs=dB.GetInformation(sql);
        try {
            rs.next();
           StudyMoney=rs.getString("学费");
            this.jTextFieldStudyMoney.setText(StudyMoney);
        } catch (SQLException ex) {
            ex.printStackTrace();
        }
         rs=dB.GetInformation(sql);
        try {
            rs.next();
            HavaNotAdd=rs.getString("欠费");
           // this.jTextFieldHaveNotAdd.setText(HavaNotAdd);
            this.jTextFieldAllHaveNot.setText(HavaNotAdd);
        } catch (SQLException ex) {
            ex.printStackTrace();
        }
       rs=dB.GetInformation(sql);
        try {
            rs.next();
           AllHaveNot=rs.getString("累计欠费");
            this.jTextFieldAllHaveNot.setText(AllHaveNot);
        } catch (SQLException ex) {
            ex.printStackTrace();
        }
       rs=dB.GetInformation(sql);
        try {
            rs.next();
          RoomMoney=rs.getString("寝费");
            this.jTextFieldRoomMoney.setText(RoomMoney);
        } catch (SQLException ex) {
            ex.printStackTrace();
    }                      
       rs=dB.GetInformation(sql);
        try {
            rs.next();
          OldRealAdd=rs.getString("实际交费");
            this.jTextFieldRealAdd.setText(OldRealAdd);
        } catch (SQLException ex) {
            ex.printStackTrace();
    }//GEN-LAST:event_jTextFieldIDActionPerformed
        this.jTextFieldRealAdd.requestFocus(true);   
    }
    /**
     * @param args the command line arguments
     */
    public static void main(String args[]) {
        java.awt.EventQueue.invokeLater(new Runnable() {
            public void run() {
                new AddMoney().setVisible(true);
            }
        });
    }
    
    // 变量声明 - 不进行修改//GEN-BEGIN:variables
    private javax.swing.JButton jButton1;
    private javax.swing.JButton jButton2;
    private javax.swing.JLabel jLabel1;
    private javax.swing.JLabel jLabel10;
    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.JPanel jPanel1;
    private javax.swing.JPanel jPanel2;
    private javax.swing.JPanel jPanel3;
    private javax.swing.JTextField jTextFieldAllHaveNot;
    private javax.swing.JTextField jTextFieldClass;
    private javax.swing.JTextField jTextFieldGrade;
    private javax.swing.JTextField jTextFieldHaveNotAdd;
    private javax.swing.JTextField jTextFieldID;
    private javax.swing.JTextField jTextFieldName;
    private javax.swing.JTextField jTextFieldRealAdd;
    private javax.swing.JTextField jTextFieldRoomMoney;
    private javax.swing.JTextField jTextFieldStudyMoney;
    private javax.swing.JTextField jTextFieldThisNotAdd;
    // 变量声明结束//GEN-END:variables
    
}