changetype.java

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

/*
// header - edit "Data/yourJavaHeader" to customize
// contents - edit "EventHandlers/Java file/onCreate" to customize
//
*/

public class ChangeType{
  public String[] changeSQLType(String[] type){
	  for(int i=1;i<type.length;i++){
		  if(type[i].equals("char")==true||type[i].equals("varchar")==true||type[i].equals("longvarchar")==true){
			  type[i]="String";
				}
			else if(type[i].equals("numeric")==true||type[i].equals("decimal")==true){
			  type[i]="java.math.BigDecimal";
				}
			else if(type[i].equals("bit")==true||type[i].equals("sex")==true){
			  type[i]="boolean";
				}
			else if(type[i].equals("tinyint")==true){
			  type[i]="byte";
				}	
		  else if(type[i].equals("smallint")==true){
			  type[i]="short";
				}	
			else if(type[i].equals("integer")==true){
			  type[i]="int";
				}		
			else if(type[i].equals("bigint")==true){
			  type[i]="long";
				}			
			else if(type[i].equals("real")==true){
			  type[i]="float";
				}
			else if(type[i].equals("float")==true||type[i].equals("double")==true){
			  type[i]="double";
				}	
			else if(type[i].equals("binary")==true||type[i].equals("varbinary")==true||type[i].equals("longvarbinary")==true){
			  type[i]="byte[]";
				}		
			else if(type[i].equals("date")==true||type[i].equals("datetime")==true||type[i].equals("time")==true||type[i].equals("timestamp")==true){
			  type[i]="Date";
				}	
			else if(type[i].equals("clob")==true){
			  type[i]="Clob";
				}	
			else if(type[i].equals("blob")==true){
			  type[i]="Blob";
				}		
			else if(type[i].equals("array")==true){
			  type[i]="Array";
				}
			else if(type[i].equals("struct")==true){
			  type[i]="Struct";
				}
			else type[i]=type[i];	
				
			}
			
			return type;
		
	}



}