简单原理就是通过vs代码写了一个对数据库的简单操作,说白了就是根据输入的数据调整操作数据库的SQL语句, 我也打包了一个安装包出来,和数据库一起放在底下了
#include<stdio.h>
#include<mysql.h>
#pragma comment(lib,"libmysql.lib")
MYSQL_RES* sr; // 结果集,记录查询结果
int Query(MYSQL mysql)//查询操作
{
int Dnum, m, n, ret;
char sql[100];
printf("请输入需要查询药品的编号\n");
scanf_s("%d", &Dnum);
snprintf(sql, 100, "select * from Drugs Join Number USING (Dno,Dname) where Drugs.Dno=Number.Dno and Drugs.Dno=%d;",Dnum);
ret = mysql_real_query(&mysql, sql, 100);
if (ret != 0)
{
printf("输入的编号不存在!\n");
return 0;
}
sr = mysql_store_result(&mysql);
if (sr->row_count == 0) {
printf("sql 语句无返回结果\n");
}
else {
MYSQL_ROW row;
printf("编号\t\t名称\t\t产地\t\t单价\t\t数量\n");
// 打印所有属性列,不考虑索引
while (row = mysql_fetch_row(sr)) {
while (strcmp("", *(row)))
{
printf("%s\t\t", *(row++));
}
printf("\n");
}
}
mysql_free_result(sr);//释放结果集
}
int Modify(MYSQL mysql)//修改函数
{
int Dnum, m, num, ret;
char sql[100];
printf("请输入需要修改的药品的编号\n");
scanf_s("%d", &Dnum);
snprintf(sql, 100, "select * from Number where Dno=%d;", Dnum);
ret = mysql_real_query(&mysql, sql, 100);
if (ret != 0) {
printf("输入的编号不存在!\n");
return 0;
}
else
{
sr = mysql_store_result(&mysql);
mysql_free_result(sr);//释放结果集
for (;;)
{
printf("已查询到该药品,请选择1.入库 2.出库\n");
scanf_s("%d", &m);
if (m == 1 || m == 2)
{
if (m == 1)
{
printf("请输入入库数量\n");
scanf_s("%d", &num);
snprintf(sql, 100, "update Number set Dnum=Dnum+ %d where Dno=%d;", num, Dnum);
ret = mysql_real_query(&mysql, sql, 100);
if (ret != 0)
{
printf("sql 语句执行出错\n");
return 0;
}
else
{
printf("入库成功!");
sr = mysql_store_result(&mysql);
mysql_free_result(sr);//释放结果集
return 0;
}
}
else
{
printf("请输入出库数量\n");
scanf_s("%d", &num);
snprintf(sql, 100, "update Number set Dnum=Dnum- %d where Dno=%d;", num, Dnum);
if (mysql_real_query(&mysql, sql, strlen(sql))) {
printf("sql 语句执行出错\n");
system("pause");
return 0;
}
else
{
printf("出库成功!");
sr = mysql_store_result(&mysql);
mysql_free_result(sr);//释放结果集
return 0;
}
}
}
else return 0;
}
}
}
void Increase(MYSQL mysql)//插入函数
{
int Dnum, price, num;
char sql[100];
char name[100], city[100],ch;
printf("请输入增加药品的编号\n");
scanf_s("%d",&Dnum);
printf("请输入增加药品的单价\n");
scanf_s("%d",&price);
printf("请输入增加药品的数量\n");
scanf_s("%d",&num);
getchar();//清空输入缓冲区
printf("请输入增加药品的名称\n");
gets_s(name);
getchar();//清空输入缓冲区
printf("请输入增加药品的产地\n");
gets_s(city);
snprintf(sql, 100, "insert into Number values('%d','%s','%d');", Dnum, name , num);
if (mysql_real_query(&mysql, sql, 100))
{
printf("sql 语句执行出错\n");
}
sr = mysql_store_result(&mysql);
mysql_free_result(sr);//释放结果集
snprintf(sql, 100, "insert into Drugs values('%d','%s','%s','%d');", Dnum, name, city, price);
if (mysql_real_query(&mysql, sql, 100))
{
printf("sql 语句执行出错\n");
}
else printf("增加成功!");
sr = mysql_store_result(&mysql);
mysql_free_result(sr);//释放结果集
}
void Delete(MYSQL mysql)//删除函数
{
int Dnum;
char sql[100],sql1[100];
printf("请输入需要删除药品的编号\n");
scanf_s("%d", &Dnum);
snprintf(sql, 100, "delete from number where dno = %d;", Dnum);
snprintf(sql1, 100, "delete from drugs where dno = %d;", Dnum);
if (mysql_real_query(&mysql, sql, 100) || mysql_real_query(&mysql, sql1, 100))
{
printf("sql 语句执行出错\n");
}
else printf("删除成功!");
sr = mysql_store_result(&mysql);
mysql_free_result(sr);//释放结果集
}
int main()
{
int m;
char name[20], password[20], database[20];
printf("请输入管理员账号\n");
gets_s(name);
printf("请输入密码\n");
gets_s(password);
printf("请输入数据库名称\n");
gets_s(database);
MYSQL mysql;
mysql_init(&mysql);//初始化数据库句柄
mysql_options(&mysql, MYSQL_SET_CHARSET_NAME, "gbk");//设置编码为gbk,没这句必乱码
if (!mysql_real_connect(&mysql, "localhost", name, password, database, 3306, NULL, 0))
{
printf("数据库 连接失败!\n");
system("pause");
return 0;
}
for (;;)
{
printf("\n1.查询药物数量 2.修改药物数量 3.增加药物种类 4.删除药物种类 5.退出\n");
scanf_s("%d", &m);
switch (m)
{
case 1:Query(mysql);
break;
case 2:Modify(mysql);
break;
case 3:Increase(mysql);
break;
case 4:Delete(mysql);
break;
case 5:printf("感谢您的使用,再见!");
break;
default:
break;
}
if (m == 5)break;
}
mysql_close(&mysql);//关闭数据库
system("pause");
}
压缩包不大,我就传百度盘了(阿里盘为什么不能分享压缩包啊魂淡!)
链接:https://pan.baidu.com/s/1TFJ8Po5adcNY7YXtBkF4iQ?pwd=dlfa
提取码:dlfa