allinfo.java

图书馆系统

import java.awt.BorderLayout;
import javax.swing.JPanel;
import java.awt.GraphicsConfiguration;
import java.awt.HeadlessException;

import javax.swing.JFrame;
import java.awt.Dimension;
import javax.swing.JLabel;
import java.awt.Rectangle;
import javax.swing.JTextField;
import java.awt.Point;
import javax.swing.JButton;
import javax.swing.JOptionPane;
import javax.swing.JScrollPane;
import javax.swing.JTable;
import java.sql.*;
import javax.swing.table.*;
import java.util.*;

public class AllInfo extends JFrame {

	private static final long serialVersionUID = 1L;

	private JPanel jContentPane = null;

	private JLabel jLabel = null;

	private JTextField jTextFieldReader = null;

	private JLabel jLabel1 = null;

	private JTextField jTextFieldBookName = null;

	private JButton jButtonSearch = null;

	private JScrollPane jScrollPane = null;

	private JTable jtable = null;
	ResultSet rs;
	DBManager db=new DBManager();	
	Vector rowData=new Vector(),tempvector;  //  @jve:decl-index=0:
	Vector columnNames=new Vector();  //  @jve:decl-index=0:		
    DefaultTableModel defaultmodel = new DefaultTableModel(rowData,columnNames);
    public void dvec(){
    	columnNames.addElement("借阅者");
    	columnNames.addElement("书名");
    	columnNames.addElement("借阅日期");
    	columnNames.addElement("还入日期");
    	columnNames.addElement("备注");
    	
    }    
	public AllInfo() throws HeadlessException {
		// TODO 自动生成构造函数存根
		super();
		initialize();
	}

	public AllInfo(GraphicsConfiguration arg0) {
		super(arg0);
		// TODO 自动生成构造函数存根
		initialize();
	}

	public AllInfo(String arg0) throws HeadlessException {
		super(arg0);
		// TODO 自动生成构造函数存根
		initialize();
	}

	public AllInfo(String arg0, GraphicsConfiguration arg1) {
		super(arg0, arg1);
		// TODO 自动生成构造函数存根
		initialize();
	}

	/**
	 * This method initializes this
	 * 
	 * @return void
	 */
	private void initialize() {
		this.setSize(495, 538);
		this.setContentPane(getJContentPane());
		this.setTitle("借阅情况查询");
	}

	/**
	 * This method initializes jContentPane
	 * 
	 * @return javax.swing.JPanel
	 */
	private JPanel getJContentPane() {
		if (jContentPane == null) {
			jLabel1 = new JLabel();
			jLabel1.setBounds(new Rectangle(213, 20, 38, 18));
			jLabel1.setText("书名");
			jLabel = new JLabel();
			jLabel.setBounds(new Rectangle(20, 20, 55, 18));
			jLabel.setText("借阅者");
			jContentPane = new JPanel();
			jContentPane.setLayout(null);
			jContentPane.add(jLabel, null);
			jContentPane.add(getJTextFieldReader(), null);
			jContentPane.add(jLabel1, null);
			jContentPane.add(getJTextFieldBookName(), null);
			jContentPane.add(getJButtonSearch(), null);
			jContentPane.add(getJScrollPane(), null);
		}
		return jContentPane;
	}

	/**
	 * This method initializes jTextFieldReader	
	 * 	
	 * @return javax.swing.JTextField	
	 */
	private JTextField getJTextFieldReader() {
		if (jTextFieldReader == null) {
			jTextFieldReader = new JTextField();
			jTextFieldReader.setLocation(new Point(90, 20));
			jTextFieldReader.setSize(new Dimension(98, 20));
		}
		return jTextFieldReader;
	}

	/**
	 * This method initializes jTextFieldBookName	
	 * 	
	 * @return javax.swing.JTextField	
	 */
	private JTextField getJTextFieldBookName() {
		if (jTextFieldBookName == null) {
			jTextFieldBookName = new JTextField();
			jTextFieldBookName.setLocation(new Point(265, 20));
			jTextFieldBookName.setSize(new Dimension(144, 20));
		}
		return jTextFieldBookName;
	}

	/**
	 * This method initializes jButtonSearch	
	 * 	
	 * @return javax.swing.JButton	
	 */
	private JButton getJButtonSearch() {
		if (jButtonSearch == null) {
			jButtonSearch = new JButton();
			jButtonSearch.setLocation(new Point(157, 50));
			jButtonSearch.setText("查询");
			jButtonSearch.setSize(new Dimension(70, 20));
			jButtonSearch.addActionListener(new java.awt.event.ActionListener() {
				public void actionPerformed(java.awt.event.ActionEvent e) {
					System.out.println("actionPerformed()"); // TODO Auto-generated Event stub actionPerformed()
					String strSQL;
					boolean isfirst=true;
					strSQL="select * from BookBorrow ";
					if(!jTextFieldReader.getText().trim().equals("")){
						strSQL=strSQL+" where Studentname='"+jTextFieldReader.getText().trim()+"'";
						isfirst=false;
					}
					if(!jTextFieldBookName.getText().trim().equals("")){
						if(isfirst){
							strSQL=strSQL+" where Bookname='"+jTextFieldBookName.getText().trim()+"'";
							
						}
						else{
							strSQL=strSQL+" and Bookname='"+jTextFieldBookName.getText().trim()+"'";
						}
					}
					//执行数据库查询操作
					System.out.println(strSQL);
					rs=db.getResult(strSQL);
					boolean isexist=false;
					try{
						isexist=rs.first();
					}
					catch(SQLException ex1){
						JOptionPane.showMessageDialog(null, "ex1.toString"+ex1.toString(), "错误", JOptionPane.ERROR_MESSAGE);
						return;
					}
					//若书目不存在
					if(!isexist){
						JOptionPane.showMessageDialog(null, "无记录", "错误", JOptionPane.ERROR_MESSAGE);
						return;
					}
					else{
						//先清空集中对象
						//tempvector.clear();
						//清空defaultmodel
						for(int n=defaultmodel.getRowCount()-1;n>=0;n--)
							defaultmodel.removeRow(n);
						try{
							//移动光标到零的位置
							rs.beforeFirst();
							while(rs.next()){
								tempvector=new Vector(1,1);
								tempvector.add(rs.getString("Studentname"));
								tempvector.add(rs.getString("Bookname"));
								tempvector.add(rs.getString("Borrowdate"));
								tempvector.add(rs.getString("Returndate"));
								tempvector.add(rs.getString("Comment"));
								defaultmodel.addRow(tempvector);
							}
						}
						catch(SQLException ex){
							JOptionPane.showMessageDialog(null, "发生错误", "错误", JOptionPane.ERROR_MESSAGE);
							return;
						}
					}
				}
			});
		}
		return jButtonSearch;
	}

	/**
	 * This method initializes jScrollPane	
	 * 	
	 * @return javax.swing.JScrollPane	
	 */
	private JScrollPane getJScrollPane() {
		if (jScrollPane == null) {
			jScrollPane = new JScrollPane();
			jScrollPane.setBounds(new Rectangle(20, 75, 453, 421));
			jScrollPane.setViewportView(getJtable());
		}
		return jScrollPane;
	}

	/**
	 * This method initializes jtable	
	 * 	
	 * @return javax.swing.JTable	
	 */
	private JTable getJtable() {
		if (jtable == null) {
			dvec();
			jtable = new JTable(defaultmodel);
			jtable.setAutoResizeMode(JTable.AUTO_RESIZE_SUBSEQUENT_COLUMNS);
		}
		return jtable;
	}

}  //  @jve:decl-index=0:visual-constraint="10,10"