roadinspectionfield.java

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

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

import java.sql.Types;

public interface RoadInspectionField {
	
	public final static short MAX = 12;
	
	public final static short ID = 0;
	public final static short ROADDEFECTID = 1;
	public final static short TASKID = 2;
	public final static short DEFECTTYPE = 3;
	public final static short DEFECTDETAIL = 4;
	public final static short ROADNAME = 5;
	public final static short LOCATION = 6;
	public final static short SEVERITY = 7;
	public final static short SUMMARY = 8;
	public final static short SOLUTION = 9;
	public final static short REPAIRREQUIRED = 10;
	public final static short CREATIONTIME = 11;
	public final static short LASTMODIFIEDTIME = 12;
	
	/**
	 * ID = 0;<br>
	 * ROADDEFECTID = 1;<br>
	 * TASKID = 2;<br>
	 * DEFECTTYPE = 3;<br>
	 * DEFECTDETAIL = 4;<br>
	 * ROADNAME = 5;<br>
	 * LOCATION = 6;<br>
	 * SEVERITY = 7;<br>
	 * SUMMARY = 8;<br>
	 * SOLUTION = 9;<br>
	 * REPAIRREQUIRED = 10;<br>
	 * CREATIONDATE = 11;<br>
	 * LASTMODIFIEDTIME = 12;<br>
	 * 
	 */
	public final static String[] FIELDS = 
		new String[] { "ID", 						//0
										"ROADDEFECTID",	//1
										"TASKID",				//2
										"DEFECTTYPE", 	//3
										"DEFECTDETAIL", //4
										"ROADNAME", 		//5
										"LOCATION", 		//6
										"SEVERITY",			//7
										"SUMMARY", 			//8
										"SOLUTION", 		//9
										"REPAIRREQUIRED", //10
										"CREATIONTIME", //11
										"LASTMODIFIEDTIME"	//12
										};

	/**
	 * 
	 */
	public final static short[] FIELDTYPES = 
		new short[] { 	Types.INTEGER,	//ID, 						
										Types.INTEGER,	//ROADDEFECTID,		
										Types.INTEGER,	//TASKID, 
										Types.VARCHAR,	//DEFECTTYPE, 		
										Types.VARCHAR,	//DEFECTDETAIL, 		
										Types.VARCHAR,	//ROADNAME, 		
										Types.VARCHAR,	//LOCATION,				
										Types.VARCHAR,	//SEVERITY, 		
										Types.VARCHAR ,			//SUMMARY, 
										Types.VARCHAR,			//SOLUTION, 	
										Types.INTEGER,		//REPAIRREQUIRED 	
										Types.TIMESTAMP,		//CREATIONDATE 	
										Types.TIMESTAMP,		//LASTMODIFIEDTIME 	
										};



}