showallinfo.java

java开发的桌面系统

import java.awt.*;
import java.awt.event.*;
import javax.swing.*;
import java.sql.*;
import javax.swing.table.*;

class ShowAllInfo extends Frame{
	ResultSet rs;
	ResultSetMetaData meta;
	JToolBar jToolBar = new JToolBar();
	JButton add = new JButton();
	JButton update = new JButton();
	JButton delet = new JButton();
	JScrollPane p = new JScrollPane();
	JTable jtab = new JTable();
	DBManager db ;
	//Panel p = null;
	//JdbTable infTab = null;
	//ScrollPane sp = null; 
	
	
	public ShowAllInfo(){
		  super("职工的全部信息");
		  db = new DBManager();
		//add.addActionListener(new OnClickDemo());
		//update.addActionListener(new OnClickDemo());
		//delet.addActionListener(new OnClickDemo());
		
		p.getViewport().add(jtab);
		
		//滚动面板加入窗口
		this.add(p,java.awt.BorderLayout.CENTER);
		
		//添加按钮
		jToolBar.add(add);
		jToolBar.add(update);
		jToolBar.add(delet);
		
		//工具条加入窗口
		this.add(jToolBar,java.awt.BorderLayout.NORTH);
		
		//查询表得到结果集
		try{
		rs = db.getResult("select * from emplyMag");//返回ResultSet类型
		
		meta = rs.getMetaData();//ResultSetMetaData  获取此 ResultSet 对象的列的编号、类型和属性。
		
		
		}
		catch(SQLException xe){
			xe.printStackTrace();
			meta = null;
		}
		
		//添加在表格中
		jtab.setModel(new AbstractTableModel(){//匿名类
			public String getColumnName(int col){
				try{
					return meta.getColumnLabel(col + 1);
				}
				catch(SQLException ex){
					return null;
				}
			}
			
			public int getColumnCount(){
				try{
					return meta.getColumnCount();
				}
				catch(SQLException ex){
					return 0;
				}
			}
			
			public int getRowCount(){
				try{
					rs.last();//结果集前进到最后一行
					int rowcount = rs.getRow();
					return rowcount;
					
				}
				catch(SQLException ex){
					return 0;
				}
			}
			
			public Object getValueAt(int row,int col){
				try{
					rs.absolute(row+1);//前进到结果集第row+1行，结果集行从1开始
					return rs.getString(col+1);//返回结果集的第 col列，结果集列从1开始
				}
				catch(SQLException ex){
					return null;
				}
			} 
		});
		
		
		//设置关闭窗口
		
		this.addWindowListener(new WindowAdapter(){
    		public void windowClosing(WindowEvent e){
    			dispose();
    		}
    	});
    	
		
		this.setSize(800,500);
		this.setLocation(280,80);
		this.setResizable(false);
		this.setVisible(true);
	}
	
	
	public static void main(String[] args){
		new ShowAllInfo();
		
	}
}