chqueryjframe.java

小区物业管理系统（java版） java swing + access 2003

/*
 * FCJFrame.java
 *
 * Created on 2006年4月22日, 上午11:08
 */

package SFManage;
import java.awt.*;
import mySql.*;
import java.sql.*;
import javax.swing.*;
import javax.swing.table.*;
import javax.swing.event.*;
import myClass.*;
/**
 *
 * @author  wang
 */
public class CHQueryJFrame extends javax.swing.JFrame{
    ResultSet rs=null;
    DBSQLManager db=new DBSQLManager();
    DefaultTableModel KHData;
    DefaultTableModel SFData;
    boolean modifyFlag=false;
    DateChooserJButton_1 dateChooser1=new DateChooserJButton_1();    
    public CHQueryJFrame() {
        super("费用查询");
        try{
            String theLook=UIManager.getSystemLookAndFeelClassName();//更新界面
            UIManager.setLookAndFeel(theLook);
            SwingUtilities.updateComponentTreeUI(this);
        } catch(Exception e){
            System.err.println("异常："+e);
        }
        initComponents();
        setSize(675,464);
        Dimension screen=getToolkit().getScreenSize();
        setLocation((screen.width-getSize().width)/2, (screen.height-getSize().height)/2);
        creatTable();
        
    }
    private void creatTable(){
        String sql="select * from roomInfo,clientInfo where roomInfo.clientCode=clientInfo.clientCode And zone='A'";       
        try{
            String data[]=new String[3];
            db.setSql(sql);
            db.executeQuery();
            rs=db.getRs();
            while(rs.next()){
                data[0]=rs.getString("zone");
                data[1]=rs.getString("roomCode");
                data[2]=rs.getString("clientName");
                KHData.addRow(data);                
            }
            status.setText("选定房间数："+KHData.getRowCount());
        }
        catch(Exception e){
            System.out.println("初始化表格显示异常:"+e);
        }
    }
    private void updateSFTable(){
        SFData.setRowCount(0);
	SFData.fireTableDataChanged();
    }
    private double total(){
        double sumOfMoney=0.0;
        for(int i=0;i<SFData.getRowCount();i++){
            sumOfMoney+=Double.valueOf(SFData.getValueAt(i, 3).toString()).doubleValue();
        }
        return sumOfMoney;
    }    
    private void query(String key,String date){        
        String sql1="select * from chargeInfo1,chargeItem where chargeInfo1.chargeCode=chargeItem.chargeCode And roomCode='"+key+"' And startTime='"+date+"'";
        String sql2="select * from chargeInfo2,chargeItem where chargeInfo2.chargeCode=chargeItem.chargeCode And roomCode='"+key+"' And startTime='"+date+"'";
        String data[]=new String[6];
        try{
            db.setSql(sql1);
            db.executeQuery();
            rs=db.getRs();
            while(rs.next()){
                 data[0]=key;//房间代码
                 data[1]=rs.getString("startTime").substring(6, 7)+"月";//费用月份
                 data[2]=rs.getString("chargeName");//项目名称
                 data[3]=new Double(rs.getDouble("fee")).toString();//费用金额
                 if(rs.getInt("status")==1){//是否收取费用
                     data[4]="是";
                 }
                 else{
                     data[4]="否";
                 }
                 data[5]=rs.getString("subTime");//交费时间
                 SFData.addRow(data);
            }
            db.setSql(sql2);
            db.executeQuery();
            rs=db.getRs();
            while(rs.next()){
                 data[0]=key;//房间代码
                 data[1]=rs.getString("startTime").substring(6, 7)+"月";//费用月份
                 data[2]=rs.getString("chargeName");//项目名称
                 data[3]=new Double(rs.getDouble("money")).toString();//费用金额
                  if(rs.getInt("status")==1){//是否收取费用
                     data[4]="是";
                 }
                 else{
                     data[4]="否";
                 }
                 data[5]=rs.getString("subTime");//交费时间
                 SFData.addRow(data);
            }
        }
        catch(Exception e){
            System.out.println("查询收费信息异常");
        }
    }   
    // <editor-fold defaultstate="collapsed" desc=" 生成的代码 ">//GEN-BEGIN:initComponents
    private void initComponents() {
        jMainPanel = new javax.swing.JPanel();
        jIndexPanel = new javax.swing.JPanel();
        jScrollPane1 = new javax.swing.JScrollPane();
        KHTable = new javax.swing.JTable();
        jStatusPanel = new javax.swing.JPanel();
        status = new javax.swing.JLabel();
        jQueryPanel = new javax.swing.JPanel();
        jLabel14 = new javax.swing.JLabel();
        keyword = new javax.swing.JComboBox();
        dingwei = new javax.swing.JButton();
        jControlPanel = new javax.swing.JPanel();
        jPanel2 = new javax.swing.JPanel();
        jLabel3 = new javax.swing.JLabel();
        jScrollPane2 = new javax.swing.JScrollPane();
        SFTable = new javax.swing.JTable();
        jPanel4 = new javax.swing.JPanel();
        jLabel4 = new javax.swing.JLabel();
        month = new javax.swing.JTextField();
        jLabel5 = new javax.swing.JLabel();
        sum = new javax.swing.JTextField();
        jLabel6 = new javax.swing.JLabel();
        count = new javax.swing.JTextField();
        jLabel1 = new javax.swing.JLabel();

        getContentPane().setLayout(null);

        setDefaultCloseOperation(javax.swing.WindowConstants.DISPOSE_ON_CLOSE);
        setResizable(false);
        jMainPanel.setLayout(null);

        jMainPanel.setBorder(new javax.swing.border.BevelBorder(javax.swing.border.BevelBorder.RAISED));
        jIndexPanel.setLayout(null);

        jIndexPanel.setBorder(new javax.swing.border.EtchedBorder());
        KHTable.setModel(new javax.swing.table.DefaultTableModel(
            new Object [][] {
                {null, null, null, null},
                {null, null, null, null},
                {null, null, null, null},
                {null, null, null, null}
            },
            new String [] {
                "Title 1", "Title 2", "Title 3", "Title 4"
            }
        ));
        KHData=new DefaultTableModel();
        KHData.addColumn("大楼");
        KHData.addColumn("房间代码");
        KHData.addColumn("客户描述");
        KHTable.setModel(KHData);
        KHTable.setCellSelectionEnabled(false);
        KHTable.addMouseListener(new java.awt.event.MouseAdapter() {
            public void mouseReleased(java.awt.event.MouseEvent evt) {
                KHTableMouseReleased(evt);
            }
        });

        jScrollPane1.setViewportView(KHTable);

        jIndexPanel.add(jScrollPane1);
        jScrollPane1.setBounds(0, 0, 220, 270);

        jMainPanel.add(jIndexPanel);
        jIndexPanel.setBounds(10, 110, 220, 270);

        jStatusPanel.setLayout(null);

        jStatusPanel.setBorder(new javax.swing.border.EtchedBorder());
        jStatusPanel.add(status);
        status.setBounds(0, 0, 220, 30);

        jMainPanel.add(jStatusPanel);
        jStatusPanel.setBounds(10, 390, 220, 30);

        jQueryPanel.setLayout(null);

        jQueryPanel.setBorder(new javax.swing.border.EtchedBorder());
        jLabel14.setText("\u6240\u5728\u5927\u697c:");
        jQueryPanel.add(jLabel14);
        jLabel14.setBounds(20, 30, 60, 20);

        keyword.setModel(new javax.swing.DefaultComboBoxModel(new String[] { "A", "B", "C" }));
        jQueryPanel.add(keyword);
        keyword.setBounds(80, 30, 90, 20);

        dingwei.setText("\u5b9a\u4f4d");
        dingwei.addActionListener(new java.awt.event.ActionListener() {
            public void actionPerformed(java.awt.event.ActionEvent evt) {
                dingweiActionPerformed(evt);
            }
        });

        jQueryPanel.add(dingwei);
        dingwei.setBounds(110, 60, 60, 23);

        jMainPanel.add(jQueryPanel);
        jQueryPanel.setBounds(10, 10, 220, 90);

        getContentPane().add(jMainPanel);
        jMainPanel.setBounds(0, 0, 240, 430);

        jControlPanel.setLayout(null);

        jControlPanel.setBorder(new javax.swing.border.BevelBorder(javax.swing.border.BevelBorder.RAISED));
        jPanel2.setLayout(null);

        jPanel2.setBorder(new javax.swing.border.EtchedBorder());
        jPanel2.add(dateChooser1);
        dateChooser1.setLocation(85,8);
        dateChooser1.setSize(100,25);
        jLabel3.setText("\u8d39\u7528\u6708\u4efd:");
        jPanel2.add(jLabel3);
        jLabel3.setBounds(20, 10, 60, 15);

        jControlPanel.add(jPanel2);
        jPanel2.setBounds(10, 40, 410, 40);

        SFTable.setModel(new javax.swing.table.DefaultTableModel(
            new Object [][] {
                {null, null, null, null},
                {null, null, null, null},
                {null, null, null, null},
                {null, null, null, null}
            },
            new String [] {
                "Title 1", "Title 2", "Title 3", "Title 4"
            }
        ));
        SFData=new DefaultTableModel();
        SFData.addColumn("房间代码");
        SFData.addColumn("费用月份");
        SFData.addColumn("项目名称");
        SFData.addColumn("费用金额");
        SFData.addColumn("已收");
        SFData.addColumn("缴费日期");
        SFTable.setModel(SFData);
        SFTable.setCellSelectionEnabled(false);
        jScrollPane2.setViewportView(SFTable);

        jControlPanel.add(jScrollPane2);
        jScrollPane2.setBounds(10, 90, 410, 220);

        jPanel4.setLayout(null);

        jPanel4.setBorder(new javax.swing.border.EtchedBorder());
        jLabel4.setText("\u8d39\u7528\u6708\u4efd:");
        jPanel4.add(jLabel4);
        jLabel4.setBounds(10, 20, 60, 15);

        month.setEnabled(false);
        jPanel4.add(month);
        month.setBounds(70, 20, 70, 20);

        jLabel5.setText("\u8d39\u7528\u5408\u8ba1:");
        jPanel4.add(jLabel5);
        jLabel5.setBounds(10, 50, 54, 15);

        sum.setEnabled(false);
        jPanel4.add(sum);
        sum.setBounds(70, 50, 70, 20);

        jLabel6.setText("\u8d39\u7528\u7b14\u6570:");
        jPanel4.add(jLabel6);
        jLabel6.setBounds(160, 20, 54, 15);

        count.setEnabled(false);
        jPanel4.add(count);
        count.setBounds(220, 20, 50, 20);

        jControlPanel.add(jPanel4);
        jPanel4.setBounds(10, 320, 410, 90);

        jLabel1.setFont(new java.awt.Font("宋体", 0, 18));
        jLabel1.setText("\u8d39\u7528\u67e5\u8be2");
        jControlPanel.add(jLabel1);
        jLabel1.setBounds(10, 10, 110, 30);

        getContentPane().add(jControlPanel);
        jControlPanel.setBounds(240, 0, 430, 430);

        pack();
    }
    // </editor-fold>//GEN-END:initComponents

