xiangmu.java

线程超市管理系统 采用线程管理的超市管系统

package zh;
import java.awt.*;
import java.awt.event.*;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.Statement;

import javax.swing.*;
public class Xiangmu extends JPanel implements ActionListener{
 
 JButton button1,button2;
  JButton buttons[];
 JTextField text;
 JTextArea text1;
 JLabel label; 
 JPanel  labelPane,tablePane,buttonPane,labelsPane;
 JScrollPane scroll;
 JTable table;
 int i;
// Object rows[][];
// Object labels[]={"商品编号","商品名称","产地","零售价格","现存数量"};
 Xiangmu(){
	 setBorder(BorderFactory.createTitledBorder("顾客管理"));
	  button1=new JButton("查   询");
	  button1.setPreferredSize(new Dimension(120,25));
	  button2=new JButton("返   回");  
	  button2.setPreferredSize(new Dimension(120,25));
	  buttons=new JButton[9];
	  buttons[0]=new JButton("调味品");
	  buttons[1]=new JButton("蔬菜类");
	  buttons[2]=new JButton("水果类");
	  buttons[3]=new JButton("熟肉类");
	  buttons[4]=new JButton("生肉类");
	  buttons[5]=new JButton("海鲜类");
	  buttons[6]=new JButton("服装类");
	  buttons[7]=new JButton("化妆品");
	  buttons[8]=new JButton("日杂类");
	  text=new JTextField();
	  text.setPreferredSize(new Dimension(120,25));
	  text1=new JTextArea(20,44);
	  labelPane=new JPanel();labelsPane=new JPanel();
	  tablePane=new JPanel();
	  buttonPane=new JPanel();
	  buttonPane.setLayout(new GridLayout(1,9));
	  int i;
	  for(i=0;i<9;i++){
		  buttonPane.add(buttons[i]);
	  }
	  label=new JLabel("请输入商品名称:");
	  GridBagConstraints constraints=new GridBagConstraints();
	  labelPane.setLayout(new GridBagLayout());
	  labelPane.add(label,constraints);
	  labelPane.add(text,constraints);
	  labelPane.add(button1,constraints);
	  labelPane.add(button2,constraints);
	  labelsPane.setLayout(new GridLayout(2,1));
	  labelsPane.add(buttonPane);
	  labelsPane.add(labelPane);
//	     rows=new Object[8][6];
//	  table=new JTable(rows,labels);
	  scroll=new JScrollPane(text1);
//	  scroll.setVerticalScrollBarPolicy(ScrollPaneConstants.VERTICAL_SCROLLBAR_ALWAYS);
//      scroll.setHorizontalScrollBarPolicy(ScrollPaneConstants.HORIZONTAL_SCROLLBAR_ALWAYS);
	  scroll.setPreferredSize(new Dimension(100,50));
	  tablePane.setLayout(new BorderLayout());
	  tablePane.setPreferredSize(new Dimension(100,20));
	  tablePane.setBorder(BorderFactory.createEtchedBorder());
	  tablePane.add(scroll,BorderLayout.CENTER);
	  setLayout(new BorderLayout());
	  add(labelsPane,BorderLayout.NORTH);
	  add(tablePane,BorderLayout.CENTER);
	  button1.addActionListener(this);
	  button2.addActionListener(this);
	  for(i=0;i<9;i++)
	  buttons[i].addActionListener(this);
 }
 public void actionPerformed(ActionEvent e){
	  if(e.getSource()==button1){
//	   int i=0;
	   
	   
   
	   String name1,name2,name3,name4;
	   StringBuffer name=new StringBuffer("");
	   try{
	   Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
	   Connection con=DriverManager.getConnection("jdbc:odbc:zz","","");
	   Statement st=con.createStatement();
	   
//	   System.out.print("555");
	   if(text.getText().equals("")){
	    ResultSet rs=st.executeQuery("select * from SP");
	    name.append("商品编号\t\t商品名称\t\t商品产地\t\t零售价格\n\n");
//	    System.out.print("585");
	    while(rs.next()){
	    	
//	     System.out.print("588");
	     
	     name1=rs.getString(1);
	     name2=rs.getString(2);
	     name3=rs.getString(3);
	     name4=rs.getString(4);
//	     System.out.print("665");
	     name.append(name1 + "\t\t" + name2 + "\t\t" + name3 + "\t\t"
					+ name4+ "\t\t"+ "\n\n");
//	     rows[i][0]=name1;
//	     rows[i][1]=name2;
//	     rows[i][2]=name3;
//	     rows[i][3]=name4;
//	     i++;
	    }
	    text1.setText(name.toString());
	   }
//    System.out.print("555");
	   else{
		   String syh = "'"+text.getText().trim()+"'";
	    ResultSet rs=st.executeQuery("select * from SP where 商品名称="+syh);
//	    System.out.print("54");
	    name.append("商品编号\t\t商品名称\t\t商品产地\t\t零售价格\n\n");  
	   
//	    System.out.print("66");
	         
	   while(rs.next()){
//	    if(rs.getString(1).equals(text.getText().trim())){
		   i++;
	    name1=rs.getString(1);
	    name2=rs.getString(2);
	    name3=rs.getString(3);
	    name4=rs.getString(4);
//	    rows[i][0]=name1;
//	    rows[i][1]=name2;
//	    rows[i][2]=name3;
//	    rows[i][3]=name4;
	    name.append(name1 + "\t\t" + name2 + "\t\t" + name3 + "\t\t"
				+ name4+ "\t\t"+ "\n\n");
//	    i++;
	    
//	    
	   }}
	   text1.setText(name.toString());
	   con.close();
//	   }
//	    else {
//	     JOptionPane.showMessageDialog(myframe,"无此学号");
//	     text.setText(null);
//	    }
////	    }
	   
//	   }
//	   table.repaint();
//	   con.close();
	   
	         
	   }catch(java.lang.Exception ee){}
	   
	   
	   
	  }
	  else if(e.getSource()==button2){
		  text.setText(null);
		  text1.setText(null);
	 }
	  for(i=0;i<9;i++)
	  { if(e.getSource()==buttons[i]){
//		  for(i=0;i<9;i++){
		  String s="'"+buttons[i].getText().trim()+"'";
//		  text.setText(s);
		  String name1,name2,name3,name4;
		   StringBuffer name=new StringBuffer("");
		   try{
		   Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
		   Connection con=DriverManager.getConnection("jdbc:odbc:zz","","");
		   Statement st=con.createStatement();
		   ResultSet rs=st.executeQuery("select * from SP where 商品类别="+s);
		    name.append("商品编号\t\t商品名称\t\t商品产地\t\t零售价格\n\n");
//		    System.out.print("585");
		    while(rs.next()){
		    	
//		     System.out.print("588");
		     
		     name1=rs.getString(1);
		     name2=rs.getString(2);
		     name3=rs.getString(3);
		     name4=rs.getString(4);
//		     System.out.println("665");
		     name.append(name1 + "\t\t" + name2 + "\t\t" + name3 + "\t\t"
						+ name4+ "\t\t"+ "\n\n");
//		     rows[i][0]=name1;
//		     rows[i][1]=name2;
//		     rows[i][2]=name3;
//		     rows[i][3]=name4;
//		     i++;
		    }
		    text1.setText(name.toString());
		    con.close();
		    }catch(java.lang.Exception ee){}
		  }
		  
		   
		         
		   
		   
		   
		   
		  }
	  }
}