请人讲解下getWherePart(' ',' ') 如题,谢谢。 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 这个是用户自己写的一个函数,oracle里本身没这个函数。 我是说网上能搜到getWherePart这个,具体函数定义我也不知,所以才问的。 strSQL = "select ProposalNo,PrtNo,RiskCode,RiskVersion,AppntName,InsuredName from LCPol where 1=1 " + "and AppFlag='0'" + getWherePart( 'ProposalNo' ) + getWherePart( 'ManageCom' ) + getWherePart( 'AgentCode' ) + getWherePart( 'AgentGroup' ) + getWherePart( 'RiskCode' ) + getWherePart( 'RiskVersion' );==================================================strSQL =" select a.UserCode,a.UserName,a.ComCode,b.ComName,(case when c.PersonMaxLimit>=0 then c.PersonMaxLimit else to_number('') end)," +" c.MakeDate,c.MakeTime from FDUser a " +" left join FDCom b on a.ComCode=b.ComCode " +" left join FDLendMaxLimitSet c on a.UserCode=c.ObjectCode and c.ObjectType='02' where 1=1 " + getWherePart('a.UserCode','UserCode') + getWherePart('a.UserName','UserName') + getWherePart('a.ComCode','OrganCode2') + getWherePart('a.UserState','UserState') +" order by a.UserCode " ; ===================================================protected String formSqlString(QuerySql querySql){StringBuffer buffer = new StringBuffer();try{buffer.append("select " + querySql.getSelectPart());buffer.append(" from " + querySql.getFromPart());if (querySql.getWherePart() != null&& !querySql.getWherePart().equals("")){buffer.append(" where " + querySql.getWherePart());}if (querySql.getOrderbyPart() != null&& !querySql.getOrderbyPart().equals("")){buffer.append(" order by " + querySql.getOrderbyPart());}} catch (Exception e){// 抛出sql语法错误throw new SystemException("SC000140", e);}String sql = buffer.toString();logger.info(" sql is :" + sql);System.out.println(" sql is " + sql);return sql;}===================================================但 不知具体实现。 { buffer.append(" where " + querySql.getWherePart()); } 这不oracle里的,是你的程序里c#?看样子应该是生成where条件应该民是个自定义的类吧 急!后天就要交毕业设计了,数据库连接池还有个错误没搞定,求高手帮帮忙 oracle 游标统计 java程序调用oracle pl-sql存储过程 使用Database Configuration Assistant使用General Purpose模板,里面的关于默认配置是自动产生还是每次都相同? ORACLE表利用序列实现自增字段的问题 数据库面试题...怎么做啊 向oracle中插入特殊字符 急问高手:安装问题 如何在oracle中指定要存储过程要使用的文本文件? 如何随机删除一个表中的若干条记录? 面试问题求助! left join on与带括号的加号的区别
+ "and AppFlag='0'"
+ getWherePart( 'ProposalNo' )
+ getWherePart( 'ManageCom' )
+ getWherePart( 'AgentCode' )
+ getWherePart( 'AgentGroup' )
+ getWherePart( 'RiskCode' )
+ getWherePart( 'RiskVersion' );
==================================================
strSQL =" select a.UserCode,a.UserName,a.ComCode,b.ComName,(case when c.PersonMaxLimit>=0 then c.PersonMaxLimit else to_number('') end),"
+" c.MakeDate,c.MakeTime from FDUser a "
+" left join FDCom b on a.ComCode=b.ComCode "
+" left join FDLendMaxLimitSet c on a.UserCode=c.ObjectCode and c.ObjectType='02' where 1=1 " + getWherePart('a.UserCode','UserCode')
+ getWherePart('a.UserName','UserName')
+ getWherePart('a.ComCode','OrganCode2')
+ getWherePart('a.UserState','UserState')
+" order by a.UserCode " ;
===================================================
protected String formSqlString(QuerySql querySql)
{
StringBuffer buffer = new StringBuffer();
try
{
buffer.append("select " + querySql.getSelectPart());
buffer.append(" from " + querySql.getFromPart());
if (querySql.getWherePart() != null
&& !querySql.getWherePart().equals(""))
{
buffer.append(" where " + querySql.getWherePart());
}
if (querySql.getOrderbyPart() != null
&& !querySql.getOrderbyPart().equals(""))
{
buffer.append(" order by " + querySql.getOrderbyPart());
}
} catch (Exception e)
{// 抛出sql语法错误
throw new SystemException("SC000140", e);
}
String sql = buffer.toString();
logger.info(" sql is :" + sql);
System.out.println(" sql is " + sql);
return sql;
}
===================================================
但 不知具体实现。
buffer.append(" where " + querySql.getWherePart());
}
c#?
看样子应该是生成where条件
应该民是个自定义的类吧