querybook.java

java图书销售系统。。。。。。。。。。。。。。。。。。。。

import java.awt.BorderLayout;
import java.awt.GridLayout;
import java.awt.event.ActionEvent;
import java.awt.event.ActionListener;
import java.sql.ResultSet;
import java.sql.ResultSetMetaData;
import java.sql.SQLException;
import java.sql.Statement;


import javax.swing.JButton;
import javax.swing.JFrame;
import javax.swing.JLabel;
import javax.swing.JOptionPane;
import javax.swing.JPanel;
import javax.swing.JTextArea;


import javax.swing.JTextField;




public class QueryBook extends JFrame{
	/**
	 * 
	 */
	private static final long serialVersionUID = 1L;
	private JFrame frame,frame1;
	private JLabel l1;
	private JTextField t1;
	private JButton b1,b2,b3;
	private JPanel p1,p2;
	private String str1,str2;
	private JTextArea a1;
	DBClass db = new DBClass();
    Statement stmt = db.getStmt();
    ResultSet rs = null;
   
	public QueryBook(){
	    frame =new JFrame();
	    frame1 = new JFrame();
		l1 = new JLabel("图书名称");
		t1 = new JTextField(10);
		b1 = new JButton("查      询");
		b2 = new JButton("查询全部");
		b3 = new JButton("取      消");
		p1 = new JPanel();
		p2 = new JPanel();
		str1 = t1.getText().trim();
		str2 = null;
		a1 = new JTextArea();
	}
	public void launchFrame(){
		p1.setLayout(new GridLayout(3,2));
		p1.add(l1);
		p1.add(t1);		
		b1.addActionListener(new action());
		p1.add(b1);		
		b2.addActionListener(new action());
		p1.add(b2);
		b3.addActionListener(new action());
		p2.add(b3);
		frame.getContentPane().add(p1,BorderLayout.NORTH);
		frame.getContentPane().add(p2,BorderLayout.SOUTH);
		frame.setVisible(true);
		frame.setSize(280,320);
		frame.setTitle("图书查询");
		
		
		
	}
	class action implements ActionListener{
		
		public void actionPerformed(ActionEvent e){
			if(e.getActionCommand()==("查      询")){
				if(t1.getText().trim().equals("")){
					JOptionPane.showMessageDialog(null,"查询不能为空","警告 ",JOptionPane.WARNING_MESSAGE);
					
				}else {
					try {
						String str="SELECT * FROM Nowbooks ";/*WHERE 图书名称='"+str1+"'";*/
						String sql=str;
						//rs=stmt.executeQuery("SELECT * FROM Nowbooks WHERE 图书名称='"+str1+"'");
						rs=stmt.executeQuery(sql);
						ResultSetMetaData data=rs.getMetaData();
						int col=data.getColumnCount();
						//if(rs.next()){
							//rs.beforeFirst(); // 指回第一条记录
						 while(rs.next()){
							  for(int i=1;i<=col;i++){
						     
							    if(i<col){
							     a1.append(rs.getString(i) + '\t');
							     
							    }
							    else{
							     a1.append(rs.getString(i) + '\n');
							     
							    }
							   }
							  
							  }
					} catch (SQLException e1) {
						// TODO Auto-generated catch block
						e1.printStackTrace();
					}
					
					
					frame1.getContentPane().add(a1,BorderLayout.CENTER);
					frame1.setVisible(true);
					frame1.setSize(700,400);
					
				}
				
			}else if(e.getActionCommand()==("查询全部")){
				AllQuery f = new AllQuery();
				f.launchFrame();
			
					
			}else if(e.getActionCommand()==("取      消")){
				frame.setVisible(false);
			}
		}
	}
	public static void main(String[] args){
		QueryBook f = new QueryBook();
		f.launchFrame();
	}
	
}