📄 db.h
字号:
typedef unsigned short num_range1;
typedef unsigned short num_range2;
typedef unsigned short error_num;
#define TRUE 1
#define FALSE 0
#define nil 0
typedef struct node *stu_p;
struct node {
num_range1 number;
char name[11];
char sex;
struct date birthdate;
num_range2 experience;
num_range2 force;
num_range2 smartness;
struct node *front;
struct node *next;
} ;
FILE *db_file; //text文件类型出错
struct node *head_db,
*current,
*last_db;
int count,
tmp;
char *command_line;//user command
/*字段缓冲变量*/
num_range1 number_c;
char name_c[11];
num_range2 experience_c;
char sex_c;
num_range2 force_c;
num_range2 smartness_c;
struct date birthdate_c;
/*过程和函数*/
student_database(); //是主函数
//布尔类型翻译出错
////////////////////////////////////
int check_number();
int check_sex();
int check_birthdate();
int check_experience();
int check_force();
int check_smartness();
///////////////////////////////////
error_num check_record();
int condition_select();
void output_title();
void output_it();
void modify_it();
void swap_it();
void delete_it();
void add_record();
void insert_it();
void save_record();
void close_database();
void output_record();
void del_record();
void find_record();
void sort_record();
void modify_record();
void read_record();
void input_record();
void insert_record();
void command_select();
void optimize();
int check_number (num_range1 check_object)
{
int function;
if ((check_object >= 1) && (check_object <= 1000))
function = TRUE;
else
function = FALSE;
return(function);
}
int check_sex (char check_object)
{
int function;
if (check_object=='m'||check_object=='M'||check_object=='f'||check_object=='M')
function = TRUE;
else
function = FALSE;
return(function);
}
int check_birthdate (struct date check_object)
{
int function;
if ((check_object.da_year >= 1000) && (check_object.da_year <= 3000))
if (check_object.da_mon==1||check_object.da_mon==3||
check_object.da_mon==5||check_object.da_mon==7||check_object.da_mon==8||
check_object.da_mon==10||check_object.da_mon==12)
if (check_object.da_day<=31&&check_object.da_day>=1)
function = TRUE;
else
function = FALSE;
else if (check_object.da_mon==4||check_object.da_mon==6||
check_object.da_mon==9||check_object.da_mon==11)
if (check_object.da_day<=30&&check_object.da_day>=1)
function = TRUE;
else
function = FALSE;
else if (check_object.da_mon == 2)
if ((check_object.da_year % 4 == 0) &&
(check_object.da_year % 100 != 0) ||
(check_object.da_year % 400 == 0))
if (check_object.da_day<=29&&check_object.da_day>=1)
function = TRUE;
else
function = FALSE;
else if (check_object.da_day<=28&&check_object.da_day>=1)
function = TRUE;
else
function = FALSE;
else
function = FALSE;
else
function = FALSE;
return(function);
}
int check_experience (num_range2 check_object)
{
int function;
if (check_object<=100&&check_object>=0)
function = TRUE;
else
function = FALSE;
return(function);
}
int check_force (num_range2 check_object)
{
int function;
if (check_object<=100&&check_object>=0)
function = TRUE;
else
function = FALSE;
return(function);
}
int check_smartness (num_range2 check_object)
{
int function;
if (check_object<=100&&check_object>=0)
function = TRUE;
else
function = FALSE;
return(function);
}
error_num check_record (num_range1 *number_c,char *sex_c,struct date *birthdate_c,
num_range2 *experience_c,num_range2 *force_c,num_range2 *smartness_c)
{
int err_p;
error_num function;
err_p = FALSE; /*CHECK NUMBER*/
if ((err_p == FALSE))
if (check_number(*number_c))
err_p = FALSE;
else {
err_p = TRUE;
function = 1;
} /*CHECK SEX*/
if ((err_p == FALSE))
if (check_sex(*sex_c))
err_p = FALSE;
else {
err_p = TRUE;
function = 2;
} /*CHECK BIRTHDATE_C*/
if ((err_p == FALSE))
if (check_birthdate(*birthdate_c))
err_p = FALSE;
else {
err_p = TRUE;
function = 3;
} /*CHECK experience*/
if ((err_p == FALSE))
if (check_experience(*experience_c))
err_p = FALSE;
else {
err_p = TRUE;
function = 4;
} /*CHECK force*/
if ((err_p == FALSE))
if (check_force(*force_c))
err_p = FALSE;
else {
err_p = TRUE;
function = 5;
} /*CHECK smartness*/
if ((err_p == FALSE))
if (check_smartness(*smartness_c))
err_p = FALSE;
else {
err_p = TRUE;
function = 6;
} /*RETURN ERR_NUMBER*/
if (err_p == FALSE)
function = 0;
return(function);
}
int condition_select (char *condition_message)
{
int condition_code;
int function;
printf("\n");
printf("%s\n",condition_message);
printf(" 1 record 2 No 3 name 4 sex\n");
printf(" 5 birthday 6 experience 7 force 8 smartness\n");
printf("\n");
printf("choise:(1~8)");
scanf("%d",&condition_code);
function = condition_code;
return(function);
}
void output_title(void)
{
printf("\n");
printf(" record no name sex birthday experience force smartness\n");
}
void output_it (struct node *c,int n)
{
printf("%7d",n); /*数据输出*/
printf("%7d",c->number);
printf("%10s",c->name);
printf("%6c",c->sex);
printf("%6d/%2d/%2d",c->birthdate.da_year,c->birthdate.da_mon,
c->birthdate.da_day);
printf("%10d",c->experience);
printf("%10d",c->force);
printf("%10d",c->smartness);
printf("\n");
}
void modify_it (struct node *c,struct node *l,int n)
{
printf("modify %d input -1 ,still\n",n);
printf("record %d\n",n);
printf("No:");
scanf("%d",&number_c);
printf("name:");
gets(name_c);
gets(name_c);
printf("sex(M,F):");
scanf("%c",&sex_c);
printf("birthda_day(1978 16 1):");
scanf("%d %d %d",&birthdate_c.da_year,&birthdate_c.da_day,&birthdate_c.da_mon);
printf("experience:");
scanf("%d",&experience_c);
printf("force:");
scanf("%d",&force_c);
printf("smartness:");
scanf("%d",&smartness_c);
printf("\n");
if (number_c != - 1)
if (check_number(number_c))
c->number = number_c;
else
printf("out record\n");
if (strcmp(name_c,"-1") != 0)
strcpy (c->name,name_c);
if (sex_c != '-')
if (check_sex(sex_c))
c->sex = sex_c;
else
printf("sex error\n");
if ((birthdate_c.da_year != - 1) && (birthdate_c.da_mon != - 1) &&
(birthdate_c.da_day != - 1))
if (check_birthdate(birthdate_c))
c->birthdate = birthdate_c;
else
printf("birthday error\n");
if (experience_c != - 1)
if (check_experience(experience_c))
c->experience = experience_c;
else
printf("experience error\n");
if (force_c != - 1)
if (check_force(force_c))
c->force = force_c;
else
printf("force error\n");
if (smartness_c != - 1)
if (check_smartness(smartness_c))
c->smartness = smartness_c;
else
printf("smartness error\n");
}
void swap_it (struct node **current,struct node **last_db,struct node **c_bak,struct node **l_bak)
{
/*用于排序*/
struct node *tmp_c,
*tmp_l;
/*使C_BAK总是指向链表尾部*/
if (((*current)->front->front == nil) && (*last_db == nil)) {
/*STATUS=4*/
/*ONLY TWO*/ *current = (*current)->front;
head_db = *c_bak;
(*current)->front = head_db;
(*c_bak)->next = *current;
(*current)->next = nil;
*last_db = nil;
*c_bak = *current;
*l_bak = nil;
} /*LAST ONE*/
else if (((*current)->front->front != nil) && (*last_db == nil)) {
*current = (*current)->front;
(*current)->front->next = *c_bak;
(*c_bak)->front = (*current)->front;
(*c_bak)->next = *current;
(*current)->front = *c_bak;
(*current)->next = nil;
*last_db = (*current)->next;
*c_bak = *current;
*l_bak = *last_db;
} /*SECOND ONE*/
else if (((*current)->front->front == nil) && (*last_db != nil)) {
head_db = *current;
*current = (*current)->front;
head_db->next->front = *current;
(*current)->next = head_db->next;
head_db->front = nil;
head_db->next = *current;
(*current)->front = head_db;
*last_db = (*current)->next;
} /*MEDIUM*/
else {
tmp_c = *current;
*current = (*current)->front;
(*current)->front->next = tmp_c;
tmp_c->next->front = *current;
tmp_c->front = (*current)->front;
(*current)->next = tmp_c->next;
tmp_c->next = *current;
(*current)->front = tmp_c;
}
}
void delete_it (struct node **current,struct node **last_db)
{
/*可以自动后移指针*/
struct node *tmp;
if ((*current == head_db) && (*last_db == nil)) { /*statue = 4*/
/*ONLY ONE*/
free(*current);
head_db = nil;
*current = nil;
*last_db = nil;
count = 0;
} /*LAST ONE*/
else if ((*current != head_db) && (*last_db == nil)) {
*current = (*current)->front;
free(*current);
(*current)->next = *last_db;
count = count - 1;
} /*FIRST ONE*/
else if ((*current == head_db) && (*last_db != nil)) {
head_db = *last_db;
free(*current);
*current = head_db;
(*current)->front = nil;
*last_db = (*current)->next;
count = count - 1;
}
else {
(*current)->front->next = (*current)->next;
(*current)->next->front = (*current)->front;
tmp = *current;
*current = *last_db;
*last_db = (*current)->next;
free(tmp);
tmp = nil;
count = count - 1;
} /*IF*/
}
/*PROCEDURE*/
void add_record (void)
{
struct node *tmp;
if (head_db == nil) {
tmp = (stu_p) malloc (sizeof(struct node));
head_db = tmp;
head_db->next = nil;
current = head_db;
current->front = nil;
last_db = current->next;
}
else {
tmp = (stu_p) malloc (sizeof(struct node));
tmp->next = nil;
current->next = tmp;
tmp->front = current;
current = tmp;
last_db = current->next;
} /*数据赋值*/
current->number = number_c;
strcpy (current->name,name_c);
current->sex = sex_c;
current->birthdate = birthdate_c;
current->experience = experience_c;
current->force = force_c;
current->smartness = smartness_c;
count = count + 1;
}
void insert_it (struct node **c,int n,int *p)
{
struct node *insert;
error_num err;
*p = 0;
printf("record %d\n",n);
printf("No:");
scanf("%d",&number_c);
printf("name:");
gets(name_c);
gets(name_c);
printf("sex(M,F):");
scanf("%c",&sex_c);
printf("birthda_day(1978 16 1):");
scanf("%d %d %d",&birthdate_c.da_year,&birthdate_c.da_day,&birthdate_c.da_mon);
printf("experience:");
scanf("%d",&experience_c);
printf("force:");
scanf("%d",&force_c);
printf("smartness:");
scanf("%d",&smartness_c);
printf("\n");
err = check_record(&number_c,&sex_c,&birthdate_c,&experience_c,
&force_c,&smartness_c);
switch (err) {
case 0:
add_record();
n = n + 1;
*p=1;
break;
case 1:
printf("no wrong:1-1000\n");
printf("try again\n");
break;
case 2:
printf("sex wrong:M male F female\n");
printf("try again\n");
break;
case 3:
printf("birthday wrong:1978 1 16\n");
printf("try again\n");
break;
case 4:
printf("experience wrong:0-100\n");
printf("try again\n");
break;
case 5:
printf("force wrong:0-100\n");
printf("try again\n");
break;
case 6:
printf("smartness wrong:0-100\n");
printf("try again\n");
break;
}
if (*p == 1) { /*NO DATA*/
if (*c == nil) {
add_record();
} /*FIRST ONE*/
else if (*c == head_db) {
insert = (stu_p) malloc (sizeof(struct node));
insert->front = nil;
insert->next = nil;
head_db->front = insert;
insert->next = head_db;
head_db = insert;
insert->number = number_c;
strcpy (insert->name,name_c);
insert->sex = sex_c;
insert->birthdate = birthdate_c;
insert->experience = experience_c;
insert->force = force_c;
insert->smartness = smartness_c;
count = count + 1;
}
else {
insert = (stu_p) malloc (sizeof(struct node));
insert->front = nil;
insert->next = nil;
(*c)->front->next = insert;
insert->front = (*c)->front;
(*c)->front = insert;
insert->next = *c;
insert->number = number_c;
strcpy (insert->name,name_c);
insert->sex = sex_c;
insert->birthdate = birthdate_c;
insert->experience = experience_c;
insert->force = force_c;
insert->smartness = smartness_c;
count = count + 1;
}
}
}
void save_record (void)
{
int n;
char path[81];
struct node *c,
*l;
if (head_db == nil)
printf("no record\n");
else {
n = 0; /*文件初始化*/
printf("\n");
printf("write file name ps:pb.TXT:\n");
gets(path);
db_file=fopen(path,"wt"); /*指针初始化*/
c = head_db;
l = head_db->next;
fprintf(db_file,"%d\n",count); /*写入最大记录数*/
while (c != nil) { /*数据输出*/
fprintf(db_file,"%d",c->number);
fprintf(db_file,"%10s",c->name);
fprintf(db_file,"%2lc",c->sex);
fprintf(db_file,"%5d%3d%3d",c->birthdate.da_year,
c->birthdate.da_day,c->birthdate.da_mon);
fprintf(db_file,"%4d",c->experience);
fprintf(db_file,"%4d",c->force);
fprintf(db_file,"%4d",c->smartness);
fprintf(db_file,"\n");
n = n + 1;
c = l;
l = c->next;
}
fclose(db_file); /*保护代码*/
if (n != count)
printf("sum of record wrong\n");
printf("have been saved\n");
}
}
void close_database (int n)
{
/*N为内部使用,信息显示开关*/
struct node *c,
*l;
int i;
char pan;
if (head_db != nil) {
c = head_db;
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -