resultsettablemodel.java

来自「是一个简化的学校教职工管理系统」· Java 代码 · 共 58 行

import java.sql.*;
import java.util.Vector;

import javax.swing.JOptionPane;
import javax.swing.table.AbstractTableModel;
public class ResultSetTableModel extends AbstractTableModel{

	String[] columnNames=null;
	Vector data=new Vector();
	public void setResult(ResultSet rs){
		
		try{
			
			ResultSetMetaData rsmd=rs.getMetaData();
			columnNames=new String[rsmd.getColumnCount()];
			for(int i=0;i<rsmd.getColumnCount();i++)
				
				columnNames[i]=rsmd.getColumnName(i+1);
			
			data.clear();
			while(rs.next()){
				String[] rowdata=new String[rsmd.getColumnCount()];
				for( int i=0;i<rsmd.getColumnCount();i++){
					
				rowdata[i]=rs.getString(i+1);
				
				
				}
				data.addElement(rowdata);
				
			}
			
			}catch(Exception e){
			
		     JOptionPane.showMessageDialog(null,e.getMessage());
		   }
	}
	public int getColumnCount() {
		// TODO Auto-generated method stub
		return columnNames.length;
	}

	public int getRowCount() {
		// TODO Auto-generated method stub
		return data.size();
	}

	public Object getValueAt(int rowIndex, int columnIndex) {
		// TODO Auto-generated method stub
		return ((String[])data.elementAt(rowIndex))[columnIndex];
	}
	public String getColumnName(int column){
		
		return columnNames[column];
	}

}