Building Yet Another Database

This sample program will build one dbf and one index files. This sample is different in that the fields are referenced using another style.

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

public class example3 {

	public static void main(String args[]){

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

			//Define fields
			CharField teacherId = new CharField("teacherId",9);
			CharField teacherNm = new CharField("teacherNm",25);
			CharField dept = new CharField("dept",4);
            LogicalField tenure = new LogicalField("tenure");

			//Add fields to database
			aDB.addField(teacherId);
			aDB.addField(teacherNm);
			aDB.addField(dept);
            aDB.addField(tenure);

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


            // fields are referenced through the database object
			aDB.getField("teacherId").put("120120120");
            aDB.getField("teacherNm").put("Joanna Coffee");

            aDB.getField("dept").put("0800");
            ((LogicalField) aDB.getField("tenure")).put(true);

			aDB.write();

            // fields are referenced by their local variables
			teacherId.put("321123120");
            teacherNm.put("Juan Veldazou");

            dept.put("0810");
            tenure.put(true);

			aDB.write();

            // fields referenced both ways
			aDB.getField("teacherId").put("300020000");
            aDB.getField("teacherNm").put("Exal De' Cuau");

            dept.put("0810");
            tenure.put(false);

			aDB.write();



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

Input To Teacher Database