#此处查询的就是20k到30k薪资的分别有关Java、Hadoop、运营的岗位信息 cursor.execute(“SELECT COUNT() FROM demo WHERE SUBSTR(salary,1,2) BETWEEN 20 AND 30 and positionName like '%”+i+“%';”);