【MyBatis】查询的例子——之前的笔记

笔记：
嵌套：别名、where嵌套

<select id="queryDictionaryNameByPid" resultType="com.dmsdbj.itoo.singleTableMaintain.entity.ext.AccountingSubjectModel">
                SELECT
                    dt.dictionary_type_name as label,
                    dt.id as id        
                   FROM
                    t_dictionary_type AS dt
                WHERE
                    dt.pid = (
                        SELECT
                            dt.id
                        FROM
                            t_dictionary_type AS dt
                        WHERE
                            dt.dictionary_type_name =#{name}
                    )
         </select>

模糊查询

<select  id="fuzzyIdByDictionaryName"  parameterType="String" resultType="com.dmsdbj.itoo.singleTableMaintain.entity.DictionaryEntity">
                SELECT  d.id 
                FROM  t_dictionary d
                WHERE  d.dictionary_name  LIKE  CONCAT('%',#{strCondition},'%')  and  d.is_delete = 0
        </select>

参数是SQL语句
    <select id="queryCourseBysqlData" resultMap="TCCModel">
            SELECT
            tc.course_id
            FROM
            t_course c
            LEFT JOIN t_training_programs tp ON c.id = tp.course_id
            LEFT JOIN t_teacher_course tc ON tc.course_id = c.id
            WHERE
            ${ value }
            AND c.is_delete = 0  AND tp.is_delete = 0 AND tp.is_use =1 AND tc.is_delete = 0
        </select>

mybatis：
使用简单的 XML或注解用于配置和原始映射，将接口和 Java 的POJOs（Plain Ordinary Java Objects，普通的 Java对象）映射成数据库中的记录， 支持普通 SQL查询，存储过程和高级映射的优秀持久层框架，他消除了几乎所有的JDBC代码和参数的手工设置以及结果集的检索。https://baike.baidu.com/item/MyBatis/2824918?fr=aladdin