#include <iostream>
#include <mysql.h>
#include <string>
using namespace std;
void registion(MYSQL *mysql)
{
char employee_number[20];//职工号
char name[20];//姓名
char age[20];//年龄
char sex[20];//性别
char zip_code[20];//邮编
char department[20];//部门
char wage[20];//工资
cout << "请输入员工信息" << endl;
cout << "职工号: " << endl;
cin >> employee_number;
cout << "职工姓名: " << endl;
cin >> name;
cout << "职工年龄: " << endl;
cin >> age;
cout << "职工性别: " << endl;
cin >> sex;
cout << "职工邮编: " << endl;
cin >> zip_code;
cout << "职工部门: " << endl;
cin >> department;
cout << "职工工资: " << endl;
cin >> wage;
char exec[1024] = {0};
sprintf_s(exec, 1024, "insert cmd.staff values('%s', '%s', '%s', '%s', '%s', '%s', '%s')", employee_number, name, age, sex, zip_code, department, wage);
int ret = mysql_query(mysql, exec);
if(ret != 0)
{
cout << "error" << mysql_error(mysql) << endl;
}
}
void show_all(MYSQL* mysql)
{
int ret = mysql_query(mysql, "select * from cmd.staff");
if(ret != 0)
{
cout << "error" << mysql_error(mysql) << endl;
}
MYSQL_RES* mysql_res = mysql_store_result(mysql);
//MYSQL_FIELD* mysql_field;
MYSQL_ROW mysql_row;
int col = mysql_num_fields(mysql_res);
int row = mysql_num_rows(mysql_res);
if(!mysql_res)
{
cout << "error" << mysql_error(mysql) << endl;
}
cout <<"工号: "<< '\t' <<"姓名: " << '\t'<< "年龄: " << '\t'<< "性别: " << '\t'<< "邮编: " << '\t'<< "部门: " << '\t'<< "工资: " << endl;
while((mysql_row = mysql_fetch_row(mysql_res)))
{
for(int i = 0 ; i < col; i++)
{
cout << (mysql_row[i]? mysql_row[i] : "NULL") << '\t';
}
cout << endl;
}
mysql_free_result(mysql_res);
}
void query(MYSQL* mysql)
{
cout << &#
#include <mysql.h>
#include <string>
using namespace std;
void registion(MYSQL *mysql)
{
char employee_number[20];//职工号
char name[20];//姓名
char age[20];//年龄
char sex[20];//性别
char zip_code[20];//邮编
char department[20];//部门
char wage[20];//工资
cout << "请输入员工信息" << endl;
cout << "职工号: " << endl;
cin >> employee_number;
cout << "职工姓名: " << endl;
cin >> name;
cout << "职工年龄: " << endl;
cin >> age;
cout << "职工性别: " << endl;
cin >> sex;
cout << "职工邮编: " << endl;
cin >> zip_code;
cout << "职工部门: " << endl;
cin >> department;
cout << "职工工资: " << endl;
cin >> wage;
char exec[1024] = {0};
sprintf_s(exec, 1024, "insert cmd.staff values('%s', '%s', '%s', '%s', '%s', '%s', '%s')", employee_number, name, age, sex, zip_code, department, wage);
int ret = mysql_query(mysql, exec);
if(ret != 0)
{
cout << "error" << mysql_error(mysql) << endl;
}
}
void show_all(MYSQL* mysql)
{
int ret = mysql_query(mysql, "select * from cmd.staff");
if(ret != 0)
{
cout << "error" << mysql_error(mysql) << endl;
}
MYSQL_RES* mysql_res = mysql_store_result(mysql);
//MYSQL_FIELD* mysql_field;
MYSQL_ROW mysql_row;
int col = mysql_num_fields(mysql_res);
int row = mysql_num_rows(mysql_res);
if(!mysql_res)
{
cout << "error" << mysql_error(mysql) << endl;
}
cout <<"工号: "<< '\t' <<"姓名: " << '\t'<< "年龄: " << '\t'<< "性别: " << '\t'<< "邮编: " << '\t'<< "部门: " << '\t'<< "工资: " << endl;
while((mysql_row = mysql_fetch_row(mysql_res)))
{
for(int i = 0 ; i < col; i++)
{
cout << (mysql_row[i]? mysql_row[i] : "NULL") << '\t';
}
cout << endl;
}
mysql_free_result(mysql_res);
}
void query(MYSQL* mysql)
{
cout << &#