sellmap.java~69~

管理系统

   /* public void showMap(){
        jTextField1.setBackground(new Color(125, 0, 0));
        jTextField1.setBorder(BorderFactory.createRaisedBevelBorder());
        jTextField1.setBounds(new Rectangle(0, 0, 418, 20));
        jTextField2.setBackground(new Color(125, 0, 0));
        jTextField2.setBorder(BorderFactory.createRaisedBevelBorder());
        jTextField2.setBounds(new Rectangle(0, 20, 31, 20));
        jTextField3.setBackground(new Color(125, 0, 0));
        jTextField3.setBorder(BorderFactory.createRaisedBevelBorder());
        jTextField3.setBounds(new Rectangle( 0, 40, 222, 20));
        jTextField4.setBackground(new Color(125, 0, 0));
        jTextField4.setBorder(BorderFactory.createRaisedBevelBorder());
        jTextField4.setBounds(new Rectangle( 0, 60, 222, 20));
        jTextField5.setBackground(new Color(125, 0, 0));
        jTextField5.setBorder(BorderFactory.createRaisedBevelBorder());
        jTextField5.setBounds(new Rectangle(0, 80, 222, 20));
        jTextField6.setBackground(new Color(125, 0, 0));
        jTextField6.setBorder(BorderFactory.createRaisedBevelBorder());
        jTextField6.setBounds(new Rectangle(0, 100, 222, 20));
        jTextField7.setBackground(new Color(125, 0, 0));
        jTextField7.setBorder(BorderFactory.createRaisedBevelBorder());
        jTextField7.setBounds(new Rectangle(0, 120, 222, 20));
        jTextField9.setBackground(new Color(125, 0, 0));
        jTextField9.setBorder(BorderFactory.createRaisedBevelBorder());
        jTextField9.setBounds(new Rectangle(1, 160, 222, 20));
        jTextField10.setBackground(new Color(125, 0, 0));
        jTextField10.setBorder(BorderFactory.createRaisedBevelBorder());
        jTextField10.setBounds(new Rectangle(0, 180, 222, 20));
        jPanel1.setBackground(new Color(0, 210, 255));
        jTextField8.setBackground(new Color(125, 0, 0));
        jTextField8.setBorder(BorderFactory.createRaisedBevelBorder());
        jTextField8.setBounds(new Rectangle(0, 140, 222, 20));
        jTextField11.setBackground(new Color(125, 0, 0));
        jTextField11.setBorder(BorderFactory.createRaisedBevelBorder());
        jTextField11.setBounds(new Rectangle(0, 200, 222, 20));
        jTextField12.setBackground(new Color(125, 0, 0));
        jTextField12.setBorder(BorderFactory.createRaisedBevelBorder());
        jTextField12.setBounds(new Rectangle(0, num1[i], 222, 20));
    }*/
    int num = 10;
    int[] num1 = {0,20,40,60,80,100,120,140,160,180,200,220};
    JLabel jLabel1 = new JLabel();
    JLabel jLabel2 = new JLabel();
    JLabel jLabel3 = new JLabel();
    JLabel jLabel4 = new JLabel();
    JLabel jLabel5 = new JLabel();
    JLabel jLabel6 = new JLabel();
    JLabel jLabel7 = new JLabel();
    JLabel jLabel8 = new JLabel();
    JLabel jLabel9 = new JLabel();
    JLabel jLabel10 = new JLabel();
    JLabel jLabel11 = new JLabel();
    JLabel jLabel12 = new JLabel();
    JLabel jLabel13 = new JLabel();
    public void getPrice(){
        String price = null;
        int i = 0;
        int k = 1;
        for ( i = 0; i < 12; i++,k++) {
           try {
            price = SDBManager.getOne("select sum(convert(float,sprice)) from sell where sdate like '2007-0"+k+"___'").elementAt(0).toString();
            if(Double.parseDouble(price) < 100000){
                num = 70;
                JTextField txt = (JTextField)v.elementAt(i);
                txt.setBackground(new Color(125, 0, 0));
                txt.setBorder(BorderFactory.createRaisedBevelBorder());
                txt.setBounds(new Rectangle(0, num1[i], num, 20));
                txt.setText(""+price+"￥");
                txt.setHorizontalAlignment(txt.RIGHT);
            }
            else if(Double.parseDouble(price) > 100000 && Double.parseDouble(price) < 300000){
                num = 60;
                JTextField txt = (JTextField)v.elementAt(i);
                txt.setBackground(new Color(125, 0, 0));
                txt.setBorder(BorderFactory.createRaisedBevelBorder());
                txt.setBounds(new Rectangle(0, num1[i], num, 20));

            }
            else if(Double.parseDouble(price) > 300000 && Double.parseDouble(price) < 500000){
                num = 90;
                JTextField txt = (JTextField)v.elementAt(i);
                txt.setBackground(new Color(125, 0, 0));
                txt.setBorder(BorderFactory.createRaisedBevelBorder());
                txt.setBounds(new Rectangle(0, num1[i], num, 20));

            }
            else if(Double.parseDouble(price) > 500000 && Double.parseDouble(price) < 700000){
                num = 120;
                JTextField txt = (JTextField)v.elementAt(i);
                txt.setBackground(new Color(125, 0, 0));
                txt.setBorder(BorderFactory.createRaisedBevelBorder());
                txt.setBounds(new Rectangle(0, num1[i], num, 20));

            }
            else if(Double.parseDouble(price) > 700000 && Double.parseDouble(price) < 900000){
                num = 150;
                JTextField txt = (JTextField)v.elementAt(i);
                txt.setBackground(new Color(125, 0, 0));
                txt.setBorder(BorderFactory.createRaisedBevelBorder());
                txt.setBounds(new Rectangle(0, num1[i], num, 20));

            }
            else if(Double.parseDouble(price) > 900000 && Double.parseDouble(price) < 1100000){
                num = 180;
                JTextField txt = (JTextField)v.elementAt(i);
                txt.setBackground(new Color(125, 0, 0));
                txt.setBorder(BorderFactory.createRaisedBevelBorder());
                txt.setBounds(new Rectangle(0, num1[i], num, 20));

            }
            else if(Double.parseDouble(price) > 1100000 && Double.parseDouble(price) < 1300000){
                num = 210;
                JTextField txt = (JTextField)v.elementAt(i);
                txt.setBackground(new Color(125, 0, 0));
                txt.setBorder(BorderFactory.createRaisedBevelBorder());
                txt.setBounds(new Rectangle(0, num1[i], num, 20));

            }
            else if(Double.parseDouble(price) > 1300000 && Double.parseDouble(price) < 1500000){
                num = 230;
                JTextField txt = (JTextField)v.elementAt(i);
                txt.setBackground(new Color(125, 0, 0));
                txt.setBorder(BorderFactory.createRaisedBevelBorder());
                txt.setBounds(new Rectangle(0, num1[i], num, 20));

            }
            else if(Double.parseDouble(price) > 1500000 && Double.parseDouble(price) < 1800000){
                num = 260;
                JTextField txt = (JTextField)v.elementAt(i);
                txt.setBackground(new Color(125, 0, 0));
                txt.setBorder(BorderFactory.createRaisedBevelBorder());
                txt.setBounds(new Rectangle(0, num1[i], num, 20));

            }
            else if(Double.parseDouble(price) > 1800000 && Double.parseDouble(price) < 2100000){
                num = 290;
                JTextField txt = (JTextField)v.elementAt(i);
                txt.setBackground(new Color(125, 0, 0));
                txt.setBorder(BorderFactory.createRaisedBevelBorder());
                txt.setBounds(new Rectangle(0, num1[i], num, 20));

            }
            else if(Double.parseDouble(price) > 2100000 && Double.parseDouble(price) < 2400000){
                num = 310;
                JTextField txt = (JTextField)v.elementAt(i);
                txt.setBackground(new Color(125, 0, 0));
                txt.setBorder(BorderFactory.createRaisedBevelBorder());
                txt.setBounds(new Rectangle(0, num1[i], num, 20));

            }
            else if(Double.parseDouble(price) > 2400000){
                num = 380;
                JTextField txt = (JTextField)v.elementAt(i);
                txt.setBackground(new Color(125, 0, 0));
                txt.setBorder(BorderFactory.createRaisedBevelBorder());
                txt.setBounds(new Rectangle(0, num1[i], num, 20));

            }
        } catch (Exception ex) {
            num = 40;
            JTextField txt = (JTextField)v.elementAt(i);
            txt.setBackground(new Color(125, 0, 0));
            txt.setBorder(BorderFactory.createRaisedBevelBorder());
            txt.setBounds(new Rectangle(0, num1[i], num, 20));
            txt.setText("0.0￥");
            txt.setHorizontalAlignment(txt.RIGHT);
        }
        }

    }

}