booklist.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.JTable;
import java.sql.*;
import java.util.*;
import javax.swing.*;
import javax.swing.JScrollPane;
import javax.swing.table.*;

public class bookList extends JFrame {

	private static final long serialVersionUID = 1L;

	private JPanel jContentPane = null;

	private JLabel jLabel = null;

	private JLabel jLabel1 = null;

	private JLabel jLabel2 = null;

	private JTextField jTextFieldname = null;

	private JTextField jTextFieldpress = null;

	private JTextField jTextFieldauthor = null;

	private JButton jButtonSearch = 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("出版日期");
    	columnNames.addElement("定价");
    	columnNames.addElement("备注");
    	columnNames.addElement("总数");
    	columnNames.addElement("借出数");
    	columnNames.addElement("累计借出");
    }    
	private JScrollPane jspane = null;

	private JTable model = null;
	
	/*public void addvec(){
		columnNames.addElement("shu");
		columnNames.addElement("shu");
		columnNames.addElement("shu");
		columnNames.addElement("shu");
		columnNames.addElement("shu");
		columnNames.addElement("shu");
		columnNames.addElement("shu");
	}*/
	
	public bookList() throws HeadlessException {
		// TODO 自动生成构造函数存根
		super();
		initialize();
	}

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

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

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

	/**
	 * This method initializes this
	 * 
	 * @return void
	 */
	private void initialize() {
		this.setSize(668, 518);
		this.setContentPane(getJContentPane());
		this.setTitle("书籍信息查询");
	}

	/**
	 * This method initializes jContentPane
	 * 
	 * @return javax.swing.JPanel
	 */
	private JPanel getJContentPane() {
		if (jContentPane == null) {
			jLabel2 = new JLabel();
			jLabel2.setBounds(new Rectangle(245, 20, 38, 18));
			jLabel2.setText("作者");
			jLabel1 = new JLabel();
			jLabel1.setBounds(new Rectangle(20, 50, 47, 18));
			jLabel1.setText("出版社");
			jLabel = new JLabel();
			jLabel.setBounds(new Rectangle(20, 20, 38, 18));
			jLabel.setText("书名");
			jContentPane = new JPanel();
			jContentPane.setLayout(null);
			jContentPane.add(jLabel, null);
			jContentPane.add(jLabel1, null);
			jContentPane.add(jLabel2, null);
			jContentPane.add(getJTextFieldname(), null);
			jContentPane.add(getJTextFieldpress(), null);
			jContentPane.add(getJTextFieldauthor(), null);
			jContentPane.add(getJButtonSearch(), null);
			jContentPane.add(getJspane(), null);
		}
		return jContentPane;
	}

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

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

	/**
	 * This method initializes jTextFieldauthor	
	 * 	
	 * @return javax.swing.JTextField	
	 */
	private JTextField getJTextFieldauthor() {
		if (jTextFieldauthor == null) {
			jTextFieldauthor = new JTextField();
			jTextFieldauthor.setLocation(new Point(300, 20));
			jTextFieldauthor.setSize(new Dimension(131, 20));
		}
		return jTextFieldauthor;
	}

	/**
	 * This method initializes jButtonSearch	
	 * 	
	 * @return javax.swing.JButton	
	 */
	private JButton getJButtonSearch() {
		if (jButtonSearch == null) {
			jButtonSearch = new JButton();
			jButtonSearch.setLocation(new Point(280, 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;//rowData[1][1]="af";
					boolean isFirst=true;
					strSQL="select * from Books ";
					if(!jTextFieldname.getText().trim().equals("")){
						strSQL=strSQL+" where Bookname='"+jTextFieldname.getText().trim()+"'";
						isFirst=false;
					}
					if(!jTextFieldpress.getText().trim().equals("")){
						if(isFirst){
							strSQL=strSQL+" where Press='"+jTextFieldpress.getText().trim()+"'";
							isFirst=false;
						}
						else{
							strSQL=strSQL+" and Press='"+jTextFieldpress.getText().trim()+"'";
						}
					}
					if(!jTextFieldauthor.getText().trim().equals("")){
						if(isFirst){
							strSQL=strSQL+" where Author='"+jTextFieldauthor.getText().trim()+"'";
							isFirst=false;
						}
						else{
							strSQL=strSQL+" and Author='"+jTextFieldauthor.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;
					}
					//若存在，则执行以下
					//晴空defaultmoedl中的对象
					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("Bookname"));
							tempvector.add(rs.getString("Press"));
							tempvector.add(rs.getString("Author"));
							tempvector.add(rs.getString("Address"));
							tempvector.add(rs.getString("Pressdate"));
							tempvector.add(rs.getString("Price"));
							tempvector.add(rs.getString("Comment"));
							tempvector.add(rs.getString("TotalNum"));
							tempvector.add(rs.getString("Jiechu"));
							tempvector.add(rs.getString("Totaljie"));
							defaultmodel.addRow(tempvector);
						}						
					}
					catch(SQLException ex){
						JOptionPane.showMessageDialog(null, "发生错误", "错误", JOptionPane.ERROR_MESSAGE);
						return;
					}
				}
			});
		}
		return jButtonSearch;
	}

	/**
	 * This method initializes jspane	
	 * 	
	 * @return javax.swing.JScrollPane	
	 */
	private JScrollPane getJspane() {
		if (jspane == null) {
			jspane = new JScrollPane();
			jspane.setLocation(new Point(20, 75));
			jspane.setSize(new Dimension(620, 421));
			jspane.setPreferredSize(new Dimension(620, 421));
			jspane.setViewportView(getModel());
		}
		return jspane;
	}

	/**
	 * This method initializes model	
	 * 	
	 * @return javax.swing.JTable	
	 */
	private JTable getModel() {
		if (model == null) {
			dvec();
			model = new JTable(defaultmodel);
			model.setSize(new Dimension(620, 80));
		}
		return model;
	}

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