{"id":3157,"date":"2023-01-04T17:02:38","date_gmt":"2023-01-04T09:02:38","guid":{"rendered":"https:\/\/qaqaq.top\/?p=3157"},"modified":"2023-01-05T18:10:27","modified_gmt":"2023-01-05T10:10:27","slug":"mybatis%e7%9a%84%e9%80%86%e5%90%91%e5%b7%a5%e7%a8%8b%e4%bb%a3%e7%a0%81","status":"publish","type":"post","link":"https:\/\/qaqaq.top\/?p=3157","title":{"rendered":"MyBatis\u7684\u9006\u5411\u5de5\u7a0b\u4ee3\u7801"},"content":{"rendered":"\n

pom.xml<\/h3>\n\n\n\n
<project xmlns=\"http:\/\/maven.apache.org\/POM\/4.0.0\" xmlns:xsi=\"http:\/\/www.w3.org\/2001\/XMLSchema-instance\"\n  xsi:schemaLocation=\"http:\/\/maven.apache.org\/POM\/4.0.0 http:\/\/maven.apache.org\/xsd\/maven-4.0.0.xsd\">\n  <modelVersion>4.0.0<\/modelVersion>\n\n  <groupId>top.qaqaq.mybatis<\/groupId>\n  <artifactId>MyBatis_MBG<\/artifactId>\n  <version>1.0-SNAPSHOT<\/version>\n  <packaging>jar<\/packaging>\n\n  <name>MyBatis_MBG<\/name>\n  <url>http:\/\/maven.apache.org<\/url>\n\n  <properties>\n    <project.build.sourceEncoding>UTF-8<\/project.build.sourceEncoding>\n  <\/properties>\n\n  <dependencies>\n    <dependency>\n      <groupId>junit<\/groupId>\n      <artifactId>junit<\/artifactId>\n      <version>3.8.1<\/version>\n      <scope>test<\/scope>\n    <\/dependency>\n\n    <!-- \u4f9d\u8d56MyBatis\u6838\u5fc3\u5305 -->\n    <dependency>\n      <groupId>org.mybatis<\/groupId>\n      <artifactId>mybatis<\/artifactId>\n      <version>3.5.7<\/version>\n    <\/dependency><\/strong>\n\n    <!-- junit\u6d4b\u8bd5 -->\n    <dependency>\n      <groupId>junit<\/groupId>\n      <artifactId>junit<\/artifactId>\n      <version>4.12<\/version>\n      <scope>test<\/scope>\n    <\/dependency>\n    <!-- MySQL\u9a71\u52a8 -->\n    <dependency>\n      <groupId>mysql<\/groupId>\n      <artifactId>mysql-connector-java<\/artifactId>\n      <version>8.0.31<\/version>\n    <\/dependency>\n    <!-- log4j\u65e5\u5fd7 -->\n    <dependency>\n      <groupId>log4j<\/groupId>\n      <artifactId>log4j<\/artifactId>\n      <version>1.2.17<\/version>\n    <\/dependency>\n\n  <\/dependencies>\n\n  <!-- \u63a7\u5236Maven\u5728\u6784\u5efa\u8fc7\u7a0b\u4e2d\u76f8\u5173\u914d\u7f6e -->\n  <build>\n    <!-- \u6784\u5efa\u8fc7\u7a0b\u4e2d\u7528\u5230\u7684\u63d2\u4ef6 -->\n    <plugins>\n      <!-- \u5177\u4f53\u63d2\u4ef6\uff0c\u9006\u5411\u5de5\u7a0b\u7684\u64cd\u4f5c\u662f\u4ee5\u6784\u5efa\u8fc7\u7a0b\u4e2d\u63d2\u4ef6\u5f62\u5f0f\u51fa\u73b0\u7684 -->\n      <plugin>\n        <groupId>org.mybatis.generator<\/groupId>\n        <artifactId>mybatis-generator-maven-plugin<\/artifactId>\n        <version>1.3.0<\/version>\n        <!-- \u63d2\u4ef6\u7684\u4f9d\u8d56 -->\n        <dependencies>\n          <!-- \u9006\u5411\u5de5\u7a0b\u7684\u6838\u5fc3\u4f9d\u8d56 -->\n          <dependency>\n            <groupId>org.mybatis.generator<\/groupId>\n            <artifactId>mybatis-generator-core<\/artifactId>\n            <version>1.3.2<\/version>\n          <\/dependency>\n          <!-- \u6570\u636e\u5e93\u8fde\u63a5\u6c60 -->\n          <dependency>\n            <groupId>com.mchange<\/groupId>\n            <artifactId>c3p0<\/artifactId>\n            <version>0.9.2<\/version>\n          <\/dependency>\n          <!-- MySQL\u9a71\u52a8 -->\n          <dependency>\n            <groupId>mysql<\/groupId>\n            <artifactId>mysql-connector-java<\/artifactId>\n            <version>8.0.31<\/version>\n          <\/dependency>\n        <\/dependencies>\n      <\/plugin>\n    <\/plugins>\n  <\/build><\/strong>\n\n<\/project>\n<\/code><\/pre>\n\n\n\n
resources<\/p>\n\n\n\n
mybatis-config.xml<\/p>\n\n\n\n
<?xml version=\"1.0\" encoding=\"UTF-8\" ?>\n<!DOCTYPE configuration\n        PUBLIC \"-\/\/mybatis.org\/\/DTD Config 3.0\/\/EN\"\n        \"http:\/\/mybatis.org\/dtd\/mybatis-3-config.dtd\">\n<configuration>\n\n    <properties resource=\"jdbc.properties\"\/>\n\n    <typeAliases>\n        <package name=\"top.qaqaq.mybatis.pojo\"\/>\n    <\/typeAliases>\n\n    <environments default=\"development\">\n        <environment id=\"development\">\n            <transactionManager type=\"JDBC\"\/>\n            <dataSource type=\"POOLED\">\n                <property name=\"driver\" value=\"${jdbc.driver}\"\/>\n                <property name=\"url\" value=\"${jdbc.url}\"\/>\n                <property name=\"username\" value=\"${jdbc.username}\"\/>\n                <property name=\"password\" value=\"${jdbc.password}\"\/>\n            <\/dataSource>\n        <\/environment>\n    <\/environments>\n\n    <mappers>\n        <package name=\"top.qaqaq.mybatis.mapper\"\/>\n    <\/mappers>\n<\/configuration><\/code><\/pre>\n\n\n\n
jdbc.properties<\/p>\n\n\n\n
jdbc.driver=com.mysql.cj.jdbc.Driver\njdbc.url=jdbc:mysql:\/\/localhost:3306\/mybatis\njdbc.username=root\njdbc.password=123456<\/code><\/pre>\n\n\n\n
log4j.xml<\/p>\n\n\n\n
<?xml version=\"1.0\" encoding=\"UTF-8\" ?>\n<!DOCTYPE log4j:configuration SYSTEM \"log4j.dtd\">\n<log4j:configuration xmlns:log4j=\"http:\/\/jakarta.apache.org\/log4j\/\">\n    <appender name=\"STDOUT\" class=\"org.apache.log4j.ConsoleAppender\">\n        <param name=\"Encoding\" value=\"UTF-8\" \/>\n        <layout class=\"org.apache.log4j.PatternLayout\">\n            <param name=\"ConversionPattern\" value=\"%-5p %d{MM-dd HH:mm:ss,SSS}%m (%F:%L) \\n\" \/>\n        <\/layout>\n    <\/appender>\n    <logger name=\"java.sql\">\n        <level value=\"debug\" \/>\n    <\/logger>\n    <logger name=\"org.apache.ibatis\">\n        <level value=\"info\" \/>\n    <\/logger>\n    <root>\n        <level value=\"debug\" \/>\n        <appender-ref ref=\"STDOUT\" \/>\n    <\/root>\n<\/log4j:configuration><\/code><\/pre>\n\n\n\n
generatorConfig.xml<\/h3>\n\n\n\n
<?xml version=\"1.0\" encoding=\"UTF-8\"?>\n<!DOCTYPE generatorConfiguration\n        PUBLIC \"-\/\/mybatis.org\/\/DTD MyBatis Generator Configuration 1.0\/\/EN\"\n        \"http:\/\/mybatis.org\/dtd\/mybatis-generator-config_1_0.dtd\">\n<generatorConfiguration>\n    <!--\n            targetRuntime: \u6267\u884c\u751f\u6210\u7684\u9006\u5411\u5de5\u7a0b\u7684\u7248\u672c\n                    MyBatis3Simple: \u751f\u6210\u57fa\u672c\u7684CRUD\uff08\u6e05\u65b0\u7b80\u6d01\u7248\uff09\n                    MyBatis3: \u751f\u6210\u5e26\u6761\u4ef6\u7684CRUD\uff08\u5962\u534e\u5c0a\u4eab\u7248\uff09\n    -->\n    <context id=\"DB2Tables\" targetRuntime=\"MyBatis3\">\n        <!-- \u6570\u636e\u5e93\u7684\u8fde\u63a5\u4fe1\u606f -->\n        <jdbcConnection driverClass=\"com.mysql.cj.jdbc.Driver\"\n                        connectionURL=\"jdbc:mysql:\/\/localhost:3306\/mybatis\"\n                        userId=\"root\"\n                        password=\"123456\">\n        <\/jdbcConnection>\n        <!-- javaBean\u7684\u751f\u6210\u7b56\u7565-->\n        <javaModelGenerator targetPackage=\"top.qaqaq.mybatis.pojo\" targetProject=\".\\src\\main\\java\">\n            <property name=\"enableSubPackages\" value=\"true\"\/>\n            <property name=\"trimStrings\" value=\"true\"\/>\n        <\/javaModelGenerator>\n        <!-- SQL\u6620\u5c04\u6587\u4ef6\u7684\u751f\u6210\u7b56\u7565 -->\n        <sqlMapGenerator targetPackage=\"top.qaqaq.mybatis.mapper\" targetProject=\".\\src\\main\\resources\">\n            <property name=\"enableSubPackages\" value=\"true\"\/>\n        <\/sqlMapGenerator>\n        <!-- Mapper\u63a5\u53e3\u7684\u751f\u6210\u7b56\u7565 -->\n        <javaClientGenerator type=\"XMLMAPPER\" targetPackage=\"top.qaqaq.mybatis.mapper\" targetProject=\".\\src\\main\\java\">\n            <property name=\"enableSubPackages\" value=\"true\"\/>\n        <\/javaClientGenerator>\n        <!-- \u9006\u5411\u5206\u6790\u7684\u8868 -->\n        <!-- tableName\u8bbe\u7f6e\u4e3a*\u53f7\uff0c\u53ef\u4ee5\u5bf9\u5e94\u6240\u6709\u8868\uff0c\u6b64\u65f6\u4e0d\u5199domainObjectName -->\n        <!-- domainObjectName\u5c5e\u6027\u6307\u5b9a\u751f\u6210\u51fa\u6765\u7684\u5b9e\u4f53\u7c7b\u7684\u7c7b\u540d -->\n        <table tableName=\"t_emp\" domainObjectName=\"Emp\"\/>\n        <table tableName=\"t_dept\" domainObjectName=\"Dept\"\/>\n    <\/context>\n<\/generatorConfiguration><\/code><\/pre>\n\n\n\n
resources\/mapper<\/p>\n\n\n\n
EmpMapper .xml\uff08\u81ea\u52a8\u751f\u6210\uff09<\/p>\n\n\n\n
<?xml version=\"1.0\" encoding=\"UTF-8\" ?>\n<!DOCTYPE mapper PUBLIC \"-\/\/mybatis.org\/\/DTD Mapper 3.0\/\/EN\" \"http:\/\/mybatis.org\/dtd\/mybatis-3-mapper.dtd\" >\n<mapper namespace=\"top.qaqaq.mybatis.mapper.EmpMapper\" >\n  <resultMap id=\"BaseResultMap\" type=\"top.qaqaq.mybatis.pojo.Emp\" >\n    <!--\n      WARNING - @mbggenerated\n      This element is automatically generated by MyBatis Generator, do not modify.\n      This element was generated on Wed Jan 04 16:17:13 CST 2023.\n    -->\n    <id column=\"eid\" property=\"eid\" jdbcType=\"INTEGER\" \/>\n    <result column=\"emp_name\" property=\"empName\" jdbcType=\"VARCHAR\" \/>\n    <result column=\"age\" property=\"age\" jdbcType=\"INTEGER\" \/>\n    <result column=\"sex\" property=\"sex\" jdbcType=\"CHAR\" \/>\n    <result column=\"email\" property=\"email\" jdbcType=\"VARCHAR\" \/>\n    <result column=\"did\" property=\"did\" jdbcType=\"INTEGER\" \/>\n  <\/resultMap>\n  <sql id=\"Example_Where_Clause\" >\n    <!--\n      WARNING - @mbggenerated\n      This element is automatically generated by MyBatis Generator, do not modify.\n      This element was generated on Wed Jan 04 16:17:13 CST 2023.\n    -->\n    <where >\n      <foreach collection=\"oredCriteria\" item=\"criteria\" separator=\"or\" >\n        <if test=\"criteria.valid\" >\n          <trim prefix=\"(\" suffix=\")\" prefixOverrides=\"and\" >\n            <foreach collection=\"criteria.criteria\" item=\"criterion\" >\n              <choose >\n                <when test=\"criterion.noValue\" >\n                  and ${criterion.condition}\n                <\/when>\n                <when test=\"criterion.singleValue\" >\n                  and ${criterion.condition} #{criterion.value}\n                <\/when>\n                <when test=\"criterion.betweenValue\" >\n                  and ${criterion.condition} #{criterion.value} and #{criterion.secondValue}\n                <\/when>\n                <when test=\"criterion.listValue\" >\n                  and ${criterion.condition}\n                  <foreach collection=\"criterion.value\" item=\"listItem\" open=\"(\" close=\")\" separator=\",\" >\n                    #{listItem}\n                  <\/foreach>\n                <\/when>\n              <\/choose>\n            <\/foreach>\n          <\/trim>\n        <\/if>\n      <\/foreach>\n    <\/where>\n  <\/sql>\n  <sql id=\"Update_By_Example_Where_Clause\" >\n    <!--\n      WARNING - @mbggenerated\n      This element is automatically generated by MyBatis Generator, do not modify.\n      This element was generated on Wed Jan 04 16:17:13 CST 2023.\n    -->\n    <where >\n      <foreach collection=\"example.oredCriteria\" item=\"criteria\" separator=\"or\" >\n        <if test=\"criteria.valid\" >\n          <trim prefix=\"(\" suffix=\")\" prefixOverrides=\"and\" >\n            <foreach collection=\"criteria.criteria\" item=\"criterion\" >\n              <choose >\n                <when test=\"criterion.noValue\" >\n                  and ${criterion.condition}\n                <\/when>\n                <when test=\"criterion.singleValue\" >\n                  and ${criterion.condition} #{criterion.value}\n                <\/when>\n                <when test=\"criterion.betweenValue\" >\n                  and ${criterion.condition} #{criterion.value} and #{criterion.secondValue}\n                <\/when>\n                <when test=\"criterion.listValue\" >\n                  and ${criterion.condition}\n                  <foreach collection=\"criterion.value\" item=\"listItem\" open=\"(\" close=\")\" separator=\",\" >\n                    #{listItem}\n                  <\/foreach>\n                <\/when>\n              <\/choose>\n            <\/foreach>\n          <\/trim>\n        <\/if>\n      <\/foreach>\n    <\/where>\n  <\/sql>\n  <sql id=\"Base_Column_List\" >\n    <!--\n      WARNING - @mbggenerated\n      This element is automatically generated by MyBatis Generator, do not modify.\n      This element was generated on Wed Jan 04 16:17:13 CST 2023.\n    -->\n    eid, emp_name, age, sex, email, did\n  <\/sql>\n  <select id=\"selectByExample\" resultMap=\"BaseResultMap\" parameterType=\"top.qaqaq.mybatis.pojo.EmpExample\" >\n    <!--\n      WARNING - @mbggenerated\n      This element is automatically generated by MyBatis Generator, do not modify.\n      This element was generated on Wed Jan 04 16:17:13 CST 2023.\n    -->\n    select\n    <if test=\"distinct\" >\n      distinct\n    <\/if>\n    <include refid=\"Base_Column_List\" \/>\n    from t_emp\n    <if test=\"_parameter != null\" >\n      <include refid=\"Example_Where_Clause\" \/>\n    <\/if>\n    <if test=\"orderByClause != null\" >\n      order by ${orderByClause}\n    <\/if>\n  <\/select>\n  <select id=\"selectByPrimaryKey\" resultMap=\"BaseResultMap\" parameterType=\"java.lang.Integer\" >\n    <!--\n      WARNING - @mbggenerated\n      This element is automatically generated by MyBatis Generator, do not modify.\n      This element was generated on Wed Jan 04 16:17:13 CST 2023.\n    -->\n    select \n    <include refid=\"Base_Column_List\" \/>\n    from t_emp\n    where eid = #{eid,jdbcType=INTEGER}\n  <\/select>\n  <delete id=\"deleteByPrimaryKey\" parameterType=\"java.lang.Integer\" >\n    <!--\n      WARNING - @mbggenerated\n      This element is automatically generated by MyBatis Generator, do not modify.\n      This element was generated on Wed Jan 04 16:17:13 CST 2023.\n    -->\n    delete from t_emp\n    where eid = #{eid,jdbcType=INTEGER}\n  <\/delete>\n  <delete id=\"deleteByExample\" parameterType=\"top.qaqaq.mybatis.pojo.EmpExample\" >\n    <!--\n      WARNING - @mbggenerated\n      This element is automatically generated by MyBatis Generator, do not modify.\n      This element was generated on Wed Jan 04 16:17:13 CST 2023.\n    -->\n    delete from t_emp\n    <if test=\"_parameter != null\" >\n      <include refid=\"Example_Where_Clause\" \/>\n    <\/if>\n  <\/delete>\n  <insert id=\"insert\" parameterType=\"top.qaqaq.mybatis.pojo.Emp\" >\n    <!--\n      WARNING - @mbggenerated\n      This element is automatically generated by MyBatis Generator, do not modify.\n      This element was generated on Wed Jan 04 16:17:13 CST 2023.\n    -->\n    insert into t_emp (eid, emp_name, age, \n      sex, email, did)\n    values (#{eid,jdbcType=INTEGER}, #{empName,jdbcType=VARCHAR}, #{age,jdbcType=INTEGER}, \n      #{sex,jdbcType=CHAR}, #{email,jdbcType=VARCHAR}, #{did,jdbcType=INTEGER})\n  <\/insert>\n  <insert id=\"insertSelective\" parameterType=\"top.qaqaq.mybatis.pojo.Emp\" >\n    <!--\n      WARNING - @mbggenerated\n      This element is automatically generated by MyBatis Generator, do not modify.\n      This element was generated on Wed Jan 04 16:17:13 CST 2023.\n    -->\n    insert into t_emp\n    <trim prefix=\"(\" suffix=\")\" suffixOverrides=\",\" >\n      <if test=\"eid != null\" >\n        eid,\n      <\/if>\n      <if test=\"empName != null\" >\n        emp_name,\n      <\/if>\n      <if test=\"age != null\" >\n        age,\n      <\/if>\n      <if test=\"sex != null\" >\n        sex,\n      <\/if>\n      <if test=\"email != null\" >\n        email,\n      <\/if>\n      <if test=\"did != null\" >\n        did,\n      <\/if>\n    <\/trim>\n    <trim prefix=\"values (\" suffix=\")\" suffixOverrides=\",\" >\n      <if test=\"eid != null\" >\n        #{eid,jdbcType=INTEGER},\n      <\/if>\n      <if test=\"empName != null\" >\n        #{empName,jdbcType=VARCHAR},\n      <\/if>\n      <if test=\"age != null\" >\n        #{age,jdbcType=INTEGER},\n      <\/if>\n      <if test=\"sex != null\" >\n        #{sex,jdbcType=CHAR},\n      <\/if>\n      <if test=\"email != null\" >\n        #{email,jdbcType=VARCHAR},\n      <\/if>\n      <if test=\"did != null\" >\n        #{did,jdbcType=INTEGER},\n      <\/if>\n    <\/trim>\n  <\/insert>\n  <select id=\"countByExample\" parameterType=\"top.qaqaq.mybatis.pojo.EmpExample\" resultType=\"java.lang.Integer\" >\n    <!--\n      WARNING - @mbggenerated\n      This element is automatically generated by MyBatis Generator, do not modify.\n      This element was generated on Wed Jan 04 16:17:13 CST 2023.\n    -->\n    select count(*) from t_emp\n    <if test=\"_parameter != null\" >\n      <include refid=\"Example_Where_Clause\" \/>\n    <\/if>\n  <\/select>\n  <update id=\"updateByExampleSelective\" parameterType=\"map\" >\n    <!--\n      WARNING - @mbggenerated\n      This element is automatically generated by MyBatis Generator, do not modify.\n      This element was generated on Wed Jan 04 16:17:13 CST 2023.\n    -->\n    update t_emp\n    <set >\n      <if test=\"record.eid != null\" >\n        eid = #{record.eid,jdbcType=INTEGER},\n      <\/if>\n      <if test=\"record.empName != null\" >\n        emp_name = #{record.empName,jdbcType=VARCHAR},\n      <\/if>\n      <if test=\"record.age != null\" >\n        age = #{record.age,jdbcType=INTEGER},\n      <\/if>\n      <if test=\"record.sex != null\" >\n        sex = #{record.sex,jdbcType=CHAR},\n      <\/if>\n      <if test=\"record.email != null\" >\n        email = #{record.email,jdbcType=VARCHAR},\n      <\/if>\n      <if test=\"record.did != null\" >\n        did = #{record.did,jdbcType=INTEGER},\n      <\/if>\n    <\/set>\n    <if test=\"_parameter != null\" >\n      <include refid=\"Update_By_Example_Where_Clause\" \/>\n    <\/if>\n  <\/update>\n  <update id=\"updateByExample\" parameterType=\"map\" >\n    <!--\n      WARNING - @mbggenerated\n      This element is automatically generated by MyBatis Generator, do not modify.\n      This element was generated on Wed Jan 04 16:17:13 CST 2023.\n    -->\n    update t_emp\n    set eid = #{record.eid,jdbcType=INTEGER},\n      emp_name = #{record.empName,jdbcType=VARCHAR},\n      age = #{record.age,jdbcType=INTEGER},\n      sex = #{record.sex,jdbcType=CHAR},\n      email = #{record.email,jdbcType=VARCHAR},\n      did = #{record.did,jdbcType=INTEGER}\n    <if test=\"_parameter != null\" >\n      <include refid=\"Update_By_Example_Where_Clause\" \/>\n    <\/if>\n  <\/update>\n  <update id=\"updateByPrimaryKeySelective\" parameterType=\"top.qaqaq.mybatis.pojo.Emp\" >\n    <!--\n      WARNING - @mbggenerated\n      This element is automatically generated by MyBatis Generator, do not modify.\n      This element was generated on Wed Jan 04 16:17:13 CST 2023.\n    -->\n    update t_emp\n    <set >\n      <if test=\"empName != null\" >\n        emp_name = #{empName,jdbcType=VARCHAR},\n      <\/if>\n      <if test=\"age != null\" >\n        age = #{age,jdbcType=INTEGER},\n      <\/if>\n      <if test=\"sex != null\" >\n        sex = #{sex,jdbcType=CHAR},\n      <\/if>\n      <if test=\"email != null\" >\n        email = #{email,jdbcType=VARCHAR},\n      <\/if>\n      <if test=\"did != null\" >\n        did = #{did,jdbcType=INTEGER},\n      <\/if>\n    <\/set>\n    where eid = #{eid,jdbcType=INTEGER}\n  <\/update>\n  <update id=\"updateByPrimaryKey\" parameterType=\"top.qaqaq.mybatis.pojo.Emp\" >\n    <!--\n      WARNING - @mbggenerated\n      This element is automatically generated by MyBatis Generator, do not modify.\n      This element was generated on Wed Jan 04 16:17:13 CST 2023.\n    -->\n    update t_emp\n    set emp_name = #{empName,jdbcType=VARCHAR},\n      age = #{age,jdbcType=INTEGER},\n      sex = #{sex,jdbcType=CHAR},\n      email = #{email,jdbcType=VARCHAR},\n      did = #{did,jdbcType=INTEGER}\n    where eid = #{eid,jdbcType=INTEGER}\n  <\/update>\n<\/mapper><\/code><\/pre>\n\n\n\n
DeptMapper.xml\uff08\u81ea\u52a8\u751f\u6210\uff09<\/p>\n\n\n\n
<?xml version=\"1.0\" encoding=\"UTF-8\" ?>\n<!DOCTYPE mapper PUBLIC \"-\/\/mybatis.org\/\/DTD Mapper 3.0\/\/EN\" \"http:\/\/mybatis.org\/dtd\/mybatis-3-mapper.dtd\" >\n<mapper namespace=\"top.qaqaq.mybatis.mapper.DeptMapper\" >\n  <resultMap id=\"BaseResultMap\" type=\"top.qaqaq.mybatis.pojo.Dept\" >\n    <!--\n      WARNING - @mbggenerated\n      This element is automatically generated by MyBatis Generator, do not modify.\n      This element was generated on Wed Jan 04 16:17:13 CST 2023.\n    -->\n    <id column=\"did\" property=\"did\" jdbcType=\"INTEGER\" \/>\n    <result column=\"dept_name\" property=\"deptName\" jdbcType=\"VARCHAR\" \/>\n  <\/resultMap>\n  <sql id=\"Example_Where_Clause\" >\n    <!--\n      WARNING - @mbggenerated\n      This element is automatically generated by MyBatis Generator, do not modify.\n      This element was generated on Wed Jan 04 16:17:13 CST 2023.\n    -->\n    <where >\n      <foreach collection=\"oredCriteria\" item=\"criteria\" separator=\"or\" >\n        <if test=\"criteria.valid\" >\n          <trim prefix=\"(\" suffix=\")\" prefixOverrides=\"and\" >\n            <foreach collection=\"criteria.criteria\" item=\"criterion\" >\n              <choose >\n                <when test=\"criterion.noValue\" >\n                  and ${criterion.condition}\n                <\/when>\n                <when test=\"criterion.singleValue\" >\n                  and ${criterion.condition} #{criterion.value}\n                <\/when>\n                <when test=\"criterion.betweenValue\" >\n                  and ${criterion.condition} #{criterion.value} and #{criterion.secondValue}\n                <\/when>\n                <when test=\"criterion.listValue\" >\n                  and ${criterion.condition}\n                  <foreach collection=\"criterion.value\" item=\"listItem\" open=\"(\" close=\")\" separator=\",\" >\n                    #{listItem}\n                  <\/foreach>\n                <\/when>\n              <\/choose>\n            <\/foreach>\n          <\/trim>\n        <\/if>\n      <\/foreach>\n    <\/where>\n  <\/sql>\n  <sql id=\"Update_By_Example_Where_Clause\" >\n    <!--\n      WARNING - @mbggenerated\n      This element is automatically generated by MyBatis Generator, do not modify.\n      This element was generated on Wed Jan 04 16:17:13 CST 2023.\n    -->\n    <where >\n      <foreach collection=\"example.oredCriteria\" item=\"criteria\" separator=\"or\" >\n        <if test=\"criteria.valid\" >\n          <trim prefix=\"(\" suffix=\")\" prefixOverrides=\"and\" >\n            <foreach collection=\"criteria.criteria\" item=\"criterion\" >\n              <choose >\n                <when test=\"criterion.noValue\" >\n                  and ${criterion.condition}\n                <\/when>\n                <when test=\"criterion.singleValue\" >\n                  and ${criterion.condition} #{criterion.value}\n                <\/when>\n                <when test=\"criterion.betweenValue\" >\n                  and ${criterion.condition} #{criterion.value} and #{criterion.secondValue}\n                <\/when>\n                <when test=\"criterion.listValue\" >\n                  and ${criterion.condition}\n                  <foreach collection=\"criterion.value\" item=\"listItem\" open=\"(\" close=\")\" separator=\",\" >\n                    #{listItem}\n                  <\/foreach>\n                <\/when>\n              <\/choose>\n            <\/foreach>\n          <\/trim>\n        <\/if>\n      <\/foreach>\n    <\/where>\n  <\/sql>\n  <sql id=\"Base_Column_List\" >\n    <!--\n      WARNING - @mbggenerated\n      This element is automatically generated by MyBatis Generator, do not modify.\n      This element was generated on Wed Jan 04 16:17:13 CST 2023.\n    -->\n    did, dept_name\n  <\/sql>\n  <select id=\"selectByExample\" resultMap=\"BaseResultMap\" parameterType=\"top.qaqaq.mybatis.pojo.DeptExample\" >\n    <!--\n      WARNING - @mbggenerated\n      This element is automatically generated by MyBatis Generator, do not modify.\n      This element was generated on Wed Jan 04 16:17:13 CST 2023.\n    -->\n    select\n    <if test=\"distinct\" >\n      distinct\n    <\/if>\n    <include refid=\"Base_Column_List\" \/>\n    from t_dept\n    <if test=\"_parameter != null\" >\n      <include refid=\"Example_Where_Clause\" \/>\n    <\/if>\n    <if test=\"orderByClause != null\" >\n      order by ${orderByClause}\n    <\/if>\n  <\/select>\n  <select id=\"selectByPrimaryKey\" resultMap=\"BaseResultMap\" parameterType=\"java.lang.Integer\" >\n    <!--\n      WARNING - @mbggenerated\n      This element is automatically generated by MyBatis Generator, do not modify.\n      This element was generated on Wed Jan 04 16:17:13 CST 2023.\n    -->\n    select \n    <include refid=\"Base_Column_List\" \/>\n    from t_dept\n    where did = #{did,jdbcType=INTEGER}\n  <\/select>\n  <delete id=\"deleteByPrimaryKey\" parameterType=\"java.lang.Integer\" >\n    <!--\n      WARNING - @mbggenerated\n      This element is automatically generated by MyBatis Generator, do not modify.\n      This element was generated on Wed Jan 04 16:17:13 CST 2023.\n    -->\n    delete from t_dept\n    where did = #{did,jdbcType=INTEGER}\n  <\/delete>\n  <delete id=\"deleteByExample\" parameterType=\"top.qaqaq.mybatis.pojo.DeptExample\" >\n    <!--\n      WARNING - @mbggenerated\n      This element is automatically generated by MyBatis Generator, do not modify.\n      This element was generated on Wed Jan 04 16:17:13 CST 2023.\n    -->\n    delete from t_dept\n    <if test=\"_parameter != null\" >\n      <include refid=\"Example_Where_Clause\" \/>\n    <\/if>\n  <\/delete>\n  <insert id=\"insert\" parameterType=\"top.qaqaq.mybatis.pojo.Dept\" >\n    <!--\n      WARNING - @mbggenerated\n      This element is automatically generated by MyBatis Generator, do not modify.\n      This element was generated on Wed Jan 04 16:17:13 CST 2023.\n    -->\n    insert into t_dept (did, dept_name)\n    values (#{did,jdbcType=INTEGER}, #{deptName,jdbcType=VARCHAR})\n  <\/insert>\n  <insert id=\"insertSelective\" parameterType=\"top.qaqaq.mybatis.pojo.Dept\" >\n    <!--\n      WARNING - @mbggenerated\n      This element is automatically generated by MyBatis Generator, do not modify.\n      This element was generated on Wed Jan 04 16:17:13 CST 2023.\n    -->\n    insert into t_dept\n    <trim prefix=\"(\" suffix=\")\" suffixOverrides=\",\" >\n      <if test=\"did != null\" >\n        did,\n      <\/if>\n      <if test=\"deptName != null\" >\n        dept_name,\n      <\/if>\n    <\/trim>\n    <trim prefix=\"values (\" suffix=\")\" suffixOverrides=\",\" >\n      <if test=\"did != null\" >\n        #{did,jdbcType=INTEGER},\n      <\/if>\n      <if test=\"deptName != null\" >\n        #{deptName,jdbcType=VARCHAR},\n      <\/if>\n    <\/trim>\n  <\/insert>\n  <select id=\"countByExample\" parameterType=\"top.qaqaq.mybatis.pojo.DeptExample\" resultType=\"java.lang.Integer\" >\n    <!--\n      WARNING - @mbggenerated\n      This element is automatically generated by MyBatis Generator, do not modify.\n      This element was generated on Wed Jan 04 16:17:13 CST 2023.\n    -->\n    select count(*) from t_dept\n    <if test=\"_parameter != null\" >\n      <include refid=\"Example_Where_Clause\" \/>\n    <\/if>\n  <\/select>\n  <update id=\"updateByExampleSelective\" parameterType=\"map\" >\n    <!--\n      WARNING - @mbggenerated\n      This element is automatically generated by MyBatis Generator, do not modify.\n      This element was generated on Wed Jan 04 16:17:13 CST 2023.\n    -->\n    update t_dept\n    <set >\n      <if test=\"record.did != null\" >\n        did = #{record.did,jdbcType=INTEGER},\n      <\/if>\n      <if test=\"record.deptName != null\" >\n        dept_name = #{record.deptName,jdbcType=VARCHAR},\n      <\/if>\n    <\/set>\n    <if test=\"_parameter != null\" >\n      <include refid=\"Update_By_Example_Where_Clause\" \/>\n    <\/if>\n  <\/update>\n  <update id=\"updateByExample\" parameterType=\"map\" >\n    <!--\n      WARNING - @mbggenerated\n      This element is automatically generated by MyBatis Generator, do not modify.\n      This element was generated on Wed Jan 04 16:17:13 CST 2023.\n    -->\n    update t_dept\n    set did = #{record.did,jdbcType=INTEGER},\n      dept_name = #{record.deptName,jdbcType=VARCHAR}\n    <if test=\"_parameter != null\" >\n      <include refid=\"Update_By_Example_Where_Clause\" \/>\n    <\/if>\n  <\/update>\n  <update id=\"updateByPrimaryKeySelective\" parameterType=\"top.qaqaq.mybatis.pojo.Dept\" >\n    <!--\n      WARNING - @mbggenerated\n      This element is automatically generated by MyBatis Generator, do not modify.\n      This element was generated on Wed Jan 04 16:17:13 CST 2023.\n    -->\n    update t_dept\n    <set >\n      <if test=\"deptName != null\" >\n        dept_name = #{deptName,jdbcType=VARCHAR},\n      <\/if>\n    <\/set>\n    where did = #{did,jdbcType=INTEGER}\n  <\/update>\n  <update id=\"updateByPrimaryKey\" parameterType=\"top.qaqaq.mybatis.pojo.Dept\" >\n    <!--\n      WARNING - @mbggenerated\n      This element is automatically generated by MyBatis Generator, do not modify.\n      This element was generated on Wed Jan 04 16:17:13 CST 2023.\n    -->\n    update t_dept\n    set dept_name = #{deptName,jdbcType=VARCHAR}\n    where did = #{did,jdbcType=INTEGER}\n  <\/update>\n<\/mapper><\/code><\/pre>\n\n\n\n
mapper<\/p>\n\n\n\n
EmpMapper .java\uff08\u81ea\u52a8\u751f\u6210\uff09<\/p>\n\n\n\n
package top.qaqaq.mybatis.mapper;\n\nimport java.util.List;\nimport org.apache.ibatis.annotations.Param;\nimport top.qaqaq.mybatis.pojo.Emp;\nimport top.qaqaq.mybatis.pojo.EmpExample;\n\npublic interface EmpMapper {\n    \/**\n     * This method was generated by MyBatis Generator.\n     * This method corresponds to the database table t_emp\n     *\n     * @mbggenerated Wed Jan 04 16:17:13 CST 2023\n     *\/\n    int countByExample(EmpExample example);\n\n    \/**\n     * This method was generated by MyBatis Generator.\n     * This method corresponds to the database table t_emp\n     *\n     * @mbggenerated Wed Jan 04 16:17:13 CST 2023\n     *\/\n    int deleteByExample(EmpExample example);\n\n    \/**\n     * This method was generated by MyBatis Generator.\n     * This method corresponds to the database table t_emp\n     *\n     * @mbggenerated Wed Jan 04 16:17:13 CST 2023\n     *\/\n    int deleteByPrimaryKey(Integer eid);\n\n    \/**\n     * This method was generated by MyBatis Generator.\n     * This method corresponds to the database table t_emp\n     *\n     * @mbggenerated Wed Jan 04 16:17:13 CST 2023\n     *\/\n    int insert(Emp record);\n\n    \/**\n     * This method was generated by MyBatis Generator.\n     * This method corresponds to the database table t_emp\n     *\n     * @mbggenerated Wed Jan 04 16:17:13 CST 2023\n     *\/\n    int insertSelective(Emp record);\n\n    \/**\n     * This method was generated by MyBatis Generator.\n     * This method corresponds to the database table t_emp\n     *\n     * @mbggenerated Wed Jan 04 16:17:13 CST 2023\n     *\/\n    List<Emp> selectByExample(EmpExample example);\n\n    \/**\n     * This method was generated by MyBatis Generator.\n     * This method corresponds to the database table t_emp\n     *\n     * @mbggenerated Wed Jan 04 16:17:13 CST 2023\n     *\/\n    Emp selectByPrimaryKey(Integer eid);\n\n    \/**\n     * This method was generated by MyBatis Generator.\n     * This method corresponds to the database table t_emp\n     *\n     * @mbggenerated Wed Jan 04 16:17:13 CST 2023\n     *\/\n    int updateByExampleSelective(@Param(\"record\") Emp record, @Param(\"example\") EmpExample example);\n\n    \/**\n     * This method was generated by MyBatis Generator.\n     * This method corresponds to the database table t_emp\n     *\n     * @mbggenerated Wed Jan 04 16:17:13 CST 2023\n     *\/\n    int updateByExample(@Param(\"record\") Emp record, @Param(\"example\") EmpExample example);\n\n    \/**\n     * This method was generated by MyBatis Generator.\n     * This method corresponds to the database table t_emp\n     *\n     * @mbggenerated Wed Jan 04 16:17:13 CST 2023\n     *\/\n    int updateByPrimaryKeySelective(Emp record);\n\n    \/**\n     * This method was generated by MyBatis Generator.\n     * This method corresponds to the database table t_emp\n     *\n     * @mbggenerated Wed Jan 04 16:17:13 CST 2023\n     *\/\n    int updateByPrimaryKey(Emp record);\n}<\/code><\/pre>\n\n\n\n
DeptMapper .java\uff08\u81ea\u52a8\u751f\u6210\uff09<\/p>\n\n\n\n
package top.qaqaq.mybatis.mapper;\n\nimport java.util.List;\nimport org.apache.ibatis.annotations.Param;\nimport top.qaqaq.mybatis.pojo.Dept;\nimport top.qaqaq.mybatis.pojo.DeptExample;\n\npublic interface DeptMapper {\n    \/**\n     * This method was generated by MyBatis Generator.\n     * This method corresponds to the database table t_dept\n     *\n     * @mbggenerated Wed Jan 04 16:17:13 CST 2023\n     *\/\n    int countByExample(DeptExample example);\n\n    \/**\n     * This method was generated by MyBatis Generator.\n     * This method corresponds to the database table t_dept\n     *\n     * @mbggenerated Wed Jan 04 16:17:13 CST 2023\n     *\/\n    int deleteByExample(DeptExample example);\n\n    \/**\n     * This method was generated by MyBatis Generator.\n     * This method corresponds to the database table t_dept\n     *\n     * @mbggenerated Wed Jan 04 16:17:13 CST 2023\n     *\/\n    int deleteByPrimaryKey(Integer did);\n\n    \/**\n     * This method was generated by MyBatis Generator.\n     * This method corresponds to the database table t_dept\n     *\n     * @mbggenerated Wed Jan 04 16:17:13 CST 2023\n     *\/\n    int insert(Dept record);\n\n    \/**\n     * This method was generated by MyBatis Generator.\n     * This method corresponds to the database table t_dept\n     *\n     * @mbggenerated Wed Jan 04 16:17:13 CST 2023\n     *\/\n    int insertSelective(Dept record);\n\n    \/**\n     * This method was generated by MyBatis Generator.\n     * This method corresponds to the database table t_dept\n     *\n     * @mbggenerated Wed Jan 04 16:17:13 CST 2023\n     *\/\n    List<Dept> selectByExample(DeptExample example);\n\n    \/**\n     * This method was generated by MyBatis Generator.\n     * This method corresponds to the database table t_dept\n     *\n     * @mbggenerated Wed Jan 04 16:17:13 CST 2023\n     *\/\n    Dept selectByPrimaryKey(Integer did);\n\n    \/**\n     * This method was generated by MyBatis Generator.\n     * This method corresponds to the database table t_dept\n     *\n     * @mbggenerated Wed Jan 04 16:17:13 CST 2023\n     *\/\n    int updateByExampleSelective(@Param(\"record\") Dept record, @Param(\"example\") DeptExample example);\n\n    \/**\n     * This method was generated by MyBatis Generator.\n     * This method corresponds to the database table t_dept\n     *\n     * @mbggenerated Wed Jan 04 16:17:13 CST 2023\n     *\/\n    int updateByExample(@Param(\"record\") Dept record, @Param(\"example\") DeptExample example);\n\n    \/**\n     * This method was generated by MyBatis Generator.\n     * This method corresponds to the database table t_dept\n     *\n     * @mbggenerated Wed Jan 04 16:17:13 CST 2023\n     *\/\n    int updateByPrimaryKeySelective(Dept record);\n\n    \/**\n     * This method was generated by MyBatis Generator.\n     * This method corresponds to the database table t_dept\n     *\n     * @mbggenerated Wed Jan 04 16:17:13 CST 2023\n     *\/\n    int updateByPrimaryKey(Dept record);\n}<\/code><\/pre>\n\n\n\n
pojo<\/p>\n\n\n\n
Emp .java\uff08\u81ea\u52a8\u751f\u6210\uff09<\/p>\n\n\n\n
package top.qaqaq.mybatis.pojo;\n\npublic class Emp {\n    \/**\n     * This field was generated by MyBatis Generator.\n     * This field corresponds to the database column t_emp.eid\n     *\n     * @mbggenerated Wed Jan 04 16:17:13 CST 2023\n     *\/\n    private Integer eid;\n\n    \/**\n     * This field was generated by MyBatis Generator.\n     * This field corresponds to the database column t_emp.emp_name\n     *\n     * @mbggenerated Wed Jan 04 16:17:13 CST 2023\n     *\/\n    private String empName;\n\n    \/**\n     * This field was generated by MyBatis Generator.\n     * This field corresponds to the database column t_emp.age\n     *\n     * @mbggenerated Wed Jan 04 16:17:13 CST 2023\n     *\/\n    private Integer age;\n\n    \/**\n     * This field was generated by MyBatis Generator.\n     * This field corresponds to the database column t_emp.sex\n     *\n     * @mbggenerated Wed Jan 04 16:17:13 CST 2023\n     *\/\n    private String sex;\n\n    \/**\n     * This field was generated by MyBatis Generator.\n     * This field corresponds to the database column t_emp.email\n     *\n     * @mbggenerated Wed Jan 04 16:17:13 CST 2023\n     *\/\n    private String email;\n\n    \/**\n     * This field was generated by MyBatis Generator.\n     * This field corresponds to the database column t_emp.did\n     *\n     * @mbggenerated Wed Jan 04 16:17:13 CST 2023\n     *\/\n    private Integer did;\n\n    \/**\n     * This method was generated by MyBatis Generator.\n     * This method returns the value of the database column t_emp.eid\n     *\n     * @return the value of t_emp.eid\n     *\n     * @mbggenerated Wed Jan 04 16:17:13 CST 2023\n     *\/\n    public Integer getEid() {\n        return eid;\n    }\n\n    \/**\n     * This method was generated by MyBatis Generator.\n     * This method sets the value of the database column t_emp.eid\n     *\n     * @param eid the value for t_emp.eid\n     *\n     * @mbggenerated Wed Jan 04 16:17:13 CST 2023\n     *\/\n    public void setEid(Integer eid) {\n        this.eid = eid;\n    }\n\n    \/**\n     * This method was generated by MyBatis Generator.\n     * This method returns the value of the database column t_emp.emp_name\n     *\n     * @return the value of t_emp.emp_name\n     *\n     * @mbggenerated Wed Jan 04 16:17:13 CST 2023\n     *\/\n    public String getEmpName() {\n        return empName;\n    }\n\n    \/**\n     * This method was generated by MyBatis Generator.\n     * This method sets the value of the database column t_emp.emp_name\n     *\n     * @param empName the value for t_emp.emp_name\n     *\n     * @mbggenerated Wed Jan 04 16:17:13 CST 2023\n     *\/\n    public void setEmpName(String empName) {\n        this.empName = empName == null ? null : empName.trim();\n    }\n\n    \/**\n     * This method was generated by MyBatis Generator.\n     * This method returns the value of the database column t_emp.age\n     *\n     * @return the value of t_emp.age\n     *\n     * @mbggenerated Wed Jan 04 16:17:13 CST 2023\n     *\/\n    public Integer getAge() {\n        return age;\n    }\n\n    \/**\n     * This method was generated by MyBatis Generator.\n     * This method sets the value of the database column t_emp.age\n     *\n     * @param age the value for t_emp.age\n     *\n     * @mbggenerated Wed Jan 04 16:17:13 CST 2023\n     *\/\n    public void setAge(Integer age) {\n        this.age = age;\n    }\n\n    \/**\n     * This method was generated by MyBatis Generator.\n     * This method returns the value of the database column t_emp.sex\n     *\n     * @return the value of t_emp.sex\n     *\n     * @mbggenerated Wed Jan 04 16:17:13 CST 2023\n     *\/\n    public String getSex() {\n        return sex;\n    }\n\n    \/**\n     * This method was generated by MyBatis Generator.\n     * This method sets the value of the database column t_emp.sex\n     *\n     * @param sex the value for t_emp.sex\n     *\n     * @mbggenerated Wed Jan 04 16:17:13 CST 2023\n     *\/\n    public void setSex(String sex) {\n        this.sex = sex == null ? null : sex.trim();\n    }\n\n    \/**\n     * This method was generated by MyBatis Generator.\n     * This method returns the value of the database column t_emp.email\n     *\n     * @return the value of t_emp.email\n     *\n     * @mbggenerated Wed Jan 04 16:17:13 CST 2023\n     *\/\n    public String getEmail() {\n        return email;\n    }\n\n    \/**\n     * This method was generated by MyBatis Generator.\n     * This method sets the value of the database column t_emp.email\n     *\n     * @param email the value for t_emp.email\n     *\n     * @mbggenerated Wed Jan 04 16:17:13 CST 2023\n     *\/\n    public void setEmail(String email) {\n        this.email = email == null ? null : email.trim();\n    }\n\n    \/**\n     * This method was generated by MyBatis Generator.\n     * This method returns the value of the database column t_emp.did\n     *\n     * @return the value of t_emp.did\n     *\n     * @mbggenerated Wed Jan 04 16:17:13 CST 2023\n     *\/\n    public Integer getDid() {\n        return did;\n    }\n\n    \/**\n     * This method was generated by MyBatis Generator.\n     * This method sets the value of the database column t_emp.did\n     *\n     * @param did the value for t_emp.did\n     *\n     * @mbggenerated Wed Jan 04 16:17:13 CST 2023\n     *\/\n    public void setDid(Integer did) {\n        this.did = did;\n    }\n\n    public Emp() {\n    }\n\n    public Emp(Integer eid, String empName, Integer age, String sex, String email, Integer did) {\n        this.eid = eid;\n        this.empName = empName;\n        this.age = age;\n        this.sex = sex;\n        this.email = email;\n        this.did = did;\n    }\n\n    @Override\n    public String toString() {\n        return \"Emp{\" +\n                \"eid=\" + eid +\n                \", empName='\" + empName + '\\'' +\n                \", age=\" + age +\n                \", sex='\" + sex + '\\'' +\n                \", email='\" + email + '\\'' +\n                \", did=\" + did +\n                '}';\n    }\n\n}<\/code><\/pre>\n\n\n\n
EmpExample.java\uff08\u81ea\u52a8\u751f\u6210\uff09<\/p>\n\n\n\n
package top.qaqaq.mybatis.pojo;\n\nimport java.util.ArrayList;\nimport java.util.List;\n\npublic class EmpExample {\n    \/**\n     * This field was generated by MyBatis Generator.\n     * This field corresponds to the database table t_emp\n     *\n     * @mbggenerated Wed Jan 04 16:17:13 CST 2023\n     *\/\n    protected String orderByClause;\n\n    \/**\n     * This field was generated by MyBatis Generator.\n     * This field corresponds to the database table t_emp\n     *\n     * @mbggenerated Wed Jan 04 16:17:13 CST 2023\n     *\/\n    protected boolean distinct;\n\n    \/**\n     * This field was generated by MyBatis Generator.\n     * This field corresponds to the database table t_emp\n     *\n     * @mbggenerated Wed Jan 04 16:17:13 CST 2023\n     *\/\n    protected List<Criteria> oredCriteria;\n\n    \/**\n     * This method was generated by MyBatis Generator.\n     * This method corresponds to the database table t_emp\n     *\n     * @mbggenerated Wed Jan 04 16:17:13 CST 2023\n     *\/\n    public EmpExample() {\n        oredCriteria = new ArrayList<Criteria>();\n    }\n\n    \/**\n     * This method was generated by MyBatis Generator.\n     * This method corresponds to the database table t_emp\n     *\n     * @mbggenerated Wed Jan 04 16:17:13 CST 2023\n     *\/\n    public void setOrderByClause(String orderByClause) {\n        this.orderByClause = orderByClause;\n    }\n\n    \/**\n     * This method was generated by MyBatis Generator.\n     * This method corresponds to the database table t_emp\n     *\n     * @mbggenerated Wed Jan 04 16:17:13 CST 2023\n     *\/\n    public String getOrderByClause() {\n        return orderByClause;\n    }\n\n    \/**\n     * This method was generated by MyBatis Generator.\n     * This method corresponds to the database table t_emp\n     *\n     * @mbggenerated Wed Jan 04 16:17:13 CST 2023\n     *\/\n    public void setDistinct(boolean distinct) {\n        this.distinct = distinct;\n    }\n\n    \/**\n     * This method was generated by MyBatis Generator.\n     * This method corresponds to the database table t_emp\n     *\n     * @mbggenerated Wed Jan 04 16:17:13 CST 2023\n     *\/\n    public boolean isDistinct() {\n        return distinct;\n    }\n\n    \/**\n     * This method was generated by MyBatis Generator.\n     * This method corresponds to the database table t_emp\n     *\n     * @mbggenerated Wed Jan 04 16:17:13 CST 2023\n     *\/\n    public List<Criteria> getOredCriteria() {\n        return oredCriteria;\n    }\n\n    \/**\n     * This method was generated by MyBatis Generator.\n     * This method corresponds to the database table t_emp\n     *\n     * @mbggenerated Wed Jan 04 16:17:13 CST 2023\n     *\/\n    public void or(Criteria criteria) {\n        oredCriteria.add(criteria);\n    }\n\n    \/**\n     * This method was generated by MyBatis Generator.\n     * This method corresponds to the database table t_emp\n     *\n     * @mbggenerated Wed Jan 04 16:17:13 CST 2023\n     *\/\n    public Criteria or() {\n        Criteria criteria = createCriteriaInternal();\n        oredCriteria.add(criteria);\n        return criteria;\n    }\n\n    \/**\n     * This method was generated by MyBatis Generator.\n     * This method corresponds to the database table t_emp\n     *\n     * @mbggenerated Wed Jan 04 16:17:13 CST 2023\n     *\/\n    public Criteria createCriteria() {\n        Criteria criteria = createCriteriaInternal();\n        if (oredCriteria.size() == 0) {\n            oredCriteria.add(criteria);\n        }\n        return criteria;\n    }\n\n    \/**\n     * This method was generated by MyBatis Generator.\n     * This method corresponds to the database table t_emp\n     *\n     * @mbggenerated Wed Jan 04 16:17:13 CST 2023\n     *\/\n    protected Criteria createCriteriaInternal() {\n        Criteria criteria = new Criteria();\n        return criteria;\n    }\n\n    \/**\n     * This method was generated by MyBatis Generator.\n     * This method corresponds to the database table t_emp\n     *\n     * @mbggenerated Wed Jan 04 16:17:13 CST 2023\n     *\/\n    public void clear() {\n        oredCriteria.clear();\n        orderByClause = null;\n        distinct = false;\n    }\n\n    \/**\n     * This class was generated by MyBatis Generator.\n     * This class corresponds to the database table t_emp\n     *\n     * @mbggenerated Wed Jan 04 16:17:13 CST 2023\n     *\/\n    protected abstract static class GeneratedCriteria {\n        protected List<Criterion> criteria;\n\n        protected GeneratedCriteria() {\n            super();\n            criteria = new ArrayList<Criterion>();\n        }\n\n        public boolean isValid() {\n            return criteria.size() > 0;\n        }\n\n        public List<Criterion> getAllCriteria() {\n            return criteria;\n        }\n\n        public List<Criterion> getCriteria() {\n            return criteria;\n        }\n\n        protected void addCriterion(String condition) {\n            if (condition == null) {\n                throw new RuntimeException(\"Value for condition cannot be null\");\n            }\n            criteria.add(new Criterion(condition));\n        }\n\n        protected void addCriterion(String condition, Object value, String property) {\n            if (value == null) {\n                throw new RuntimeException(\"Value for \" + property + \" cannot be null\");\n            }\n            criteria.add(new Criterion(condition, value));\n        }\n\n        protected void addCriterion(String condition, Object value1, Object value2, String property) {\n            if (value1 == null || value2 == null) {\n                throw new RuntimeException(\"Between values for \" + property + \" cannot be null\");\n            }\n            criteria.add(new Criterion(condition, value1, value2));\n        }\n\n        public Criteria andEidIsNull() {\n            addCriterion(\"eid is null\");\n            return (Criteria) this;\n        }\n\n        public Criteria andEidIsNotNull() {\n            addCriterion(\"eid is not null\");\n            return (Criteria) this;\n        }\n\n        public Criteria andEidEqualTo(Integer value) {\n            addCriterion(\"eid =\", value, \"eid\");\n            return (Criteria) this;\n        }\n\n        public Criteria andEidNotEqualTo(Integer value) {\n            addCriterion(\"eid <>\", value, \"eid\");\n            return (Criteria) this;\n        }\n\n        public Criteria andEidGreaterThan(Integer value) {\n            addCriterion(\"eid >\", value, \"eid\");\n            return (Criteria) this;\n        }\n\n        public Criteria andEidGreaterThanOrEqualTo(Integer value) {\n            addCriterion(\"eid >=\", value, \"eid\");\n            return (Criteria) this;\n        }\n\n        public Criteria andEidLessThan(Integer value) {\n            addCriterion(\"eid <\", value, \"eid\");\n            return (Criteria) this;\n        }\n\n        public Criteria andEidLessThanOrEqualTo(Integer value) {\n            addCriterion(\"eid <=\", value, \"eid\");\n            return (Criteria) this;\n        }\n\n        public Criteria andEidIn(List<Integer> values) {\n            addCriterion(\"eid in\", values, \"eid\");\n            return (Criteria) this;\n        }\n\n        public Criteria andEidNotIn(List<Integer> values) {\n            addCriterion(\"eid not in\", values, \"eid\");\n            return (Criteria) this;\n        }\n\n        public Criteria andEidBetween(Integer value1, Integer value2) {\n            addCriterion(\"eid between\", value1, value2, \"eid\");\n            return (Criteria) this;\n        }\n\n        public Criteria andEidNotBetween(Integer value1, Integer value2) {\n            addCriterion(\"eid not between\", value1, value2, \"eid\");\n            return (Criteria) this;\n        }\n\n        public Criteria andEmpNameIsNull() {\n            addCriterion(\"emp_name is null\");\n            return (Criteria) this;\n        }\n\n        public Criteria andEmpNameIsNotNull() {\n            addCriterion(\"emp_name is not null\");\n            return (Criteria) this;\n        }\n\n        public Criteria andEmpNameEqualTo(String value) {\n            addCriterion(\"emp_name =\", value, \"empName\");\n            return (Criteria) this;\n        }\n\n        public Criteria andEmpNameNotEqualTo(String value) {\n            addCriterion(\"emp_name <>\", value, \"empName\");\n            return (Criteria) this;\n        }\n\n        public Criteria andEmpNameGreaterThan(String value) {\n            addCriterion(\"emp_name >\", value, \"empName\");\n            return (Criteria) this;\n        }\n\n        public Criteria andEmpNameGreaterThanOrEqualTo(String value) {\n            addCriterion(\"emp_name >=\", value, \"empName\");\n            return (Criteria) this;\n        }\n\n        public Criteria andEmpNameLessThan(String value) {\n            addCriterion(\"emp_name <\", value, \"empName\");\n            return (Criteria) this;\n        }\n\n        public Criteria andEmpNameLessThanOrEqualTo(String value) {\n            addCriterion(\"emp_name <=\", value, \"empName\");\n            return (Criteria) this;\n        }\n\n        public Criteria andEmpNameLike(String value) {\n            addCriterion(\"emp_name like\", value, \"empName\");\n            return (Criteria) this;\n        }\n\n        public Criteria andEmpNameNotLike(String value) {\n            addCriterion(\"emp_name not like\", value, \"empName\");\n            return (Criteria) this;\n        }\n\n        public Criteria andEmpNameIn(List<String> values) {\n            addCriterion(\"emp_name in\", values, \"empName\");\n            return (Criteria) this;\n        }\n\n        public Criteria andEmpNameNotIn(List<String> values) {\n            addCriterion(\"emp_name not in\", values, \"empName\");\n            return (Criteria) this;\n        }\n\n        public Criteria andEmpNameBetween(String value1, String value2) {\n            addCriterion(\"emp_name between\", value1, value2, \"empName\");\n            return (Criteria) this;\n        }\n\n        public Criteria andEmpNameNotBetween(String value1, String value2) {\n            addCriterion(\"emp_name not between\", value1, value2, \"empName\");\n            return (Criteria) this;\n        }\n\n        public Criteria andAgeIsNull() {\n            addCriterion(\"age is null\");\n            return (Criteria) this;\n        }\n\n        public Criteria andAgeIsNotNull() {\n            addCriterion(\"age is not null\");\n            return (Criteria) this;\n        }\n\n        public Criteria andAgeEqualTo(Integer value) {\n            addCriterion(\"age =\", value, \"age\");\n            return (Criteria) this;\n        }\n\n        public Criteria andAgeNotEqualTo(Integer value) {\n            addCriterion(\"age <>\", value, \"age\");\n            return (Criteria) this;\n        }\n\n        public Criteria andAgeGreaterThan(Integer value) {\n            addCriterion(\"age >\", value, \"age\");\n            return (Criteria) this;\n        }\n\n        public Criteria andAgeGreaterThanOrEqualTo(Integer value) {\n            addCriterion(\"age >=\", value, \"age\");\n            return (Criteria) this;\n        }\n\n        public Criteria andAgeLessThan(Integer value) {\n            addCriterion(\"age <\", value, \"age\");\n            return (Criteria) this;\n        }\n\n        public Criteria andAgeLessThanOrEqualTo(Integer value) {\n            addCriterion(\"age <=\", value, \"age\");\n            return (Criteria) this;\n        }\n\n        public Criteria andAgeIn(List<Integer> values) {\n            addCriterion(\"age in\", values, \"age\");\n            return (Criteria) this;\n        }\n\n        public Criteria andAgeNotIn(List<Integer> values) {\n            addCriterion(\"age not in\", values, \"age\");\n            return (Criteria) this;\n        }\n\n        public Criteria andAgeBetween(Integer value1, Integer value2) {\n            addCriterion(\"age between\", value1, value2, \"age\");\n            return (Criteria) this;\n        }\n\n        public Criteria andAgeNotBetween(Integer value1, Integer value2) {\n            addCriterion(\"age not between\", value1, value2, \"age\");\n            return (Criteria) this;\n        }\n\n        public Criteria andSexIsNull() {\n            addCriterion(\"sex is null\");\n            return (Criteria) this;\n        }\n\n        public Criteria andSexIsNotNull() {\n            addCriterion(\"sex is not null\");\n            return (Criteria) this;\n        }\n\n        public Criteria andSexEqualTo(String value) {\n            addCriterion(\"sex =\", value, \"sex\");\n            return (Criteria) this;\n        }\n\n        public Criteria andSexNotEqualTo(String value) {\n            addCriterion(\"sex <>\", value, \"sex\");\n            return (Criteria) this;\n        }\n\n        public Criteria andSexGreaterThan(String value) {\n            addCriterion(\"sex >\", value, \"sex\");\n            return (Criteria) this;\n        }\n\n        public Criteria andSexGreaterThanOrEqualTo(String value) {\n            addCriterion(\"sex >=\", value, \"sex\");\n            return (Criteria) this;\n        }\n\n        public Criteria andSexLessThan(String value) {\n            addCriterion(\"sex <\", value, \"sex\");\n            return (Criteria) this;\n        }\n\n        public Criteria andSexLessThanOrEqualTo(String value) {\n            addCriterion(\"sex <=\", value, \"sex\");\n            return (Criteria) this;\n        }\n\n        public Criteria andSexLike(String value) {\n            addCriterion(\"sex like\", value, \"sex\");\n            return (Criteria) this;\n        }\n\n        public Criteria andSexNotLike(String value) {\n            addCriterion(\"sex not like\", value, \"sex\");\n            return (Criteria) this;\n        }\n\n        public Criteria andSexIn(List<String> values) {\n            addCriterion(\"sex in\", values, \"sex\");\n            return (Criteria) this;\n        }\n\n        public Criteria andSexNotIn(List<String> values) {\n            addCriterion(\"sex not in\", values, \"sex\");\n            return (Criteria) this;\n        }\n\n        public Criteria andSexBetween(String value1, String value2) {\n            addCriterion(\"sex between\", value1, value2, \"sex\");\n            return (Criteria) this;\n        }\n\n        public Criteria andSexNotBetween(String value1, String value2) {\n            addCriterion(\"sex not between\", value1, value2, \"sex\");\n            return (Criteria) this;\n        }\n\n        public Criteria andEmailIsNull() {\n            addCriterion(\"email is null\");\n            return (Criteria) this;\n        }\n\n        public Criteria andEmailIsNotNull() {\n            addCriterion(\"email is not null\");\n            return (Criteria) this;\n        }\n\n        public Criteria andEmailEqualTo(String value) {\n            addCriterion(\"email =\", value, \"email\");\n            return (Criteria) this;\n        }\n\n        public Criteria andEmailNotEqualTo(String value) {\n            addCriterion(\"email <>\", value, \"email\");\n            return (Criteria) this;\n        }\n\n        public Criteria andEmailGreaterThan(String value) {\n            addCriterion(\"email >\", value, \"email\");\n            return (Criteria) this;\n        }\n\n        public Criteria andEmailGreaterThanOrEqualTo(String value) {\n            addCriterion(\"email >=\", value, \"email\");\n            return (Criteria) this;\n        }\n\n        public Criteria andEmailLessThan(String value) {\n            addCriterion(\"email <\", value, \"email\");\n            return (Criteria) this;\n        }\n\n        public Criteria andEmailLessThanOrEqualTo(String value) {\n            addCriterion(\"email <=\", value, \"email\");\n            return (Criteria) this;\n        }\n\n        public Criteria andEmailLike(String value) {\n            addCriterion(\"email like\", value, \"email\");\n            return (Criteria) this;\n        }\n\n        public Criteria andEmailNotLike(String value) {\n            addCriterion(\"email not like\", value, \"email\");\n            return (Criteria) this;\n        }\n\n        public Criteria andEmailIn(List<String> values) {\n            addCriterion(\"email in\", values, \"email\");\n            return (Criteria) this;\n        }\n\n        public Criteria andEmailNotIn(List<String> values) {\n            addCriterion(\"email not in\", values, \"email\");\n            return (Criteria) this;\n        }\n\n        public Criteria andEmailBetween(String value1, String value2) {\n            addCriterion(\"email between\", value1, value2, \"email\");\n            return (Criteria) this;\n        }\n\n        public Criteria andEmailNotBetween(String value1, String value2) {\n            addCriterion(\"email not between\", value1, value2, \"email\");\n            return (Criteria) this;\n        }\n\n        public Criteria andDidIsNull() {\n            addCriterion(\"did is null\");\n            return (Criteria) this;\n        }\n\n        public Criteria andDidIsNotNull() {\n            addCriterion(\"did is not null\");\n            return (Criteria) this;\n        }\n\n        public Criteria andDidEqualTo(Integer value) {\n            addCriterion(\"did =\", value, \"did\");\n            return (Criteria) this;\n        }\n\n        public Criteria andDidNotEqualTo(Integer value) {\n            addCriterion(\"did <>\", value, \"did\");\n            return (Criteria) this;\n        }\n\n        public Criteria andDidGreaterThan(Integer value) {\n            addCriterion(\"did >\", value, \"did\");\n            return (Criteria) this;\n        }\n\n        public Criteria andDidGreaterThanOrEqualTo(Integer value) {\n            addCriterion(\"did >=\", value, \"did\");\n            return (Criteria) this;\n        }\n\n        public Criteria andDidLessThan(Integer value) {\n            addCriterion(\"did <\", value, \"did\");\n            return (Criteria) this;\n        }\n\n        public Criteria andDidLessThanOrEqualTo(Integer value) {\n            addCriterion(\"did <=\", value, \"did\");\n            return (Criteria) this;\n        }\n\n        public Criteria andDidIn(List<Integer> values) {\n            addCriterion(\"did in\", values, \"did\");\n            return (Criteria) this;\n        }\n\n        public Criteria andDidNotIn(List<Integer> values) {\n            addCriterion(\"did not in\", values, \"did\");\n            return (Criteria) this;\n        }\n\n        public Criteria andDidBetween(Integer value1, Integer value2) {\n            addCriterion(\"did between\", value1, value2, \"did\");\n            return (Criteria) this;\n        }\n\n        public Criteria andDidNotBetween(Integer value1, Integer value2) {\n            addCriterion(\"did not between\", value1, value2, \"did\");\n            return (Criteria) this;\n        }\n    }\n\n    \/**\n     * This class was generated by MyBatis Generator.\n     * This class corresponds to the database table t_emp\n     *\n     * @mbggenerated do_not_delete_during_merge Wed Jan 04 16:17:13 CST 2023\n     *\/\n    public static class Criteria extends GeneratedCriteria {\n\n        protected Criteria() {\n            super();\n        }\n    }\n\n    \/**\n     * This class was generated by MyBatis Generator.\n     * This class corresponds to the database table t_emp\n     *\n     * @mbggenerated Wed Jan 04 16:17:13 CST 2023\n     *\/\n    public static class Criterion {\n        private String condition;\n\n        private Object value;\n\n        private Object secondValue;\n\n        private boolean noValue;\n\n        private boolean singleValue;\n\n        private boolean betweenValue;\n\n        private boolean listValue;\n\n        private String typeHandler;\n\n        public String getCondition() {\n            return condition;\n        }\n\n        public Object getValue() {\n            return value;\n        }\n\n        public Object getSecondValue() {\n            return secondValue;\n        }\n\n        public boolean isNoValue() {\n            return noValue;\n        }\n\n        public boolean isSingleValue() {\n            return singleValue;\n        }\n\n        public boolean isBetweenValue() {\n            return betweenValue;\n        }\n\n        public boolean isListValue() {\n            return listValue;\n        }\n\n        public String getTypeHandler() {\n            return typeHandler;\n        }\n\n        protected Criterion(String condition) {\n            super();\n            this.condition = condition;\n            this.typeHandler = null;\n            this.noValue = true;\n        }\n\n        protected Criterion(String condition, Object value, String typeHandler) {\n            super();\n            this.condition = condition;\n            this.value = value;\n            this.typeHandler = typeHandler;\n            if (value instanceof List<?>) {\n                this.listValue = true;\n            } else {\n                this.singleValue = true;\n            }\n        }\n\n        protected Criterion(String condition, Object value) {\n            this(condition, value, null);\n        }\n\n        protected Criterion(String condition, Object value, Object secondValue, String typeHandler) {\n            super();\n            this.condition = condition;\n            this.value = value;\n            this.secondValue = secondValue;\n            this.typeHandler = typeHandler;\n            this.betweenValue = true;\n        }\n\n        protected Criterion(String condition, Object value, Object secondValue) {\n            this(condition, value, secondValue, null);\n        }\n    }\n}<\/code><\/pre>\n\n\n\n
Dept.java\uff08\u81ea\u52a8\u751f\u6210\uff09<\/p>\n\n\n\n
package top.qaqaq.mybatis.pojo;\n\npublic class Dept {\n    \/**\n     * This field was generated by MyBatis Generator.\n     * This field corresponds to the database column t_dept.did\n     *\n     * @mbggenerated Wed Jan 04 16:17:13 CST 2023\n     *\/\n    private Integer did;\n\n    \/**\n     * This field was generated by MyBatis Generator.\n     * This field corresponds to the database column t_dept.dept_name\n     *\n     * @mbggenerated Wed Jan 04 16:17:13 CST 2023\n     *\/\n    private String deptName;\n\n    \/**\n     * This method was generated by MyBatis Generator.\n     * This method returns the value of the database column t_dept.did\n     *\n     * @return the value of t_dept.did\n     *\n     * @mbggenerated Wed Jan 04 16:17:13 CST 2023\n     *\/\n    public Integer getDid() {\n        return did;\n    }\n\n    \/**\n     * This method was generated by MyBatis Generator.\n     * This method sets the value of the database column t_dept.did\n     *\n     * @param did the value for t_dept.did\n     *\n     * @mbggenerated Wed Jan 04 16:17:13 CST 2023\n     *\/\n    public void setDid(Integer did) {\n        this.did = did;\n    }\n\n    \/**\n     * This method was generated by MyBatis Generator.\n     * This method returns the value of the database column t_dept.dept_name\n     *\n     * @return the value of t_dept.dept_name\n     *\n     * @mbggenerated Wed Jan 04 16:17:13 CST 2023\n     *\/\n    public String getDeptName() {\n        return deptName;\n    }\n\n    \/**\n     * This method was generated by MyBatis Generator.\n     * This method sets the value of the database column t_dept.dept_name\n     *\n     * @param deptName the value for t_dept.dept_name\n     *\n     * @mbggenerated Wed Jan 04 16:17:13 CST 2023\n     *\/\n    public void setDeptName(String deptName) {\n        this.deptName = deptName == null ? null : deptName.trim();\n    }\n}<\/code><\/pre>\n\n\n\n
DeptExample.java\uff08\u81ea\u52a8\u751f\u6210\uff09<\/p>\n\n\n\n
package top.qaqaq.mybatis.pojo;\n\nimport java.util.ArrayList;\nimport java.util.List;\n\npublic class DeptExample {\n    \/**\n     * This field was generated by MyBatis Generator.\n     * This field corresponds to the database table t_dept\n     *\n     * @mbggenerated Wed Jan 04 16:17:13 CST 2023\n     *\/\n    protected String orderByClause;\n\n    \/**\n     * This field was generated by MyBatis Generator.\n     * This field corresponds to the database table t_dept\n     *\n     * @mbggenerated Wed Jan 04 16:17:13 CST 2023\n     *\/\n    protected boolean distinct;\n\n    \/**\n     * This field was generated by MyBatis Generator.\n     * This field corresponds to the database table t_dept\n     *\n     * @mbggenerated Wed Jan 04 16:17:13 CST 2023\n     *\/\n    protected List<Criteria> oredCriteria;\n\n    \/**\n     * This method was generated by MyBatis Generator.\n     * This method corresponds to the database table t_dept\n     *\n     * @mbggenerated Wed Jan 04 16:17:13 CST 2023\n     *\/\n    public DeptExample() {\n        oredCriteria = new ArrayList<Criteria>();\n    }\n\n    \/**\n     * This method was generated by MyBatis Generator.\n     * This method corresponds to the database table t_dept\n     *\n     * @mbggenerated Wed Jan 04 16:17:13 CST 2023\n     *\/\n    public void setOrderByClause(String orderByClause) {\n        this.orderByClause = orderByClause;\n    }\n\n    \/**\n     * This method was generated by MyBatis Generator.\n     * This method corresponds to the database table t_dept\n     *\n     * @mbggenerated Wed Jan 04 16:17:13 CST 2023\n     *\/\n    public String getOrderByClause() {\n        return orderByClause;\n    }\n\n    \/**\n     * This method was generated by MyBatis Generator.\n     * This method corresponds to the database table t_dept\n     *\n     * @mbggenerated Wed Jan 04 16:17:13 CST 2023\n     *\/\n    public void setDistinct(boolean distinct) {\n        this.distinct = distinct;\n    }\n\n    \/**\n     * This method was generated by MyBatis Generator.\n     * This method corresponds to the database table t_dept\n     *\n     * @mbggenerated Wed Jan 04 16:17:13 CST 2023\n     *\/\n    public boolean isDistinct() {\n        return distinct;\n    }\n\n    \/**\n     * This method was generated by MyBatis Generator.\n     * This method corresponds to the database table t_dept\n     *\n     * @mbggenerated Wed Jan 04 16:17:13 CST 2023\n     *\/\n    public List<Criteria> getOredCriteria() {\n        return oredCriteria;\n    }\n\n    \/**\n     * This method was generated by MyBatis Generator.\n     * This method corresponds to the database table t_dept\n     *\n     * @mbggenerated Wed Jan 04 16:17:13 CST 2023\n     *\/\n    public void or(Criteria criteria) {\n        oredCriteria.add(criteria);\n    }\n\n    \/**\n     * This method was generated by MyBatis Generator.\n     * This method corresponds to the database table t_dept\n     *\n     * @mbggenerated Wed Jan 04 16:17:13 CST 2023\n     *\/\n    public Criteria or() {\n        Criteria criteria = createCriteriaInternal();\n        oredCriteria.add(criteria);\n        return criteria;\n    }\n\n    \/**\n     * This method was generated by MyBatis Generator.\n     * This method corresponds to the database table t_dept\n     *\n     * @mbggenerated Wed Jan 04 16:17:13 CST 2023\n     *\/\n    public Criteria createCriteria() {\n        Criteria criteria = createCriteriaInternal();\n        if (oredCriteria.size() == 0) {\n            oredCriteria.add(criteria);\n        }\n        return criteria;\n    }\n\n    \/**\n     * This method was generated by MyBatis Generator.\n     * This method corresponds to the database table t_dept\n     *\n     * @mbggenerated Wed Jan 04 16:17:13 CST 2023\n     *\/\n    protected Criteria createCriteriaInternal() {\n        Criteria criteria = new Criteria();\n        return criteria;\n    }\n\n    \/**\n     * This method was generated by MyBatis Generator.\n     * This method corresponds to the database table t_dept\n     *\n     * @mbggenerated Wed Jan 04 16:17:13 CST 2023\n     *\/\n    public void clear() {\n        oredCriteria.clear();\n        orderByClause = null;\n        distinct = false;\n    }\n\n    \/**\n     * This class was generated by MyBatis Generator.\n     * This class corresponds to the database table t_dept\n     *\n     * @mbggenerated Wed Jan 04 16:17:13 CST 2023\n     *\/\n    protected abstract static class GeneratedCriteria {\n        protected List<Criterion> criteria;\n\n        protected GeneratedCriteria() {\n            super();\n            criteria = new ArrayList<Criterion>();\n        }\n\n        public boolean isValid() {\n            return criteria.size() > 0;\n        }\n\n        public List<Criterion> getAllCriteria() {\n            return criteria;\n        }\n\n        public List<Criterion> getCriteria() {\n            return criteria;\n        }\n\n        protected void addCriterion(String condition) {\n            if (condition == null) {\n                throw new RuntimeException(\"Value for condition cannot be null\");\n            }\n            criteria.add(new Criterion(condition));\n        }\n\n        protected void addCriterion(String condition, Object value, String property) {\n            if (value == null) {\n                throw new RuntimeException(\"Value for \" + property + \" cannot be null\");\n            }\n            criteria.add(new Criterion(condition, value));\n        }\n\n        protected void addCriterion(String condition, Object value1, Object value2, String property) {\n            if (value1 == null || value2 == null) {\n                throw new RuntimeException(\"Between values for \" + property + \" cannot be null\");\n            }\n            criteria.add(new Criterion(condition, value1, value2));\n        }\n\n        public Criteria andDidIsNull() {\n            addCriterion(\"did is null\");\n            return (Criteria) this;\n        }\n\n        public Criteria andDidIsNotNull() {\n            addCriterion(\"did is not null\");\n            return (Criteria) this;\n        }\n\n        public Criteria andDidEqualTo(Integer value) {\n            addCriterion(\"did =\", value, \"did\");\n            return (Criteria) this;\n        }\n\n        public Criteria andDidNotEqualTo(Integer value) {\n            addCriterion(\"did <>\", value, \"did\");\n            return (Criteria) this;\n        }\n\n        public Criteria andDidGreaterThan(Integer value) {\n            addCriterion(\"did >\", value, \"did\");\n            return (Criteria) this;\n        }\n\n        public Criteria andDidGreaterThanOrEqualTo(Integer value) {\n            addCriterion(\"did >=\", value, \"did\");\n            return (Criteria) this;\n        }\n\n        public Criteria andDidLessThan(Integer value) {\n            addCriterion(\"did <\", value, \"did\");\n            return (Criteria) this;\n        }\n\n        public Criteria andDidLessThanOrEqualTo(Integer value) {\n            addCriterion(\"did <=\", value, \"did\");\n            return (Criteria) this;\n        }\n\n        public Criteria andDidIn(List<Integer> values) {\n            addCriterion(\"did in\", values, \"did\");\n            return (Criteria) this;\n        }\n\n        public Criteria andDidNotIn(List<Integer> values) {\n            addCriterion(\"did not in\", values, \"did\");\n            return (Criteria) this;\n        }\n\n        public Criteria andDidBetween(Integer value1, Integer value2) {\n            addCriterion(\"did between\", value1, value2, \"did\");\n            return (Criteria) this;\n        }\n\n        public Criteria andDidNotBetween(Integer value1, Integer value2) {\n            addCriterion(\"did not between\", value1, value2, \"did\");\n            return (Criteria) this;\n        }\n\n        public Criteria andDeptNameIsNull() {\n            addCriterion(\"dept_name is null\");\n            return (Criteria) this;\n        }\n\n        public Criteria andDeptNameIsNotNull() {\n            addCriterion(\"dept_name is not null\");\n            return (Criteria) this;\n        }\n\n        public Criteria andDeptNameEqualTo(String value) {\n            addCriterion(\"dept_name =\", value, \"deptName\");\n            return (Criteria) this;\n        }\n\n        public Criteria andDeptNameNotEqualTo(String value) {\n            addCriterion(\"dept_name <>\", value, \"deptName\");\n            return (Criteria) this;\n        }\n\n        public Criteria andDeptNameGreaterThan(String value) {\n            addCriterion(\"dept_name >\", value, \"deptName\");\n            return (Criteria) this;\n        }\n\n        public Criteria andDeptNameGreaterThanOrEqualTo(String value) {\n            addCriterion(\"dept_name >=\", value, \"deptName\");\n            return (Criteria) this;\n        }\n\n        public Criteria andDeptNameLessThan(String value) {\n            addCriterion(\"dept_name <\", value, \"deptName\");\n            return (Criteria) this;\n        }\n\n        public Criteria andDeptNameLessThanOrEqualTo(String value) {\n            addCriterion(\"dept_name <=\", value, \"deptName\");\n            return (Criteria) this;\n        }\n\n        public Criteria andDeptNameLike(String value) {\n            addCriterion(\"dept_name like\", value, \"deptName\");\n            return (Criteria) this;\n        }\n\n        public Criteria andDeptNameNotLike(String value) {\n            addCriterion(\"dept_name not like\", value, \"deptName\");\n            return (Criteria) this;\n        }\n\n        public Criteria andDeptNameIn(List<String> values) {\n            addCriterion(\"dept_name in\", values, \"deptName\");\n            return (Criteria) this;\n        }\n\n        public Criteria andDeptNameNotIn(List<String> values) {\n            addCriterion(\"dept_name not in\", values, \"deptName\");\n            return (Criteria) this;\n        }\n\n        public Criteria andDeptNameBetween(String value1, String value2) {\n            addCriterion(\"dept_name between\", value1, value2, \"deptName\");\n            return (Criteria) this;\n        }\n\n        public Criteria andDeptNameNotBetween(String value1, String value2) {\n            addCriterion(\"dept_name not between\", value1, value2, \"deptName\");\n            return (Criteria) this;\n        }\n    }\n\n    \/**\n     * This class was generated by MyBatis Generator.\n     * This class corresponds to the database table t_dept\n     *\n     * @mbggenerated do_not_delete_during_merge Wed Jan 04 16:17:13 CST 2023\n     *\/\n    public static class Criteria extends GeneratedCriteria {\n\n        protected Criteria() {\n            super();\n        }\n    }\n\n    \/**\n     * This class was generated by MyBatis Generator.\n     * This class corresponds to the database table t_dept\n     *\n     * @mbggenerated Wed Jan 04 16:17:13 CST 2023\n     *\/\n    public static class Criterion {\n        private String condition;\n\n        private Object value;\n\n        private Object secondValue;\n\n        private boolean noValue;\n\n        private boolean singleValue;\n\n        private boolean betweenValue;\n\n        private boolean listValue;\n\n        private String typeHandler;\n\n        public String getCondition() {\n            return condition;\n        }\n\n        public Object getValue() {\n            return value;\n        }\n\n        public Object getSecondValue() {\n            return secondValue;\n        }\n\n        public boolean isNoValue() {\n            return noValue;\n        }\n\n        public boolean isSingleValue() {\n            return singleValue;\n        }\n\n        public boolean isBetweenValue() {\n            return betweenValue;\n        }\n\n        public boolean isListValue() {\n            return listValue;\n        }\n\n        public String getTypeHandler() {\n            return typeHandler;\n        }\n\n        protected Criterion(String condition) {\n            super();\n            this.condition = condition;\n            this.typeHandler = null;\n            this.noValue = true;\n        }\n\n        protected Criterion(String condition, Object value, String typeHandler) {\n            super();\n            this.condition = condition;\n            this.value = value;\n            this.typeHandler = typeHandler;\n            if (value instanceof List<?>) {\n                this.listValue = true;\n            } else {\n                this.singleValue = true;\n            }\n        }\n\n        protected Criterion(String condition, Object value) {\n            this(condition, value, null);\n        }\n\n        protected Criterion(String condition, Object value, Object secondValue, String typeHandler) {\n            super();\n            this.condition = condition;\n            this.value = value;\n            this.secondValue = secondValue;\n            this.typeHandler = typeHandler;\n            this.betweenValue = true;\n        }\n\n        protected Criterion(String condition, Object value, Object secondValue) {\n            this(condition, value, secondValue, null);\n        }\n    }\n}<\/code><\/pre>\n\n\n\n
test<\/p>\n\n\n\n
MBGTest .java<\/strong><\/h3>\n\n\n\n
package top.qaqaq.mybatis.test;\n\nimport org.apache.ibatis.io.Resources;\nimport org.apache.ibatis.session.SqlSession;\nimport org.apache.ibatis.session.SqlSessionFactory;\nimport org.apache.ibatis.session.SqlSessionFactoryBuilder;\nimport org.junit.Test;\nimport top.qaqaq.mybatis.mapper.EmpMapper;\nimport top.qaqaq.mybatis.pojo.Emp;\nimport top.qaqaq.mybatis.pojo.EmpExample;\n\nimport java.io.IOException;\nimport java.io.InputStream;\nimport java.util.List;\n\npublic class MBGTest {\n\n    @Test\n    public void testMBG() {\n        try {\n            InputStream is = Resources.getResourceAsStream(\"mybatis-config.xml\");\n            SqlSessionFactory sqlSessionFactory = new SqlSessionFactoryBuilder().build(is);\n            SqlSession sqlSession = sqlSessionFactory.openSession(true);\n            EmpMapper mapper = sqlSession.getMapper(EmpMapper.class);\n\n            \/\/\u67e5\u8be2\u6240\u6709\u6570\u636e\n            \/\/List<Emp> list = mapper.selectByExample(null);\n            \/\/ist.forEach(emp -> System.out.println(emp));\n            \/\/System.out.println(\"********************************************************\");\n\n            \/\/\u6839\u636e\u6761\u4ef6\u67e5\u8be2\n            \/\/EmpExample example = new EmpExample();\n            \/\/example.createCriteria().andEmpNameEqualTo(\"\u5f20\u4e09\").andAgeGreaterThanOrEqualTo(20);\n            \/\/example.or().andDidIsNotNull();\n            \/\/List<Emp> list = mapper.selectByExample(example);\n            \/\/list.forEach(emp -> System.out.println(emp));\n\n            \/\/\u6839\u636e\u4e3b\u952e\u76f4\u63a5\u4fee\u6539\n            \/\/mapper.updateByPrimaryKey(new Emp(1,\"admin\",22,null,\"456@qq.com\",3));\n            \/\/\u6839\u636e\u4e3b\u952e\u9009\u62e9\u6027\u4fee\u6539\n            mapper.updateByPrimaryKeySelective(new Emp(1,\"admin\",22,null,\"456@qq.com\",3));\n        } catch (IOException e) {\n            throw new RuntimeException(e);\n        }\n    }\n\n}\n<\/code><\/pre>\n","protected":false},"excerpt":{"rendered":"
pom.xml resources mybatis-config.xml jdbc.properties lo […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[108],"tags":[111],"class_list":["post-3157","post","type-post","status-publish","format-standard","hentry","category-mybatis-code","tag-mybatis"],"_links":{"self":[{"href":"https:\/\/qaqaq.top\/index.php?rest_route=\/wp\/v2\/posts\/3157"}],"collection":[{"href":"https:\/\/qaqaq.top\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/qaqaq.top\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/qaqaq.top\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/qaqaq.top\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=3157"}],"version-history":[{"count":2,"href":"https:\/\/qaqaq.top\/index.php?rest_route=\/wp\/v2\/posts\/3157\/revisions"}],"predecessor-version":[{"id":3257,"href":"https:\/\/qaqaq.top\/index.php?rest_route=\/wp\/v2\/posts\/3157\/revisions\/3257"}],"wp:attachment":[{"href":"https:\/\/qaqaq.top\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=3157"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/qaqaq.top\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=3157"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/qaqaq.top\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=3157"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}