tbmodel.java

本工程模拟网上社区,其中包括银行,软件销售公司,软件投资公司,茶餐馆,和多个服务器.

package investcompanyclient;

import java.sql.*;
import javax.swing.table.AbstractTableModel;
import java.util.*;

public class TbModel extends AbstractTableModel {

	private static final long serialVersionUID = 1L;

	private Vector data;

	private Vector titles;

	Connection connect;

	Statement state;

	ResultSet rs;

	public TbModel() {
		data = new Vector();
		String JDriver = "sun.jdbc.odbc.JdbcOdbcDriver";
		String conURL = "jdbc:odbc:testDB";
		try {
			Class.forName(JDriver);
		} catch (java.lang.ClassNotFoundException e) {
			System.out.println("forname:" + e.getMessage());
		}
		try {

			connect = DriverManager.getConnection(conURL);
			state = connect.createStatement();
			rs = state
					.executeQuery("select * from gss where isComplete = false");
			while (rs.next()) {
				data.add(rs.getString("project"));
				data.add(rs.getString("developer"));
				data.add(rs.getDouble("pay"));
				data.add(rs.getString("detail"));
				data.add(rs.getString("duetime"));
				data.add(rs.getBoolean("isComplete"));
			}
		} catch (SQLException e) {
			System.out.println("Connection failed:\n" + e);
		}

		titles = new Vector();
		titles.add("project");
		titles.add("bidder");
		titles.add("pay");
		titles.add("detail");
		titles.add("duetime");
		titles.add("isComplete");
	}
    public TbModel(Vector data)
    {
    	this.data = data;
		titles = new Vector();
		titles.add("项目名称");
		titles.add("竞标商");
		titles.add("投资商");
		titles.add("详细信息");
		titles.add("项目截止完成时间");
		titles.add("是否完成招标");
 
    }
	public int getRowCount() {
		return data.size() / getColumnCount();
	}

	public int getColumnCount() {
		return titles.size();
	}

	public Object getValueAt(int rowIndex, int columnIndex) {
		return data.get((rowIndex * getColumnCount()) + columnIndex);
	}

	public String getColumnName(int columnIndex) {

		String colName = new String();

		if (columnIndex <= getColumnCount())

			colName = (String) titles.get(columnIndex);

		return colName;

	}

}