borbookfrm.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.*;
import java.util.Date;
class Borbookfrm extends JFrame implements ActionListener
{
	JLabel l_msg,l_user,l_bookname,l_data,l_department,l_id;
	JTextField t_user,t_bookname,t_data,t_department,t_id;
	JButton b_enter,b_clear,b_back,b_search;
	JPanel pan1,pan2,pan3,pan4,pan5,pan6,pan7,pan8;
	Date d;
	String sid,sde,wenli;
	
	NetConn sql;
	Statement sqll,sqlll;
	ResultSet rs,rss;
	
	Borbookfrm()
	{
		
		super("借书窗口");
		l_msg      =new JLabel("借书窗口    ");
		l_user     =new JLabel("借阅学生：");
		l_department=new JLabel("学生院系：");
		l_id=new JLabel("书籍编号：");
		l_bookname =new JLabel("书籍名称：");
		l_data     =new JLabel("借阅日期：");
		t_department=new JTextField("",11);
		t_department.setEditable(false);
		t_user     =new JTextField("",11);
		t_id=new JTextField("",11);
		t_bookname =new JTextField("",11);
		t_bookname.setEditable(false);
		t_data     =new JTextField("",11);
		d=new Date();
		t_data.setText(d.toLocaleString());
		b_search=new JButton("查询");
		b_enter    =new JButton("确定");
		b_clear    =new JButton("清除");
		b_back     =new JButton("返回");
		b_search.addActionListener(this);
		b_enter.addActionListener(this);
		b_clear.addActionListener(this);
		b_back.addActionListener(this);
		pan1=new JPanel();pan2=new JPanel();pan3=new JPanel();pan4=new JPanel();pan5=new JPanel();pan6=new JPanel();pan7=new JPanel();pan8=new JPanel();
		pan1.add(l_msg);pan2.add(l_user);pan2.add(t_user);pan7.add(l_department);pan7.add(t_department);pan8.add(l_id);pan8.add(t_id);pan8.add(b_search);pan3.add(l_bookname);pan3.add(t_bookname);
		pan4.add(l_data);pan4.add(t_data);pan6.add(b_enter);pan6.add(b_clear);pan6.add(b_back);
		setLayout(new GridLayout(7,1));
		add(pan1);add(pan2);add(pan7);add(pan8);add(pan3);add(pan4);add(pan6);
		
		sql=new NetConn();
		
		//setBounds(400,100,400,500);
		this.pack();
		this.setLocation(this.getToolkit().getScreenSize().width/2-this.getWidth()/2,this.getToolkit().getScreenSize().height/2-this.getHeight()/2);				
	}
	
	public void actionPerformed(ActionEvent ed)
	{
		
		if(ed.getSource()==b_back)
		{			
			dispose();
		}
		
		else if(ed.getSource()==b_clear)
		{
			t_user.setText("");t_id.setText("");
			l_msg.setText("借书窗口    ");
		}
		
		else if(ed.getSource()==b_enter)
		{
			if(t_department.getText().equals("")||t_bookname.getText().equals(""))
			{
				l_msg.setText("学生院系和书籍名称不能为空！");
			}
			else
			{
			try
			{
				 sqll=sql.connect();
				 sqlll=sql.connect();
				 
				 boolean loop=true;
				 boolean mark=true;
				 int num;
				 String s0=new String();
				 String s2="'"+t_user.getText().trim()+"'";
				 String s3="'"+t_id.getText().trim()+"'";
				 String s4="'"+t_data.getText().trim()+"'";
				 String s6="'"+"n"+"'";
				 l_msg.setText("1");
				 
				 rss=sqlll.executeQuery("SELECT * FROM books where id="+s3);
				 while(rss.next())
				 {
				 	s0=rss.getString(6);
				 }
				 if(Integer.parseInt(s0)<=0)
				 {
				 	mark=false;
				 	l_msg.setText("该书没有库存，暂不能借！");
				 }
				 
				 rss=sqlll.executeQuery("SELECT * FROM bookbrowse where studentname="+s2+" and isreturn="+"'"+"n"+"'"+" and bookname="+sid);
				 while(rss.next())
				 {
				 	loop=false;
				 }
				 
				 if(loop==true&&mark==true)
				 {
				 num=Integer.parseInt(s0);
				 num--;
				 s0=Integer.toString(num);
				 String tem="UPDATE books set conun="+s0+" where id="+s3;
				 sqll.executeUpdate(tem);
				 String temp="INSERT INTO bookbrowse (id,studentname, bookname, borrowdata, wenli, isreturn, studepartment) VALUES ("+s3+","+s2+","+sid+","+s4+","+wenli+","+s6+","+sde+")";
				 sqll.executeUpdate(temp);
				 l_msg.setText("用户借书成功！");
				 }
				 else if(loop==false)
				 {
				 	l_msg.setText("你借该书未还，暂不能借！");
				 }
			}
			catch(SQLException er)
			{
				System.out.println(er);
			}
			}
		}
		else if(ed.getSource()==b_search)
		{
				t_department.setText("");
				t_bookname.setText("");
				try
			{
				sqll=sql.connect();
				
				String a1="'"+t_user.getText().trim()+"'";
				String a2="'"+t_id.getText().trim()+"'";
				
				rs=sqll.executeQuery("SELECT * FROM users where username="+a1);
				 while(rs.next())
				 {
				 t_department.setText(rs.getString(5));
				 }
				 sde="'"+t_department.getText().trim()+"'";
				 
				rs=sqll.executeQuery("SELECT * FROM books where id="+a2);
				 while(rs.next())
				 {
				 t_bookname.setText(rs.getString(2));
				 }
				 l_msg.setText("查找成功！");
				 sid="'"+t_bookname.getText().trim()+"'";
				 
				 rs=sqll.executeQuery("SELECT * FROM books where id="+a2);
				 while(rs.next())
				 {
				 wenli="'"+rs.getString(7)+"'";
				 }
			}
			catch(SQLException es)
			{
				System.out.println(es);
			}
	    }
}
}