goods.java

能简单的实现商品的查询

import javax.swing.*;
import java.awt.*;
import java.awt.event.*;
import java.sql.*;
class goods extends JFrame implements ActionListener
{
	JTable table;
	Object a[][];
	Object name[]={"商品编号","商品名称","商品价格","商品折扣","进货渠道"};

	
	Connection con;
	PreparedStatement sql;
	ResultSet rs;
    int i=0,j=0,h=0,m=0,n=0;
	JButton button;

 
 goods()
 {	  a=new Object[12][5];
	 try
	 {
		 con=DriverManager.getConnection("jdbc:odbc:sun","","");
		 sql=con.prepareStatement("select * from COMMODITY_ID");
		 rs=sql.executeQuery();
		 while(rs.next())
		 {
			 int t=rs.getInt("商品编号");
			 String s1=rs.getString("商品名称");
			 String s2=rs.getString("商品价格");
			 float f1=rs.getFloat("商品折扣");
			 String s3=rs.getString("进货渠道");
			 a[n++][0]=t;				
			 a[i++][1]=s1;
			 a[j++][2]=s2;
			 a[h++][3]=f1;
			 a[m++][4]=s3;
		 }	
		 
		 con.close();
	 }
	 catch(SQLException w)
	 {System.out.println(w);}
	 table=new JTable(a,name);
	  button=new JButton("返回上一层");
		button.addActionListener(this);
		Container con=getContentPane();
		getContentPane().add(new JScrollPane(table),BorderLayout.CENTER);
		con.add(new JLabel("这是用户查询界面"),BorderLayout.SOUTH);
		con.add(button,BorderLayout.SOUTH);
		setSize(600,600);
		setVisible(true);
		validate();
		setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);
	}
	public void actionPerformed(ActionEvent e4)
	{
		if(e4.getSource()==button)
	 {  System.out.println("all right!");
		
		setVisible(false);
	 }
	}
}