多选判断查询

    public String countChoose(String name, String cid, String state) { //选择算法
        int lable = 0; //跟踪标记
        String sqladd = ""; //动态生成的sql部分语句
        String sql = "";
      
       if (!name.equals("")) {
            sqladd = "p.name='" + name + "'";//这里也需要注意，单引号
            lable = 1;
        }


         /**
         * 另外,不要用p.g_id因为有联级
         */

       if (!cid.equals("") && lable == 0) {
            sqladd = "p.g_id=" + Integer.parseInt(cid) + "";
            log.info("1:" + sqladd);
            lable = 1;
        }

        if (!cid.equals("") && lable == 1) {
            sqladd = sqladd + " and p.g_id=" + Integer.parseInt(cid) + "";

            log.info("2:" + sqladd);
        }

        if (!state.equals("") && lable == 1) {
            sqladd = sqladd + " and p.state=" + Integer.parseInt(state) + "";
        }
        if (!state.equals("") && lable == 0) {
            sqladd = "p.state=" + Integer.parseInt(state) + "";
            lable = 1;
        }

        if (lable == 0) {
            sql = "from ProductVO as p order by p.id desc";
        } else {
            sql = "from ProductVO as p where " + sqladd + " order by p.id desc";
        }
        log.info("search sql:" + sql);

        return sql;
   }