<?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="com.kuang.springbootmybatis.mapper.UserMapper"><select id="getUsers" resultType="User">
select * from user
</select><select id="getUserById" resultType="User">
select * from user where id = #{id}</select><insert id="addUser" parameterType="User">
insert into user (id,username) values (#{id},#{username})</insert><update id="updateUser" parameterType="User">
update user set username=#{username} where id=#{id}</update><delete id="deleteUser" parameterType="int">
delete from user where id = #{id}</delete></mapper>