    private void KHTableMouseReleased(java.awt.event.MouseEvent evt) {//GEN-FIRST:event_KHTableMouseReleased
// TODO 将在此处添加您的处理代码：
        int row1= KHTable.getSelectedRow();       
        String key1=KHData.getValueAt(row1,1).toString();        
        String date=dateChooser1.getText().trim()+"-01";
        String key2=dateChooser1.getText().substring(6,7)+"月";    
        updateSFTable();
        query(key1,date);        
        month.setText(key2);        
        count.setText(new Integer(SFData.getRowCount()).toString());
        sum.setText(new Double(total()).toString());                       
    }//GEN-LAST:event_KHTableMouseReleased

    private void dingweiActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_dingweiActionPerformed
// TODO 将在此处添加您的处理代码：
        String key=keyword.getSelectedItem().toString();
        String sql="select * from roomInfo,clientInfo where roomInfo.clientCode=clientInfo.clientCode And zone='"+key+"'";
        KHData.setRowCount(0);
	KHData.fireTableDataChanged();
        try{
               String data[]=new String[3];
               db.setSql(sql);
               db.executeQuery();
               rs=db.getRs();
               while(rs.next()){
                   data[0]=rs.getString("zone");
                   data[1]=rs.getString("roomCode");
                   data[2]=rs.getString("clientName");
                   KHData.addRow(data);
               }
               status.setText("选定房间数："+KHData.getRowCount());
        }
        catch(Exception e){
               System.out.println("客户信息表格显示异常:"+e);
        }
        
        
    }//GEN-LAST:event_dingweiActionPerformed
            
    /**
     * @param args the command line arguments
     */
    public static void main(String args[]) {
        java.awt.EventQueue.invokeLater(new Runnable() {
            public void run() {
                new CHQueryJFrame().setVisible(true);
            }
        });
    }
    
    // 变量声明 - 不进行修改//GEN-BEGIN:variables
    private javax.swing.JTable KHTable;
    private javax.swing.JTable SFTable;
    private javax.swing.JTextField count;
    private javax.swing.JButton dingwei;
    private javax.swing.JPanel jControlPanel;
    private javax.swing.JPanel jIndexPanel;
    private javax.swing.JLabel jLabel1;
    private javax.swing.JLabel jLabel14;
    private javax.swing.JLabel jLabel3;
    private javax.swing.JLabel jLabel4;
    private javax.swing.JLabel jLabel5;
    private javax.swing.JLabel jLabel6;
    private javax.swing.JPanel jMainPanel;
    private javax.swing.JPanel jPanel2;
    private javax.swing.JPanel jPanel4;
    private javax.swing.JPanel jQueryPanel;
    private javax.swing.JScrollPane jScrollPane1;
    private javax.swing.JScrollPane jScrollPane2;
    private javax.swing.JPanel jStatusPanel;
    private javax.swing.JComboBox keyword;
    private javax.swing.JTextField month;
    private javax.swing.JLabel status;
    private javax.swing.JTextField sum;
    // 变量声明结束//GEN-END:variables
    
}