mybatis 注解形式的动态sql妙用

根据字段名和编码进行查询

@Select({"<script> " +
			"select * from user " +
			"where" +
			"<if test=\"type == 'school'\"> school = #{code}</if>" +
			"<if test=\"type == 'major'\"> major = #{code}</if>" +
			"<if test=\"type == 'identity'\"> identity = #{code}</if>" +
			"<if test=\"type == 'gender'\"> gender = #{code}</if>" +
			"<if test=\"type == 'status'\"> status = #{code}</if>" +
			"</script>"}
		   )
	Page<User> getUsersByParam(@Param("code") int code,@Param("type") String type);

展示结果

：下面的接口在数据库执行的语句是：select * from user where major=-10000000