首页 > 代码库 > 高校学生学籍系统C++&mysql

高校学生学籍系统C++&mysql

/*
C++程序设计实践教学环节任务书
一、题目:高校学籍管理系统
二、目的与要求
1. 目的:
1.掌握C++语言基本知识及其编程方法 
2.掌握类和对象的基本概念与用法
3.掌握面向对象中的继承与多态等面象对象特性
4.掌握文件流的基本操作
2. 要求 
基本要求:
(1)要求利用面向对象的方法以及C++的编程思想来完毕系统的设计; 
(2)要求在设计的过程中,建立清晰的类层次。 
(3)在系统中至少要定义8个类,每一个类中要有各自的属性和方法。 
(4)在系统的设计中,要求使用面向对象的继承与多态
*/
#include <iostream>
#include <stdlib.h>
#include <string>
#include <winsock2.h>
#include <mysql.h>
#pragma comment(lib,"ws2_32")
#pragma comment(lib,"libmysql")
using namespace std;


class Student
{
int id;
    char name[200];
    char sex[100];
    char min_zu[220];
    char ji_guan[330];
char sheng_fen_zheng_hao[20];
    char QQ[20];
    char phone[20];
int score;
public:
void show_table();
int main_menu();
void input();
int xiu_gai();
int xiu_gai_menu();
int cha_xun();
int cha_xun_menu();
int del();
int shan_menu();
int score_tong_ji();
int score_tong_ji_menu();
};


class Xu_gai:public Student//改动类
{
public:
void xiu_gai_xue_hao();
void xiu_gai_xing_ming();
void xiu_gai_xing_bie();
    void xiu_gai_min_zu();
void xiu_gai_ji_guan();
void xiu_gai_shen_fen_zheng_hao();
void xiu_gai_QQ_hao();
void xiu_gai_dian_hua();
void xiu_gai_cheng_ji();
};


class Cha_xun:public Student//查询类
{
public:
void xue_hao_cha_xun();
void xing_ming_cha_xun();
};


class Shan_chu:public Student//删除类
{
public:
void xue_hao_shan_chu();
void xing_ming_shan_chu();
};


class Score:public Student//成绩统计类
{
public:
void cheng_ji_pai_xu();
void zui_gao_zui_di_fen_xin_xi();
void ping_jun_fen();
void ji_ge_lv();
};


void Score::ji_ge_lv()//全体学生的及格率
{
Student zhao;
system("pause");
system("cls");
zhao.show_table();
    MYSQL mysql;
    mysql_init(&mysql); 
MYSQL_RES *resultset;
MYSQL_ROW row;
     mysql_options(&mysql, MYSQL_SET_CHARSET_NAME, "latin1");
    if(!mysql_real_connect(&mysql, "localhost", "root", "123456", "student", 3306, NULL, 0))  
    {  
        printf("\n数据库连接错误发生!");  
    }  
    else   
{
   float a,b;
mysql_query(&mysql,"select count(*) from xueji where score >= 450");
cout<<"及格人数:";
resultset=mysql_store_result(&mysql);
if(mysql_num_rows(resultset)!=NULL)
{
int numFields = mysql_num_fields(resultset);
while(row=mysql_fetch_row(resultset))
{ 

cout<<row[0];
a = atoi(row[0]);
cout<<endl;
}
}
mysql_query(&mysql,"select count(*) from xueji");
cout<<"总人数:";
resultset=mysql_store_result(&mysql);
if(mysql_num_rows(resultset)!=NULL)
{
int numFields = mysql_num_fields(resultset);
while(row=mysql_fetch_row(resultset))
{ 
cout<<row[0];
b = atoi(row[0]);
cout<<endl;
}
}
cout<<"及格率:";
cout << ((a/b)*100)<<"%" << endl<<endl;
mysql_free_result(resultset);
}
}


void Score::ping_jun_fen()//全体学生的平均分
{
Student zhao;
system("pause");
system("cls");
zhao.show_table();
    MYSQL mysql;
    mysql_init(&mysql); 
MYSQL_RES *resultset;
MYSQL_ROW row;
     mysql_options(&mysql, MYSQL_SET_CHARSET_NAME, "latin1");
    if(!mysql_real_connect(&mysql, "localhost", "root", "123456", "student", 3306, NULL, 0))  
    {  
        printf("\n数据库连接错误发生!");  
    }  
    else   
{
    float a,b;
mysql_query(&mysql,"select avg(score) from xueji");
cout<<"平均分:";
resultset=mysql_store_result(&mysql);
if(mysql_num_rows(resultset)!=NULL)
{
int numFields = mysql_num_fields(resultset);
while(row=mysql_fetch_row(resultset))
{ 
cout<<row[0];
a = atoi(row[0]);
cout<<endl;
}
}
mysql_free_result(resultset);
}
}


