tabledata.java

大型数据库课程设计源码

package com.vbank.admin.component;
import com.vbank.db.*;

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

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

public class TableData {
	Vector ve=new Vector();
	Vector data=new Vector();
	JTable ta;
	DefaultTableModel mod=new DefaultTableModel();
	String tableName;
	String sql="select * from"+tableName;
	public TableData(String na) {
		tableName=na;
		DBManager.getConnection();
		ve=DBManager.getMeta(tableName);
		mod.setColumnIdentifiers(ve);
		DBManager.getConnection();
		ResultSet rs=DBManager.executeSelect(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));
				mod.addRow(data);
				data=new Vector();
			}
		} catch (SQLException e) {
			// TODO 自动生成 catch 块
			e.printStackTrace();
		}
		
		ta=new JTable(mod);
		JScrollPane jsp=new JScrollPane(ta);
		JFrame f=new JFrame();
		f.getContentPane().add(jsp,BorderLayout.CENTER);
		f.setBounds(250, 120, 480, 390);
		f.setVisible(true);
	}
	public static void main(String arg[]) {
		new TableData("employee");
	}
}