sfijframe.java

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

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

package SFManage;
import java.awt.*;
import mySql.*;
import myClass.*;
import java.sql.*;
import javax.swing.*;
import javax.swing.table.*;
import javax.swing.event.*;
/**
 *
 * @author  wang
 */
public class SFIJFrame extends javax.swing.JFrame{
    ResultSet rs=null;
    DBSQLManager db=new DBSQLManager();
    DefaultTableModel KHData;
    DefaultTableModel NData;
    DefaultTableModel ZBData;
    DateChooserJButton_1 dateChooser1=new DateChooserJButton_1();
    DateChooserJButton_1 dateChooser2=new DateChooserJButton_1();
    boolean modifyFlag=false;
    public SFIJFrame() {
        super("费用信息录入");
        try{
            String theLook=UIManager.getSystemLookAndFeelClassName();//更新界面
            UIManager.setLookAndFeel(theLook);
            SwingUtilities.updateComponentTreeUI(this);
        } catch(Exception e){
            System.err.println("异常："+e);
        }
        initComponents();
        setSize(770,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 updateNTable(){
        NData.setRowCount(0);
	NData.fireTableDataChanged();
    }
    private void updateZBTable(){
        ZBData.setRowCount(0);
	ZBData.fireTableDataChanged();
    }
    private double getUprice(String key){
        double uPrice=0.0;
        String sql="select uPrice from chargeItem where chargeCode='"+key+"'";
        try{
            db.setSql(sql);
            db.executeQuery();
            rs=db.getRs();
            if(rs.next()){
                uPrice=rs.getDouble("uPrice");
            }
        }
        catch(Exception e){
            System.out.println("获取单价异常:"+e);
        }
        return uPrice;
    }
    private String getChargeCode(String key){
        String chargeCode=null;
         String sql="select chargeCode from chargeItem where chargeName='"+key+"'";
        try{
            db.setSql(sql);
            db.executeQuery();
            rs=db.getRs();
            if(rs.next()){
                chargeCode=rs.getString("chargeCode");
            }
        }
        catch(Exception e){
            System.out.println("获取收费项目代码异常:"+e);
        }
        return chargeCode;
    }
    private void insert1(){        
        int row = KHTable.getSelectedRow();
        String roomCode=KHData.getValueAt(row,1).toString();
        String chargeCode=Integer.valueOf(addChargeItem1.getSelectedIndex()+3).toString();        
        try{
            Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");//加载驱动
            Connection conn=DriverManager.getConnection("jdbc:odbc:wySystem","admin", "admin");
            String sql="insert into chargeInfo2 values(?,?,?,?,?,?,?)";
            PreparedStatement pre=conn.prepareCall(sql);
            pre.clearParameters();
            pre.setString(1,chargeCode);
            pre.setString(2,roomCode);
            pre.setDouble(3,getUprice(chargeCode));
            pre.setString(4,dateChooser1.getText()+"-01");
            pre.setString(5,"");
            pre.setInt(6,0);
            pre.setString(7,operator1.getText().trim());
            int flag=pre.executeUpdate();
            if(flag==1){
                JOptionPane.showMessageDialog(this,"添加常规类费用信息成功","添加费用信息",JOptionPane.INFORMATION_MESSAGE);
                queryKind1(roomCode,chargeCode);               
            }            
        }
        catch(Exception e){
            JOptionPane.showMessageDialog(this,"添加常规类费用信息失败","添加费用信息",JOptionPane.ERROR_MESSAGE);
            System.out.println("添加常规类收费信息异常:"+e);
        }
    }
    private void query1(String key){  //查询
        String sql="select * from chargeInfo2,chargeItem where chargeInfo2.chargeCode=chargeItem.chargeCode And roomCode='"+key+"'";
        String data[]=new String[5];
        try{
            db.setSql(sql);
            db.executeQuery();
            rs=db.getRs();
            while(rs.next()){
                 data[0]=rs.getString("roomCode");
                 data[1]=rs.getString("startTime").substring(6, 7)+"月";
                 data[2]=rs.getString("chargeName");
                 data[3]=new Double(rs.getDouble("money")).toString();
                 data[4]=rs.getString("operator");
                 NData.addRow(data);
            }
        }
        catch(Exception e){
            System.out.println("查询常规类费用全部信息异常:"+e);
        }
    }
    private void queryKind1(String key1,String key2){  //查询
        String sql="select * from chargeInfo2,chargeItem where chargeInfo2.chargeCode=chargeItem.chargeCode And roomCode='"+key1+"' And chargeInfo2.chargeCode='"+key2+"'";
        String data[]=new String[5];
        try{
            db.setSql(sql);
            db.executeQuery();
            rs=db.getRs();
            if(rs.next()){
                 data[0]=rs.getString("roomCode");
                 data[1]=rs.getString("startTime").substring(6, 7)+"月";
                 data[2]=rs.getString("chargeName");
                 data[3]=new Double(rs.getDouble("money")).toString();
                 data[4]=rs.getString("operator");
                 NData.addRow(data);
            }
        }
        catch(Exception e){
            System.out.println("查询指定费用信息异常:"+e);
        }
    }
    private void insert2(){        
        int row = KHTable.getSelectedRow();
        String roomCode=KHData.getValueAt(row,1).toString();
        String chargeCode=Integer.valueOf(addChargeItem2.getSelectedIndex()+1).toString();
        int first=Integer.valueOf(firstNo.getText().trim()).intValue();
        int second=Integer.valueOf(secondNo.getText().trim()).intValue();
        int amount=second-first;
        double money=amount*getUprice(chargeCode);
        try{
            Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");//加载驱动
            Connection conn=DriverManager.getConnection("jdbc:odbc:wySystem","admin", "admin");
            String sql="insert into chargeInfo1 values(?,?,?,?,?,?,?,?,?,?)";
            PreparedStatement pre=conn.prepareCall(sql);
            pre.clearParameters();
            pre.setString(1,chargeCode);
            pre.setString(2,roomCode);
            pre.setInt(3,first);
            pre.setInt(4,second);
            pre.setInt(5,amount);
            pre.setDouble(6,money);          
            pre.setString(7,dateChooser1.getText()+"-01");
            pre.setString(8,"");
            pre.setInt(9,0);
            pre.setString(10,operator2.getText().trim());
            int flag=pre.executeUpdate();
            if(flag==1){
                JOptionPane.showMessageDialog(this,"添加走表类费用信息成功","添加费用信息",JOptionPane.INFORMATION_MESSAGE);
                queryKind2(roomCode,chargeCode);               
            }           
        }
        catch(Exception e){
            JOptionPane.showMessageDialog(this,"添加走表类费用信息失败","添加费用信息",JOptionPane.ERROR_MESSAGE);
            System.out.println("添加走表类费用信息异常:"+e);
        }
    }
    private void query2(String key){  //查询
        String sql="select * from chargeInfo1,chargeItem where chargeInfo1.chargeCode=chargeItem.chargeCode And roomCode='"+key+"'";
        String data[]=new String[7];
        try{
            db.setSql(sql);
            db.executeQuery();
            rs=db.getRs();
            while(rs.next()){
                 data[0]=rs.getString("roomCode");
                 data[1]=rs.getString("startTime").substring(6, 7)+"月";
                 data[2]=rs.getString("chargeName");
                 data[3]=new Integer(rs.getInt("firstNo")).toString();
                 data[4]=new Integer(rs.getInt("secondNo")).toString();
                 data[5]=rs.getString("operator");
                 ZBData.addRow(data);
            }
        }
        catch(Exception e){
            System.out.println("查询全部费用信息异常:"+e);
        }
    }
    private void queryKind2(String key1,String key2){  //查询
        String sql="select * from chargeInfo1,chargeItem where chargeInfo1.chargeCode=chargeItem.chargeCode And roomCode='"+key1+"' And chargeInfo1.chargeCode='"+key2+"'";
        String data[]=new String[6];
        try{
            db.setSql(sql);
            db.executeQuery();
            rs=db.getRs();
            if(rs.next()){
                 data[0]=rs.getString("roomCode");
                 data[1]=rs.getString("startTime").substring(6, 7)+"月";
                 data[2]=rs.getString("chargeName");
                 data[3]=new Integer(rs.getInt("firstNo")).toString();
                 data[4]=new Integer(rs.getInt("secondNo")).toString();
                 data[5]=rs.getString("operator");
                 ZBData.addRow(data);
            }
        }
        catch(Exception e){
            System.out.println("查询指定费用信息异常:"+e);
        }
    }
    private void update(){ 
        int row1=KHTable.getSelectedRow();
        String roomCode=KHData.getValueAt(row1, 1).toString();
        int row2=ZBTable.getSelectedRow();
        String chargeName=ZBData.getValueAt(row2, 2).toString();
        String chargeCode=getChargeCode(chargeName);
        int firstNo=Integer.valueOf(ZBData.getValueAt(row2,3).toString()).intValue();
        int secondNo=Integer.valueOf(ZBData.getValueAt(row2,4).toString()).intValue();
        int amount=secondNo-firstNo;
        double uPrice=getUprice(chargeCode);
        double money=amount*uPrice;
        String sql="update chargeInfo1 set firstNo="+firstNo+
                ",secondNo="+secondNo+",amount="+amount+",fee="+money+
                " where chargeCode='"+chargeCode+"' And roomCode='"+roomCode+"'";        
        try{
              db.setSql(sql);
              db.executeUpdate();             
        }
        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();