存储过程 1
create procedure pr_add
(
a int,
b int
)
begin
declare c int;
if a is null then
set a = 0;
end if;
if b is null then
set b = 0;
end if;
set c = a + b;
select c as sum;
end;
存储过程 2
CREATE PROCEDURE productpricing(
OUT p1 DECIMAL(8,2),
OUT ph DECIMAL(8,2),
OUT pa DECIMAL(8,2)
)
BEGIN
SELECT MIN(id)
INTO p1
FROM test;
SELECT MAX(id)
INTO ph
FROM test;
SELECT avg(id)
INTO pa
FROM test;
END;
调用 如下:
bool cmysqlDB::selectSum( int a, int b, QVector > &vec)//调用存储过程1
{
bool reVal = false;
vec.clear();
QVector vecInsert;
QSqlQuery sql_query(m_phmDB);
i