Building A Database Sample


This is a sample program that will build one dbf and two associated index files


/**
 *
 */
package org.xBaseJ.examples;

/**
 * @author joseph mcverry
 *
 */



import org.xBaseJ.*;
import org.xBaseJ.fields.CharField;
import org.xBaseJ.fields.LogicalField;
import org.xBaseJ.fields.NumField;

public class example1 {


	public static void main(String args[]){


		try{
			//Create a new dbf file
			DBF aDB=new DBF("class.dbf",true);

			//Create the fields

			CharField classId = new CharField("classId",9);
			CharField className = new CharField("className",25);
			CharField teacherId = new CharField("teacherId",9);
			CharField daysMeet = new CharField("daysMeet",7);
			CharField timeMeet =new CharField("timeMeet",4);
			NumField credits = new NumField("credits",2, 0);
			LogicalField UnderGrad = new LogicalField("UnderGrad");


			//Add field definitions to database
			aDB.addField(classId);
			aDB.addField(className);
			aDB.addField(teacherId);
			aDB.addField(daysMeet);
			aDB.addField(timeMeet);
			aDB.addField(credits);
			aDB.addField(UnderGrad);

			aDB.createIndex("classId.ndx","classId",true,true);     //  true - delete ndx, true - unique index,
			aDB.createIndex("TchrClass.ndx","teacherID+classId", true, false);     //true - delete NDX,  false - unique index,
			System.out.println("index created");

			classId.put("JAVA10100");
			className.put("Introduction to JAVA");
			teacherId.put("120120120");
			daysMeet.put("NYNYNYN");
			timeMeet.put("0800");
			credits.put(3);
			UnderGrad.put(true);

			aDB.write();

			classId.put("JAVA10200");
			className.put("Intermediate JAVA");
			teacherId.put("300020000");
			daysMeet.put("NYNYNYN");
			timeMeet.put("0930");
			credits.put(3);
			UnderGrad.put(true);

			aDB.write();

			classId.put("JAVA501");
			className.put("JAVA And Abstract Algebra");
			teacherId.put("120120120");
			daysMeet.put("NNYNYNN");
			timeMeet.put("0930");
			credits.put(6);
			UnderGrad.put(false);

			aDB.write();


		}catch(Exception e){
			e.printStackTrace();
		}
	}
}



If you ran the dbfHTML application against the class.dbf file you would get the following html text file

Input To Class Database

classId className teacherId daysMeet timeMeet credits UnderGrad
JAVA10100 Introduction to JAVA 120120120 NYNYNYN 0800 3 T
JAVA10200 Intermediate JAVA 300020000 NYNYNYN 0930 3 T
JAVA501 JAVA And Abstract Algebra 120120120 NNYNYNN 0930 6 F