nvl函数判参数为空时用双引号替换的代码实现

public List<Map<String, String>>findYqmcInstrName(String yqmc,int num){

       String sql = "    select *                                    "+

              " from(select                                "+

              "        nvl(t.JLQJBH,'\"\"') as JLQJBH,                              "+

              "        nvl(t.JLQJMC,'\"\"') asJLQJMC,                            "+

              "        nvl(t.SSKS,'\"\"') asSSKS,                               "+

              "        nvl(t.JLTX,'\"\"') asJLTX,                               "+

              "        nvl(t.CLFW,'\"\"') asCLFW,                               "+

              "        nvl(t.GGXH,'\"\"') asGGXH,                               "+

              "        nvl(t.DW,'\"\"') as DW,                                  "+

              "        t.BJ,                                  "+

              "        nvl(t.JCLX,'\"\"') asJCLX,                               "+

              "        nvl(m.BY5,'\"\"') asBY5,                                "+

              "        nvl(t.SFBZID,'\"\"') asSFBZID                            "+

              "    from                                       "+

              "        D_SF_SHOUFEIBZXXB t,                   "+

              "        T_SYS_KAIZHANGXMDA m                   "+

              "    where                                      "+

              "         t.XMBH = m.XMDM                    "+

              "        and (                                  "+

              "            instr(t.JLQJMC,'"+yqmc+"')>0           "+

              "            or instr(t.by3,'"+yqmc+"')>0           "+

              "        )                                      " +

              " ) a WHEREROWNUM <= " +num;

       String scalars="JLQJBH,JLQJMC,SSKS,JLTX,CLFW,GGXH,DW,BJ,JCLX,BY5,SFBZID";

       return sqlExecuteByScalars(sql,scalars);

    }

 

 

当t.JLQJBH 为空时用””进行替换的代码为：nvl(t.JLQJBH,'\"\"') as JLQJBH