chjframe.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 CHJFrame extends javax.swing.JFrame{
    ResultSet rs=null;
    DBSQLManager db=new DBSQLManager();
    DefaultTableModel KHData;
    DefaultTableModel SFData;
    boolean modifyFlag=false;
    DateChooserJButton_1 dateChooser1=new DateChooserJButton_1();
    DateChooserJButton dateChooser2=new DateChooserJButton();
    public CHJFrame() {
        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, 2).toString()).doubleValue();
        }
        return sumOfMoney;
    }
    private void query1(String key){  //查询
        String sql="select * from roomInfo,clientInfo where roomInfo.clientCode=clientInfo.clientCode And roomCode='"+key+"'";
        try{
            db.setSql(sql);
            db.executeQuery();
            rs=db.getRs();
            if(rs.next()){
                   roomCode.setText(rs.getString("roomCode").trim());
                   clientName.setText(rs.getString("clientName").trim());
            }
        }
        catch(Exception e){
            System.out.println("查询业主信息异常："+e);
        }
    }
    private void query2(String key,String date){
        String sql1="select * from chargeInfo1,chargeItem where chargeInfo1.chargeCode=chargeItem.chargeCode And roomCode='"+key+"' And startTime='"+date+"' And status=0";
        String sql2="select * from chargeInfo2,chargeItem where chargeInfo2.chargeCode=chargeItem.chargeCode And roomCode='"+key+"' And startTime='"+date+"' And status=0";
        String data[]=new String[4];
        try{
            db.setSql(sql1);
            db.executeQuery();
            rs=db.getRs();
            while(rs.next()){              
                 data[0]=rs.getString("startTime").substring(6, 7)+"月";
                 data[1]=rs.getString("chargeName");
                 data[2]=new Double(rs.getDouble("fee")).toString();
                 data[3]=rs.getString("subTime");
                 SFData.addRow(data);
            }
            db.setSql(sql2);
            db.executeQuery();
            rs=db.getRs();
            while(rs.next()){              
                 data[0]=rs.getString("startTime").substring(6, 7)+"月";
                 data[1]=rs.getString("chargeName");
                 data[2]=new Double(rs.getDouble("money")).toString();
                 data[3]=rs.getString("subTime");
                 SFData.addRow(data);
            }
        }
        catch(Exception e){
            System.out.println("查询收费信息异常");
        }
    }
    private void update(String key,String date){
        String sql1="update chargeInfo1 set subTime='"+dateChooser2.getText()+
                   "',status=1 where roomCode='"+key+"' And startTime='"+date+"'";//更新走表类费用sql语句
        String sql2="update chargeInfo2 set subTime='"+dateChooser2.getText()+
                   "',status=1 where roomCode='"+key+"' And startTime='"+date+"'";//更新常规类费用sql语句
        try{
            db.setSql(sql1);
            db.executeUpdate();//更新走表类费用
            db.setSql(sql2);
            db.executeUpdate();//更新常规类费用
        }
        catch(Exception e){
            System.out.println("交费异常:"+e);
        }       
    }
    // <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();
        jPanel1 = new javax.swing.JPanel();
        jLabel1 = new javax.swing.JLabel();
        roomCode = new javax.swing.JTextField();
        jLabel2 = new javax.swing.JLabel();
        clientName = new javax.swing.JTextField();
        jPanel2 = new javax.swing.JPanel();
        jLabel3 = new javax.swing.JLabel();
        jScrollPane2 = new javax.swing.JScrollPane();
        SFTable = new javax.swing.JTable();
        jPanel3 = new javax.swing.JPanel();
        charge = new javax.swing.JButton();
        ok = new javax.swing.JButton();
        dispose = new javax.swing.JButton();
        quit = new javax.swing.JButton();
        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();
        jPanel5 = new javax.swing.JPanel();
        jLabel7 = 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));
        jPanel1.setLayout(null);

        jPanel1.setBorder(new javax.swing.border.EtchedBorder());
        jLabel1.setText("\u623f\u95f4\u4ee3\u7801:");
        jPanel1.add(jLabel1);
        jLabel1.setBounds(30, 20, 60, 15);

        roomCode.setEnabled(false);
        jPanel1.add(roomCode);
        roomCode.setBounds(100, 20, 80, 20);

        jLabel2.setText("\u4e1a\u4e3b:");
        jPanel1.add(jLabel2);
        jLabel2.setBounds(210, 20, 30, 15);

        clientName.setEnabled(false);
        jPanel1.add(clientName);
        clientName.setBounds(250, 20, 80, 20);