/**

db实例的类.封装了数据的常用函数
参考: http://help.kdayun.com/api/java/com/kdayun/api/service/ApiDBContext.html

db的select 函数来实现按条件执行语句
**/

val=1
return db.select("""
    SELECT * FROM CORE_USER
    WHERE  1=1
     <if test="val == 2">
        AND OBJNAME LIKE concat('%',#{OBJNAME},'%')
    </if>
    <if test="val == 1">
        AND OBJCODE = #{OBJCODE} 
        
    </if> 
    """
    ,getBinding().getVariables())