🚀 go-pugleaf

  ����һ��������ݿ�,�Ͱ�ȫ����,������ݿ����Ա(DBA)�Կ��
�����Ǻ��б�Ҫ��,������Ӧ�ó���IJ����Ƶ�ԭ��,DBA�Կ�IJ���
�ֲ��ɱ��⡣Ϊ��ȷ��Ӧ��ϵͳ��ȫ����,�������Ƴ�һ��ʵ�õ���
�ݿ�DBA����ϵͳ��������ϵͳ����Informix��ݿ���ʵ�ֵġ�
    DBA�Կ��ֱ�Ӳ�����������ݿ��ѯ����isql,����ܽ�DBA��
����������ͬ�����ٲ�ӳ�䵽Ӳ����,�����պ�IJ��������Ǻ���
����ġ�Ϊ��,������C���Ա���һ��isqlӲ��ӳ�����,��DBAÿһ��
��������¼��һ���ļ���,Ȼ������Shell���Ա���һ���������,��
���ز���DBA�������͡�������Ӧ��־,ʹ��DBAÿ����������
�ݿɲ顣
    ϵͳʵ��

    1.��informixע��,ת��$HOME/bin��,��isql����,�༭C���Գ�
�򲢱���,ִ���ļ���Ϊisql,���Ϊgroup,Ȩ��Ϊ754��

    2.����dba�û�,��Ϊgroup,Ȩ��Ϊ731,�γ�CXLOG���ļ�,Ȩ�޸�
Ϊ666,��.profile�����������:
    dbamain
    exit

    3.�༭shell����dbamain��CX1��CX5���������,����Ϊdba,Ȩ
�޸�Ϊ700��
    ϵͳ���ܼ�����
    ��ϵͳ���в�����,ʹ�÷��㡢��ֲ�Ժõ��ŵ�,������˵,��
ϵͳ�ɶ�DBA��־/usr/ dba/CXLOG���м�⡣�����ļ��ֽ��������
��ɶ�DBA���������з���ͳ�ƻ��ѯ���, ����ϵͳ��ʾ�޼�¼
��
    ��������ϵͳ���DZ�����Informix CSE��ONLINE5.0�϶�isql��
�򵥼ӹ�,�������һ���ľ�����,ϣ���λͬ�ʲ��ߴͽ�,ʹDBA�Կ�
�IJ����ܵ�������ܵļල����,��ȷ����ݿ�İ�ȫ��
    �����嵥����
    dbamain:
    dispmenu(){
    clear
    echo"\t  DBA ADMINISTRATION SYSTEM"
    echo
    echo"\t\t 1.Display Number of DBA Into DB"
    echo"\t\t 2.Display Number of DBA Query DB"
    echo"\t\t 3.Display Number of DBA Add DB"
    echo"\t\t 4.Display Number of DBA Update DB"
    echo"\t\t 5.Display Number of DBA Remove DB"
    echo"\t\t 6.Browse LOG of DBA Into  DB"
    echo"\t\t 7.Browse  LOG of DBA Query DB"
    echo"\t\t 8.Browse LOG of DBA Add  DB"
    echo"\t\t 9.Browse LOG of DBA Update  DB"
    echo"\t\t 10.Browse LOG of DBA Remove DB"
    echo"\t\t 0.Quit"echoechoecho"\t\t Please choose[0-10]:\
c"
    }
    while[1]  do
      dispmenu
    read ans
    if["$ans"=0]
    then
      clear
      exit
    fi
    if[$"ans"-lt 1-o $ "ans"-gt 10]
    then
      echo"\007\n\t\tInvalid choice!!"
      sleep 1
    else
      clear
      case $ans in
      1) if[-s/usr/dba/CXLOG]
          then
          echo "DBA into DB number is:\c"
          grep -c��date +%Y�� /usr/dba/CXLOG
          else
          echo"\t\007\007\007No record!!!"
          fi
         sleep 2;;
      2) if[-s /usr/dba/CXLOG]
          then
          echo"DBA into DB Query Number is:\c"
          grep -c Searching.../usr/dba/CXLOG
          else
          echo "\t\007\007\007No record!!!"
          fi
          sleep 2;;
      3) if[-s /usr/dba/CXLOG]
          then
          echo "DBA into DB Add Number is:\c"
          grep -c added /usr/dba/CXLOG
          else
          echo"\t\007\007\007No record!!!"
          fi
          sleep 2;;
      4) if[-s /usr/dba/CXLOG]
          then
          echo "DBA into DB Update number is:\c"
          grep -c changed /usr/dba/CXLOG
          else
          echo"\t\007\007\007No record!!!"
          fi
          sleep 2;;
      5) if[-s /usr/dba/CXLOG]
          then
          echo"DBA into DB Remove number is:\c"
          grep -c deleted /usr/dba/CXLOG
          else
          echo"\t\007\007\007No record!!!��
          fi
          sleep 2;;
      6) if[-s usr/dba/CXLOG]
          then
          clear
          echo"DBA into DB context is:\c"
          ./CX1
          else
          echo"\t\007\007\007No record!!!"
          fi;;
      7) if[-s /usr/dba/CXLOG]
          then
          echo"DBA into DB Query context is:\c"
          ./CX2
          else
          echo"\t\007\007\007No record!!!"
          fi
          sleep 2;;
      8) if[-s /usr/dba/CXLOG]
         then
         ./CX3
         else
         echo"\t\007\007\007No record!!!"
         fi
         sleep 2;;
      9) if[-s /usr/dba/CXLOG]
         then
         ./CX4
         else
         echo"\t\007\007\007No record!!!"
         if
         sleep 2;;
      10) if[-s /usr/dba/CXLOG]
          then
          ./CX5
          else
          echo"\t\007\007\007No record!!!"
          fi
          sleep 2;;
         esca
         fi
         done
    C����:
    #include<stdio.h>
    #include<curses.h>
    #include<fcntl.h>
    #include<signal.h>
    #include<time.h>
    #include<sys/ioctl.h>
    #include<sys/ipc.h>
    #include<sys/sem.h>
    #define BS 8#define ENTER 10
    #define SPACE 32
    #define MAX 5
    main(){system("date>>/usr/dba/CXLOG");
    system("who am i>>/usr/dba/CXLOG");
    system("cxcx|tee -a /usr/dba/CXLOG");
    CX1:
    fgrep -v ��INFORMIX
    informix
    ALL
    Press
    Copyright��/usr/dba/CXLOG|more
    CX2��CS6�ԡ�

--
 ________ _____          _____        ______________  _____ 
 ___  __ \___(_)________ ___(_)       __  ___/___  /_ ___(_)
 __  /_/ /__  / ___  __ \__  /        _____ \ __  __ \__  / 
 _  ____/ _  /  __  /_/ /_  /         ____/ / _  / / /_  /  
 /_/      /_/   _  .___/ /_/          /____/  /_/ /_/ /_/   
                /_/                                         

�� ��Դ:���ϴ�С�ٺ���Ϣ����վ bbs.nju.edu.cn��[FROM: hsia.nju.edu.cn]