booklist.java

基于目前许多中小型公司, 机关,中小学校,大学院系等都有自己的图书库, 供内部人员借阅。传统的手工登记办法

import java.awt.*;
import java.awt.event.*;
import javax.swing.*;
import java.sql.*;
import javax.swing.table.*;
import java.util.Vector;
public class BookList extends JFrame implements ActionListener
{
	Container c;
	JPanel panel1,panel2,panel3;
	JLabel BookNameLabel,AuthorLabel,PressLabel;
	JTextField BookNameTextField,AuthorTextField,
	           PressTextField;
	JButton SearchBtn,ExitBtn;
	JTable table=null;
	DefaultTableModel defaultModel=null;
	public BookList()
	{
		super("书籍信息一览！");
		c=getContentPane();
		c.setLayout(new BorderLayout());
		BookNameLabel=new JLabel("名称",JLabel.CENTER);
		AuthorLabel=new JLabel("作者",JLabel.CENTER);
		PressLabel=new JLabel("出版社",JLabel.CENTER);
		BookNameTextField=new JTextField(15);
		AuthorTextField=new JTextField(15);
		PressTextField=new JTextField(15);
		SearchBtn=new JButton("查询");
		SearchBtn.addActionListener(this);
		ExitBtn=new JButton("退出");
		ExitBtn.addActionListener(this);
		panel1=new JPanel();
		panel3=new JPanel();
		panel1.add(BookNameLabel);
		panel1.add(BookNameTextField);
		panel1.add(AuthorLabel);
		panel1.add(AuthorTextField);
		panel3.add(PressLabel);
		panel3.add(PressTextField);
		panel3.add(SearchBtn);
		panel3.add(ExitBtn);
		String[] name={"编号","名称","作者","出版社","出版日期","定价","状态"};
		String[][] data=new String[0][0];
		defaultModel=new DefaultTableModel(data,name);
		table=new JTable(defaultModel);
		table.setPreferredScrollableViewportSize(new Dimension(480,80));
		JScrollPane s=new JScrollPane(table);
		panel2=new JPanel();
		panel2.add(s);
		c.add(panel1,BorderLayout.NORTH);
		c.add(panel3,BorderLayout.CENTER);
		c.add(panel2,BorderLayout.SOUTH);
		setBounds(300,300,500,230);
		Dimension FrameSize=this.getPreferredSize();
		setVisible(true);
	}
	public void actionPerformed(ActionEvent e)
	{
		Connection con;
    	Statement sql;
        ResultSet rs;
        boolean boo=true;
		if(e.getSource()==SearchBtn)
		{
		String strSQL="select* from book";
		String strSql=null;
		if(BookNameTextField.getText().trim().equals("")&&
		   AuthorTextField.getText().trim().equals("")&&
		   PressTextField.getText().trim().equals(""))
		{
			strSql=strSQL;
		}
		else if(BookNameTextField.getText().trim().equals("")&&
		        AuthorTextField.getText().trim().equals(""))
		        {
		        	strSql=strSQL+" where printer='"+PressTextField.getText().trim()+"'";
		        }
		else if(BookNameTextField.getText().trim().equals("")&&
		        PressTextField.getText().trim().equals(""))
		        {
		        	strSql=strSQL+" where worker='"+AuthorTextField.getText().trim()+"'";
		        }
	        else if(AuthorTextField.getText().trim().equals("")&&
		        PressTextField.getText().trim().equals(""))
		        {
		        	strSql=strSQL+" where bname='"+BookNameTextField.getText().trim()+"'";
		        }
		else if(BookNameTextField.getText().trim().equals(""))
		       {
		       	        strSql=strSQL+" where author='"+AuthorTextField.getText().trim()+
		       	        "'and press='"+PressTextField.getText().trim()+"'";
		       }
		else if(AuthorTextField.getText().trim().equals(""))
		       {
		       	        strSql=strSQL+" where bname='"+BookNameTextField.getText().trim()+
		       	        "'and printer='"+PressTextField.getText().trim()+"'";
		       }
		 else if(PressTextField.getText().trim().equals(""))
		       {
		       	        strSql=strSQL+" where bname='"+BookNameTextField.getText().trim()+
		       	        "'and worker='"+AuthorTextField.getText().trim()+"'";
		       }
		 else
		 {
		 	strSql=strSQL+" where bname='"+BookNameTextField.getText().trim()+
		       	        "'and worker='"+AuthorTextField.getText().trim()+"'and printer='"+
		       	        PressTextField.getText().trim()+"'";
		}
		try {  Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");  
          }
      catch(ClassNotFoundException f){}
		try
		{
	             con=DriverManager.getConnection("jdbc:odbc:tushuguan");
	             sql=con.createStatement();
	             rs=sql.executeQuery(strSql);
	        //首先要删除table中的数据先：
	        int rowCount=defaultModel.getRowCount()-1;//取得table中的数据行；
	        int j=rowCount;
	        for(int i=0;i<=rowCount;i++)
	        {
	        	defaultModel.removeRow(j);//删除rowCount行的数据；
	        	defaultModel.setRowCount(j);//重新设置行数；
	        	j=j-1;
	        }
				while(rs.next())
				{   boo=false;
					Vector data=new Vector();
					data.addElement(rs.getString(1));
					data.addElement(rs.getString(2));
					data.addElement(rs.getString(3));
					data.addElement(rs.getString(4));
					data.addElement(rs.getString(5));
					data.addElement(rs.getString(6));
					data.addElement(rs.getString(7));
					defaultModel.addRow(data);
				}
				table.revalidate();
				if(boo)JOptionPane.showMessageDialog(this,"输入的图书信息不存在！","提示对话框",JOptionPane.WARNING_MESSAGE);
	}
	catch(SQLException sqle)
		{
			System.out.println(sqle.toString());
		}
	catch(Exception ex)
		{
			System.out.println(ex.toString());
		}
	}
	if(e.getSource()==ExitBtn)
	{
		this.dispose();
	}
}
public static void main(String args[]){
	new BookList();
}
}