C嵌入SQL编程(informix数据库)

main.ec文件

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

EXEC SQL define NAMELEN 60;
EXEC SQL define COMPLEN 80;
EXEC SQL define ADDRLEN 10;

EXEC SQL INCLUDE SQLCA;

char * myTrim(char * str) /*去掉字符串首尾*/
{
    if(NULL == str)
    {
        return NULL;
    }
    char * head = str;
    char * tail = str + strlen(str) -1;
    while((*head == ' ')&&(head < tail))head++;
    while((*tail == ' ')&&(tail > head))tail--;
    *(tail + 1) = '\0';
    memcpy(str, head, sizeof(char) * (tail - head + 2));
    return str;
}

int main(int argc, char ** argv)
{
    EXEC SQL BEGIN DECLARE SECTION;
    char name[NAMELEN];
    char comp[COMPLEN];
    char addr[ADDRLEN];
    int age = 0;
    double amt = 0.00;
    int nameind = -2;
    int addrind = -2;
    int compind = -2;
    int ageind = -2;
    int amtind = -2;
    EXEC SQL END DECLARE SECTION;

    memset(name, '\0', sizeof(name));
    memset(comp, '\0', sizeof(comp));
    memset(addr, '\0', sizeof(addr));

    EXEC SQL CONNECT TO "dbtbank";
    if(0 != sqlca.sqlcode)
    {
        printf("connect err! sqlcode = [%d]\n",sqlca.sqlcode);
        return -1;
    }

    EXEC SQL select lname, address, company, age, amt
    into :name indicator :nameind, :addr indicator addrind, :comp indicator :compind, :age indicator :ageind, :amt indicator :amtind
    from customer where custid = '108';
    if(0 != sqlca.sqlcode)
    {
        printf("select err! sqlcode = [%d]\n", sqlca.sqlcode);
        return -1;
    }
    myTrim(name);
    myTrim(comp);
    printf("name = [%s]\n", name);
    printf("addr = [%s]\n", addr);
    printf("comp = [%s]\n", comp);
    printf("age = [%d]\n", age);
    printf("amt = [%f]\n", amt);
    printf("amt = [%d]\n", amt);
    printf("nameind = [%d]\n", nameind);
    printf("addrind = [%d]\n", addrind);
    printf("compind = [%d]\n", compind);
    printf("ageind = [%d]\n", ageind);
    printf("amtind = [%d]\n", amtind);
    return 0;
}

customer.txt文件

105|wangxiancai|hubei|tienon|25|105.23|
106|zzzzzhhhhhaaaaannnnnggggg|hubeijingzho|llllliiiiiaaaaannnnn|24|100.0|
107| | | |0|0.0|
108||hubeijingzho|hua|||
109|wangxc|||||
110||||||

customer_create.sql文件

dbaccess dbtbank <<!
drop table customer;
create table customer
(
    custid int primary key,
    lname char(30),
    address char(12),
    company char(36),
    age int,
    amt decimal(10,2)
);
!

customer_delete.sql文件

dbaccess dbtbank <<!
delete from customer;
!

customer_insert.sql文件

dbaccess dbtbank <<!
insert into customer values('105', 'wangxiancai', 'hubei', 'tienon', 25, 105.23);
insert into customer values('106', 'zzzzzhhhhhaaaaannnnnggggg','hubeijingzhoujianli', 'llllliiiiiaaaaannnnn', 24, 100);
insert into customer values('107', ' ', ' ', '           ', 0, 0.00);
insert into customer(custid, address, company) values('108','hubeijingzhoujianli', 'hua');
insert into customer(custid, lname) values('109', 'wangxc');
insert into customer(custid) values('110');
insert into customer values('112', 'yangmeixue', 'hubei', 'huaxin', 26, 1100.5);
!

customer_select.sql文件

dbaccess dbtbank <<!
 select * from customer where lname like 'yang%';
!

customer_unload.sql文件

dbaccess dbtbank <<!
unload to customer.txt select * from customer;
!

customer_update.sql文件

dbaccess dbtbank <<!
update customer set lname='yangmeixue_pig' where lname='yangmeixue'
!