Here is a menu driven program for elementary database management system using C. There is a provision to Add, Modify, List and Delete records, the operations that are imperative in any database management. Following comments would help you in understand the program easily:
- Addition of record must always take place at the end of existing records in the file, much in the same way you would add new records in a register manually.
- Listing records means displaying the existing record on the screen. Naturally, record should be listed from first record to last record.
- While modifying records, first we must ask the user which record he intends to modify. Instead of asking the record number to be modified, it would be more meaningful to ask for the name of the employee whose record is to be modified. On modifying the record, the existing record gets overwritten by the new record.
- In deleting records, except for the record to be deleted, rest of the records must first be written to a temporary file must be renamed back to original.
- Observe carefully the way the file has been opened, first for reading and writing, and if this fails (the first time you run this program it would certainly fail, because that time the file is not existing), for writing and reading. It is imperative that the file should be opened in binary mode.
- Note that the file is being opened only once and closed only once, which is quite logical.
Software Code for Elementary Database Management System using C
|
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 |
#include <stdio.h> #include <conio.h> #include <stdlib.h> int main() { FILE *fp, *ft; char another, choice; struct empty{ char name[40]; int age; float bs; }; struct emp e; char empname[40]; long int recsize; fp=fopen("EMP.DAT","rb+"); if(fp==NULL) { fp=fopen("EMP.DAT","wb+"); if(fp==NULL) { puts("Cannot open file"); exit(); } } recsize=sizeof(e); while(1) { cls(); gotorc(10,30); printf("1.Add Records"); gotorc(12,30); printf("2.List Records"); gotorc(14,30); printf("3.Modify Records"); gotorc(16,30); printf("4.Delete Records"); gotorc(18,30); printf("0.Exit"); gotorc(20,30); printf("Your choice"); fflush(stdin); choice=getch(); switch(choice) { case '1': fseek(fp, 0, SEEK_END); another='Y'; while(another=='Y') { printf("\nEnter name, age, and basic sal."); scanf("%s%d%f",e.name,&e.age,&e.bs); fwrite(&e, recsize, 1, fp); printf("\nAdd another Record (Y/N)"); fflush(stdin); another=getche(); } break; case '2': rewind(fp); while(fread(&e, recsize, 1, fp)==1) printf("\n%s%d%f",e.name,e.age, e.bs); break; case '3': another='Y'; while(another=='Y') { printf("\nEnter name of employee to modify"); scanf("%s",empname); rewind(fp); while(fread(&e, recsize, 1, fp)==) { if(strcmp(e.name,empname)==) { scanf("%s%d%f",e.name,&e.age,&e.bs); fseek(fp,-recsize,SEEK_CUR); fwrite(&e, recsize, 1, fp); break; } } printf("\nModify another Record (Y/N)"); fflush(stdin); another=getche(); } break; case '4': another='Y'; while(another=='Y') { printf("\nEnter name of employee to delete"); scanf("%s",empname); ft=fopen("TEMP.DAT","wb"); rewind(fp); while(fread(&e, recsize, 1, fp)==1) { if(strcmp(e.name,empname)!=0) fwrite(&e, recsize, 1, ft); } fclose(fp); fclose(ft); remove("EMP.DAT"); rename("TEMP.DAT","EMP.DAT"); fp=fopen("EMP.DAT","rb+"); printf("Delete another Record (Y/N)"); fflush(stdin); another=getche(); } break; case'0': fclose(fp); exit(); } } } |
To understand how this program works, you need to be familiar with the concept of pointer. A pointer is initiated whenever we open a file. On opening a file a pointer is set up which points to the first record in the file. On using the functions fread() or fwrite(), the pointer moves to the beginning of the next record. On closing a file the pointer is deactivated.
The rewind() function places the pointer to the beginning of the file, irrespective of where it is present right now.
Note that the pointer movement is of utmost importance since fread() always reads that records where the pointer is currently placed. Similarly, fwrite() always the record where the pointer is currently placed.
The fseek() function lets us move the pointer from one record to another. In the program above, to move the pointer to the previous record from its current position, we used the function,
fseek(fp, -recsize, SEEK_CUR);
Here, -recsize moves the pointer back by recsize bytes from the current position. SEEK_CUR is a macro defined in “stdio.h”.
Similarly, the following fseek() would place the pointer beyond the last record in the file.
fseek(fp, 0, SEEK_END);
In fact -recsize or 0 are just the offsets that tell the compiler by how many bytes should the pointer be moved from a particular position. The third argument could be SEEK_END, SEEK_CUR or SEEK_SET. All these act as a reference from which the pointer should be offset. SEEK_END means move the pointer from the end of the file, SEEK_CUR means move the pointer with reference to its current position and SEEK_SET means move the pointer with reference to the beginning of the file.
If we wish to know where the pointer is positioned right now, we can use the function ftell(). It returns this position as a long int which is an offset from the beginning of the file. The value returned by ftell() can be used in subsequent calls to fseek(). A sample call to ftell() is shown below.
position=ftell(fp);
where position is a long int.
Respected website Admin sir,
Please post some projects using python programming language.