statistics.java

在程序的Borlistbookfrm.java中实现打印功能

import java.util.*;
import java.awt.*;
import java.io.*;
import java.net.*;
import java.sql.*;
import java.awt.event.*;
import javax.swing.*;

public class Statistics extends JFrame implements ActionListener
{
    JLabel l_msg,l_total,l_guancang,l_waijie,l_wenke,l_like;
    JButton b_sta,b_back;
    JProgressBar p_total,p_guancang,p_waijie,p_wenke,p_like;
    JPanel pan1,pan2,pan3,pan4,pan5,pan6,pan7;
    
    NetConn sql;
	Statement sqll;
	ResultSet rs;
    
    Statistics()
    {
    	super("信息统计");
    	l_msg=new JLabel("信息统计      ");
    	l_total=new JLabel("总库存量：");
    	l_guancang=new JLabel("馆藏书籍：");
    	l_waijie=new JLabel("外借书籍：");
    	l_wenke=new JLabel("文科书籍：");
    	l_like=new JLabel("理科书籍：");
    	b_sta=new JButton("统计");
    	b_back=new JButton("返回");
    	b_sta.addActionListener(this);
    	b_back.addActionListener(this);
    	p_total=new JProgressBar();
		p_total.setStringPainted(true);
		p_guancang=new JProgressBar();
		p_guancang.setStringPainted(true);
		p_waijie=new JProgressBar();
		p_waijie.setStringPainted(true);
		p_wenke=new JProgressBar();
		p_wenke.setStringPainted(true);
		p_like=new JProgressBar();
		p_like.setStringPainted(true);
    	pan1=new JPanel();pan2=new JPanel();pan3=new JPanel();pan4=new JPanel();
    	pan5=new JPanel();pan6=new JPanel();pan7=new JPanel();
    	pan1.add(l_msg);
    	pan2.add(l_total);pan2.add(p_total);
    	pan3.add(l_guancang);pan3.add(p_guancang);
    	pan4.add(l_waijie);pan4.add(p_waijie);
    	pan5.add(l_wenke);pan5.add(p_wenke);
    	pan6.add(l_like);pan6.add(p_like);
    	pan7.add(b_sta);pan7.add(b_back);
    	
    	setLayout(new GridLayout(7,1));
    	add(pan1);add(pan2);add(pan3);add(pan4);add(pan5);add(pan6);add(pan7);
    	
    	sql=new NetConn();
    	
    	this.pack();
		this.setLocation(this.getToolkit().getScreenSize().width/2-this.getWidth()/2,this.getToolkit().getScreenSize().height/2-this.getHeight()/2);        
    }
    public void  actionPerformed(ActionEvent e)
    {
    	if(e.getSource()==b_back)
    	{
    		dispose();
    	}
    	else if(e.getSource()==b_sta)
    	{
    		try{
    			sqll=sql.connect();
    			int bookswen,booksli,borwen,borli;
    			int total,guancang,waijie,wenke,like;
    			bookswen=0;booksli=0;borwen=0;borli=0;
    			
    			String temp="select * from books where wenli="+"'"+"文"+"'";
				rs=sqll.executeQuery(temp);
				while(rs.next())
				{
					bookswen+=rs.getInt(6);
				}
				
				temp="select * from books where wenli="+"'"+"理"+"'";
				rs=sqll.executeQuery(temp);
				while(rs.next())
				{
					booksli+=rs.getInt(6);
				}
				
				temp="select * from bookbrowse where wenli="+"'"+"文"+"'"+" and isreturn="+"'"+"n"+"'";
				rs=sqll.executeQuery(temp);
				while(rs.next())
				{
					borwen++;
				}
				
				temp="select * from bookbrowse where wenli="+"'"+"理"+"'"+" and isreturn="+"'"+"n"+"'";
				rs=sqll.executeQuery(temp);
				while(rs.next())
				{
					borli++;
				}
				
				total=bookswen+booksli+borwen+borli;
				guancang=bookswen+booksli;
				waijie=total-guancang;
				wenke=bookswen+borwen;
				like=booksli+borli;
				
				int i2=(guancang*100)/total;
				int i3=(waijie*100)/total;
				int i4=(wenke*100)/(wenke+like);
				int i5=(like*100)/(wenke+like);
				
				p_total.setValue(100);p_total.setString("共"+total+"本");
				p_guancang.setValue(i2);p_guancang.setString("共"+guancang+"本");
				p_waijie.setValue(i3);p_waijie.setString("共"+waijie+"本");
				p_wenke.setValue(i4);p_wenke.setString("共"+wenke+"本");
				p_like.setValue(i5);p_like.setString("共"+like+"本");
    		}catch(SQLException ed)
			{
				System.out.print(ed);
				
			}
    	}
    }
}