postgresql - libpq，带参数插入

Question

我想知道我是否可以使用 libpq 直接从 C/C++ 进行参数化查询而不是使用字符串，如果这样做，这段代码应该是什么样子？

string tblins = "";
tblins = "INSERT INTO " + commtable + " "
         "(vdoc, bdoc, mytime, txml) VALUES ("
         "'" + cxml.vdoc + "', "
             + cxml.bdoc + ", " //integer
         "'" + cxml.mytime + "', "
         "'" + cxml.txml + "')";

result = PQexec(conn, tblins.c_str());

谢谢。

Answer 1

是的，您可以按照说明使用PQexecParams 函数in the documentation .

If parameters are used, they are referred to in the command string as $1, $2, etc. nParams is the number of parameters supplied; it is the length of the arrays paramTypes[], paramValues[], paramLengths[], and paramFormats[].