根据学号查询成绩和根据姓名查询成绩两种方法

查询成绩的方式可以使用数据库查询语言来实现，在学生信息表中添加成绩字段，然后根据学号或姓名进行查询。

1. 根据学号查询成绩

可以使用如下的 SQL 语句来查询指定学号的成绩：

SELECT score FROM student_info WHERE student_id = '学号';

其中，`student_id` 表示学号字段，`score` 表示成绩字段。

2. 根据姓名查询成绩

可以使用如下的 SQL 语句来查询指定姓名的成绩：

SELECT score FROM student_info WHERE student_name = '姓名';

其中，`student_name` 表示姓名字段，`score` 表示成绩字段。需要注意的是，如果存在同名的情况，这种方式可能会返回多个结果。

相关问题

根据学号查询成绩和根据姓名查询成绩两种方法 c语言

以下是根据学号查询成绩的 C 语言代码：

#include <stdio.h>
#include <string.h>

struct student {
    char name[50];
    int id;
    float score;
};

int main() {
    int n, i, search_id;
    printf("Enter number of students: ");
    scanf("%d", &n);

    struct student students[n];

    for (i = 0; i < n; i++) {
        printf("\nStudent %d:\n", i + 1);
        printf("Enter name: ");
        scanf("%s", students[i].name);
        printf("Enter ID: ");
        scanf("%d", &students[i].id);
        printf("Enter score: ");
        scanf("%f", &students[i].score);
    }

    printf("\nEnter the ID of the student to search: ");
    scanf("%d", &search_id);

    for (i = 0; i < n; i++) {
        if (students[i].id == search_id) {
            printf("\nName: %s\n", students[i].name);
            printf("ID: %d\n", students[i].id);
            printf("Score: %.2f\n", students[i].score);
            break;
        }
    }

    if (i == n) {
        printf("\nNo student with ID %d found!\n", search_id);
    }

    return 0;
}

以下是根据姓名查询成绩的 C 语言代码：

#include <stdio.h>
#include <string.h>

struct student {
    char name[50];
    int id;
    float score;
};

int main() {
    int n, i, found = 0;
    char search_name[50];

    printf("Enter number of students: ");
    scanf("%d", &n);

    struct student students[n];

    for (i = 0; i < n; i++) {
        printf("\nStudent %d:\n", i + 1);
        printf("Enter name: ");
        scanf("%s", students[i].name);
        printf("Enter ID: ");
        scanf("%d", &students[i].id);
        printf("Enter score: ");
        scanf("%f", &students[i].score);
    }

    printf("\nEnter the name of the student to search: ");
    scanf("%s", search_name);

    for (i = 0; i < n; i++) {
        if (strcmp(students[i].name, search_name) == 0) {
            printf("\nName: %s\n", students[i].name);
            printf("ID: %d\n", students[i].id);
            printf("Score: %.2f\n", students[i].score);
            found = 1;
        }
    }

    if (!found) {
        printf("\nNo student with name %s found!\n", search_name);
    }

    return 0;
}

根据学号查询成绩和根据姓名查询成绩调用函数两种方法 c语言

1. 根据学号查询成绩

#include <stdio.h>
#include <string.h>

struct Student {
    char name[20];
    int id;
    int score;
};

void searchById(struct Student s[], int n, int id) {
    int i;
    for (i = 0; i < n; i++) {
        if (s[i].id == id) {
            printf("Name: %s\n", s[i].name);
            printf("ID: %d\n", s[i].id);
            printf("Score: %d\n", s[i].score);
            return;
        }
    }
    printf("No record found for ID %d\n", id);
}

int main() {
    struct Student students[3] = {{"Alice", 1001, 85}, {"Bob", 1002, 90}, {"Charlie", 1003, 95}};
    int id;
    printf("Enter ID to search: ");
    scanf("%d", &id);
    searchById(students, 3, id);
    return 0;
}

2. 根据姓名查询成绩

#include <stdio.h>
#include <string.h>

struct Student {
    char name[20];
    int id;
    int score;
};

void searchByName(struct Student s[], int n, char* name) {
    int i;
    for (i = 0; i < n; i++) {
        if (strcmp(s[i].name, name) == 0) {
            printf("Name: %s\n", s[i].name);
            printf("ID: %d\n", s[i].id);
            printf("Score: %d\n", s[i].score);
            return;
        }
    }
    printf("No record found for name %s\n", name);
}

int main() {
    struct Student students[3] = {{"Alice", 1001, 85}, {"Bob", 1002, 90}, {"Charlie", 1003, 95}};
    char name[20];
    printf("Enter name to search: ");
    scanf("%s", name);
    searchByName(students, 3, name);
    return 0;
}