borlistbookfrm.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.*;

class Borlistbookfrm extends JFrame implements ActionListener
{
	Object a[][]; 
	Object colname[]={"借阅学生","书籍名称","借阅日期","还书日期","文理分类","是否归还"};
	JLabel l_name,l_bookname;
	JTextField t_name,t_bookname;
	JTable table;
	JButton b_enter,b_back;
	JProgressBar p_bar;
	JPanel pan1;
	String a1,a2;
	Container container;
	
	NetConn sql;
	Statement sqll;
	ResultSet rs;
	
	Borlistbookfrm()
	{
		
		super("借书列表");
		l_name=new JLabel("借阅者：");
		l_bookname=new JLabel("书籍：");
		t_name=new JTextField("",10);
		t_bookname=new JTextField("",10);
		a=new Object[30][6];
		table=new JTable(a,colname);
		b_enter=new JButton("确定");
		b_back=new JButton("打印");
		b_enter.addActionListener(this);
		b_back.addActionListener(this);
		pan1=new JPanel();
		pan1.add(l_name);pan1.add(t_name);
		pan1.add(l_bookname);pan1.add(t_bookname);pan1.add(b_enter);pan1.add(b_back);
		
		p_bar=new JProgressBar();
		p_bar.setStringPainted(true);
		container=getContentPane();
		container.add(new JScrollPane(table),BorderLayout.CENTER);
		container.add(pan1,BorderLayout.NORTH);
		container.add(p_bar,BorderLayout.SOUTH);
		
		sql=new NetConn();
		setBounds(0,0,500,300);
		//this.pack();
		this.setLocation(this.getToolkit().getScreenSize().width/2-this.getWidth()/2,this.getToolkit().getScreenSize().height/2-this.getHeight()/2);
	}
	public void  actionPerformed(ActionEvent eb)
	{
		
		if(eb.getSource()==b_back)
		{
			//dispose();
			table.print();
		}
		
		if(eb.getSource()==b_enter)
		{
			try
			{
				int i=0;
				sqll=sql.connect();
				
				for(int x=0;x<table.getRowCount();x++)
			    {
				    for(int y=0;y<6;y++)
				    {
					while(a[x][y]!="")
					{
						a[x][y]="";
					}
				    }
			    }
				
				a1="'"+"%"+t_name.getText().trim()+"%"+"'";
				a2="'"+"%"+t_bookname.getText().trim()+"%"+"'";
				
				String temp="select * from bookbrowse where studentname like "+a1+" and bookname like "+a2;
				rs=sqll.executeQuery(temp);
				
				while(rs.next())
				{
					a[i][0]=rs.getString(2);a[i][1]=rs.getString(3);a[i][2]=rs.getString(4);a[i][3]=rs.getDate(5);
					a[i][4]=rs.getString(6);a[i][5]=rs.getString(7);
					i++;
					p_bar.setValue(i);p_bar.setString("查询了"+i+"条记录");
					table.selectAll();
					table.clearSelection();
				}
			}
			catch(SQLException ed)
			{
				System.out.print(ed);
				
			}
		}
	}
}