Student Database using Shell 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 Shell Programming Code
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/> echo $record>stud <br/> ;; <br/> 2) echo " showing database of student" <br/> cat 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/> echo $record>>stud <br/> ;; <br/> 4) echo " enter roll number " <br/> read rn <br/> grep ^$rn stud <br/> if [ $? -ne 0 ]; then <br/> echo "record for roll number does not exist " <br/> else <br/> grep -v $rn stud>>tmp <br/> cp tmp stud <br/> echo "deletion complete " <br/> fi <br/> ;; <br/> 5) echo " enter roll number " <br/> read rn1 <br/> grep ^$rn stud <br/> if [ $? -ne 0 ]; then <br/> echo "record for roll number does not exist " <br/> else <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=`grep -n ^$rn1 stud | cut -c 1` <br/> echo $var <br/> var1=`expr $var - 1` <br/> head -$var1 stud>temp <br/> echo $record>>temp <br/> var3=`wc -l < stud` <br/> var2=`expr $var3 - $var ` <br/> tail -$var2 stud>>temp <br/> cp temp stud <br/> fi <br/> ;; <br/> 6) echo " enter roll number " <br/> read rn <br/> echo "printing result " <br/> grep ^$rn stud <br/> ;; <br/> 7) ;; <br/> * ) echo "enter right choice" <br/> esac |
Source projectgeek.com