roaddefectfield.java

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

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

import java.sql.Types;

/**
 * The representation of the road defect fields in the database
 * to facilitate SQL query generation.
 * @author jov
 * @date Sep 23, 2005
 * @version 1.0.1.0
 */
public interface RoadDefectField {
	
	public final static short MAX = 11;

	public final static short ID = 0;
	public final static short DEFECTTYPE = 1;
	public final static short DEFECTDETAIL = 2;
	public final static short ROADID = 3;
	public final static short LOCATION = 4;
	public final static short SEVERITY = 5;
	public final static short STATUS = 6;
//	public final static short COORDINATES = 7;
	public final static short CONTACTID = 8;
	public final static short CLOSEDDATE = 9;
	public final static short CREATIONTIME = 10;
	public final static short LASTMODIFIEDTIME = 11;
	
	/**
	 * The array of field names.
	 * ID = 0;<br>
	 * DEFECTTYPE = 1;<br>
	 * DEFECTDETAIL = 2;<br>
	 * ROADID = 3;<br>
	 * LOCATION = 4;<br>
	 * SEVERITY = 5;<br>
	 * STATUS = 6;<br>
	 * COORDINATES = 7;<br>
	 * CONTACTID = 8;<br>
	 * CREATIONDATE = 9;<br>
	 * CLOSEDDATE = 10;<br>
	 * LASTMODIFIEDTIME = 11;<br>
	 * 
	 */
	public final static String[] FIELDS = 
		new String[] { "ID", 							//0
										"DEFECTTYPE",			//1
										"DEFECTDETAIL", 	//2
										"ROADID", 				//3
										"LOCATION", 			//4
										"SEVERITY", 			//5
										"STATUS",					//6
										"COORDINATES", 		//7
										"CONTACTID", 			//8
										"CLOSEDDATE", 		//9
										"CREATIONTIME", 	//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.INTEGER,		//DEFECTTYPE,		
									Types.VARCHAR,		//DEFECTDETAIL, 
									Types.INTEGER,		//ROADID, 		
									Types.VARCHAR,		//LOCATION, 		
									Types.INTEGER,		//SEVERITY, 		
									Types.INTEGER,		//STATUS,				
									Types.VARCHAR,		//COORDINATES, 		
									Types.INTEGER,		//CONTACTID, 		
									Types.TIMESTAMP ,	//CLOSEDDATE, 
									Types.TIMESTAMP,	//CREATIONTIME, 	
									Types.TIMESTAMP,	//LASTMODIFIEDTIME 	
								};



}