contactfield.java

来自「Java的框架」· Java 代码 · 共 79 行

package mcaps.apps.prrm.roaddefect.dao.util;

import java.sql.Types;

/**
 * The representation of the contact fields in the database
 * to facilitate SQL query generation.
 * @author jov
 * @date Sep 23, 2005
 * @version 1.0.1.0
 */
public interface ContactField {

	public final static short MAX = 11;

	public final static short ID = 0;
	public final static short FIRSTNAME = 1;
	public final static short LASTNAME = 2;
	public final static short BLOCK = 3;
	public final static short FLOOR = 4;
	public final static short UNIT = 5;
	public final static short ROADNAME = 6;
	public final static short POSTCODE = 7;
	public final static short COUNTRY = 8;
	public final static short TELEPHONE = 9;
	public final static short EMAIL = 10;
	public final static short LASTMODIFIEDTIME = 11;
	
	/**
	 * The array of field names.
	 * ID = 0;<br>
	 * FIRSTNAME = 1;<br>
	 * LASTNAME = 2;<br>
	 * BLOCK = 3;<br>
	 * FLOOR = 4;<br>
	 * UNIT = 5;<br>
	 * ROADNAME = 6;<br>
	 * POSTCODE = 7;<br>
	 * COUNTRY = 8;<br>
	 * TELEPHONE = 9;<br>
	 * EMAIL = 10;<br>
	 * LASTMODIFIEDTIME = 11;<br>
	 */
	public final static String[] FIELDS = 
		new String[] { "ID", 					//0
										"FIRSTNAME",	//1
										"LASTNAME", 	//2
										"BLOCK", 			//3
										"FLOOR", 			//4
										"UNIT", 			//5
										"ROADNAME", 	//6
										"POSTCODE", 	//7
										"COUNTRY",		//8
										"TELEPHONE", 	//9
										"EMAIL", 			//10
										"LASTMODIFIEDTIME"	//11 
										};

	/**
	 * The array of field types according to the field names order.
	 */
	public final static short[] FIELDTYPES =
		new short[]{
								Types.INTEGER,			//ID, 					
								Types.VARCHAR,			//FIRSTNAME,	
								Types.VARCHAR,			//LASTNAME, 	
								Types.VARCHAR,			//BLOCK, 			
								Types.TINYINT,			//FLOOR, 			
								Types.TINYINT,			//UNIT, 			
								Types.VARCHAR,			//ROADNAME, 	
								Types.VARCHAR,			//POSTCODE, 	
								Types.VARCHAR,			//COUNTRY,		
								Types.VARCHAR,			//TELEPHONE, 	
								Types.VARCHAR,			//EMAIL, 			
								Types.TIMESTAMP			//LASTMODIFIEDTIME	 
								};
	
}