soci连接mysql_介绍一个针对C++程序的MySQL访问库soci

TEST(soci,select_multi2)

{

try

{

session sql(mysql, "db=soci user=dantezhu");

indicator ind;

int count;

sql << "select count(*) from tb_test", into(count, ind);

ASSERT_EQ(ind, i_ok) << count;

if (count == 0)

{

SUCCEED();

return;

}

int sex = 1;

vector vec_name(count);

vector vec_sex(count);

sql << "select name,sex from tb_test where sex = :sex",

into(vec_name), into(vec_sex), use(sex);

}

catch (exception const &e)

{

FAIL()<

}

}

TEST(soci,select_multi2)

{

try

{

session sql(mysql, "db=soci user=dantezhu");

indicator ind;

int count;

sql << "select count(*) from tb_test", into(count, ind);

ASSERT_EQ(ind, i_ok) << count;

if (count == 0)

{

SUCCEED();

return;

}

int sex = 1;

vector vec_name(count);

vector vec_sex(count);

sql << "select name,sex from tb_test where sex = :sex",

into(vec_name), into(vec_sex), use(sex);

}

catch (exception const &e)

{

FAIL()<

}

}

热点聚合:

©CopyRight 2010-2020 EASCK.COM Inc All Rights Reserved. 易采站长站 版权所有

微信扫一扫