tdmodel2.java

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

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

public class TdModel2 extends AbstractTableModel
{

       private static final long serialVersionUID = 1L;
       private Vector data;   
       private Vector titles;
       Connection connect;
       Statement state;
       ResultSet rs;
       public TdModel2()
       {
           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 = true");
                   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("developer");
       titles.add("pay");
       titles.add("detail");
       titles.add("duetime");
       titles.add("isComplete");
       }
       public TdModel2(Vector data)
       {
    	   this.data = data;
   		titles = new Vector();
   		titles.add("项目名称");
   		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;

       }

}