borrowf.java

java实现的图书馆管理系统－设计论文

//图书借阅查询
import javax.swing.*;
import java.awt.*;
import java.awt.event.*;
import javax.swing.table.*;
import java.util.*;
import java.sql.*;
import javax.swing.table.AbstractTableModel;

public class BorrowF implements ActionListener,ItemListener
{ private JFrame frame;
  private Statement stmt;
  private Connection con;
  private JTable tableTest;
  private String[]columnNames={"书名","条形码","分类号","分类名","排架号","出版社",
                               "出版日期","入库日期","状态","简介"};
  private Object[][]rowData=new Object[100][10];
  private JButton btn;
  private JRadioButton rbtn1,rbtn2,rbtn3,rbtn4,rbtn5,rbtn6,rbtn7;
  private JComboBox jcb,jcb1;
  private JLabel lb1,lb2,lb3,lb4;
  private JTextField jtfd;
	public BorrowF()
	{
		frame=new JFrame("图书借阅查询");
		ImageIcon icon=new ImageIcon("images/home.gif");
		frame.setIconImage(icon.getImage());
		frame.setResizable(false);
        Font font1=new Font("宋体",Font.PLAIN,13);
		Container content=frame.getContentPane();

        //--创建各个组件--
	    btn=new JButton("执行查询");
	    jtfd=new JTextField();
	    jcb=new JComboBox();
	    jcb1=new JComboBox();
	    lb1=new JLabel("查询依据:");
	    lb2=new JLabel("关键词语:");
	    lb3=new JLabel("从");
	    lb4=new JLabel("到");
	    lb3.setVisible(false);
	    lb4.setVisible(false);
	    jcb.setVisible(false);
	    jcb1.setVisible(false);
	    JPanel pl=new JPanel();
	    rbtn1=new JRadioButton("图书编号");
	    rbtn2=new JRadioButton("图书名称");
	    rbtn3=new JRadioButton("读者条码");
	    rbtn4=new JRadioButton("读者姓名");
	    rbtn5=new JRadioButton("读者编号");
	    rbtn6=new JRadioButton("借阅时间");
	    rbtn7=new JRadioButton("应还时间");

	    //--设置各组件的事件--
	    rbtn1.addItemListener(this);
		rbtn2.addItemListener(this);
		rbtn3.addItemListener(this);
		rbtn4.addItemListener(this);
		rbtn5.addItemListener(this);
		rbtn6.addItemListener(this);
	    rbtn7.addItemListener(this);
	    rbtn1.setSelected(true);
	    btn.addActionListener(this);

        //--设置单选按钮组--
	    ButtonGroup group=new ButtonGroup();
	    group.add(rbtn1);
	    group.add(rbtn2);
	    group.add(rbtn3);
	    group.add(rbtn4);
	    group.add(rbtn5);
	    group.add(rbtn6);
	    group.add(rbtn7);


	    //--设置各个组件的大小和位置--
	    lb1.setBounds(50,30,80,25);
	    rbtn1.setBounds(130,30,80,25);
		rbtn2.setBounds(220,30,80,25);
		rbtn3.setBounds(130,60,80,25);
		rbtn4.setBounds(220,60,80,25);
		rbtn5.setBounds(130,90,80,25);
		rbtn6.setBounds(220,90,80,25);
		rbtn7.setBounds(130,120,80,25);
		lb2.setBounds(50,150,80,25);
        lb3.setBounds(115,150,30,25);
        jcb.setBounds(135,150,80,25);
        lb4.setBounds(220,150,30,25);
        jcb1.setBounds(240,150,80,25);
        jtfd.setBounds(130,150,190,25);
	    btn.setBounds(325,150,90,25);

	    //--设置各个组件的字体--
	    lb1.setFont(font1);
	    lb2.setFont(font1);
	    lb3.setFont(font1);
	    lb4.setFont(font1);
	    jcb.setFont(font1);
	    jcb1.setFont(font1);
        rbtn1.setFont(font1);
		rbtn2.setFont(font1);
		rbtn3.setFont(font1);
		rbtn4.setFont(font1);
		rbtn5.setFont(font1);
		rbtn6.setFont(font1);
		rbtn7.setFont(font1);
		jtfd.setFont(font1);
	    btn.setFont(font1);

        //--添加各个组件--
	    pl.setLayout(null);
	    pl.add(lb1);
	    pl.add(rbtn1);
	    pl.add(rbtn2);
	    pl.add(rbtn3);
	    pl.add(rbtn4);
	    pl.add(rbtn5);
	    pl.add(rbtn6);
	    pl.add(rbtn7);
	    pl.add(lb2);
	    pl.add(lb3);
	    pl.add(jcb);
	    pl.add(lb4);
	    pl.add(lb2);
	    pl.add(jcb1);
	    pl.add(jtfd);
	    pl.add(btn);
        pl.setBorder(BorderFactory.createTitledBorder("图书借阅查询"));
        pl.setBounds(10,10,400,140);
	    content.add(pl);


        frame.pack();
        frame.setBounds(300,200,430,230);
        frame.setVisible(true);
	}

    public void itemStateChanged(ItemEvent eg)
    {if(eg.getItemSelectable()==rbtn6)
     {lb3.setVisible(true);
	  lb4.setVisible(true);
	  jcb.setVisible(true);
	  jcb1.setVisible(true);
	  jtfd.setVisible(false);
     }
     if(eg.getItemSelectable()==rbtn7)
	      {lb3.setVisible(true);
	 	  lb4.setVisible(true);
	 	  jcb.setVisible(true);
	 	  jcb1.setVisible(true);
	 	  jtfd.setVisible(false);
     }
     if(eg.getItemSelectable()==rbtn1)
	 	      {lb3.setVisible(false);
	 	 	  lb4.setVisible(false);
	 	 	  jcb.setVisible(false);
	 	 	  jcb1.setVisible(false);
	 	 	  jtfd.setVisible(true);
     }
     if(eg.getItemSelectable()==rbtn2)
	 	      {lb3.setVisible(false);
	 	 	  lb4.setVisible(false);
	 	 	  jcb.setVisible(false);
	 	 	  jcb1.setVisible(false);
	 	 	  jtfd.setVisible(true);
     }
     if(eg.getItemSelectable()==rbtn3)
	 	      {lb3.setVisible(false);
	 	 	  lb4.setVisible(false);
	 	 	  jcb.setVisible(false);
	 	 	  jcb1.setVisible(false);
	 	 	  jtfd.setVisible(true);
     }
     if(eg.getItemSelectable()==rbtn4)
	 	      {lb3.setVisible(false);
	 	 	  lb4.setVisible(false);
	 	 	  jcb.setVisible(false);
	 	 	  jcb1.setVisible(false);
	 	 	  jtfd.setVisible(true);
     }
     if(eg.getItemSelectable()==rbtn5)
	 	      {lb3.setVisible(false);
	 	 	  lb4.setVisible(false);
	 	 	  jcb.setVisible(false);
	 	 	  jcb1.setVisible(false);
	 	 	  jtfd.setVisible(true);
     }
    }
	public void actionPerformed(ActionEvent e)
	{
     Object obj=e.getSource();

	}
	public static void main(String[]args)
	{try {
	            UIManager.setLookAndFeel("com.sun.java.swing.plaf.windows.WindowsLookAndFeel");
	            }
	        catch(Exception e) {
	            e.printStackTrace();
	           }
		new BorrowF();
	}
	}