informationsearch.java

这是一个简单的图书管理系统,适用于教学中演示,讲解java高级编程语言

package lib_source;
import javax.swing.*;
import javax.swing.border.BevelBorder;
import java.awt.*;
import java.awt.event.*;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.Statement;
public class InformationSearch extends JFrame implements ActionListener {
	/**
	 * 
	 */
	private static final long serialVersionUID = 1L;
	public static final int WIDTH = 484;
	public static final int HEIGHT = 310;
	public CardLayout Dealer;
	public JPanel DeckPanel, HelpPanel;
	JComboBox[] comboBox = new JComboBox[13];
	JTextField[] text = new JTextField[4];
	JTextArea txt;
	public JTable table;
	String[] str=new String[5];
	public InformationSearch() {
		setTitle("图书查询");
		setSize(WIDTH, HEIGHT);
	    setResizable(false);
		setDefaultCloseOperation(WindowConstants.DO_NOTHING_ON_CLOSE);
		addWindowListener(new WindowAdapter() {
			public void windowClosing(WindowEvent e) {
				dispose();
			}
		});
		
		Container contentPane = getContentPane();
		contentPane.setLayout(new BorderLayout());
		DeckPanel = new JPanel();
		Dealer = new CardLayout();
		DeckPanel.setBorder(new BevelBorder(BevelBorder.RAISED));
		DeckPanel.setLayout(new BoxLayout(DeckPanel, BoxLayout.X_AXIS));
		
		String[] s1 = { "图书查询", "读者查询", "帮助" };
		JButton[] button = new JButton[3];
		for (int i = 0; i < 3; i++) {
			button[i] = new JButton(s1[i]);
			button[i].addActionListener(this);
			DeckPanel.add(button[i]);
		}DeckPanel.add(new JLabel(new ImageIcon(ClassLoader.getSystemResource("images/冰山.JPG"))));
		contentPane.add(DeckPanel, BorderLayout.NORTH);
		
		HelpPanel = new JPanel();
		HelpPanel.setLayout(Dealer);
		JPanel jPanel = new JPanel();
		jPanel.setBorder(new BevelBorder(BevelBorder.RAISED));
		jPanel.setLayout(new FlowLayout());
		String[][] str1 = {
				{ "图书书名", "图书作者", "图书编号", "图书序号", "图书出版社", "图书分类", "关键字" },
				{ "并且", "或者", "非" }, { "任意一致", "后方一致", "前方一致", "等于" } };
		JPanel[] panel = new JPanel[4];
		for (int i = 0; i < 4; i++) {
			panel[i] = new JPanel();
			panel[i].setBorder(new BevelBorder(BevelBorder.RAISED));
			panel[i].setLayout(new FlowLayout());
			text[i] = new JTextField(18);
			text[i].setBorder(new BevelBorder(BevelBorder.LOWERED));
			for (int j = 0; j < 3; j++) {
				comboBox[3 * i + j] = new JComboBox(str1[j]);
				if (j == 0) {
					panel[i].add(comboBox[3 * i + j]);
					panel[i].add(text[i]);
				}
				else panel[i].add(comboBox[3 * i + j]);
			}jPanel.add(panel[i]);
		}
		
		JPanel buttonPanel = new JPanel();
		buttonPanel.setLayout(new FlowLayout());
		buttonPanel.setBorder(new BevelBorder(BevelBorder.RAISED));
		button = new JButton[4];
		String[] str2 = { "搜索", "清除", "返回主界面", "退出" };
	jPanel.add(new JLabel(new ImageIcon(ClassLoader.getSystemResource("images/狗.JPG"))));
		for (int i = 0; i < str2.length; i++) {
			button[i] = new JButton(str2[i]);
			button[i].addActionListener(this);
			buttonPanel.add(button[i]);
		}
		jPanel.add(buttonPanel);
		jPanel.add(new JLabel(new ImageIcon(ClassLoader.getSystemResource("images/企鹅.JPG"))));
		HelpPanel.add("图书查询", jPanel);
		String[] str3 = { "读者ID号", "读者状态" };
		String[ ]str5={"images/天空.JPG" ,"images/故宫.JPG"};
		comboBox[12] = new JComboBox();
		comboBox[12].setEditable(true);
		//comboBox[12].setSize(2, 2);
		jPanel = new JPanel();
		jPanel.setBorder(new BevelBorder(BevelBorder.RAISED));
		jPanel.setLayout(new FlowLayout(FlowLayout.LEFT));
		JPanel[] tempPanel = new JPanel[2];
		for (int i = 0; i < str3.length; i++) {
			tempPanel[i] = new JPanel();
			tempPanel[0].setSize(500, 10);
			tempPanel[i].setLayout(new FlowLayout());
			tempPanel[i].setBorder(new BevelBorder(BevelBorder.RAISED));
			tempPanel[i].add(new JLabel(str3[i]));
			if (i == 0)
				{
				
				tempPanel[i].add(comboBox[12]);
				
				}
			else {
				
				txt = new JTextArea(6, 15);
				txt.setEditable(false);
				txt.setBorder(new BevelBorder(BevelBorder.LOWERED));
			//table = new JTable(rowData, columnNames); 
		//	table.setAutoResizeMode(table.AUTO_RESIZE_ALL_COLUMNS);
				//table.setEnabled(false);
				//txt.add(new JScrollPane(table));
				JScrollPane scrolledText = new JScrollPane(txt);
				scrolledText
						.setHorizontalScrollBarPolicy(JScrollPane.HORIZONTAL_SCROLLBAR_ALWAYS);
				scrolledText
						.setVerticalScrollBarPolicy(JScrollPane.VERTICAL_SCROLLBAR_ALWAYS);
				tempPanel[i].add(scrolledText);

			}
			if (i == 0)
				jPanel.add(tempPanel[i],FlowLayout.LEFT);
			else
				jPanel.add(tempPanel[i]);
			jPanel.add(new JLabel(new ImageIcon(ClassLoader.getSystemResource(str5[i])),JLabel.CENTER));
		}jPanel.add(new JLabel(new ImageIcon(ClassLoader.getSystemResource("images/悟空.JPG")),JLabel.LEFT));
		buttonPanel = new JPanel();
		buttonPanel.setLayout(new FlowLayout());
		buttonPanel.setBorder(new BevelBorder(BevelBorder.RAISED));
		
		button = new JButton[3];
		String[] str4 = { "确定", "清除", "退出" };
		for (int i = 0; i < str4.length; i++) {
			button[i] = new JButton(str4[i]);
			button[i].addActionListener(this);
			buttonPanel.add(button[i]);
		}
		jPanel.add(buttonPanel);
		jPanel.add(new JLabel(new ImageIcon(ClassLoader.getSystemResource("images/流传风.JPG")),JLabel.CENTER));
		HelpPanel.add("读者查询", jPanel);
		jPanel = new JPanel();
		jPanel.add(new JLabel(new ImageIcon(ClassLoader.getSystemResource("images/tree016副本.jpg"))));
		HelpPanel.add("帮助", jPanel);
		contentPane.add(HelpPanel, BorderLayout.CENTER);
	
		Dimension screen = getToolkit().getScreenSize();
		setLocation((screen.width - getSize().width) / 2,
				(screen.height - getSize().height) / 2);
	}
	public void actionPerformed(ActionEvent e) {
		String actionCommand = e.getActionCommand();
		if (actionCommand.equals("图书查询"))
			Dealer.show(HelpPanel, "图书查询");
		else if (actionCommand.equals("搜索")) {
			new BookSearchButton();
		} else if (actionCommand.equals("清除")) {
			for (int i = 0; i < text.length; i++)
				text[i].setText("");
			comboBox[12].setSelectedItem("");
			txt.setText("");
		} else if (actionCommand.equals("确定")) {
			new ReaderSearchButton();
		}
		else if (actionCommand.equals("返回主界面")) {
			dispose();
			new LibraryManagementSystem().setVisible(true);
		} else if (actionCommand.equals("退出")) {
			dispose();
		} else if (actionCommand.equals("读者查询"))
			Dealer.show(HelpPanel, "读者查询");
		else if (actionCommand.equals("帮助"))
			Dealer.show(HelpPanel, "帮助");
		else
			JOptionPane.showMessageDialog(this,"按钮监听注册出现错误!");
	}
	public static void main(String[] args) {
	new InformationSearch().setVisible(true);
	}
	private class BookSearchButton extends JFrame {
		/**
		 * 
		 */
		private static final long serialVersionUID = 1L;

