pom.xml<\/p>\n\n\n\n
<project xmlns=\"http:\/\/maven.apache.org\/POM\/4.0.0\" xmlns:xsi=\"http:\/\/www.w3.org\/2001\/XMLSchema-instance\"\r\n xsi:schemaLocation=\"http:\/\/maven.apache.org\/POM\/4.0.0 http:\/\/maven.apache.org\/xsd\/maven-4.0.0.xsd\">\r\n <modelVersion>4.0.0<\/modelVersion>\r\n\r\n <groupId>top.qaqaq.mybatis<\/groupId>\r\n <artifactId>MyBatis_demo3<\/artifactId>\r\n <version>1.0-SNAPSHOT<\/version>\r\n <packaging>jar<\/packaging>\r\n\r\n <name>MyBatis_demo3<\/name>\r\n <url>http:\/\/maven.apache.org<\/url>\r\n\r\n <properties>\r\n <project.build.sourceEncoding>UTF-8<\/project.build.sourceEncoding>\r\n <\/properties>\r\n\r\n <dependencies>\r\n <dependency>\r\n <groupId>junit<\/groupId>\r\n <artifactId>junit<\/artifactId>\r\n <version>3.8.1<\/version>\r\n <scope>test<\/scope>\r\n <\/dependency>\r\n\r\n <!-- Mybatis\u6838\u5fc3 -->\r\n <dependency>\r\n <groupId>org.mybatis<\/groupId>\r\n <artifactId>mybatis<\/artifactId>\r\n <version>3.5.7<\/version>\r\n <\/dependency>\r\n <!-- junit\u6d4b\u8bd5 -->\r\n <dependency>\r\n <groupId>junit<\/groupId>\r\n <artifactId>junit<\/artifactId>\r\n <version>4.12<\/version>\r\n <scope>test<\/scope>\r\n <\/dependency>\r\n <!-- MySQL\u9a71\u52a8 -->\r\n <dependency>\r\n <groupId>mysql<\/groupId>\r\n <artifactId>mysql-connector-java<\/artifactId>\r\n <version>8.0.31<\/version>\r\n <\/dependency>\r\n <!-- log4j\u65e5\u5fd7 -->\r\n <dependency>\r\n <groupId>log4j<\/groupId>\r\n <artifactId>log4j<\/artifactId>\r\n <version>1.2.17<\/version>\r\n <\/dependency>\r\n\r\n <\/dependencies>\r\n<\/project>\r\n<\/code><\/pre>\n\n\n\nresources<\/p>\n\n\n\n
mybatis-config.xml<\/p>\n\n\n\n
<?xml version=\"1.0\" encoding=\"UTF-8\" ?>\r\n<!DOCTYPE configuration\r\n PUBLIC \"-\/\/mybatis.org\/\/DTD Config 3.0\/\/EN\"\r\n \"http:\/\/mybatis.org\/dtd\/mybatis-3-config.dtd\">\r\n<configuration>\r\n\r\n <properties resource=\"jdbc.properties\"\/>\r\n\r\n <!--\u8bbe\u7f6eMyBatis\u7684\u5168\u5c40\u914d\u7f6e-->\r\n <settings>\r\n <!--\u5c06_\u81ea\u52a8\u6620\u5c04\u4e3a\u9a7c\u5cf0\uff0cemp_name:empName-->\r\n <setting name=\"mapUnderscoreToCamelCase\" value=\"true\"\/>\r\n <!--\u5f00\u542f\u5ef6\u8fdf\u52a0\u8f7d-->\r\n <setting name=\"lazyLoadingEnabled\" value=\"true\"\/>\r\n <\/settings>\r\n\r\n <typeAliases>\r\n <package name=\"top.qaqaq.mybatis.pojo\"\/>\r\n <\/typeAliases>\r\n\r\n <environments default=\"development\">\r\n <environment id=\"development\">\r\n <transactionManager type=\"JDBC\"\/>\r\n <dataSource type=\"POOLED\">\r\n <property name=\"driver\" value=\"${jdbc.driver}\"\/>\r\n <property name=\"url\" value=\"${jdbc.url}\"\/>\r\n <property name=\"username\" value=\"${jdbc.username}\"\/>\r\n <property name=\"password\" value=\"${jdbc.password}\"\/>\r\n <\/dataSource>\r\n <\/environment>\r\n <\/environments>\r\n\r\n <mappers>\r\n <package name=\"top.qaqaq.mybatis.mapper\"\/>\r\n <\/mappers>\r\n<\/configuration><\/code><\/pre>\n\n\n\njdbc.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\n<\/code><\/pre>\n\n\n\nlog4j.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\nresources\/mapper<\/p>\n\n\n\n
DynamicSQLMapper.xml<\/strong><\/h3>\n\n\n\n<?xml version=\"1.0\" encoding=\"UTF-8\" ?>\r\n<!DOCTYPE mapper\r\n PUBLIC \"-\/\/mybatis.org\/\/DTD Mapper 3.0\/\/EN\"\r\n \"http:\/\/mybatis.org\/dtd\/mybatis-3-mapper.dtd\">\r\n<mapper namespace=\"top.qaqaq.mybatis.mapper.DynamicSQLMapper\">\r\n\r\n <!--int insertMoreByList(List<Emp> emps);-->\r\n <insert id=\"insertMoreByList\">\r\n insert into t_emp values\r\n <foreach collection=\"emps\" item=\"emp\" separator=\",\">\r\n (null,#{emp.empName},#{emp.age},#{emp.sex},#{emp.email},null)\r\n <\/foreach>\r\n <\/insert>\r\n \r\n <!--int deleteMoreByArray(@Param(\"eids\") Integer[] eids);-->\r\n <delete id=\"deleteMoreByArray\">\r\n delete from t_emp where\r\n <foreach collection=\"eids\" item=\"eid\" separator=\"or\">\r\n eid = #{eid}\r\n <\/foreach>\r\n <\/delete>\r\n\r\n <delete id=\"deleteMoreByArrayOne\">\r\n delete from t_emp where eid in\r\n <foreach collection=\"eids\" item=\"eid\" separator=\",\" open=\"(\" close=\")\">\r\n #{eid}\r\n <\/foreach>\r\n <\/delete>\r\n\r\n <!--List<Emp> getEmpByChoose(Emp emp);-->\r\n <select id=\"getEmpByChoose\" resultType=\"Emp\">\r\n select * from t_emp\r\n <where>\r\n <choose>\r\n <when test=\"empName != null and empName != ''\">\r\n emp_name = #{empName}\r\n <\/when>\r\n <when test=\"age != null and age != ''\">\r\n age = #{age}\r\n <\/when>\r\n <when test=\"sex != null and sex != ''\">\r\n sex = #{sex}\r\n <\/when>\r\n <when test=\"email != null and email != ''\">\r\n email = #{email}\r\n <\/when>\r\n <otherwise>\r\n did = 1\r\n <\/otherwise>\r\n <\/choose>\r\n <\/where>\r\n <\/select>\r\n\r\n <sql id=\"empColumns\">eid,emp_name,age,sex,email<\/sql>\r\n\r\n <!--List<Emp> getEmpByCondition(Emp emp);-->\r\n <select id=\"getEmpByCondition\" resultType=\"Emp\">\r\n select <include refid=\"empColumns\"><\/include> from t_emp\r\n <trim prefix=\"where\" suffixOverrides=\"and|or\">\r\n <if test=\"empName != null and empName != ''\">\r\n emp_name = #{empName} and\r\n <\/if>\r\n <if test=\"age != null and age != ''\">\r\n age = #{age} or\r\n <\/if>\r\n <if test=\"sex != null and sex != ''\">\r\n sex = #{sex} and\r\n <\/if>\r\n <if test=\"email != null and email != ''\">\r\n email = #{email}\r\n <\/if>\r\n <\/trim>\r\n\r\n <\/select>\r\n\r\n <select id=\"getEmpByConditionTwo\" resultType=\"Emp\">\r\n select * from t_emp\r\n <where>\r\n <if test=\"empName != null and empName != ''\">\r\n emp_name = #{empName}\r\n <\/if>\r\n <if test=\"age != null and age != ''\">\r\n and age = #{age}\r\n <\/if>\r\n <if test=\"sex != null and sex != ''\">\r\n or sex = #{sex}\r\n <\/if>\r\n <if test=\"email != null and email != ''\">\r\n and email = #{email}\r\n <\/if>\r\n <\/where>\r\n\r\n <\/select>\r\n\r\n <select id=\"getEmpByConditionOne\" resultType=\"Emp\">\r\n select * from t_emp where 1=1\r\n <if test=\"empName != null and empName != ''\">\r\n emp_name = #{empName}\r\n <\/if>\r\n <if test=\"age != null and age != ''\">\r\n and age = #{age}\r\n <\/if>\r\n <if test=\"sex != null and sex != ''\">\r\n and sex = #{sex}\r\n <\/if>\r\n <if test=\"email != null and email != ''\">\r\n and email = #{email}\r\n <\/if>\r\n <\/select>\r\n\r\n<\/mapper><\/code><\/pre>\n\n\n\nmapper<\/p>\n\n\n\n
DynamicSQLMapper .java<\/strong><\/h3>\n\n\n\npackage top.qaqaq.mybatis.mapper;\r\n\r\nimport org.apache.ibatis.annotations.Param;\r\nimport top.qaqaq.mybatis.pojo.Emp;\r\n\r\nimport java.util.List;\r\n\r\npublic interface DynamicSQLMapper {\r\n\r\n \/**\r\n * \u591a\u6761\u4ef6\u67e5\u8be2\r\n *\/\r\n List<Emp> getEmpByCondition(Emp emp);\r\n\r\n \/**\r\n * \u6d4b\u8bd5choose\u3001when\u3001otherwise\r\n *\/\r\n List<Emp> getEmpByChoose(Emp emp);\r\n\r\n \/**\r\n * \u901a\u8fc7\u6570\u7ec4\u5b9e\u73b0\u6279\u91cf\u5220\u9664\r\n *\/\r\n int deleteMoreByArray(@Param(\"eids\") Integer[] eids);\r\n\r\n \/**\r\n * \u901a\u8fc7list\u96c6\u5408\u5b9e\u73b0\u6279\u91cf\u6dfb\u52a0\r\n *\/\r\n int insertMoreByList(@Param(\"emps\") List<Emp> emps);\r\n}\r\n<\/code><\/pre>\n\n\n\npojo<\/p>\n\n\n\n
Emp .java<\/p>\n\n\n\n
package top.qaqaq.mybatis.pojo;\n\npublic class Emp {\n\n private Integer eid;\n private String empName;\n private Integer age;\n private String sex;\n private String email;\n private Dept dept;\n\n public Emp() {\n }\n\n public Emp(Integer eid, String empName, Integer age, String sex, String email) {\n this.eid = eid;\n this.empName = empName;\n this.age = age;\n this.sex = sex;\n this.email = email;\n }\n\n public Integer getEid() {\n return eid;\n }\n\n public void setEid(Integer eid) {\n this.eid = eid;\n }\n\n public String getEmpName() {\n return empName;\n }\n\n public void setEmpName(String empName) {\n this.empName = empName;\n }\n\n public Integer getAge() {\n return age;\n }\n\n public void setAge(Integer age) {\n this.age = age;\n }\n\n public String getSex() {\n return sex;\n }\n\n public void setSex(String sex) {\n this.sex = sex;\n }\n\n public String getEmail() {\n return email;\n }\n\n public void setEmail(String email) {\n this.email = email;\n }\n\n public Dept getDept() {\n return dept;\n }\n\n public void setDept(Dept dept) {\n this.dept = dept;\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 \", dept=\" + dept +\n '}';\n }\n\n}\n<\/code><\/pre>\n\n\n\nutils<\/p>\n\n\n\n
SqlSessionUtils .java<\/p>\n\n\n\n
package top.qaqaq.mybatis.utils;\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;\n\nimport java.io.IOException;\nimport java.io.InputStream;\n\npublic class SqlSessionUtils {\n\n public static SqlSession getSqlSession() {\n SqlSession sqlSession = null;\n try {\n InputStream is = Resources.getResourceAsStream(\"mybatis-config.xml\");\n SqlSessionFactory sqlSessionFactory = new SqlSessionFactoryBuilder().build(is);\n sqlSession = sqlSessionFactory.openSession(true);\n } catch (IOException e) {\n throw new RuntimeException(e);\n }\n return sqlSession;\n }\n}\n<\/code><\/pre>\n\n\n\ntest<\/p>\n\n\n\n
DynamicSQLMapperTest .java<\/strong><\/h3>\n\n\n\npackage top.qaqaq.mybatis.test;\r\n\r\nimport org.apache.ibatis.session.SqlSession;\r\nimport org.junit.Test;\r\nimport top.qaqaq.mybatis.mapper.DynamicSQLMapper;\r\nimport top.qaqaq.mybatis.pojo.Emp;\r\nimport top.qaqaq.mybatis.utils.SqlSessionUtils;\r\n\r\nimport java.util.Arrays;\r\nimport java.util.List;\r\n\r\npublic class DynamicSQLMapperTest {\r\n\r\n \/**\r\n * \u52a8\u6001SQL\uff1a\r\n * 1\u3001if\uff1a\u6839\u636e\u6807\u7b7e\u4e2dtest\u5c5e\u6027\u6240\u5bf9\u5e94\u7684\u8868\u8fbe\u5f0f\u51b3\u5b9a\u6807\u7b7e\u4e2d\u7684\u5185\u5bb9\u662f\u5426\u9700\u8981\u62fc\u63a5\u5230SQL\u4e2d\r\n * 2\u3001where\uff1a\r\n * \u5f53where\u6807\u7b7e\u4e2d\u6709\u5185\u5bb9\u65f6\uff0c\u4f1a\u81ea\u52a8\u751f\u6210where\u5173\u952e\u5b57\uff0c\u5e76\u4e14\u5c06\u5185\u5bb9\u524d\u591a\u4f59\u7684and \u6216 or \u53bb\u6389\r\n * \u5f53where\u6807\u7b7e\u4e2d\u6ca1\u6709\u5185\u5bb9\u65f6\uff0c\u6b64\u65f6where\u6807\u7b7e\u6ca1\u6709\u4efb\u4f55\u6548\u679c\r\n * \u6ce8\u610f\uff1awhere\u6807\u7b7e\u4e0d\u80fd\u5c06\u5176\u4e2d\u5185\u5bb9\u540e\u9762\u591a\u4f59\u7684 and \u6216 or \u53bb\u6389\r\n * 3\u3001trim\uff1a\r\n * \u82e5\u6807\u7b7e\u4e2d\u6709\u5185\u5bb9\u65f6\uff1a\r\n * prefix|suffix\uff1a\u5c06trim\u6807\u7b7e\u4e2d\u5185\u5bb9\u524d\u9762\u6216\u540e\u9762\u6dfb\u52a0\u6307\u5b9a\u5185\u5bb9\r\n * prefixOverrides|suffixOverrides\uff1a\u5c06trim\u6807\u7b7e\u4e2d\u5185\u5bb9\u524d\u9762\u6216\u540e\u9762\u53bb\u6389\u6307\u5b9a\u5185\u5bb9\r\n * \u82e5\u6807\u7b7e\u4e2d\u6ca1\u6709\u5185\u5bb9\u65f6\uff0ctrim\u6807\u7b7e\u4e5f\u6ca1\u6709\u4efb\u4f55\u6548\u679c\r\n * 4\u3001choose\u3001when\u3001otherwise\uff0c\u76f8\u5f53\u4e8eif...else if...else\r\n * when\u81f3\u5c11\u8981\u6709\u4e00\u4e2a\uff0cotherwise\u6700\u591a\u53ea\u80fd\u6709\u4e00\u4e2a\r\n * 5\u3001foreach\r\n * collection\uff1a\u8bbe\u7f6e\u9700\u8981\u5faa\u73af\u7684\u6570\u7ec4\u6216\u96c6\u5408\r\n * item\uff1a\u8868\u793a\u6570\u7ec4\u6216\u96c6\u5408\u4e2d\u7684\u6bcf\u4e00\u4e2a\u6570\u636e\r\n * separator\uff1a\u5faa\u73af\u4f53\u4e4b\u95f4\u7684\u5206\u5272\u7b26\r\n * open\uff1aforeach\u6807\u7b7e\u6240\u5faa\u73af\u7684\u6240\u6709\u5185\u5bb9\u7684\u5f00\u59cb\u7b26\r\n * close\uff1aforeach\u6807\u7b7e\u6240\u5faa\u73af\u7684\u6240\u6709\u5185\u5bb9\u7684\u7ed3\u675f\u7b26\r\n * 6\u3001sql\u6807\u7b7e\r\n * \u8bbe\u7f6eSQL\u7247\u6bb5\uff1a<sql id=\"empColumns\">eid,emp_name,age,sex,email<\/sql>\r\n * \u5f15\u7528SQL\u7247\u6bb5\uff1a<include refid=\"empColumns\"><\/include>\r\n *\/\r\n\r\n @Test\r\n public void testInsertMoreByList() {\r\n SqlSession sqlSession = SqlSessionUtils.getSqlSession();\r\n DynamicSQLMapper mapper = sqlSession.getMapper(DynamicSQLMapper.class);\r\n Emp emp1 = new Emp(null, \"a1\", 23, \"\u7537\", \"123@qq.com\");\r\n Emp emp2 = new Emp(null, \"a2\", 23, \"\u7537\", \"123@qq.com\");\r\n Emp emp3 = new Emp(null, \"a3\", 23, \"\u7537\", \"123@qq.com\");\r\n List<Emp> emps = Arrays.asList(emp1, emp2, emp3);\r\n System.out.println(mapper.insertMoreByList(emps));\r\n }\r\n\r\n @Test\r\n public void testDeleteMoreByArray() {\r\n SqlSession sqlSession = SqlSessionUtils.getSqlSession();\r\n DynamicSQLMapper mapper = sqlSession.getMapper(DynamicSQLMapper.class);\r\n int result = mapper.deleteMoreByArray(new Integer[]{6, 7, 8});\r\n System.out.println(result);\r\n }\r\n\r\n @Test\r\n public void testGetEmpByChoose() {\r\n SqlSession sqlSession = SqlSessionUtils.getSqlSession();\r\n DynamicSQLMapper mapper = sqlSession.getMapper(DynamicSQLMapper.class);\r\n List<Emp> list = mapper.getEmpByChoose(new Emp(null, \"\", null, \"\", \"\"));\r\n System.out.println(list);\r\n }\r\n\r\n @Test\r\n public void testGetEmpByCondition() {\r\n SqlSession sqlSession = SqlSessionUtils.getSqlSession();\r\n DynamicSQLMapper mapper = sqlSession.getMapper(DynamicSQLMapper.class);\r\n List<Emp> list = mapper.getEmpByCondition(new Emp(null, \"\", null, \"\", null));\r\n System.out.println(list);\r\n }\r\n}\r\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-3116","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\/3116"}],"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=3116"}],"version-history":[{"count":1,"href":"https:\/\/qaqaq.top\/index.php?rest_route=\/wp\/v2\/posts\/3116\/revisions"}],"predecessor-version":[{"id":3117,"href":"https:\/\/qaqaq.top\/index.php?rest_route=\/wp\/v2\/posts\/3116\/revisions\/3117"}],"wp:attachment":[{"href":"https:\/\/qaqaq.top\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=3116"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/qaqaq.top\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=3116"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/qaqaq.top\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=3116"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}