dbkeyinfo.java

实体对象javabean的自动生成工具。用于生成数据库表单的javabean程序

/*
// header - edit "Data/yourJavaHeader" to customize
// contents - edit "EventHandlers/Java file/onCreate" to customize
//
*/
import java.sql.*;

public class DBKeyInfo{
  public String[] getPrimaryKey(Connection con,String tablename)throws SQLException,Exception{
	  DatabaseMetaData dbmd=con.getMetaData();
		ResultSet rest=dbmd.getPrimaryKeys(null,null,tablename);
		ResultSet res=dbmd.getPrimaryKeys(null,null,tablename);
		int n=0;
		while(rest.next()){
		  n++;
		}
	  String[] Key=new String[n+1];
		int m=0;
		while(res.next()){
	  m++;
		Key[m]=res.getString(4);
		}
		return Key;
  }
	
	public String[] getKeyType(String[] ColumnName,String[] ColumnType,String[] Key){
	  String[] KeyType = new String[Key.length];
	  for(int i=1;i<Key.length;i++){
		  for(int j=1;j<ColumnName.length;j++){
			  if(Key[i].equals(ColumnName[j])==true){
				  KeyType[i]=ColumnType[j];
				}
			}
		}
		return KeyType;
	}	

}