mytablemodel.java

大型数据库课程设计源码

package com.vbank.admin.component;

import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.Vector;

import javax.swing.JTable;
import javax.swing.table.DefaultTableModel;

import com.vbank.db.DBManager;

public class MyTableModel extends DefaultTableModel{
	private static final long serialVersionUID = 12L;
	
	Vector ve=new Vector();
	Vector data=new Vector();
	JTable ta;
	String tableName;
	private boolean cellEditable;
	
	public MyTableModel(int r,int c) {
		super(r,c);
	}
	public MyTableModel(String na) {
		String sql="select * from"+" "+na;
		tableName=na;
		cellEditable=false;
		DBManager.getConnection();
		ve=DBManager.getMeta(na);
		this.setColumnIdentifiers(ve);
		DBManager.getConnection();
		ResultSet rs=DBManager.executeSelect(sql);
		System.out.println(sql);
		//rs.afterLast();
		//int n=rs.getRow();
		//rs.beforeFirst();
		try {
			while(rs.next()) {
				data.add(rs.getString(1));
				data.add(rs.getString(2));
				data.add(rs.getString(3));
				data.add(rs.getInt(4));
				data.add(rs.getString(5));
				data.add(rs.getDate(6).toString());
				data.add(rs.getString(7));
				data.add(rs.getString(8));
				data.add(rs.getFloat(9));
				this.addRow(data);
				data=new Vector();
			}
		} catch (SQLException e) {
			// TODO 自动生成 catch 块
			e.printStackTrace();
		}
	}
	public boolean isCellEditable(int row,int column) {
		return cellEditable;
	}
}