{"id":3161,"date":"2023-01-04T17:41:20","date_gmt":"2023-01-04T09:41:20","guid":{"rendered":"https:\/\/qaqaq.top\/?p=3161"},"modified":"2023-01-05T18:09:32","modified_gmt":"2023-01-05T10:09:32","slug":"%e5%88%86%e9%a1%b5%e6%8f%92%e4%bb%b6%e4%bb%a3%e7%a0%81","status":"publish","type":"post","link":"https:\/\/qaqaq.top\/?p=3161","title":{"rendered":"\u5206\u9875\u63d2\u4ef6\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>\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    <dependency>\n      <groupId>com.github.pagehelper<\/groupId>\n      <artifactId>pagehelper<\/artifactId>\n      <version>5.2.0<\/version>\n    <\/dependency><\/strong>\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>\n\n<\/project>\n<\/code><\/pre>\n\n\n\n
resources<\/p>\n\n\n\n
mybatis-config.xml<\/h3>\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    <plugins>\n        <!--\u8bbe\u7f6e\u5206\u9875\u63d2\u4ef6-->\n        <plugin interceptor=\"com.github.pagehelper.PageInterceptor\"><\/plugin>\n    <\/plugins><\/strong>\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<\/p>\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
DeptMapper.xml\uff08\u81ea\u52a8\u751f\u6210\uff09<\/p>\n\n\n\n
******************************************************************<\/p>\n\n\n\n
mapper<\/p>\n\n\n\n
EmpMapper .java\uff08\u81ea\u52a8\u751f\u6210\uff09<\/p>\n\n\n\n
DeptMapper .java\uff08\u81ea\u52a8\u751f\u6210\uff09<\/p>\n\n\n\n
******************************************************************<\/p>\n\n\n\n
pojo<\/p>\n\n\n\n
Emp .java\uff08\u81ea\u52a8\u751f\u6210\uff09<\/p>\n\n\n\n
EmpExample.java\uff08\u81ea\u52a8\u751f\u6210\uff09<\/p>\n\n\n\n
Dept.java\uff08\u81ea\u52a8\u751f\u6210\uff09<\/p>\n\n\n\n
DeptExample.java\uff08\u81ea\u52a8\u751f\u6210\uff09<\/p>\n\n\n\n
******************************************************************<\/p>\n\n\n\n
test<\/p>\n\n\n\n
PageHelperTest .java<\/strong><\/h3>\n\n\n\n
package top.qaqaq.mybatis.test;\n\nimport com.github.pagehelper.Page;\nimport com.github.pagehelper.PageHelper;\nimport com.github.pagehelper.PageInfo;\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;\n\nimport java.io.IOException;\nimport java.io.InputStream;\nimport java.util.List;\n\npublic class PageHelperTest {\n\n    \/**\n     * limit index,pageSize\n     * index: \u5f53\u524d\u9875\u7684\u8d77\u59cb\u7d22\u5f15\n     * pageSize: \u6bcf\u9875\u663e\u793a\u7684\u6761\u6570\n     * pageNum: \u5f53\u524d\u9875\u7684\u9875\u7801\n     * index=(pageNum-1)*pageSize\n     *\n     * \u4f7f\u7528MyBatis\u7684\u5206\u9875\u63d2\u4ef6\u5b9e\u73b0\u5206\u9875\u529f\u80fd\n     * 1\u3001\u9700\u8981\u5728\u67e5\u8be2\u529f\u80fd\u4e4b\u524d\u5f00\u542f\u5206\u9875\n     * PageHelper.startPage(int pageNum, int pageSize);\n     * 2\u3001\u5728\u67e5\u8be2\u529f\u80fd\u4e4b\u540e\u83b7\u53d6\u5206\u9875\u76f8\u5173\u4fe1\u606f\n     * PageInfo<Emp> page = new PageInfo<>(list, 5);\n     * list\u8868\u793a\u5206\u9875\u6570\u636e\n     * 5\u8868\u793a\u5f53\u524d\u5bfc\u822a\u5206\u9875\u7684\u6570\u91cf\n     *\/\n\n    @Test\n    public void testPageHelper() {\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            \/\/Page<Object> page = PageHelper.startPage(1, 4);\n            PageHelper.startPage(1, 4);\n            List<Emp> list = mapper.selectByExample(null);\n            PageInfo<Emp> page = new PageInfo<>(list, 5);\n            \/\/list.forEach(emp -> System.out.println(emp));\n            System.out.println(page);\n        } catch (IOException e) {\n            throw new RuntimeException(e);\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-3161","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\/3161"}],"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=3161"}],"version-history":[{"count":2,"href":"https:\/\/qaqaq.top\/index.php?rest_route=\/wp\/v2\/posts\/3161\/revisions"}],"predecessor-version":[{"id":3256,"href":"https:\/\/qaqaq.top\/index.php?rest_route=\/wp\/v2\/posts\/3161\/revisions\/3256"}],"wp:attachment":[{"href":"https:\/\/qaqaq.top\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=3161"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/qaqaq.top\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=3161"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/qaqaq.top\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=3161"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}