java yml mapper

yml

server:
  port: 8081

spring:
  datasource:
    username: root
    password: 123456
    url: jdbc:mysql://localhost:3306/caiji?useUnicode=true&characterEncoding=utf-8
    driver-class-name: com.mysql.cj.jdbc.Driver
    #springBoot数据库驱动默认为mysql8.0版本，使用8.0以下版本的数据库需要在pom.xml手动更改数据库驱动版本

    #切换为阿里巴巴druid源

    # 自定义数据源





#yml整合mybatis
mybatis:
  type-aliases-package : com.example.demo3
  mapperLocations: classpath:mapper/*.xml

<?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.example.demo3.dao.UserMapper">

    <select id="getInfo" resultType="com.example.demo3.bean.User">
        SELECT * FROM user
        WHERE
     name = #{name} AND password = #{password}
    </select>
    <!--    根据ID查询用户信息-->
    <select id="selectUserById"  parameterType="String" resultType="com.example.demo3.bean.User">
        select * from user where id=#{id};
    </select>
    <!--    插入新用户 id自增-->
    <insert id="insertUser" parameterType="com.example.demo3.bean.User" useGeneratedKeys="true" keyProperty="id">
        insert into user(name, password) VALUES (#{name},#{password});
    </insert>
    <delete id="deleteUser" parameterType="String">
        delete  from user where id=#{id};
    </delete>
    <!--根据ID修改用户信息，返回数据库操作影响行数，为0则是失败-->
    <update id="updateUser" parameterType="com.example.demo3.bean.User">
        update user set name=#{name} ,password=#{password} where id=#{id};
    </update>
    <select id="getAllUser" resultType="com.example.demo3.bean.User">
        select * from user;
    </select>

</mapper>

<?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.example.demo8.mapper.UserMapper">

    <select id="chauser" resultType="com.example.demo8.bean.UserBean">
        SELECT * FROM user
        WHERE
     name = #{name} AND password = #{password}
    </select>

    <insert id="jiauser" parameterType="com.example.demo8.bean.UserBean">
        insert into user(name, password) VALUES (#{name},#{password});
    </insert>
    <delete id="shanchu" parameterType="com.example.demo8.bean.UserBean">
                delete  from user where id=#{id};
    </delete>
    <update id="gengxin" parameterType="com.example.demo8.bean.UserBean">
        update user set name=#{name} ,password=#{password} where id=#{id};
    </update>


</mapper>

查询resultType用bean
增加删除修改parameterType 都可以直接用bean