khjframe.java

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

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

package resourceInfoManage;
import java.awt.*;
import mySql.*;
import java.sql.*;
import javax.swing.*;
import javax.swing.table.*;
import javax.swing.event.*;
/**
 *
 * @author  wang
 */
public class KHJFrame extends javax.swing.JFrame{
    ResultSet rs=null;
    DBSQLManager db=new DBSQLManager();
    DefaultTableModel KHData;
    boolean modifyFlag=false;
    public KHJFrame() {
        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 query(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());
                   zone.setText(rs.getString("zone").trim());
                   roomStatus.setSelectedIndex(rs.getInt("roomStatus"));
                   clientCode.setText(rs.getString("clientCode").trim());
                   clientName.setText(rs.getString("clientName").trim());
                   sex.setSelectedIndex(rs.getInt("sex"));
                   inTime.setText(rs.getString("inTime").trim());
                   phone.setText(rs.getString("phone").trim());
                   np.setText(rs.getString("np").trim());
                   idKind.setSelectedIndex(rs.getInt("idKind"));
                   idNo.setText(rs.getString("idNo").trim());
                   remark.setText(rs.getString("remark").trim());
            }
        }
        catch(Exception e){
            System.out.println("查询客户信息异常："+e);
        }
    }
    private void enabledTools(){  //使用控件
        clientName.setEnabled(true);sex.setEnabled(true);
        inTime.setEnabled(true);phone.setEnabled(true);
        np.setEnabled(true);idKind.setEnabled(true);
        idNo.setEnabled(true);remark.setEnabled(true);       
    }
    private void disabledTools(){  //禁用控件
        clientName.setEnabled(false);sex.setEnabled(false);
        inTime.setEnabled(false);phone.setEnabled(false);
        np.setEnabled(false);idKind.setEnabled(false);
        idNo.setEnabled(false);remark.setEnabled(false);
    }
    private void clearTools(){  //清空输入
        clientName.setText("");sex.setSelectedIndex(0);
        inTime.setText("");phone.setText("");
        np.setText("");idKind.setSelectedIndex(0);
        idNo.setText("");remark.setText("");
    }
    private void update(){
        String sql="update clientInfo set clientName=?,sex=?,inTime=?,phone=?,np=?,idKind=?,idNo=?,remark=?  where clientCode=?";
        try{
               Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");//加载驱动
               Connection conn=DriverManager.getConnection("jdbc:odbc:wySystem","admin", "admin");
               PreparedStatement pre=conn.prepareCall(sql);
               pre.clearParameters();
               pre.setString(1,clientName.getText().trim());
               pre.setInt(2,sex.getSelectedIndex());
               pre.setString(3,inTime.getText().trim());
               pre.setString(4,phone.getText().trim());
               pre.setString(5,np.getText().trim());
               pre.setInt(6,idKind.getSelectedIndex());
               pre.setString(7,idNo.getText().trim());
               pre.setString(8,remark.getText().trim());
               pre.setString(9, clientCode.getText().trim());              
               int flag=pre.executeUpdate();
               if(flag==1){
                   JOptionPane.showMessageDialog(this,"更新业主信息成功","更新",JOptionPane.INFORMATION_MESSAGE);
               }               
            }
        catch(Exception e){
            JOptionPane.showMessageDialog(this,"更新业主信息失败","更新",JOptionPane.ERROR_MESSAGE);
            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();
        operates = new javax.swing.JPanel();
        jLabel12 = new javax.swing.JLabel();
        jPanel1 = new javax.swing.JPanel();
        jLabel1 = new javax.swing.JLabel();
        roomCode = new javax.swing.JTextField();
        jLabel2 = new javax.swing.JLabel();
        zone = new javax.swing.JTextField();
        jLabel3 = new javax.swing.JLabel();
        roomStatus = new javax.swing.JComboBox();
        jPanel2 = new javax.swing.JPanel();
        jLabel4 = new javax.swing.JLabel();
        clientCode = new javax.swing.JTextField();
        jLabel5 = new javax.swing.JLabel();
        clientName = new javax.swing.JTextField();
        jLabel6 = new javax.swing.JLabel();
        sex = new javax.swing.JComboBox();
        jLabel7 = new javax.swing.JLabel();
        inTime = new javax.swing.JTextField();
        jLabel8 = new javax.swing.JLabel();
        phone = new javax.swing.JTextField();
        jLabel9 = new javax.swing.JLabel();
        np = new javax.swing.JTextField();
        jLabel10 = new javax.swing.JLabel();
        idKind = new javax.swing.JComboBox();
        jLabel11 = new javax.swing.JLabel();
        idNo = new javax.swing.JTextField();
        jLabel13 = new javax.swing.JLabel();
        jPanel3 = new javax.swing.JPanel();
        jScrollPane2 = new javax.swing.JScrollPane();
        remark = new javax.swing.JTextArea();
        buttons = new javax.swing.JPanel();
        modify = new javax.swing.JButton();
        save = new javax.swing.JButton();
        clear = new javax.swing.JButton();
        quit = new javax.swing.JButton();
        dispose = new javax.swing.JButton();

        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));
        operates.setLayout(null);

        operates.setBorder(new javax.swing.border.EtchedBorder());
        jLabel12.setFont(new java.awt.Font("宋体", 0, 18));
        jLabel12.setText("\u5ba2\u6237\u7ba1\u7406");
        operates.add(jLabel12);
        jLabel12.setBounds(10, 10, 90, 20);

        jPanel1.setLayout(null);

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

        roomCode.setEditable(false);
        jPanel1.add(roomCode);
        roomCode.setBounds(70, 10, 90, 20);

        jLabel2.setText("\u6240\u5c5e\u5927\u697c:");
        jPanel1.add(jLabel2);
        jLabel2.setBounds(170, 10, 60, 15);

        zone.setEditable(false);
        jPanel1.add(zone);
        zone.setBounds(230, 10, 90, 20);

        jLabel3.setText("\u4f7f\u7528\u72b6\u6001:");
        jPanel1.add(jLabel3);
        jLabel3.setBounds(10, 50, 60, 15);

        roomStatus.setModel(new javax.swing.DefaultComboBoxModel(new String[] { "", "空闲", "出租", "自住" }));
        roomStatus.setEnabled(false);
        jPanel1.add(roomStatus);
        roomStatus.setBounds(70, 50, 90, 20);

        operates.add(jPanel1);
        jPanel1.setBounds(10, 40, 390, 80);

        jPanel2.setLayout(null);