Student Database using AWK Programming
Write a program to handle student data base with options given below
a) Create data base.
b) View Data Base.
c) Insert a record.
d) Delete a record.
e) Modify a record.
f) Result of a particular student.
g) Exit.
Student Database using AWK
1 |
clear <br/> echo "1. create database " <br/> echo "2. view database " <br/> echo "3. insert a record " <br/> echo "4. delete record " <br/> echo "5. modify a record " <br/> echo "6. result of particular student " <br/> echo "7. exit" <br/> echo " enter ur choice " <br/> read d <br/> case $d in <br/> 1) <br/> echo " enter rollnumber of student " <br/> read rn <br/> echo " enter name of student " <br/> read nm <br/> echo " enter marks sanskrit " <br/> read sk <br/> echo " enter marks english " <br/> read eg <br/> echo " enter marks hindi " <br/> read hn <br/> record="$rn :$nm: $sk: $eg: $hn " <br/> awk 'BEGIN{ print "'"$record"'">"stud" }' <br/> ;; <br/> 2) awk 'BEGIN{print "rollno name smarks emarks hmarks"}{print $0}' stud;; <br/> 3) <br/> echo " enter rollnumber of student " <br/> read rn <br/> echo " enter name of student " <br/> read nm <br/> echo " enter marks sanskrit " <br/> read sk <br/> echo " enter marks english " <br/> read eg <br/> echo " enter marks hindi " <br/> read hn <br/> record="$rn: $nm: $sk: $eg: $hn " <br/> awk 'BEGIN { print "'"$record"'">>"stud" }' <br/> ;; <br/> 4) echo " enter roll number " <br/> read rn <br/> awk 'BEGIN{FS=":"}$1=='$rn' {print }' stud <br/> echo "RECORD FOUND " <br/> awk 'BEGIN{FS=":"}$1!='$rn'{print >"temp"}' stud <br/> cp temp stud <br/> ;; <br/> 5) echo " enter roll number " <br/> read rn1 <br/> awk 'BEGIN{FS=":"}$1=='$rn1' {print }' stud <br/> echo " enter roll number " <br/> read rn <br/> echo " enter name of student " <br/> read nm <br/> echo " enter marks sanskrit " <br/> read sk <br/> echo " enter marks english " <br/> read eg <br/> echo " enter marks hindi " <br/> read hn <br/> record="$rn: $nm: $sk: $eg: $hn " <br/> var=`awk 'BEGIN{FS=":"}$1=='$rn1' {print NR}' stud ` <br/> echo $var <br/> awk 'BEGIN{FS=":"}NR<'$var'{print >"temp"}' stud <br/> echo $record>>temp <br/> var3=`awk 'END{print NR}' stud ` <br/> var2=`expr $var3 - $var ` <br/> awk 'BEGIN{FS=":"}NR>'$var2' && NR<'var3' {print >>"temp"}' stud <br/> cp temp stud <br/> ;; <br/> 6) echo " enter roll number " <br/> read rn <br/> echo "printing result " <br/> awk 'BEGIN{FS=":"}$1=='$rn' {print }' stud <br/> echo "RECORD FOUND " <br/> ;; <br/> 7) ;; <br/> * ) echo "enter right choice" <br/> esac |
Source projectgeek.com