mapper.xml文件参数化

单个参数的传递

#{参数}

数据库信息

mysql> select * from fz03;
+------+--------+------+------+
| id   | name   | age  | x    |
+------+--------+------+------+
|    1 | 小明   |   15 | 男   |
|    2 | 小黄   |   16 | 女   |
+------+--------+------+------+
2 rows in set (0.00 sec)

mysql>

mybatis.xml文件

<?xml version="1.0" encoding="UTF-8" ?>
<!DOCTYPE configuration
        PUBLIC "-//mybatis.org//DTD Config 3.0//EN"
        "https://mybatis.org/dtd/mybatis-3-config.dtd">
<configuration>
    <typeAliases>
                    <!-- 设置别名-->
        <package name="org.example.pojo"/>
    </typeAliases>
    <environments default="development">
        <environment id="development">
            <transactionManager type="JDBC"/>
            <dataSource type="POOLED">
                <property name="driver" value="com.mysql.cj.jdbc.Driver"/>
                <property name="url" value="jdbc:mysql://127.0.0.1:3306/fzhl_?serverTimezone=UTC"/>
                <property name="username" value="root"/>
                <property name="password" value="root"/>
            </dataSource>
        </environment>
    </environments>
    <mappers>
        <mapper resource="org/example/mapper/Usermapper.xml"/>
    </mappers>
</configuration>

mapper接口

public interface Usermapper {
    // 传入一个参数a
    User selectlist(String a);
}

mapper.xml文件

<mapper namespace="org.example.mapper.Usermapper">
        <!-- 返回类型 以在mybits.xml写入type别名标签-->
    <selec