MyBatis中的sql语句
模糊查询: LIKE CONCAT('%',#{参数},'%')<select id="getTeacherCount" resultType="int" parameterType="teacher">SELECT COUNT(1) from teacher_info where 1=1 <if test="name!=null">AND tname LIKE CO
复制链接