void Score::zui_gao_zui_di_fen_xin_xi()//最高最低分学生的信息
{
Student zhao;
system("pause");
system("cls");
zhao.show_table();
    MYSQL mysql;
    mysql_init(&mysql); 
MYSQL_RES *resultset;
MYSQL_ROW row;
     mysql_options(&mysql, MYSQL_SET_CHARSET_NAME, "latin1");
    if(!mysql_real_connect(&mysql, "localhost", "root", "123456", "student", 3306, NULL, 0))  
    {  
        printf("\n数据库连接错误发生!");  
    }  
    else   
{
    float a,b;
mysql_query(&mysql,"select max(score) from xueji");
cout<<"最高分:";
resultset=mysql_store_result(&mysql);
if(mysql_num_rows(resultset)!=NULL)
{
int numFields = mysql_num_fields(resultset);
while(row=mysql_fetch_row(resultset))
{ 
cout<<row[0];
a = atoi(row[0]);
cout<<endl;
}
}
mysql_query(&mysql,"select min(score) from xueji");
cout<<"最低分:";
resultset=mysql_store_result(&mysql);
if(mysql_num_rows(resultset)!=NULL)
{
int numFields = mysql_num_fields(resultset);
while(row=mysql_fetch_row(resultset))
{ 
cout<<row[0];
b = atoi(row[0]);
cout<<endl;
}
} 
mysql_free_result(resultset);
}
}


void Score::cheng_ji_pai_xu()//成绩排序
{
Student zhao;
system("pause");
system("cls");
zhao.show_table();
    MYSQL mysql;
    mysql_init(&mysql); 
MYSQL_RES *resultset;
MYSQL_ROW row;
mysql_options(&mysql, MYSQL_SET_CHARSET_NAME, "latin1");
    if(!mysql_real_connect(&mysql, "localhost", "root", "123456", "student", 3306, NULL, 0))  
    {  
        printf("\n数据库连接错误发生!");  
    }  
    else   
    {  
cout<<"**************************************開始成绩排名**************************************"<<endl;
  cout<<"    学号  "<<"    姓名  "<<"性别 "<<"民族  "<<"籍贯  "<<"      身份证  "<<"         QQ  "<<"       电话  "<<"    成绩  "<<endl;
cout<<"--------------------------------------------------------------------------------------"<<endl;
mysql_query(&mysql,"select * from xueji order by score desc");
resultset=mysql_store_result(&mysql);
         if(mysql_num_rows(resultset)!=NULL)
{
//int numRows = mysql_num_rows(resultset);
int numFields = mysql_num_fields(resultset);
while(row=mysql_fetch_row(resultset))
{
int i;
for(i=0;i<numFields;i++)
{
cout<<" "<<row[i]<<" ";
}
cout<<endl;
cout<<"--------------------------------------------------------------------------------------"<<endl;
}
}
else
{
cout<<"\n无查询结果!";
}
mysql_free_result(resultset);
}
}


void Shan_chu::xing_ming_shan_chu()//按姓名删除
{
Student zhao;
system("pause");
system("cls");
zhao.show_table();
    MYSQL mysql;   
    mysql_init(&mysql);   
mysql_options(&mysql, MYSQL_SET_CHARSET_NAME, "latin1");
    if(!mysql_real_connect(&mysql, "localhost", "root", "123456", "student", 3306, NULL, 0))  
    {  
        printf("\n数据库连接错误发生!");  
    }  
    else   
    {  
        char std[220]; 
char  na[200];
cout<<"请输入要删除学籍信息的学生姓名: "<<endl;
cin>>na;
        sprintf(std,"delete from xueji where name=‘%s‘;",na);
if(mysql_query(&mysql, std))
{ 
   cout<<"数据查询错误发生"<<endl;
}
        else
{
cout<<"删除成功!"<<endl;
}
}
}


