pom.xml\u589e\u52a0\u5982\u4e0b\u4f9d\u8d56\uff1a<\/p>\n\n\n\n
<!--MyBatis\u7684\u6574\u5408-->\n <!-- https:\/\/mvnrepository.com\/artifact\/org.mybatis.spring.boot\/mybatis-spring-boot-starter -->\n <dependency>\n <groupId>org.mybatis.spring.boot<\/groupId>\n <artifactId>mybatis-spring-boot-starter<\/artifactId>\n <version>2.2.2<\/version>\n <\/dependency>\n <!-- https:\/\/mvnrepository.com\/artifact\/mysql\/mysql-connector-java -->\n <dependency>\n <groupId>mysql<\/groupId>\n <artifactId>mysql-connector-java<\/artifactId>\n <version>8.0.33<\/version>\n <\/dependency>\n <!-- https:\/\/mvnrepository.com\/artifact\/junit\/junit -->\n <dependency>\n <groupId>junit<\/groupId>\n <artifactId>junit<\/artifactId>\n <version>4.13<\/version>\n <scope>test<\/scope>\n <\/dependency>\n <!-- https:\/\/mvnrepository.com\/artifact\/com.alibaba\/druid-spring-boot-starter -->\n <dependency>\n <groupId>com.alibaba<\/groupId>\n <artifactId>druid-spring-boot-starter<\/artifactId>\n <version>1.2.17<\/version>\n <\/dependency><\/pre>\n\n\n\napplication.properties\u6587\u4ef6\u589e\u52a0\u5982\u4e0b\u914d\u7f6e\uff1a<\/p>\n\n\n\n
spring.datasource.url=jdbc:mysql:\/\/localhost:3306\/sway-doctor-service-user\nspring.datasource.username=root\nspring.datasource.password=\nspring.datasource.driver-class-name=com.mysql.cj.jdbc.Driver\n\n# \u6dfb\u52a0\u5e76\u914d\u7f6e\u7b2c\u4e09\u65b9\u6570\u636e\u6e90Druid\n# \u6570\u636e\u6e90\u7c7b\u578b\nspring.datasource.type=com.alibaba.druid.pool.DruidDataSource\n# \u521d\u59cb\u5316\u8fde\u63a5\u6570\nspring.datasource.initialSize=20\n# \u6700\u5c0f\u7a7a\u95f2\u6570\nspring.datasource.minIdle=10\n# \u6700\u5927\u8fde\u63a5\u6570\nspring.datasource.maxActive=100\n\n# \u914d\u7f6eMyBatis\u7684XML\u914d\u7f6e\u6587\u4ef6\u4f4d\u7f6e\nmybatis.mapper-locations = classpath:mapper\/*.xml\n# \u914d\u7f6eXML\u6620\u5c04\u6587\u4ef6\u4e2d\u6307\u5b9a\u7684\u5b9e\u4f53\u7c7b\u522b\u540d\u8def\u5f84\n#mybatis.type-aliases-package = cn.com.sway.doctor.service.common\n# \u5f00\u542f\u9a7c\u5cf0\u547d\u540d\u5339\u914d\u6620\u5c04\nmybatis.configuration.map-underscore-to-camel-case=true\n#mybatis.configuration.log-impl = org.apache.ibatis.logging.stdout.StdOutImpl<\/pre>\n\n\n\n\u7f16\u5199DataSourceConfig.java\u6570\u636e\u6e90\u914d\u7f6e\u6587\u4ef6\uff0c\u4ee3\u7801\u5982\u4e0b\uff1a<\/p>\n\n\n\n
package cn.com.sway.doctor.service.user.config;\n\nimport com.alibaba.druid.pool.DruidDataSource;\nimport org.springframework.boot.context.properties.ConfigurationProperties;\nimport org.springframework.context.annotation.Bean;\nimport org.springframework.context.annotation.Configuration;\n\nimport javax.sql.DataSource;\n\n@Configuration\npublic class DataSourceConfig {\n @Bean\n @ConfigurationProperties(prefix = \"spring.datasource\")\n public DataSource getDruid() {\n return new DruidDataSource();\n }\n}<\/pre>\n\n\n\n\u7f16\u5199\u5b9e\u4f53Account.java\u6587\u4ef6\uff0c\u4ee3\u7801\u5982\u4e0b\uff1a<\/p>\n\n\n\n
package cn.com.sway.doctor.service.common.model;\n\nimport lombok.Data;\n\n@Data\npublic class Account {\n\n private String id;\n private String mobile;\n private String password;\n private String name;\n\n}\n<\/pre>\n\n\n\n\u7f16\u5199\u67e5\u8be2\u7528\u989dAccountQuery.java\u6587\u4ef6\uff0c\u4ee3\u7801\u5982\u4e0b\uff1a<\/p>\n\n\n\n
package cn.com.sway.doctor.service.common.query;\n\nimport lombok.Data;\n\nimport javax.validation.constraints.Min;\nimport javax.validation.constraints.Pattern;\n\n@Data\npublic class AccountQuery {\n\n private String id;\n\n @Pattern(regexp = \"1\\\\d{10}\", message = \"\u8bf7\u8f93\u5165\u6b63\u786e\u7684\u624b\u673a\u53f7\u554a\")\n private String mobile;\n\n private String password;\n\n @Min(value = 0, message = \"offset\u4e0d\u80fd\u4e3a\u8d1f\u6570\")\n private Integer offset;\n\n @Min(value = 0, message = \"limit\u4e0d\u80fd\u4e3a\u8d1f\u6570\")\n private Integer limit;\n\n}<\/pre>\n\n\n\n\u7f16\u5199AccountDao.java\u6587\u4ef6\uff0c\u4ee3\u7801\u5982\u4e0b\uff1a<\/p>\n\n\n\n
package cn.com.sway.doctor.service.user.dao;\n\nimport cn.com.sway.doctor.service.common.model.Account;\nimport cn.com.sway.doctor.service.common.query.AccountQuery;\nimport org.apache.ibatis.annotations.Mapper;\nimport org.springframework.validation.annotation.Validated;\n\nimport java.util.List;\n\n@Mapper\npublic interface AccountDao {\n\n List<Account> query(@Validated AccountQuery accountQuery);\n\n}\n<\/pre>\n\n\n\n\u7f16\u5199AccountMapper.xml\uff0c\u4ee3\u7801\u5982\u4e0b\uff1a<\/p>\n\n\n\n
<?xml version=\"1.0\" encoding=\"UTF-8\" ?>\n<!DOCTYPE mapper\n PUBLIC \"-\/\/mybatis.org\/\/DTD Mapper 3.0\/\/EN\"\n \"http:\/\/mybatis.org\/dtd\/mybatis-3-mapper.dtd\">\n\n<mapper namespace=\"cn.com.sway.doctor.service.user.dao.AccountDao\">\n\n <resultMap id=\"account\" type=\"cn.com.sway.doctor.service.common.model.Account\">\n <id property=\"id\" column=\"id\"\/>\n <result property=\"mobile\" column=\"mobile\"\/>\n <result property=\"name\" column=\"name\"\/>\n <\/resultMap>\n\n <!-- \u67e5\u8be2\u8d26\u53f7\u5217\u8868 -->\n <select id=\"query\" resultMap=\"account\">\n SELECT * FROM account\n <where>\n <if test=\"mobile!=null and mobile!=''\">\n and mobile = #{mobile}\n <\/if>\n <\/where>\n <\/select>\n\n<\/mapper><\/pre>\n\n\n\n\u7f16\u5199\u5355\u5143\u6d4b\uff0c\u4ee3\u7801\u5982\u4e0b\uff1a<\/p>\n\n\n\n
package cn.com.sway.doctor.service.user;\n\nimport cn.com.sway.doctor.service.common.query.AccountQuery;\nimport cn.com.sway.doctor.service.user.dao.AccountDao;\nimport org.junit.jupiter.api.Test;\nimport org.springframework.beans.factory.annotation.Autowired;\nimport org.springframework.boot.test.context.SpringBootTest;\n\n@SpringBootTest\nclass ServiceUserApplicationTests {\n\n @Autowired\n private AccountDao accountDao;\n\n @Test\n public void testAccountMapper(){\n AccountQuery accountQuery = new AccountQuery();\n accountQuery.setMobile(\"18688814832\");\n System.out.println(accountDao.query(accountQuery).size());\n }\n\n}\n<\/pre>\n","protected":false},"excerpt":{"rendered":"pom.xml\u589e\u52a0\u5982\u4e0b\u4f9d\u8d56\uff1a application.properties\u6587\u4ef6\u589e\u52a0\u5982\u4e0b\u914d\u7f6e\uff1a \u7f16\u5199DataSo […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[],"class_list":["post-1067","post","type-post","status-publish","format-standard","hentry","category-uncategorized"],"_links":{"self":[{"href":"http:\/\/blog.sway.com.cn\/index.php?rest_route=\/wp\/v2\/posts\/1067","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/blog.sway.com.cn\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/blog.sway.com.cn\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/blog.sway.com.cn\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/blog.sway.com.cn\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=1067"}],"version-history":[{"count":2,"href":"http:\/\/blog.sway.com.cn\/index.php?rest_route=\/wp\/v2\/posts\/1067\/revisions"}],"predecessor-version":[{"id":1069,"href":"http:\/\/blog.sway.com.cn\/index.php?rest_route=\/wp\/v2\/posts\/1067\/revisions\/1069"}],"wp:attachment":[{"href":"http:\/\/blog.sway.com.cn\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1067"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/blog.sway.com.cn\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1067"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/blog.sway.com.cn\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1067"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}