sellmap.java

管理系统

package com.aptech.cdjj.sex.gui;

/**
 * <p>Title: </p>
 *
 * <p>Description: </p>
 *
 * <p>Copyright: Copyright (c) 2007</p>
 *
 * <p>Company: </p>
 *
 * @author not attributable
 * @version 1.0
 */
import javax.swing.*;
import java.awt.BorderLayout;
import java.awt.Rectangle;
import java.awt.Color;
import javax.swing.BorderFactory;
import java.awt.Dimension;
import java.awt.event.ActionEvent;
import java.awt.event.ActionListener;
import com.aptech.cdjj.sex.database.SDBManager;
import java.util.Vector;
import java.awt.SystemColor;
import java.awt.Font;
import java.awt.Frame;

public class SellMap extends JDialog{ //600，400

    SellMap(Frame ower,String title,boolean modal){
        super(ower,title,modal);
        try {
            jbInit();
        } catch (Exception ex) {
            ex.printStackTrace();
        }
    }

  SellMap(){
       this(new Frame(),"销售分析图",false);
   }

    private void jbInit() throws Exception {
        jPanel2.setBackground(SystemColor.desktop);
        jPanel2.setBorder(BorderFactory.createRaisedBevelBorder());
        jPanel2.setBounds(new Rectangle(113, 65, 418, 243));
        jPanel2.setLayout(null);
        jPanel1.setBackground(Color.orange);
        jLabel1.setFont(new java.awt.Font("宋体", Font.PLAIN, 32));
        jLabel1.setText("  2007年珠宝销售情况（比列图）");
        jLabel1.setBounds(new Rectangle(62, 4, 510, 55));
        jLabel2.setFont(new java.awt.Font("宋体", Font.PLAIN, 18));
        jLabel2.setForeground(Color.magenta);
        jLabel2.setText("一  月:");
        jLabel2.setBounds(new Rectangle(40, 66, 68, 17));
        jLabel3.setFont(new java.awt.Font("宋体", Font.PLAIN, 18));
        jLabel3.setForeground(new Color(0, 118, 0));
        jLabel3.setText("二  月:");
        jLabel3.setBounds(new Rectangle(40, 85, 71, 17));
        jLabel4.setFont(new java.awt.Font("宋体", Font.PLAIN, 18));
        jLabel4.setForeground(SystemColor.desktop);
        jLabel4.setText("三  月:");
        jLabel4.setBounds(new Rectangle(40, 105, 70, 17));
        jLabel5.setFont(new java.awt.Font("宋体", Font.PLAIN, 18));
        jLabel5.setForeground(Color.blue);
        jLabel5.setText("四  月:");
        jLabel5.setBounds(new Rectangle(40, 125, 67, 17));
        jLabel6.setFont(new java.awt.Font("宋体", Font.PLAIN, 18));
        jLabel6.setText("五  月:");
        jLabel6.setBounds(new Rectangle(40, 146, 69, 17));
        jLabel7.setFont(new java.awt.Font("宋体", Font.PLAIN, 18));
        jLabel7.setForeground(new Color(171, 33, 98));
        jLabel7.setText("六  月:");
        jLabel7.setBounds(new Rectangle(40, 165, 71, 17));
        jLabel8.setFont(new java.awt.Font("宋体", Font.PLAIN, 18));
        jLabel8.setForeground(Color.white);
        jLabel8.setText("七  月:");
        jLabel8.setBounds(new Rectangle(40, 186, 68, 17));
        jLabel9.setFont(new java.awt.Font("宋体", Font.PLAIN, 18));
        jLabel9.setForeground(Color.cyan);
        jLabel9.setText("八  月:");
        jLabel9.setBounds(new Rectangle(40, 206, 68, 17));
        jLabel10.setFont(new java.awt.Font("宋体", Font.PLAIN, 18));
        jLabel10.setForeground(SystemColor.desktop);
        jLabel10.setText("九  月:");
        jLabel10.setBounds(new Rectangle(40, 227, 68, 17));
        jLabel11.setFont(new java.awt.Font("宋体", Font.PLAIN, 18));
        jLabel11.setForeground(Color.gray);
        jLabel11.setText("十  月:");
        jLabel11.setBounds(new Rectangle(40, 248, 70, 17));
        jLabel12.setFont(new java.awt.Font("宋体", Font.PLAIN, 18));
        jLabel12.setForeground(Color.yellow);
        jLabel12.setText("十一月:");
        jLabel12.setBounds(new Rectangle(40, 267, 72, 17));
        jLabel13.setFont(new java.awt.Font("宋体", Font.PLAIN, 18));
        jLabel13.setForeground(Color.red);
        jLabel13.setText("十二月:");
        jLabel13.setBounds(new Rectangle(40, 286, 72, 17));
        jTextField1.setEnabled(false);
        jTextField1.setForeground(Color.blue);
        jTextField1.setDisabledTextColor(Color.cyan);
        jTextField2.setEnabled(false);
        jTextField2.setDisabledTextColor(Color.cyan);
        jTextField3.setEnabled(false);
        jTextField3.setDisabledTextColor(Color.cyan);
        jTextField4.setEnabled(false);
        jTextField4.setDisabledTextColor(Color.cyan);
        jTextField5.setEnabled(false);
        jTextField5.setDisabledTextColor(Color.cyan);
        jTextField6.setEnabled(false);
        jTextField6.setDisabledTextColor(Color.cyan);
        jTextField7.setEnabled(false);
        jTextField7.setDisabledTextColor(Color.cyan);
        jTextField8.setEnabled(false);
        jTextField8.setDisabledTextColor(Color.cyan);
        jTextField9.setEnabled(false);
        jTextField9.setDisabledTextColor(Color.cyan);
        jTextField10.setEnabled(false);
        jTextField10.setDisabledTextColor(Color.cyan);
        jTextField11.setEnabled(false);
        jTextField11.setDisabledTextColor(Color.cyan);
        jTextField12.setEnabled(false);
        jTextField12.setDisabledTextColor(Color.cyan);
        jPanel2.add(jTextField2);
        jPanel2.add(jTextField5);
        jPanel2.add(jTextField6);
        jPanel2.add(jTextField7);
        jPanel2.add(jTextField11);
        jPanel2.add(jTextField12);
        jPanel2.add(jTextField4);
        jPanel2.add(jTextField3);
        jPanel2.add(jTextField8);
        jPanel2.add(jTextField9);
        jPanel2.add(jTextField10);
        jPanel2.add(jTextField1);
        this.getContentPane().add(jPanel1, java.awt.BorderLayout.CENTER);
        jPanel1.add(jPanel2);
        jPanel1.add(jLabel9);
        jPanel1.add(jLabel10);
        jPanel1.add(jLabel11);
        jPanel1.add(jLabel13);
        jPanel1.add(jLabel12);
        jPanel1.add(jLabel8);
        jPanel1.add(jLabel7);
        jPanel1.add(jLabel2);
        jPanel1.add(jLabel3);
        jPanel1.add(jLabel4);
        jPanel1.add(jLabel5);
        jPanel1.add(jLabel6);
        jPanel1.add(jLabel1);
        jPanel1.setLayout(null);
        v.addElement(jTextField1);v.addElement(jTextField2);v.addElement(jTextField3);
        v.addElement(jTextField4);v.addElement(jTextField5);v.addElement(jTextField6);
        v.addElement(jTextField7);v.addElement(jTextField8);v.addElement(jTextField9);
        v.addElement(jTextField10);v.addElement(jTextField11);v.addElement(jTextField12);
        this.getPrice();
    }