void Shan_chu::xue_hao_shan_chu()//按学号删除
{
Student zhao;
system("pause");
system("cls");
zhao.show_table();
    MYSQL mysql;   
    mysql_init(&mysql);   
mysql_options(&mysql, MYSQL_SET_CHARSET_NAME, "latin1");
    if(!mysql_real_connect(&mysql, "localhost", "root", "123456", "student", 3306, NULL, 0))  
    {  
        printf("\n数据库连接错误发生!");  
    }  
    else   
    {  
        char std[220]; 
int  na;
cout<<"请输入要删除学籍信息的学生学号: "<<endl;
cin>>na;
        sprintf(std,"delete from xueji where id=%d;",na);
if(mysql_query(&mysql, std))
{ 
   cout<<"数据查询错误发生"<<endl;
}
        else
{
cout<<"删除成功!

"<<endl; } } } void Cha_xun::xing_ming_cha_xun()//姓名查询 { system("cls"); system("pause"); MYSQL mysql; mysql_init(&mysql); MYSQL_RES *resultset; MYSQL_ROW row; mysql_options(&mysql,MYSQL_SET_CHARSET_NAME,"latin1"); if(!mysql_real_connect(&mysql, "localhost", "root", "123456", "student", 3306, NULL, 0)) { cout<<"数据库连接错误!"<<endl; } else { char std[200]; char n[200]; cout<<"请输入要查的姓名:"<<endl; cin>>n; sprintf(std,"select * from xueji where name=‘%s‘;",n); if(mysql_query(&mysql, std)) { printf("\n数据查询错误发生\n"); } else { resultset=mysql_store_result(&mysql); if(mysql_num_rows(resultset)!=NULL) { int numFields=mysql_num_fields(resultset);//**获得表中的字段 while(row=mysql_fetch_row(resultset)) { int i=0; for(i=0;i<numFields;i++) { mysql_query(&mysql,"SET NAMES LATIN1"); cout<<" "<<row[i]<<" "; } cout<<endl; } } else { cout<<"显示无果。"; } } mysql_free_result(resultset); } } void Cha_xun::xue_hao_cha_xun()//学号查询 { system("cls"); system("pause"); MYSQL mysql; mysql_init(&mysql); MYSQL_RES *resultset; MYSQL_ROW row; mysql_options(&mysql,MYSQL_SET_CHARSET_NAME,"latin1"); if(!mysql_real_connect(&mysql, "localhost", "root", "123456", "student", 3306, NULL, 0)) { cout<<"数据库连接错误!"<<endl; } else { char std[200]; int n; cout<<"请输入要查的学号:"<<endl; cin>>n; cout<<"--------------------------------------显示查询----------------------------------------"<<endl; cout<<" 学号 "<<" 姓名 "<<"性别 "<<"民族 "<<"籍贯 "<<" 身份证 "<<" QQ "<<" 电话 "<<" 成绩 "<<endl; cout<<"--------------------------------------------------------------------------------------"<<endl; sprintf(std,"select * from xueji where id=%d;",n); if(mysql_query(&mysql, std)) { printf("\n数据查询错误发生\n"); } else { resultset=mysql_store_result(&mysql); if(mysql_num_rows(resultset)!=NULL) { int numFields=mysql_num_fields(resultset);//**获得表中的字段 while(row=mysql_fetch_row(resultset)) { int i=0; for(i=0;i<numFields;i++) { mysql_query(&mysql,"SET NAMES LATIN1"); cout<<" "<<row[i]<<" "; } cout<<endl; } cout<<"--------------------------------------------------------------------------------------"<<endl; } else { cout<<"显示无果。"; } } mysql_free_result(resultset); } } void Xu_gai::xiu_gai_cheng_ji()//改动成绩 { system("cls"); system("pause"); cout<<"显示学生数据"<<endl; Xu_gai zhao; zhao.show_table(); MYSQL mysql; mysql_init(&mysql); mysql_options(&mysql,MYSQL_SET_CHARSET_NAME,"latin1"); if(!mysql_real_connect(&mysql, "localhost", "root", "123456", "student", 3306, NULL, 0)) { cout<<"数据库连接错误!"<<endl; } else { char std[200]; char m[200]; int n; cout<<"对目标学号信息进行改动:"<<endl; cin>>n; cout<<"请输入要新的成绩:"<<endl; cin>>m; sprintf(std,"update xueji set score=‘%s‘ where id=%d;",m,n); if(mysql_query(&mysql, std)) { printf("\n数据库更改错误发生\n"); } else { printf("\n数据库更改数据成功\n"); } } } void Xu_gai::xiu_gai_dian_hua()//改动电话 { system("cls"); system("pause"); cout<<"显示学生数据"<<endl; Xu_gai zhao; zhao.show_table(); MYSQL mysql; mysql_init(&mysql); mysql_options(&mysql,MYSQL_SET_CHARSET_NAME,"latin1"); if(!mysql_real_connect(&mysql, "localhost", "root", "123456", "student", 3306, NULL, 0)) { cout<<"数据库连接错误!"<<endl; } else { char std[200]; char m[200]; int n; cout<<"对目标学号信息进行改动:"<<endl; cin>>n; cout<<"请输入要新的电话:"<<endl; cin>>m; sprintf(std,"update xueji set phone=‘%s‘ where id=%d;",m,n); if(mysql_query(&mysql, std)) { printf("\n数据库更改错误发生\n"); } else { printf("\n数据库更改数据成功\n"); } } } void Xu_gai::xiu_gai_QQ_hao()//改动QQ号 { system("cls"); system("pause"); cout<<"显示学生数据"<<endl; Xu_gai zhao; zhao.show_table(); MYSQL mysql; mysql_init(&mysql); mysql_options(&mysql,MYSQL_SET_CHARSET_NAME,"latin1"); if(!mysql_real_connect(&mysql, "localhost", "root", "123456", "student", 3306, NULL, 0)) { cout<<"数据库连接错误!

"<<endl; } else { char std[200]; char m[200]; int n; cout<<"对目标学号信息进行改动:"<<endl; cin>>n; cout<<"请输入要新的QQ号:"<<endl; cin>>m; sprintf(std,"update xueji set QQ=‘%s‘ where id=%d;",m,n); if(mysql_query(&mysql, std)) { printf("\n数据库更改错误发生\n"); } else { printf("\n数据库更改数据成功\n"); } } } void Xu_gai::xiu_gai_shen_fen_zheng_hao()//改动身份证号************************************************************ { system("cls"); system("pause"); cout<<"显示学生数据"<<endl; Xu_gai zhao; zhao.show_table(); MYSQL mysql; mysql_init(&mysql); mysql_options(&mysql,MYSQL_SET_CHARSET_NAME,"latin1"); if(!mysql_real_connect(&mysql, "localhost", "root", "123456", "student", 3306, NULL, 0)) { cout<<"数据库连接错误。"<<endl; } else { char std[200]; char m[200]; int n; cout<<"对目标学号信息进行改动:"<<endl; cin>>n; cout<<"请输入要新的身份证号:"<<endl; cin>>m; sprintf(std,"update xueji set sheng_fen_zheng_hao=‘%s‘ where id=%d;",m,n); if(mysql_query(&mysql, std)) { printf("\n数据库更改错误发生\n"); } else { printf("\n数据库更改数据成功\n"); } } } void Xu_gai::xiu_gai_ji_guan()//改动籍贯 { system("cls"); system("pause"); cout<<"显示学生数据"<<endl; Xu_gai zhao; zhao.show_table(); MYSQL mysql; mysql_init(&mysql); mysql_options(&mysql,MYSQL_SET_CHARSET_NAME,"latin1"); if(!mysql_real_connect(&mysql, "localhost", "root", "123456", "student", 3306, NULL, 0)) { cout<<"数据库连接错误!"<<endl; } else { char std[200]; char m[200]; int n; cout<<"对目标学号信息进行改动:"<<endl; cin>>n; cout<<"请输入要新的籍贯:"<<endl; cin>>m; sprintf(std,"update xueji set ji_guan=‘%s‘ where id=%d;",m,n); if(mysql_query(&mysql, std)) { printf("\n数据库更改错误发生\n"); } else { printf("\n数据库更改数据成功\n"); } } } void Xu_gai::xiu_gai_min_zu()//改动民族 { system("cls"); system("pause"); cout<<"显示学生数据"<<endl; Xu_gai zhao; zhao.show_table(); MYSQL mysql; mysql_init(&mysql); mysql_options(&mysql,MYSQL_SET_CHARSET_NAME,"latin1"); if(!mysql_real_connect(&mysql, "localhost", "root", "123456", "student", 3306, NULL, 0)) { cout<<"数据库连接错误!"<<endl; } else { char std[200]; char m[200]; int n; cout<<"对目标学号信息进行改动:"<<endl; cin>>n; cout<<"请输入要新的民族:"<<endl; cin>>m; sprintf(std,"update xueji set min_zu=‘%s‘ where id=%d;",m,n); if(mysql_query(&mysql, std)) { printf("\n数据库更改错误发生\n"); } else { printf("\n数据库更改数据成功\n"); } } } void Xu_gai::xiu_gai_xing_bie()//改动性别 { system("cls"); system("pause"); cout<<"显示学生数据"<<endl; Xu_gai zhao; zhao.show_table(); MYSQL mysql; mysql_init(&mysql); mysql_options(&mysql,MYSQL_SET_CHARSET_NAME,"latin1"); if(!mysql_real_connect(&mysql, "localhost", "root", "123456", "student", 3306, NULL, 0)) { cout<<"数据库连接错误!"<<endl; } else { char std[200]; char m[200]; int n; cout<<"对目标学号信息进行改动:"<<endl; cin>>n; cout<<"请输入要新的性别:"<<endl; cin>>m; sprintf(std,"update xueji set sex=‘%s‘ where id=%d;",m,n); if(mysql_query(&mysql, std)) { printf("\n数据库更改错误发生\n"); } else { printf("\n数据库更改数据成功\n"); } } } void Xu_gai::xiu_gai_xing_ming()//改动姓名 { system("cls"); system("pause"); cout<<"显示学生数据"<<endl; Xu_gai zhao; zhao.show_table(); MYSQL mysql; mysql_init(&mysql); mysql_options(&mysql,MYSQL_SET_CHARSET_NAME,"latin1"); if(!mysql_real_connect(&mysql, "localhost", "root", "123456", "student", 3306, NULL, 0)) { cout<<"数据库连接错误!"<<endl; } else { char std[200]; char m[200]; int n; cout<<"对目标学号信息进行改动:"<<endl; cin>>n; cout<<"请输入要新的姓名:"<<endl; cin>>m; sprintf(std,"update xueji set name=‘%s‘ where id=%d;",m,n); if(mysql_query(&mysql, std)) { printf("\n数据库更改错误发生\n"); } else { printf("\n数据库更改数据成功\n"); } } } void Xu_gai::xiu_gai_xue_hao()//改动学号 { system("cls"); system("pause"); cout<<"显示学生数据"<<endl; Xu_gai zhao; zhao.show_table(); MYSQL mysql; mysql_init(&mysql); mysql_options(&mysql,MYSQL_SET_CHARSET_NAME,"latin1"); if(!mysql_real_connect(&mysql, "localhost", "root", "123456", "student", 3306, NULL, 0)) { cout<<"数据库连接错误!"<<endl; } else { char std[200]; int n,m; cout<<"请输入要改动的学号:"<<endl; cin>>n; cout<<"请输入要新的学号:"<<endl; cin>>m; sprintf(std,"update xueji set id=%d where id=%d;",m,n); if(mysql_query(&mysql, std)) { printf("\n数据库更改错误发生\n"); } else { printf("\n数据库更改数据成功\n"); } } } int Student::xiu_gai()//定义改动函数 { cout<<"进入改动系统..."<<endl; int h; Xu_gai geng_zheng; system("pause"); system("cls"); MYSQL mysql; mysql_init(&mysql); mysql_options(&mysql,MYSQL_SET_CHARSET_NAME,"latin1"); if(!mysql_real_connect(&mysql, "localhost", "root", "123456", "student", 3306, NULL, 0)) { cout<<"数据库连接错误!

"<<endl; } else { while(1) { h=geng_zheng.xiu_gai_menu(); switch(h) { case 1: geng_zheng.xiu_gai_xue_hao(); break; case 2: geng_zheng.xiu_gai_xing_ming(); break; case 3: geng_zheng.xiu_gai_xing_bie(); break; case 4: geng_zheng.xiu_gai_min_zu(); break; case 5: geng_zheng.xiu_gai_ji_guan(); break; case 6: geng_zheng.xiu_gai_shen_fen_zheng_hao(); break; case 7: geng_zheng.xiu_gai_QQ_hao(); break; case 8: geng_zheng.xiu_gai_dian_hua(); break; case 9: geng_zheng.xiu_gai_cheng_ji(); break; case 0: return 0; break; default: cout<<"请选择正确的菜单项进行操作。多谢合作!"<<endl; } } } return 0; } int Student::cha_xun()//查询 { system("pause"); system("cls"); Cha_xun cha; MYSQL mysql; int h; mysql_init(&mysql); mysql_options(&mysql,MYSQL_SET_CHARSET_NAME,"latin1"); if(!mysql_real_connect(&mysql, "localhost", "root", "123456", "student", 3306, NULL, 0)) { cout<<"数据库连接错误!

"<<endl; } else { while(1) { h=cha.cha_xun_menu(); switch(h) { case 1: cha.xue_hao_cha_xun(); break; case 2: cha.xing_ming_cha_xun(); break; case 0: return 0; break; default: cout<<"请选择正确的菜单项进行操作。多谢合作!"<<endl; } } } return 0; } int Student::del()//删除 { system("pause"); system("cls"); Shan_chu shan; MYSQL mysql; int h; mysql_init(&mysql); mysql_options(&mysql,MYSQL_SET_CHARSET_NAME,"latin1"); if(!mysql_real_connect(&mysql, "localhost", "root", "123456", "student", 3306, NULL, 0)) { cout<<"数据库连接错误!

"<<endl; } else { while(1) { h=shan.shan_menu(); switch(h) { case 1: shan.xue_hao_shan_chu(); break; case 2: shan.xing_ming_shan_chu(); break; case 0: return 0; break; default: cout<<"请选择正确的菜单项进行操作。多谢合作!"<<endl; } } } return 0; } int Student::score_tong_ji()//成绩统计分析 { system("pause"); system("cls"); Score tong_ji; MYSQL mysql; int h; mysql_init(&mysql); mysql_options(&mysql,MYSQL_SET_CHARSET_NAME,"latin1"); if(!mysql_real_connect(&mysql, "localhost", "root", "123456", "student", 3306, NULL, 0)) { cout<<"数据库连接错误!"<<endl; } else { while(1) { h=tong_ji.score_tong_ji_menu(); switch(h) { case 1: tong_ji.cheng_ji_pai_xu(); break; case 2: tong_ji.zui_gao_zui_di_fen_xin_xi(); break; case 3: tong_ji.ping_jun_fen(); break; case 4: tong_ji.ji_ge_lv(); break; case 0: return 0; break; default: cout<<"请选择正确的菜单项进行操作。

多谢合作!"<<endl; } } } return 0; } void Student::input()//录入学生信息 { system("pause"); system("cls"); Student lu_ru; char std[200]; MYSQL mysql; mysql_init(&mysql); mysql_options(&mysql,MYSQL_SET_CHARSET_NAME,"latin1"); if(!mysql_real_connect(&mysql, "localhost", "root", "123456", "student", 3306, NULL, 0)) { cout<<"数据库连接错误!

"<<endl; } else { cout<<"请录入学生信息数据"<<endl<<endl<<"录入格式说明:输入一项按Enter键进行下一项的输入"<<endl<<endl; mysql_query(&mysql, "SET NAMES LATIN1"); cout<<"学号 "<<"姓名 "<<"性别 "<<"民族 "<<"籍贯 "<<"身份证 "<<"QQ "<<"电话 "<<"成绩 "<<endl; cin>>lu_ru.id>>lu_ru.name>>lu_ru.sex>>lu_ru.min_zu>>lu_ru.ji_guan>>lu_ru.sheng_fen_zheng_hao>>lu_ru.QQ>>lu_ru.phone>>lu_ru.score; sprintf(std,"insert into xueji VALUES(%d,‘%s‘,‘%s‘,‘%s‘,‘%s‘,‘%s‘,‘%s‘,‘%s‘,%d);" ,lu_ru.id,lu_ru.name,lu_ru.sex,lu_ru.min_zu,lu_ru.ji_guan,lu_ru.sheng_fen_zheng_hao,lu_ru.QQ,lu_ru.phone,lu_ru.score); mysql_query(&mysql,std); cout<<"加入成功"<<endl; } } void Student::show_table()//信息表数据的显示 { system("cls"); MYSQL mysql; MYSQL_RES *resultset; MYSQL_ROW row; mysql_init(&mysql); mysql_options(&mysql,MYSQL_SET_CHARSET_NAME,"latin1"); if(!mysql_real_connect(&mysql,"localhost","root","123456","student",3306,NULL,0)) { cout<<"\n数据库连接错误发生。"; } else { if(mysql_query(&mysql,"select * from xueji")) { cout<<"表格数据显示失败!"; } else { cout<<"--------------------------------------显示信息----------------------------------------"<<endl; cout<<" 学号 "<<" 姓名 "<<"性别 "<<"民族 "<<"籍贯 "<<" 身份证 "<<" QQ "<<" 电话 "<<" 成绩 "<<endl; cout<<"--------------------------------------------------------------------------------------"<<endl; resultset=mysql_store_result(&mysql); if(mysql_num_rows(resultset)!=NULL) { int numFields=mysql_num_fields(resultset);//**获得表中的字段 while(row=mysql_fetch_row(resultset)) { int i=0; for(i=0;i<numFields;i++) { mysql_query(&mysql,"SET NAMES LATIN1"); cout<<" "<<row[i]<<" "; } cout<<endl; cout<<"--------------------------------------------------------------------------------------"<<endl; } } else { cout<<"显示无果!"; } } mysql_free_result(resultset); } } int Student::main_menu()//主菜单 { system("pause"); system("cls"); int s; cout<<endl<<endl<<endl<<endl<<endl<<endl<<endl <<" 1: 录入学生信息 "<<endl <<" 2: 显示学生信息 "<<endl <<" 3: 查找学生信息 "<<endl <<" 4: 删除学生信息 "<<endl <<" 5: 改动学生信息 "<<endl <<" 6: 统计学生成绩 "<<endl <<" 0: 退出系统 "<<endl <<" 请选择:"; cin>>s; return s; } int Student::xiu_gai_menu()//改动菜单 { system("pause"); system("cls"); int a; cout<<endl<<endl<<endl<<endl<<endl <<" 1: 改动学号 "<<endl <<" 2: 改动姓名 "<<endl <<" 3: 改动性别 "<<endl <<" 4: 改动民族 "<<endl <<" 5: 改动籍贯 "<<endl <<" 6: 改动身份证 "<<endl <<" 7: 改动QQ号 "<<endl <<" 8: 改动手机号 "<<endl <<" 9: 改动成绩 "<<endl <<" 0: 返回上一层 "<<endl <<" 请选择:"; cin>>a; return a; } int Student::cha_xun_menu()//查询菜单 { system("pause"); system("cls"); int k; cout<<endl<<endl<<endl<<endl<<endl<<endl<<endl<<endl <<" 1: 按学号查找 "<<endl <<" 2: 按姓名查找 "<<endl <<" 0: 返回上一层 "<<endl <<" 请选择:"; cin>>k; return k; } int Student::shan_menu()//删除菜单 { system("pause"); system("cls"); int g; cout<<endl<<endl<<endl<<endl<<endl<<endl<<endl<<endl <<" 1: 按学号删除 "<<endl <<" 2: 按姓名删除 "<<endl <<" 0: 返回上一层 "<<endl <<" 请选择:"; cin>>g; return g; } int Student::score_tong_ji_menu()//成绩统计菜单 { system("pause"); system("cls"); int d; cout<<endl<<endl<<endl<<endl<<endl<<endl<<endl<<endl <<" 1: 对成绩进行排序 "<<endl <<" 2: 最高和最低成绩的学生信息 "<<endl <<" 3: 全体学生的平均分 "<<endl <<" 4: 及格率 "<<endl <<" 0: 返回上一层 "<<endl <<" 请选择:"; cin>>d; return d; } int main() { int n; Student zhao; MYSQL mysql; mysql_init(&mysql); if(!mysql_real_connect(&mysql,"localhost","root","123456","student",3306,NULL,0)) { cout<<"\n数据库连接错误发生!"; } else { cout<<"\n\n\n\n\n\n\n\n\n 数据库连接成功!

\n\n\n\n\n\n\n\n"; system("PAUSE"); system("cls"); while(1) { n=zhao.main_menu(); switch(n) { case 1: zhao.input(); break; case 2: zhao.show_table(); break; case 3: zhao.cha_xun(); break; case 4: zhao.del(); break; case 5: zhao.xiu_gai(); break; case 6: zhao.score_tong_ji(); break; case 0: system("cls"); cout<<endl<<endl<<endl<<endl<<endl<<endl<<endl<<endl; cout<<" ··········"<<endl; cout<<" ***···谢谢使用···***"<<endl; cout<<" ··········"<<endl<<endl<<endl<<endl<<endl<<endl; exit(1); break; default: cout<<"请选择正确的菜单项进行操作。多谢合作!"<<endl; } } } return 0; }


高校学生学籍系统C++&amp;mysql