sybase数据库,mybatis动态sql查不出数据

Question

以下是相关的sql语句

select top 10 * from query where 1=1

and NAME = #{name}


and PID = #{pid}


and ISCHECK = #{ischeck}


and ISLOCAL = #{islocal}


and SMS_TYPE = #{sms_type}


and PHONE_NUM = #{phone_num}


and GJJ_NUM = #{gjj_num}

Answer 1

se数据库,mybatis动态sql查不出数据
以下是相关的sql语句

select top 10 * from query where 1=1

and NAME = #{name}

and PID = #{pid}

and ISCHECK = #{ischeck}

and ISLOCAL = #{islocal}

and SMS_TYPE = #{sms_type}

and PHONE_NUM = #{phone_num}

and GJJ_NUM = #{gjj_num}