borrowbooklist.java

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

import java.awt.*;
import java.awt.event.*;
import javax.swing.*;
import java.sql.*;
import javax.swing.table.*;
import java.util.Vector;
public class BorrowBookList extends JFrame implements ActionListener
{
	Container c;
	JPanel panel1,panel2;
	JLabel BookNameLabel,StudentNameLabel;
	JTextField BookNameTextField,StudentNameTextField;
	JButton SearchBtn,ExitBtn;
	JTable table=null;
	DefaultTableModel defaultModel=null;
	public BorrowBookList()
	{
		super("书籍借阅一览！");
		c=getContentPane();
		c.setLayout(new BorderLayout());
		BookNameLabel=new JLabel("图书编号   ",JLabel.CENTER);
		StudentNameLabel=new JLabel("借阅者编号",JLabel.CENTER);
		BookNameTextField=new JTextField(15);
		StudentNameTextField=new JTextField(15);
		SearchBtn=new JButton("查询");
		ExitBtn=new JButton("退出");
		SearchBtn.addActionListener(this);
		ExitBtn.addActionListener(this);
		Box box1=Box.createHorizontalBox();
		box1.add(StudentNameLabel);
		box1.add(StudentNameTextField);
		box1.add(SearchBtn);
		Box box2=Box.createHorizontalBox();
		box2.add(BookNameLabel);
		box2.add(BookNameTextField);
		box2.add(ExitBtn);
		Box boxH=Box.createVerticalBox();
		boxH.add(box1);
		boxH.add(box2);
		boxH.add(Box.createVerticalGlue());
		panel1=new JPanel();
		panel1.add(boxH);
		panel2=new JPanel();
		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.add(s);
		c.add(panel1,BorderLayout.NORTH);
		c.add(panel2,BorderLayout.SOUTH);
		setBounds(300,300,500,230);
		setVisible(true);
	}
	public void actionPerformed(ActionEvent e)
	{
		boolean boo=true;
		Connection con;
    	Statement sql;
        ResultSet rs;
		if(e.getSource()==ExitBtn)
	        {
		    this.dispose();
	        } 
	        else if(e.getSource()==SearchBtn)
	        {
	        	String strSQL="select * from borrow";
	        	String strSql=null;
	        	if(StudentNameTextField.getText().trim().equals("")&&
	        	   BookNameTextField.getText().trim().equals(""))
	        	 {
	        	 	strSql=strSQL;
	        	 }
	        	 else if(StudentNameTextField.getText().trim().equals(""))
	        	 {
	        	 	strSql=strSQL+" where bid='"+
	        	 	BookNameTextField.getText().trim()+"'";
	        	}
	        	else if(BookNameTextField.getText().trim().equals(""))
	        	{
	        		strSql=strSQL+" where rid='"+
	        		StudentNameTextField.getText().trim()+"'";
	        	}
	        	else
	        	{
	        		strSql=strSQL+" where rid='"+
	        		StudentNameTextField.getText().trim()+"'and bid='"+
	        		BookNameTextField.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));
			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());
		}
	        }
	}
	public static void main(String args[]){
		new BorrowBookList();
	}
	
}