sfitemjframe.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.tree.*;
import javax.swing.event.*;
/**
 *
 * @author  wang
 */
public class SFItemJFrame extends javax.swing.JFrame{
    ResultSet rs=null;
    DBSQLManager db=new DBSQLManager();
    DefaultListModel SFData;
    boolean addFlag=false;
    boolean modifyFlag=false;
    public SFItemJFrame() {
        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);
        creatList();
        
    }
    private void creatList(){
        String sql="select chargeName from chargeItem";      
        try{
            db.setSql(sql);
            db.executeQuery();
            rs=db.getRs();
            while(rs.next()){
                SFData.addElement(rs.getString("chargeName"));        
            }
        }
        catch(Exception e){
            System.out.println("初始化列表显示异常:"+e);
        }
    }
    private void enabledTools(){  //使用控件
        unit.setEnabled(true);
        uPrice.setEnabled(true);
        remark.setEnabled(true);       
    }
    private void disabledTools(){  //禁用控件
        unit.setEnabled(false);
        uPrice.setEnabled(false);
        remark.setEnabled(false);
    }
    private void query(int key1){  //查询
        String key=new Integer(key1+1).toString();
        String sql="select * from chargeItem where chargeCode='"+key+"'";
        try{
            db.setSql(sql);
            db.executeQuery();
            rs=db.getRs();
            if(rs.next()){
                   chargeCode.setText(rs.getString("chargeCode").trim());
                   chargeName.setText(rs.getString("chargeName").trim());
                   uPrice.setText(new Double(rs.getDouble("uPrice")).toString().trim());                                    
                   unit.setSelectedIndex(rs.getInt("unit"));                                  
                   remark.setText(rs.getString("remark").trim());
            }
        }
        catch(Exception e){
            System.out.println("查询收费项目异常："+e);
        }
    }
    private void update(){
        String sql="update chargeItem set unit=?,uPrice=?,remark=?  where chargeCode=?";
        try{
               Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");//加载驱动
               Connection conn=DriverManager.getConnection("jdbc:odbc:wySystem","admin", "admin");
               PreparedStatement pre=conn.prepareCall(sql);
               pre.clearParameters();
               pre.setInt(1,unit.getSelectedIndex());
               pre.setDouble(2,Double.valueOf(uPrice.getText().trim()).doubleValue());              
               pre.setString(3,remark.getText().trim());
               pre.setString(4, chargeCode.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();
        SFList = new javax.swing.JList();
        jPanel2 = new javax.swing.JPanel();
        status = new javax.swing.JLabel();
        jLabel8 = new javax.swing.JLabel();
        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();
        chargeCode = new javax.swing.JTextField();
        jLabel2 = new javax.swing.JLabel();
        chargeName = new javax.swing.JTextField();
        jLabel3 = new javax.swing.JLabel();
        uPrice = new javax.swing.JTextField();
        jLabel4 = new javax.swing.JLabel();
        dateCount = new javax.swing.JTextField();
        jLabel6 = new javax.swing.JLabel();
        jScrollPane2 = new javax.swing.JScrollPane();
        remark = new javax.swing.JTextArea();
        jLabel7 = new javax.swing.JLabel();
        unit = new javax.swing.JComboBox();
        buttons = new javax.swing.JPanel();
        modify = new javax.swing.JButton();
        save = 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());
        SFData=new DefaultListModel();
        SFList.setModel(SFData);
        SFList.setSelectionMode(ListSelectionModel.SINGLE_SELECTION);
        SFList.setSelectedIndex(0);
        SFList.addListSelectionListener(new javax.swing.event.ListSelectionListener() {
            public void valueChanged(javax.swing.event.ListSelectionEvent evt) {
                SFListValueChanged(evt);
            }
        });

        jScrollPane1.setViewportView(SFList);

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

        jMainPanel.add(jIndexPanel);
        jIndexPanel.setBounds(10, 50, 220, 330);

        jPanel2.setLayout(null);

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

        jMainPanel.add(jPanel2);
        jPanel2.setBounds(10, 390, 220, 20);

        jLabel8.setFont(new java.awt.Font("宋体", 0, 14));
        jLabel8.setText("\u6536\u8d39\u9879\u76ee:");
        jMainPanel.add(jLabel8);
        jLabel8.setBounds(20, 20, 70, 16);

        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);

        jLabel12.setFont(new java.awt.Font("宋体", 0, 18));
        jLabel12.setText("\u6536\u8d39\u9879\u76ee\u7ba1\u7406");
        operates.add(jLabel12);
        jLabel12.setBounds(10, 10, 110, 30);

        jpanel1.setLayout(null);

        jpanel1.setBorder(new javax.swing.border.EtchedBorder());
        jLabel1.setText("\u6536\u8d39\u4ee3\u7801:");
        jpanel1.add(jLabel1);
        jLabel1.setBounds(10, 50, 60, 15);

        chargeCode.setEnabled(false);
        jpanel1.add(chargeCode);
        chargeCode.setBounds(90, 50, 90, 20);

        jLabel2.setText("\u6536\u8d39\u540d\u79f0:");
        jpanel1.add(jLabel2);
        jLabel2.setBounds(190, 50, 60, 15);

        chargeName.setEnabled(false);
        jpanel1.add(chargeName);
        chargeName.setBounds(280, 50, 90, 20);

        jLabel3.setText("\u8d39\u7528\u5355\u4ef7(\u5143):");
        jpanel1.add(jLabel3);
        jLabel3.setBounds(10, 90, 78, 15);

        uPrice.setEnabled(false);
        jpanel1.add(uPrice);
        uPrice.setBounds(90, 90, 90, 20);

        jLabel4.setText("\u8bb0\u8d39\u65b9\u5f0f:");
        jpanel1.add(jLabel4);
        jLabel4.setBounds(10, 130, 70, 15);

        dateCount.setText("\u6309\u6708\u8ba1\u7b97");
        dateCount.setEnabled(false);
        jpanel1.add(dateCount);
        dateCount.setBounds(90, 130, 90, 20);

        jLabel6.setText("\u5907\u6ce8\u8bf4\u660e:");
        jpanel1.add(jLabel6);
        jLabel6.setBounds(10, 180, 60, 15);

        remark.setEnabled(false);
        jScrollPane2.setViewportView(remark);

        jpanel1.add(jScrollPane2);
        jScrollPane2.setBounds(90, 180, 270, 110);

        jLabel7.setText("\u6536\u8d39\u5355\u4f4d:");
        jpanel1.add(jLabel7);
        jLabel7.setBounds(190, 90, 60, 15);

        unit.setModel(new javax.swing.DefaultComboBoxModel(new String[] { "", "度", "月", "立方" }));
        unit.setEnabled(false);
        jpanel1.add(unit);
        unit.setBounds(280, 90, 90, 23);

        operates.add(jpanel1);
        jpanel1.setBounds(10, 60, 390, 300);

        jControlPanel.add(operates);
        operates.setBounds(10, 10, 410, 370);

        buttons.setLayout(null);

        modify.setText("\u7f16\u8f91");
        modify.addActionListener(new java.awt.event.ActionListener() {
            public void actionPerformed(java.awt.event.ActionEvent evt) {
                modifyActionPerformed(evt);
            }
        });

        buttons.add(modify);
        modify.setBounds(50, 10, 60, 23);

        save.setText("\u4fdd\u5b58");
        save.setEnabled(false);
        save.addActionListener(new java.awt.event.ActionListener() {
            public void actionPerformed(java.awt.event.ActionEvent evt) {
                saveActionPerformed(evt);
            }
        });

        buttons.add(save);
        save.setBounds(140, 10, 60, 23);

        quit.setText("\u5173\u95ed");
        quit.addActionListener(new java.awt.event.ActionListener() {
            public void actionPerformed(java.awt.event.ActionEvent evt) {
                quitActionPerformed(evt);
            }
        });

        buttons.add(quit);
        quit.setBounds(320, 10, 60, 23);

        dispose.setText("\u653e\u5f03");
        dispose.setEnabled(false);
        dispose.addActionListener(new java.awt.event.ActionListener() {
            public void actionPerformed(java.awt.event.ActionEvent evt) {
                disposeActionPerformed(evt);
            }
        });

        buttons.add(dispose);
        dispose.setBounds(230, 10, 60, 23);

        jControlPanel.add(buttons);
        buttons.setBounds(10, 380, 410, 40);

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

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

    private void SFListValueChanged(javax.swing.event.ListSelectionEvent evt) {//GEN-FIRST:event_SFListValueChanged
// TODO 将在此处添加您的处理代码：       
            query(SFList.getSelectedIndex());            
            status.setText("收费项目："+SFList.getSelectedValue().toString());
        
    }//GEN-LAST:event_SFListValueChanged

    private void disposeActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_disposeActionPerformed
// TODO 将在此处添加您的处理代码：
        if(modifyFlag==true){
            disabledTools();           
            modify.setEnabled(true);
            save.setEnabled(false);dispose.setEnabled(false);
            modifyFlag=false;
        }       
    }//GEN-LAST:event_disposeActionPerformed

    private void saveActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_saveActionPerformed
