tongji.java

图书馆系统

import java.awt.BorderLayout;

import javax.swing.JOptionPane;
import javax.swing.JPanel;
import java.awt.GraphicsConfiguration;
import java.awt.HeadlessException;

import javax.swing.JFrame;
import java.awt.Dimension;
import javax.swing.JButton;
import java.awt.Rectangle;
import java.awt.Point;
import java.sql.*;
import java.util.*;
import java.awt.*;

public class TongJi extends JFrame {

	private static final long serialVersionUID = 1L;

	private JPanel jContentPane = null;

	ResultSet rs;
	DBManager db=new DBManager();  //  @jve:decl-index=0:
	int [] one=new int[5];
	int i=0,j=0,k=0;
	String [] two=new String[5];
	String [] three=new String[4];  //  @jve:decl-index=0:

	public TongJi() throws HeadlessException {
		// TODO 自动生成构造函数存根
		super();
		initialize();
	}

	public TongJi(GraphicsConfiguration arg0) {
		super(arg0);
		// TODO 自动生成构造函数存根
		initialize();
	}

	public TongJi(String arg0) throws HeadlessException {
		super(arg0);
		// TODO 自动生成构造函数存根
		initialize();
	}

	public TongJi(String arg0, GraphicsConfiguration arg1) {
		super(arg0, arg1);
		// TODO 自动生成构造函数存根
		initialize();
	}

	/**
	 * This method initializes this
	 * 
	 * @return void
	 */
	private void initialize() {
		this.setSize(636, 364);
		this.setContentPane(getJContentPane());
		this.setTitle("五大热门图书--统计图");
		this.addWindowListener(new java.awt.event.WindowAdapter() {
			public void windowOpened(java.awt.event.WindowEvent e) {
				System.out.println("windowOpened()"); // TODO Auto-generated Event stub windowOpened()
				String sql="select top 5 * from Books order by Totaljie desc";
				rs=db.getResult(sql);
				try{
					while(rs.next()){
						one[i]=rs.getInt("Totaljie");
						two[i]=rs.getString("Bookname").trim();
						System.out.println(one[i]);
						System.out.println(two[i]);
						i++;							
					}
				}
				catch(Exception e2){}
			}
		});
		
	}

	/**
	 * This method initializes jContentPane
	 * 
	 * @return javax.swing.JPanel
	 */
	private JPanel getJContentPane() {
		if (jContentPane == null) {
			jContentPane = new JPanel();
			jContentPane.setLayout(null);
		}
		return jContentPane;
	}

	/**
	 * This method initializes jButtonOK	
	 * 	
	 * @return javax.swing.JButton	
	 */	
	
	public void paint(Graphics g) {
		j=one[0]/4;
		three[0]=Integer.toString(j);
		three[1]=Integer.toString(j*2);
		three[2]=Integer.toString(j*3);
		three[3]=Integer.toString(j*4);		
		setBackground(new Color(200, 100, 100));
		Graphics2D g2D = (Graphics2D) g;
		g2D.setPaint(Color.blue);
		g2D.fillRect(100, 280-200, 60, 200);
		g2D.fillRect(200, 280-200*one[1]/one[0], 60, 200*one[1]/one[0]);
		g2D.fillRect(300, 280-200*one[2]/one[0], 60, 200*one[2]/one[0]);
		g2D.fillRect(400, 280-200*one[3]/one[0], 60, 200*one[3]/one[0]);
		g2D.fillRect(500, 280-200*one[4]/one[0], 60, 200*one[4]/one[0]);	
		g2D.setPaint(Color.black);
		g2D.drawLine(50, 280, 600, 280);
		g2D.drawLine(50, 280, 50, 20);
		g2D.drawLine(50, 230, 60, 230);
		g2D.drawLine(50, 180, 60, 180);
		g2D.drawLine(50, 130, 60, 130);
		g2D.drawLine(50, 80, 60, 80);
		g2D.drawLine(50, 30, 60, 30);
		
		g2D.drawString("人数", 40, 10);
		g2D.drawString("0", 40, 280);
		g2D.drawString(three[0], 30, 230);
		g2D.drawString(three[1], 30, 180);
		g2D.drawString(three[2], 30, 130);
		g2D.drawString(three[3], 30, 80);
		g2D.drawString("5", 30, 30);
		g2D.drawString(two[0], 100, 295);
		g2D.drawString(two[1], 200, 295);
		g2D.drawString(two[2], 300, 295);
		g2D.drawString(two[3], 400, 295);
		g2D.drawString(two[4], 500, 295);
		

		// g2D.drawRect(100, 280-bachelor/maxMan*250, 80, bachelor/maxMan*250);

	}

}  //  @jve:decl-index=0:visual-constraint="10,10"