statframe.java

简单的书店管理系统,是课设期间教师指导完成的,希望会对大家有帮助!

package book;

import java.awt.Color;
import java.awt.event.ItemEvent;
import java.awt.event.ItemListener;
import java.sql.ResultSet;
import java.sql.SQLException;

import javax.swing.ImageIcon;
import javax.swing.JComboBox;
import javax.swing.JLabel;
import javax.swing.JOptionPane;
import javax.swing.JProgressBar;

public class StatFrame extends Mb implements ItemListener{

	private ButtonIcon close;
	private float sum,sum1,sum2,sum3;
	private JProgressBar p_bar,p_bar1,p_bar2,p_bar3;
	private JLabel icon,book,book1,book2,book3;
	private JLabel reader,reader1,reader2,reader3;;
	private JComboBox bookType;
	private ResultSet rs;
	StatFrame(String s, int i, int j) throws SQLException{
		super(s, i, j);
		con.setLayout(null);	
		shezhi();
		add();
	
	}
	
	void shezhi() throws SQLException{
		readerStat();
		setLabel();
		setCombobox();
		setProgressBar();
		setP_barValut();
		setBook();
	}
	
	void setLabel(){
		
		icon=new JLabel(new ImageIcon("./data/image/heard/zonghetongji.jpg"));
		icon.setBounds(0,8,500,50);
		
		book=new JLabel("统计方式   :");
		book.setBounds(10,60,120,18);
		
		reader=new JLabel("当前所有读者:");
		reader.setBounds(20,130,120,18);
		
		book=new JLabel("");
		book.setBounds(430,130,120,18);
		
		reader1=new JLabel("当前借书读者:");
		reader1.setBounds(20,170,120,18);
		
		book1=new JLabel("");
		book1.setBounds(430,170,120,18);
		
		reader2=new JLabel("当前男性读者:");
		reader2.setBounds(20,210,120,18);
		
		book2=new JLabel("");
		book2.setBounds(430,210,120,18);
		
		reader3=new JLabel("当前女性读者:");
		reader3.setBounds(20,250,120,18);
		
		book3=new JLabel("");
		book3.setBounds(430,250,120,18);
	}
	
	void setCombobox(){
		bookType = new JComboBox();
		bookType.addItem("图书状态统计");
		bookType.addItem("读者状态统计");
		bookType.setBounds(10,80,120,18);
		bookType.addItemListener(this);
		
		close=new ButtonIcon("关闭");
		close.setBounds(400,280,70,25);
	}
	
	
    public void itemStateChanged(ItemEvent arg0) {
	  if(bookType.getSelectedIndex()==0){
		  try {
			readerStat();
			setReaderLabel();
			setP_barValut();
			setBook();
		} catch (SQLException e) {
			e.printStackTrace();
		}
	  }
	  
     if(bookType.getSelectedIndex()==1){
		  

		  try {
			BookStat();
			setBookLabel();
			setP_barValut();
			setBook();
			
		} catch (SQLException e) {
			// TODO 自动生成 catch 块
			e.printStackTrace();
		}
	  }
		
	}
	
	void setProgressBar(){
		p_bar=new JProgressBar(0,100);
		p_bar.setBackground(Color.white);
		p_bar.setStringPainted(true);
		p_bar.setBounds(130,130,280,18);
		
		
		p_bar1=new JProgressBar(0,100);
		p_bar1.setBackground(Color.white);
		p_bar1.setStringPainted(true);
		p_bar1.setBounds(130,170,280,18);
		
		
		p_bar2=new JProgressBar(0,100);
		p_bar2.setBackground(Color.white);
		p_bar2.setStringPainted(true);
		p_bar2.setBounds(130,210,280,18);
		
		p_bar3=new JProgressBar(0,100);
		p_bar3.setBackground(Color.white);
		p_bar3.setStringPainted(true);
		p_bar3.setBounds(130,250,280,18);
	}
	
	void setBook(){
		book.setText("数量： "+String.valueOf((int)sum));
		book1.setText("数量： "+String.valueOf((int)sum1));
		book2.setText("数量： "+String.valueOf((int)sum2));
		book3.setText("数量： "+String.valueOf((int)sum3));
	}
	
   void setP_barValut(){
	   p_bar.setValue(100); 
	   p_bar1.setValue((int)((sum1/sum)*100));
	   p_bar2.setValue((int)((sum2/sum)*100));
	   p_bar3.setValue((int)((sum3/sum)*100));
   }
	
   
   
   void  setReaderLabel(){
	   reader.setText("当前所有读者:");
	   reader1.setText("当前所有读者:");
	   reader2.setText("当前男性读者:");
	   reader3.setText("当前女性读者:");      
   }
   
   void setBookLabel(){
	   reader.setText("当前所有图书:");
	   reader1.setText("当前借出图书:");
	   reader2.setText("当前剩余图书:");
	   reader3.setText("当前超期图书:"); 
   }
	void readerStat() throws SQLException{
		MainDAO dao=new MainDAO();
		
		rs=dao.getSelect("select * from duzheziliao");
		rs.last();
		sum=rs.getRow();	
		
		
		rs=dao.getSelect("select * from duzheziliao where 已借数量>0");
		rs.last();
		sum1=rs.getRow();	
	
		rs=dao.getSelect("select * from duzheziliao where 读者性别='男'");
		rs.last();
		sum2=rs.getRow();	
		
		rs=dao.getSelect("select * from duzheziliao where 读者性别='女'");
		rs.last();
		sum3=rs.getRow();	
		
		dao.close();
		
	}
	
	void BookStat() throws SQLException{
		MainDAO dao=new MainDAO();
		
		rs=dao.getSelect("select * from tushuziliao");
		rs.last();
		sum=rs.getRow();	
		
		
		rs=dao.getSelect("select * from tushuziliao where 是否借出='是'");
		rs.last();
		sum1=rs.getRow();	
	
		sum2=sum-sum1;
		
		rs=dao.getSelect("select * from jiechutushu where 是否超期='是'");
		rs.last();
		sum3=rs.getRow();	
		
		dao.close();
		
	}
	
	
	void add(){
		
		con.add(icon);
		con.add(close);
		con.add(book);
		con.add(bookType);
		con.add(reader);
		con.add(reader1);
		con.add(reader2);
		con.add(reader3);
		
		con.add(book);
		con.add(book1);
		con.add(book2);
		con.add(book3);
		
		con.add(p_bar);
		con.add(p_bar1);
		con.add(p_bar2);
		con.add(p_bar3);
		con.validate();
	}

}