【笔记】mybatis改进，crud个人低级笔记

insert：

老项目：

	<!-- 插入 -->
    <insert id="saveVC" parameterType="pd">
		insert into USER_COLLEGE(
		COLLEGE_ID,
		USER_ID
		)
		values (
		#{COLLEGE_ID},
		#{USER_ID}
		)
	</insert>

2022：

    <insert id="saveVC" parameterType="java.util.HashMap">
        insert into USER_COLLEGE
        <trim prefix="(" suffix=")" suffixOverrides=",">
            <if test="COLLEGE_ID != null  and COLLEGE_ID != ''">COLLEGE_ID,</if>
            <if test="USER_ID != null  and USER_ID != ''">USER_ID,</if>
        </trim>
        <trim prefix="values (" suffix=")" suffixOverrides=",">
            <if test="COLLEGE_ID != null  and COLLEGE_ID != ''">#{COLLEGE_ID},</if>
            <if test="USER_ID != null  and USER_ID != ''">#{USER_ID},</if>
        </trim>
    </insert>

select：

老项目：

	<!-- 查询 -->
    <select id="findVC" parameterType="pd" resultType="pd">
		select
		COLLEGE_ID,
		USER_ID
		from
		USER_COLLEGE where
		COLLEGE_ID = #{COLLEGE_ID} and USER_ID = #{USER_ID}
	</select>

2022：

    <select id="findVC" parameterType="java.util.HashMap" resultType="java.util.HashMap">
            select
                COLLEGE_ID,
                USER_ID
            from
                USER_COLLEGE
        <where>
        <if test="COLLEGE_ID != null  and COLLEGE_ID != ''">  COLLEGE_ID = #{COLLEGE_ID}</if>
        <if test="USER_ID != null  and USER_ID != ''"> and USER_ID = #{USER_ID}</if>
        </where>
    </select>

update：

老项目：

	<!-- 修改 -->
	<update id="edit" parameterType="pd">
		update  "USERS"
			set 	
				"NAME" = #{NAME},	
				"SEX" = #{SEX},	
				"TEL_NUM" = #{TEL_NUM},	
				<!-- "ALLOTTEAM" = #{ALLOTTEAM}, -->
				"EMAIL"=#{EMAIL},
				"MEMO" = #{MEMO},
				<!-- "IS_LEADER"=9, -->
				"ID"="ID"
			where 
				"ID" = #{ID}
	</update>

2022：

    //TODO

delete：

老项目：

    <!-- 删除 -->
	<delete id="deleteVC" parameterType="pd">
		delete from USER_COLLEGE
		where
		COLLEGE_ID = #{COLLEGE_ID} and USER_ID = #{USER_ID}
	</delete>

2022：

    <delete id="deleteVC" parameterType="java.util.HashMap">
        delete from USER_COLLEGE
        <where>
            <if test="COLLEGE_ID != null  and COLLEGE_ID != ''"> COLLEGE_ID = #{COLLEGE_ID}</if>
            <if test="USER_ID != null  and USER_ID != ''"> and USER_ID = #{USER_ID}</if>
        </where>
    </delete>