ibatisnet+access sql 语句中有空格
这是log4net 中看到他的实际执行的sql 语句,
select P_ID,P_Name,P_Tel,P_Memo from Persons where P_Name like '* ? *'
其实应该执行select P_ID,P_Name,P_Tel,P_Memo from Persons where P_Name like '*?*'
这是关系 statement
<select id="GetPersonByLikeName" resultMap="PersonResult" parameterClass="System.String" >
select P_ID,P_Name,P_Tel,P_Memo from Persons where P_Name like '*#value#*';
</select>