store_server.java

用java编写的c/s结构的网络社区

package server;
import java.awt.BorderLayout;
import java.awt.event.ActionEvent;
import java.awt.event.ActionListener;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;

import javax.swing.JButton;
import javax.swing.JPanel;
import javax.swing.JScrollPane;
import javax.swing.JTable;

public class Store_Server extends JPanel implements ActionListener
{
	Object a[][];
	Object columnName[]={"商品名称","VIP价格","普通价格","数量"};
	JTable table;
	JButton btFresh;
	int iNum=0;
	public Store_Server()
	{
		a=new Object[60][4];;
		table=new JTable(a,columnName);
		JScrollPane jsp2=new JScrollPane(table);
		JPanel p=new JPanel();
		btFresh=new JButton("刷新");
		btFresh.addActionListener(this);
		p.add(btFresh);
		setLayout(new BorderLayout());
		add(jsp2);
		add(p,BorderLayout.SOUTH);
		Query();
		repaint();
	}
	void Query()
	{
		Connection con;
		Statement sql;
		ResultSet rs;
		try{
			Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
		}catch(ClassNotFoundException ec){
			ec.printStackTrace();
		}
		int i=0;
		try{
			con=DriverManager.getConnection("jdbc:odbc:Driver={MicroSoft Access Driver (*.mdb)};DBQ=商品.mdb");
			sql=con.createStatement();
			rs=sql.executeQuery("Select * From 商品");
			while(rs.next())
			{
			    a[i][0]=rs.getString("商品名称");
				a[i][1]=rs.getInt("VIP价格");
				a[i][2]=rs.getInt("普通价格");
				a[i][3]=rs.getInt("数量");
				i++;
			}
			con.close();
			repaint();
		}catch(SQLException ec){
		    ec.printStackTrace();
		}
	}
	public void actionPerformed(ActionEvent e) {
		if(e.getSource()==btFresh)
		{
			Query();
		}
		
	}
}