taskfield.java

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

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

import java.sql.Types;

public interface TaskField {
	
	public final static short MAX = 9;

	public final static short ID = 0;
	public final static short CATEGORY = 1;
	public final static short PRIORITY = 2;
	public final static short STATUS = 3;
	public final static short REMARKS = 4;
	public final static short ASSIGNEDUSERID = 5;
	public final static short ROADDEFECTID = 6;
	public final static short DUEDATE = 7;
	public final static short CREATIONTIME = 8;
	public final static short LASTMODIFIEDTIME = 9;
	
	/**
	 * ID = 0;<br>
	 * CATEGORY = 1;<br>
	 * PRIORITY  = 2;<br>
	 * STATUS = 3;<br>
	 * REMARKS = 4;<br>
	 * ASSIGNEDUSERID = 5;<br>
	 * ROADDEFECTID = 6;<br>
	 * DUEDATE = 7;<br>
	 * CREATIONDATE = 8;<br>
	 * LASTMODIFIEDTIME = 9;<br>
	 * 
	 */
	public final static String[] FIELDS = 
		new String[] { "ID", 						//0
										"CATEGORY",		//1
										"PRIORITY", //2
										"STATUS", 		//3
										"REMARKS", 		//4
										"ASSIGNEDUSERID", 		//5
										"ROADDEFECTID",				//6
										"DUEDATE", 		//7
										"CREATIONTIME", //8
										"LASTMODIFIEDTIME", 	//9
										};

	public final static short[] FIELDTYPES = 
		new short[] { 	Types.INTEGER,	//ID, 						
										Types.INTEGER,	//CATEGORY,		
										Types.INTEGER,	//PRIORITY , 
										Types.INTEGER,	//STATUS, 		
										Types.VARCHAR,	//REMARKS, 		
										Types.VARCHAR,	//ASSIGNEDUSERID, 		
										Types.INTEGER,	//ROADDEFECTID,				
										Types.TIMESTAMP,	//DUEDATE, 		
										Types.TIMESTAMP ,			//CREATIONTIME, 
										Types.TIMESTAMP,			//LASTMODIFIEDTIME, 	
										};



}