package?day18;

import?java.sql.ResultSet;
import?java.sql.SQLException;
import?java.util.HashMap;
import?java.util.Iterator;
import?java.util.Map;
import?java.util.Set;
import?java.util.Map.Entry;
import?javax.swing.table.AbstractTableModel;

public?class?DataTableModel?extends?AbstractTableModel?{
	private?final?static?String?columnName[]={“id““date““name““unit““price““amount““money“};
	private?Map?map=new?HashMap（）;
	private?int?rows=0;
	private?ResultSet?rs;
	public?DataTableModel（）{
		try?{
			rs=new?DBConn（）.getResult（）;
			while（rs.next（））{
				String[]?data=new?String[7];
				for（int?i=0;i					data[i]=rs.getString（getColumnName（i））;
				}
				map.put（rowsdata）;
				rows++;
			}
			rs.close（）;
		}?catch?（SQLException?e）?{
			e.printStackTrace（）;
		}
	}
	//為什么會出現一個值，這是因為全局變量和局部變量
	public?void?print（Map?map）{
		Set>?set=map.entrySet（）;
		Iterator>?it=set.iterator（）;
		while（it.hasNext（））{
			int?index=it.next（）.getKey（）;
			System.out.println（map.get（index））;
		}
	}
	public?int?getColumnCount（）?{
		return?columnName.length;
	}

	public?int?getRowCount（）?{
		//?TODO?Auto-generated?method?stub
		return?rows;
	}
	public?String?getColumnName（int?column）?{
		
		String?result?=?columnName[column];
		return?result;
	}
	public?object?getValueAt（int?rowIndex?int?columnIndex）?{
		String[]?dd=（String[]）?map.get（rowIndex）;
		return?dd[columnIndex];
	}

}

?屬性????????????大小?????日期????時間???名稱
-----------?---------??----------?-----??----

?????文件???????1472??2009-09-26?13:11??DBConn.java

?????文件???????1593??2009-09-26?14:49??DataTableModel.java

?????文件????????744??2009-09-26?12:05??DBTable.java

?????文件?????????83??2009-09-26?12:11??dbcon.config

-----------?---------??----------?-----??----

?????????????????3892????????????????????4