mysql api编程（三) 事务

来源：互联网发布：零基础学算法第三版编辑：程序博客网时间：2024/06/05 20:19

(1)代码:

/************************************************************************* * File Name: commit.c * Author:    The answer * Function:  Other         * Mail:      2412799512@qq.com  * Created Time: 2017年06月30日 星期五 19时22分31秒 ************************************************************************/#include<stdio.h>#include<stdlib.h>#include<mysql.h>#include<errno.h>#include<string.h>int main(int argc,char **argv){    MYSQL *mysql = NULL;    mysql = mysql_init(NULL);    mysql = mysql_real_connect(mysql,"127.0.0.1","root","lxg","date",3306,NULL, CLIENT_MULTI_STATEMENTS);    if(NULL == mysql)    {        perror("mysql_real_connect.\n");        return -1;    }    mysql_query(mysql,"set names utf8");    mysql_query(mysql, "start transaction");    int ret = mysql_query(mysql,"insert into sub values(8,27,'赵六','g','mysql',13666.60)");    int ret1 = mysql_query(mysql,"insert into sub values(9,28,'小黎','m','json',16688.00)");    if(ret || ret1)    {        mysql_query(mysql,"rollback");        return -1;    }    if(mysql_query(mysql,"commit"))    {        fprintf(stderr,"mysql_query failure.\n");        return -1;    }    mysql_close(mysql);    return 0;}

(2) 代码执行之前如下：

这里写图片描述

（3）执行代码后：

这里写图片描述

阅读全文

0 0