mdibookfrm.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 javax.swing.JFrame;

class Mdibookfrm extends JFrame implements ActionListener
{
	 JLabel l_msg,l_idd,l_bookname,l_company,l_author,l_wenli,l_price,l_number,l_beizhu;
	 JTextField t_idd,t_bookname,t_company,t_author,t_price,t_number,t_beizhu;
	 JButton b_clear,b_enter,b_update,b_back;
	 JPanel pan1,pan2,pan3,pan4,pan5,pan6,pan7,pan8,pan9,pan10;
	 JComboBox c_wenli;
	 
	 NetConn sql;
	 Statement sqll,sql0;
	 ResultSet rs,rs0;
	 String a0,a1,a2,a3,a4,a5,a6,a7;
	 
	 Mdibookfrm()
	 {
		 
		 super("修改书籍窗口");
		 l_msg     =new JLabel("修改书籍        ");
		 l_idd     =new JLabel("输入id查询：");
		 l_bookname=new JLabel("书籍名称：");
		 l_company =new JLabel("出版发行：");
		 l_author  =new JLabel("书籍作者：");
		 l_wenli   =new JLabel("文理分类：");
		 l_price   =new JLabel("书籍售价：");
		 l_number  =new JLabel("书籍数量：");
		 t_idd     =new JTextField("",10);
		 t_bookname=new JTextField("",10);
		 t_company=new JTextField("",10);
		 t_author=new JTextField("",10);
		 c_wenli=new JComboBox();
		 c_wenli.addItem("文");
		 c_wenli.addItem("理");
		 c_wenli.setEditable(false);
		 t_price=new JTextField("",10);
		 t_number=new JTextField("",10);
		 b_clear=new JButton("删除");
		 b_enter=new JButton("查询");
		 b_update=new JButton("更新");
		 b_back=new JButton("返回");
		 b_clear.addActionListener(this);
		 b_enter.addActionListener(this);
		 b_update.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();pan9=new JPanel();pan10=new JPanel();
		 pan1.add(l_msg);pan2.add(l_bookname);pan2.add(t_bookname);pan3.add(l_company);pan3.add(t_company);
		 pan4.add(l_author);pan4.add(t_author);pan5.add(l_wenli);pan5.add(c_wenli);pan6.add(l_price);pan6.add(t_price);
		 pan7.add(l_number);pan7.add(t_number);pan9.add(b_update);pan9.add(b_clear);pan9.add(b_back);
		 pan10.add(l_idd);pan10.add(t_idd);pan10.add(b_enter);
		 setLayout(new GridLayout(9,1));
		 add(pan1);add(pan10);add(pan2);add(pan3);add(pan4);add(pan5);add(pan6);add(pan7);add(pan9);
		 
		 sql=new NetConn();
		 
		 //setBounds(350,150,400,500);
		 this.pack();
		 this.setLocation(this.getToolkit().getScreenSize().width/2-this.getWidth()/2,this.getToolkit().getScreenSize().height/2-this.getHeight()/2);
		 setVisible(true);
		 
	 }
	 public void actionPerformed(ActionEvent ef)
	 {
		 
		 if(ef.getSource()==b_back)
		 {
			 dispose();
		 }
		 
		 else if(ef.getSource()==b_update)
		 {
			 if(t_bookname.getText().equals("")||t_company.getText().equals("")||t_author.getText().equals(""))
			 {
				 l_msg.setText("书名，出版社和作者不能为空！");
				 
			 }
			 
			 else
			 {
				try
				 {
					 sqll=sql.connect();
					 a0="'"+t_idd.getText().trim()+"'";
					 a1="'"+t_bookname.getText().trim()+"'";
					 a2="'"+t_company.getText().trim()+"'";
					 a3="'"+t_author.getText().trim()+"'";
					 a4="'"+c_wenli.getSelectedItem()+"'";
					 a5="'"+t_price.getText().trim()+"'";
					 a6="'"+t_number.getText().trim()+"'";
					 l_msg.setText("1");
					 String temp="UPDATE books set bookname="+a1+", company="+a2+", author="+a3+", price="+a5+", conun="+a6+", wenli="+a4+" where id="+a0;
					 sqll.executeUpdate(temp);
					 String tem="UPDATE bookbrowse set bookname="+a1+", wenli="+a4+" where id="+a0;
					 sqll.executeUpdate(tem);
					 l_msg.setText("书籍修改成功！");
				 }
				 catch(SQLException e3)
				 {}
			 }
		 }
		 
		 else if(ef.getSource()==b_clear)
		 {
			try
			{
			boolean loop=false;
			sql0=sql.connect();
			String s0="'"+t_bookname.getText().trim()+"'";
			rs0=sql0.executeQuery("SELECT * FROM bookbrowse where isreturn="+"'"+"n"+"'"+" and bookname="+s0);
			while(rs0.next())
			{
				loop=true;
			}
			if(loop==false)
			{
			sqll=sql.connect();
			
			sqll.executeUpdate("delete from books where id="+"'"+t_idd.getText()+"'");
			l_msg.setText("书籍删除成功！");
			}
			else
			{
				l_msg.setText("该书籍有外借，不能删除！");
			}
			}catch(SQLException e6)
			{}
		 }
		 
		 else if(ef.getSource()==b_enter)
		 {
			 try
			 {
				 sqll=sql.connect();
				 
				 String temp="SELECT * FROM books where id="+t_idd.getText().trim();
				 rs=sqll.executeQuery(temp);
				 l_msg.setText("1");
				 if(rs.next())
				 {
					 l_msg.setText("2");
					 t_bookname.setText(rs.getString(2));
					 t_company.setText(rs.getString(3));
					 t_author.setText(rs.getString(4));
					 t_price.setText(String.valueOf(rs.getInt(5)));
					 t_number.setText(String.valueOf(rs.getInt(6)));
					 c_wenli.setSelectedItem(rs.getString(7));
					 
					 l_msg.setText("找到书籍！");
				 }
				 else
				 {
					 l_msg.setText("没有找到书籍！");
				 }
			 }
			 catch(SQLException e4)
			 {}
		 }
	 }
}