application_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 Application_Server extends JPanel implements ActionListener
{
	Object a[][];
	Object columnName[]={"项目名","投资公司","申请公司","目前最低金额"};
	JTable table;
	JButton btFresh;
	int iNum=0;
	public Application_Server()
	{
		a=new Object[30][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();
	}
	void Query()
	{
		while(iNum>=0)
		{
			a[iNum][0]=" ";
			a[iNum][1]=" ";
			a[iNum][2]=" ";
			a[iNum][3]=" ";
			iNum--;
		}
		Connection con;
		Statement sql;
		ResultSet rs;
		try{
			Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
		}catch(ClassNotFoundException ec){
			ec.printStackTrace();
		}
		iNum=0;
		try{
			con=DriverManager.getConnection("jdbc:odbc:Driver={MicroSoft Access Driver (*.mdb)};DBQ=投资.mdb");
			sql=con.createStatement();
			rs=sql.executeQuery("Select * From Application");
			while(rs.next())
			{
			    a[iNum][0]=rs.getString("项目名");
				a[iNum][1]=rs.getString("投资公司");
				a[iNum][2]=rs.getString("申请公司");
				a[iNum][3]=rs.getLong("目前最低金额");
				
				iNum++;
			}
			con.close();
			repaint();
		}catch(SQLException ec){
		    ec.printStackTrace();
		}
	}
	public void actionPerformed(ActionEvent e) {
		if(e.getSource()==btFresh)
		{
			Query();
		}
		
	}
}