Mybatis的动态SQL的语句

例子、

select * from t_teacher where id=#{id}

select * from t_teacher id > #{id} and <!-- 空串 "" and； && or: ||； if()：传入非常强大的判断条件； OGNL表达式；对象导航图 Person ===lastName ===email ===Address ===city ===province ===Street ===adminName ===info ===perCount 方法、静态方法、构造器。xxx 在mybatis中，传入的参数可以用来做判断； 额外还有两个东西； _parameter：代表传入来的参数； 1）、传入了单个参数：_parameter就代表这个参数 2）、传入了多个参数：_parameter就代表多个参数集合起来的map _databaseId：代表当前环境 如果配置了databaseIdProvider：_databaseId就有值 --> teacherName like #{name} and birth_date < #{birth} and

SELECT * FROM t_teacher WHERE id IN #{id_item}

select * from t_teacher id=#{id} teacherName=#{name} birth_date = #{birth} 1=1 实例、
select * from t_teacher
where id=#{id}

select * from t_teacher where 1=1 and name=#{name} and course=#{course}

select * from t_teacher name=#{name} and course=#{course}

select * from t_teacher name=#{name} and course=#{course} and

update t_teacher


name=#{name},


course=#{course},


address=#{address},


birth=#{birth}



id=#{id}

select * from t_teacher where id in #{id}

select * from t_teacher name=#{name} course=#{course} address=#{address} 1=1