The column name of the order by cannot be parameterized, and you want to spell SQL

From T_company C joins t_company_position p on c.id = P.companyid

ORDER by : type desc nulls last;

Initially do not know this can not, debugging Baidu got a long time, finally know the order by column name (cannot be parameter)

Then to display different sorting results based on different choices, you can only spell SQL.

if (type = = "Hot Jobs")
{
cmdstr+= "ORDER BY p.receive_resume Desc nulls Last";// Note there is a space in front of the order.
}
Else
{
cmdstr+= "ORDER BY p.create_time Desc nulls Last";
}

The column name of the order by cannot be parameterized, and you want to spell SQL