		private String dbURL = "jdbc:odbc:Student2007"; 

		private String user = "devon";

		private String password = "book"; 

		

		public BookSearchButton() {
			super("查询结果显示"); 
			setResizable(false);
			String[] columnNames = { "图书序号", "图书编号", "图书书名", "图书作者", "图书出版社",
					"图书单价", "图书摘要", "图书分类", "图书状态" }; 
			Object[][] rowData = new Object[30][columnNames.length]; 
			table = new JTable(rowData, columnNames); 
			table.setEnabled(false);
			if ((text[0]).getText().equals("")
					& text[1].getText().equals("")
					& text[2].getText().equals("")
					& text[3].getText().equals(""))
			{
				JOptionPane.showMessageDialog(this,
						"     请检查您的输入是否正确，所输入的内容不能全为空！      ");
			}
			else if(text[0].getText().equals(""))
			{
				JOptionPane.showMessageDialog(this,
						"     请检查您的输入是否正确， 第一项所输入的内容不能全为空！      ");
			}
			else {
			try {
	boolean[] isNotNull=new boolean[5];
	    		String[] str3=new String[5];
	    		String[] str4={"图书书名","图书作者","图书编号","图书序号","图书出版社","图书分类"};
	    	            	
	    	String[] str2={"AND","OR"};
	    		
	    		boolean isExit=false;
	    		  int i=0;