笔记:
嵌套:别名、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