// TODO 将在此处添加您的处理代码：
        if(addFlag==true){
                disabledTools();
                addFlag=false;
            }
        if(modifyFlag==true){
                disabledTools();                
                update();          
                modifyFlag=false;            
        }
        modify.setEnabled(true);
        save.setEnabled(false);dispose.setEnabled(false);
    }//GEN-LAST:event_saveActionPerformed

    private void modifyActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_modifyActionPerformed
// TODO 将在此处添加您的处理代码：
        modifyFlag=true;
        enabledTools();
        modify.setEnabled(false);
        save.setEnabled(true);dispose.setEnabled(true);
    }//GEN-LAST:event_modifyActionPerformed
        
    private void quitActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_quitActionPerformed
// TODO 将在此处添加您的处理代码：
        dispose();
        try{
            db.close();
        }
        catch(Exception e){
            System.out.println("数据库关闭异常"+e);
        }
    }//GEN-LAST:event_quitActionPerformed
    
    /**
     * @param args the command line arguments
     */
    public static void main(String args[]) {
        java.awt.EventQueue.invokeLater(new Runnable() {
            public void run() {
                new SFItemJFrame().setVisible(true);
            }
        });
    }
    
    // 变量声明 - 不进行修改//GEN-BEGIN:variables
    private javax.swing.JList SFList;
    private javax.swing.JPanel buttons;
    private javax.swing.JTextField chargeCode;
    private javax.swing.JTextField chargeName;
    private javax.swing.JTextField dateCount;
    private javax.swing.JButton dispose;
    private javax.swing.JPanel jControlPanel;
    private javax.swing.JPanel jIndexPanel;
    private javax.swing.JLabel jLabel1;
    private javax.swing.JLabel jLabel12;
    private javax.swing.JLabel jLabel2;
    private javax.swing.JLabel jLabel3;
    private javax.swing.JLabel jLabel4;
    private javax.swing.JLabel jLabel6;
    private javax.swing.JLabel jLabel7;
    private javax.swing.JLabel jLabel8;
    private javax.swing.JPanel jMainPanel;
    private javax.swing.JPanel jPanel2;
    private javax.swing.JScrollPane jScrollPane1;
    private javax.swing.JScrollPane jScrollPane2;
    private javax.swing.JPanel jpanel1;
    private javax.swing.JButton modify;
    private javax.swing.JPanel operates;
    private javax.swing.JButton quit;
    private javax.swing.JTextArea remark;
    private javax.swing.JButton save;
    private javax.swing.JLabel status;
    private javax.swing.JTextField uPrice;
    private javax.swing.JComboBox unit;
    // 变量声明结束//GEN-END:variables
    
}