member_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.*;

public class Member_Server extends JPanel implements ActionListener
{
	Object a[][];
	Object columnName[]={"帐号","密码","问题","答案","余额","类型"};
	JTable table;
	JButton btFresh;
	int iNum=0;
	public Member_Server()
	{
		a=new Object[60][6];
		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=new.mdb");
			sql=con.createStatement();
			rs=sql.executeQuery("Select * From 用户");
			while(rs.next())
			{
			    a[i][0]=rs.getString("id");
				a[i][1]=rs.getString("password");
				a[i][2]=rs.getString("question");
				a[i][3]=rs.getString("answer");
				a[i][4]=rs.getFloat("balance");
				a[i][5]=rs.getInt("sort");
				
				i++;
			}
			con.close();
			repaint();
		}catch(SQLException ec){
		    ec.printStackTrace();
		}
	}
	public void actionPerformed(ActionEvent e) {
		if(e.getSource()==btFresh)
		{
			Query();
		}
	}
}