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

来源：互联网发布：数据库的两级映像包括编辑：程序博客网时间：2024/05/21 11:05

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";

returnsqlExecuteByScalars(sql,scalars);

}

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

0 0