    Vector v = new Vector();
    JPanel jPanel1 = new JPanel();
    JTextField jTextField1 = new JTextField();
    JTextField jTextField2 = new JTextField();
    JTextField jTextField3 = new JTextField();
    JTextField jTextField4 = new JTextField();
    JTextField jTextField5 = new JTextField();
    JTextField jTextField6 = new JTextField();
    JTextField jTextField7 = new JTextField();
    JTextField jTextField9 = new JTextField();
    JTextField jTextField10 = new JTextField();
    JTextField jTextField8 = new JTextField();
    JTextField jTextField11 = new JTextField();
    JTextField jTextField12 = new JTextField();
    JPanel jPanel2 = new JPanel();
    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 = 100;
                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) > 300000 && Double.parseDouble(price) < 500000){
                num = 130;
                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) > 500000 && Double.parseDouble(price) < 700000){
                num = 160;
                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) > 700000 && Double.parseDouble(price) < 900000){
                num = 190;
                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) > 900000 && Double.parseDouble(price) < 1100000){
                num = 220;
                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) > 1100000 && Double.parseDouble(price) < 1300000){
                num = 250;
                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) > 1300000 && Double.parseDouble(price) < 1500000){
                num = 280;
                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) > 1500000 && Double.parseDouble(price) < 1800000){
                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));
                txt.setText(""+price+"￥");
                txt.setHorizontalAlignment(txt.RIGHT);

            }
            else if(Double.parseDouble(price) > 1800000 && Double.parseDouble(price) < 2100000){
                num = 340;
                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) > 2100000 && Double.parseDouble(price) < 2400000){
                num = 370;
                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) > 2400000){
                num = 400;
                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);

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