newchangshi.java

基于Java的仓库信息管理系统。本系统主要完成对超市仓库的库存管理

import java.awt.*;
import java.sql.*;
import java.awt.event.*;
import javax.swing.*;
import javax.swing.event.*;
import javax.swing.table.*;
import java.util.*;

public class newChangshi extends JFrame implements ActionListener
{
	JTable table;
	DefaultTableModel dtm;
	Vector title=new Vector();
	JPanel p1=new JPanel();
	JPanel p2;
	JButton ok=new JButton("查询");
	JLabel l1=new JLabel("类型");
	JLabel l2=new JLabel("商品名称");
	JComboBox combSex=new JComboBox();
	JTextField txtAddr=new JTextField(20);
	Statement s;
	ResultSet rs;
	public newChangshi()
	{
	  


		  combSex.addItem("所有");
           try
	      {
		  String url="jdbc:odbc:Test";
	    Connection  con=DriverManager.getConnection(url);
		  Statement  s1=con.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE);
		  ResultSet r=s1.executeQuery("select * from spxz");
		  r.first();
		  do{
		  	combSex.addItem(r.getString(1));
		  }while(r.next());
		  }
		  catch(Exception e111)
		  {
	      }
	      p1.add(l1);
	      p1.add(combSex);
	      p1.add(l2);
	      p1.add(txtAddr);
	      p1.add(ok);
	      p1.setBackground(new Color(190,190,190));
	      p2=new JPanel();
	      ok.addActionListener(this);
	      this.getContentPane().add(p1,"North");
	      JLabel lbb11=new JLabel(new ImageIcon("pic1\\back2.jpg"));
	      p2.add(lbb11,"Center");
	      this.getContentPane().add(p2,"Center");
	      
	 	this.addWindowListener(new WindowAdapter()
		{
		public void windowClosing(WindowEvent e)
		{
			try
			{
				rs.close();
				s.close();
			}catch(Exception wwww)
			{
			}
		}
		}	);

	  	

      setTitle("查询");
      setSize(600,400);
      setVisible(true);
      
	}
		void initTable()
	{
		dtm.setRowCount(0);
		try
		{//1
			rs.beforeFirst();
			while(rs.next())
			{
			
				Vector v1=new Vector();
				for(int i=1;i<=title.size();i++)
				v1.addElement(rs.getString(i));
				dtm.addRow(v1);
			}
		}//1
		catch(Exception eee)
		{
		}
		dtm.fireTableStructureChanged();
	}
	public void actionPerformed(ActionEvent e)
	{
		if(e.getSource()==ok)
		{
		   if(txtAddr.getText().equals(""))
		   {
		   	String sss=(String)combSex.getSelectedItem();
		   	if(sss.equals("所有"))
		   new 	Changshi1("");
		   	
		   	else
		   	
		   	  new  Changshi1(sss);	

		   }
		   else
		   new Changshi2(txtAddr.getText());
		}
		
	
	}
	//public static void main(String args[])
//	{
	//	new newChangshi();
//	}
}