commonable.java

用java开发的一个进销存,开发工具jc, 数据库sql server

package classfile;
import java.awt.*;
import java.awt.event.*;
import javax.swing.*;
import java.sql.*;
import java.util.*;
import javax.swing.table.AbstractTableModel;
import java.util.Vector;

class Commonable{		
	static void screenCenter(JFrame frm){
	    Dimension screenSize = Toolkit.getDefaultToolkit().getScreenSize();
	    Dimension frameSize = frm.getSize();
	    if (frameSize.height > screenSize.height) {
	        frameSize.height = screenSize.height;
	    }
	    if (frameSize.width > screenSize.width) {
	        frameSize.width = screenSize.width;
	    }
	    frm.setLocation((screenSize.width - frameSize.width) / 2,(screenSize.height - frameSize.height) / 2);	
	}
	static void screenCenter(JDialog frm){
	    Dimension screenSize = Toolkit.getDefaultToolkit().getScreenSize();
	    Dimension frameSize = frm.getSize();
	    if (frameSize.height > screenSize.height) {
	        frameSize.height = screenSize.height;
	    }
	    if (frameSize.width > screenSize.width) {
	        frameSize.width = screenSize.width;
	    }
	    frm.setLocation((screenSize.width - frameSize.width) / 2,(screenSize.height - frameSize.height) / 2);	
	}
}

class MyTableModel extends AbstractTableModel{
	private Vector vData = null; 
	public MyTableModel(Vector v){
		vData = v;
	}
	public MyTableModel(){
	}
	public int getRowCount(){
		return vData.size()-1;
	}
	public int getColumnCount(){
		return ((Vector)vData.get(0)).size();
	}
	public Object getValueAt(int row,int col){
		return ((Vector)vData.get(row+1)).get(col);
	}
	
	public String getColumnName(int col){
		return ((Vector)vData.get(0)).get(col).toString();
	}
	public Vector getRowData(int row){
		return ((Vector)vData.get(row+1));
	}
	
	
	
	 void setData(String[] title, ResultSet rs) throws Exception{
		try{
			ResultSetMetaData rm = rs.getMetaData();
			if(title.length != rm.getColumnCount()){
				throw new Exception("标题与记录集不符");
			}
			int size = title.length;
			vData = new Vector();
			Vector vTitle = new Vector();
			for(int i=0; i<size; i++ ){
				vTitle.add(title[i]);
				
			}
			vData.add(vTitle);
			while(rs.next()){
				Vector v = new Vector();
				for(int i=1; i<size+1; i++){
					v.add(rs.getString(i));
				}
				vData.add(v);
			}
		}catch(SQLException e){
			throw e;
		}
	}
}