庚子鼠年 戊寅月 戊戌日
描述
springboot练习
随笔
整合Druid
JDBCTemplate的使用 https://blog.csdn.net/qq_23329167/article/details/81841996
参考博客:https://www.cnblogs.com/SimpleWu/p/10049825.html
整合mybatis
https://blog.csdn.net/qq_40674583/article/details/104499926
<?xml version="1.0" encoding="UTF-8" ?>
<!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" "http://mybatis.org/dtd/mybatis-3-mapper.dtd" >
<mapper namespace="chang.mapper.UserMapper">
<insert id="addUser" parameterType="user">
insert into user(xh,username,sex,banji,xb) values (#{xh},#{username},#{sex},#{banji},#{xb});
</insert>
<delete id="deleteUser">
delete from user where xh = #{xh}
</delete>
<update id="updataUser" parameterType="map">
<if test="#{xh} != null">
update user
<set>
<if test="#{username} != null">username = #{username},</if>
<if test="#{sex} != null">sex = #{sex},</if>
<if test="#{banji} != null">username = #{banji},</if>
<if test="#{xb} != null">xb = #{xb},</if>
</set>
where xh = #{xh}
</if>
</update>
<select id="findOneByXh" resultType="user">
select * from user where xh = #{xh}
</select>
</mapper>