getresults.java

用来管理在校学生的出勤．作息等的管理系统

/*
 * @author 黎龙飞 , 创建日期 2008-5-19
 *
 * Blog : http://lilongfei1030.blog.163.com
 */
package stu.util;

import java.sql.Connection;
import java.sql.ResultSet;
import java.sql.ResultSetMetaData;
import java.util.Vector;

import javax.swing.table.DefaultTableModel;
import javax.swing.table.TableModel;

public class getResults {

	public TableModel Results(String sql) throws Exception {
		
	//	Vector<String> columnNames = new Vector<String>();

		Connection con = new ConnectDatabase().getResultString();
		ResultSet rs = con.createStatement().executeQuery(sql);
		
		ResultSetMetaData data = rs.getMetaData();
		int col = data.getColumnCount();
		String[] columnName = new String[col + 1];
		for (int i = 1; i <= col; i++) {
			if (i < col) {
				columnName[i] = data.getColumnName(i);
			} else {

				columnName[i] = data.getColumnName(i);
			}
		}
		//Vector<String> vname = new Vector<String>();
		DefaultTableModel tableModel = new DefaultTableModel(0, 0);
		for (int k = 1; k <= col; k++)
			tableModel.addColumn(columnName[k]);
		while (rs.next()) {
			Vector<Object> vdata = new Vector<Object>();
			for (int i = 1; i <= col; i++) {
				vdata.addElement(rs.getObject(i));
			}
			tableModel.addRow(vdata);
		}
		return tableModel;
	}
}