search.java

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

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


public class Search extends JFrame implements ActionListener
{
		JButton x1=new JButton("查询",new ImageIcon("pic\\首记录.gif"));
		JButton x2=new JButton("下一个",new ImageIcon("pic\\下记录.gif"));
		JButton x3=new JButton("上一个",new ImageIcon("pic\\上记录.gif"));
		JButton x4=new JButton("尾纪录",new ImageIcon("pic\\尾记录.gif"));
     	JTextField jt1=new JTextField(20);
		String s2=null;
		Statement s;
		ResultSet rs;
		int i=0;
		JTextField jt2=new JTextField(20);
		JTextField jt3=new JTextField(20);
		JTextField jt4=new JTextField(20);
		JTextField jt5=new JTextField(20);
		JTextField jt6=new JTextField(20);
		JTextField jt7=new JTextField(20);
		JTextField jt8=new JTextField(20);
		JTextField jt9=new JTextField(20);
		JTextField jt10=new JTextField(20);
		JTextField jt11=new JTextField(20);
	public Search()
	{
		super.setTitle("查找数据处理");
		Container con1=getContentPane();
		con1.setLayout(new GridLayout(6,1));
			try{
					String url="jdbc:odbc:Test";
				Connection con=DriverManager.getConnection(url);
				 s=con.createStatement
				 (ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_READ_ONLY);
			    rs=s.executeQuery("select * from ruku");	
				rs.first();
				loadData();
			}catch(Exception e2)
			{
				e2.printStackTrace();
			}
			
	
		
		JLabel lb1=new JLabel("商品编号");
		JLabel lb2=new JLabel("商品名称");
		JLabel lb3=new JLabel("来源");
		JLabel lb4=new JLabel("单位    ");
		JLabel lb5=new JLabel("单价");
		JLabel lb6=new JLabel("          数量   ");
		JLabel lb7=new JLabel("接手人");
		JLabel lb8=new JLabel("生产日期");
		JLabel lb9=new JLabel("期限");
		JLabel lb10=new JLabel("合计总金额");
		JLabel lb11=new JLabel("按照商品编号查询");


		x1.addActionListener(this);
		x2.addActionListener(this);
		x3.addActionListener(this);
		x4.addActionListener(this);
		
		
		JPanel p1=new JPanel();
		p1.setLayout(new FlowLayout());
		p1.add(lb1);
		p1.add(jt1);
		p1.add(lb2);
		p1.add(jt2);
		p1.add(lb3);
		p1.add(jt3);
		
		
		
		JPanel p2=new JPanel();
		p2.setLayout(new FlowLayout());
		p2.add(lb4);
		p2.add(jt4);
		p2.add(lb5);
		p2.add(jt5);
		p2.add(lb6);
		p2.add(jt6);
		
		
     	JPanel p3=new JPanel();
     	p3.setLayout(new FlowLayout());
		p3.add(lb7);
		p3.add(jt7);
		p3.add(lb8);
		p3.add(jt8);
		p3.add(lb9);
		p3.add(jt9);
		
		
		JPanel p4=new JPanel();
		p4.setLayout(new FlowLayout());
		p4.add(lb10);
		p4.add(jt10);
		
		
		
		
			JPanel p5=new JPanel();
     	p4.setLayout(new FlowLayout());
		p4.add(lb11);
		p4.add(jt11);
		
		
			JPanel p6=new JPanel();
			p6.setLayout(new FlowLayout());
			p6.add(x1);
			p6.add(x2);
			p6.add(x3);
			p6.add(x4);
		
		con1.add(p1);
	    con1.add(p2);
		con1.add(p3);
		con1.add(p4);
		con1.add(p5);
		con1.add(p6);
					
			super.setSize(900,400);
			super.setResizable(false);
	super.setVisible(true);
		 
		
	}
	boolean loadData()
	{
		try{
			 jt1.setText(rs.getString(1));
			 jt2.setText(rs.getString(2));
		     jt3.setText(rs.getString(3));
		     jt4.setText(rs.getString(4));
		     jt5.setText(rs.getString(5));
		     jt6.setText(rs.getString(6));
		     jt10.setText(rs.getString(7));
		     jt7.setText(rs.getString(8));
		     jt8.setText(rs.getString(9));
		     jt9.setText(rs.getString(10));
		     
		}catch(Exception e2)
		{
			return false;
		}
		return true;
	
	}
	public void actionPerformed(ActionEvent e)
	{
		try
	{
		if(e.getSource()==x1)
		{
	
	String url="jdbc:odbc:Test";
	Connection con=DriverManager.getConnection(url);
	s=con.createStatement
	 (ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_READ_ONLY);
	 rs=s.executeQuery("select * from ruku");	
	 rs.first();
	 while(rs.next())
	 {
	 	if(rs.getString(1).equals(jt11.getText()))
	 	{
	 		i=1;
	 		loadData();
	 		break;

	 	}
	 
	 
	 }
	 if(i==1)
	 {
	 	JOptionPane.showMessageDialog(null,"查找成功");
	 	i=0;
	 	
	 }
	 else
	 {
	 	
	 	JOptionPane.showMessageDialog(null,"您查找的数据不存在");
	 }
	 
	
	 }
		
	}catch(Exception ee)
	{
		
	}
	}


	


//	public static void main(String args[])
//	{
	
//		new Search();
//	}
}