GitHub – mybatis-mapper\/mapper: MyBatis Mapper<\/a><\/p>\n\n\n\n\u4e00\u952e\u751f\u6210\u6b65\u9aa4<\/h2>\n\n\n\nSQL<\/h3>\n\n\n\n
\u6570\u636e\u5e93\u540d\uff1aspringcloud<\/p>\n\n\n\n
# MySQL \u7248\u672c
SELECT VERSION<\/em>();
# SpringCloud \u7528
DROP TABLE IF EXISTS `t_pay`;
CREATE TABLE `t_pay`
(
`id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
`pay_no` VARCHAR(50) NOT NULL COMMENT '\u652f\u4ed8\u6d41\u6c34\u53f7',
`order_no` VARCHAR(50) NOT NULL COMMENT '\u8ba2\u5355\u6d41\u6c34\u53f7',
`user_id` INT(10) DEFAULT '1' COMMENT '\u7528\u6237\u8d26\u53f7ID',
`amount` DECIMAL(8, 2) NOT NULL DEFAULT '9.9' COMMENT '\u4ea4\u6613\u91d1\u989d',
`deleted` TINYINT(4) UNSIGNED NOT NULL DEFAULT '0' COMMENT '\u5220\u9664\u6807\u5fd7\uff0c\u9ed8\u8ba40\u4e0d\u5220\u9664\uff0c1\u5220\u9664',
`create_time` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP <\/em>COMMENT '\u521b\u5efa\u65f6\u95f4',
`update_time` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP <\/em>ON UPDATE CURRENT_TIMESTAMP <\/em>COMMENT '\u66f4\u65b0\u65f6\u95f4',
PRIMARY KEY (`id`)
) ENGINE = INNODB
AUTO_INCREMENT = 1
DEFAULT CHARSET = utf8mb4 COMMENT ='\u652f\u4ed8\u4ea4\u6613\u8868';
INSERT INTO t_pay(pay_no, order_no)
VALUES ('pay17203699', '6544bafb424a');
SELECT *
FROM t_pay;<\/code><\/pre>\n\n\n\nModule<\/h3>\n\n\n\n
\u666e\u901aMaven\u5de5\u7a0b<\/p>\n\n\n\n
mybatis-generator<\/p>\n\n\n\n![\"\"](\"data:image\/svg+xml;base64,PCEtLUFyZ29uTG9hZGluZy0tPgo8c3ZnIHdpZHRoPSIxIiBoZWlnaHQ9IjEiIHhtbG5zPSJodHRwOi8vd3d3LnczLm9yZy8yMDAwL3N2ZyIgc3Ryb2tlPSIjZmZmZmZmMDAiPjxnPjwvZz4KPC9zdmc+\")
<\/div><\/figure>\n\n\n\n
POM<\/h3>\n\n\n\n <!--\u6211\u81ea\u5df1\u72ec\u4e00\u4efd\uff0c\u53ea\u662f\u4e00\u4e2a\u666e\u901aMaven\u5de5\u7a0b\uff0c\u4e0eboot\u548ccloud\u65e0\u5173-->\n <artifactId>mybatis-generator<\/artifactId>\n\n <properties>\n <maven.compiler.source>17<\/maven.compiler.source>\n <maven.compiler.target>17<\/maven.compiler.target>\n <project.build.sourceEncoding>UTF-8<\/project.build.sourceEncoding>\n <\/properties>\n\n <dependencies>\n <!--Mybatis \u901a\u7528mapper tk\u5355\u72ec\u4f7f\u7528\uff0c\u81ea\u5df1\u72ec\u6709+\u81ea\u5e26\u7248\u672c\u53f7-->\n <dependency>\n <groupId>org.mybatis<\/groupId>\n <artifactId>mybatis<\/artifactId>\n <version>3.5.13<\/version>\n <\/dependency>\n <!-- Mybatis Generator \u81ea\u5df1\u72ec\u6709+\u81ea\u5e26\u7248\u672c\u53f7-->\n <dependency>\n <groupId>org.mybatis.generator<\/groupId>\n <artifactId>mybatis-generator-core<\/artifactId>\n <version>1.4.2<\/version>\n <\/dependency>\n <!--\u901a\u7528Mapper-->\n <dependency>\n <groupId>tk.mybatis<\/groupId>\n <artifactId>mapper<\/artifactId>\n <\/dependency>\n <!--mysql8.0-->\n <dependency>\n <groupId>mysql<\/groupId>\n <artifactId>mysql-connector-java<\/artifactId>\n <\/dependency>\n <!--persistence-->\n <dependency>\n <groupId>javax.persistence<\/groupId>\n <artifactId>persistence-api<\/artifactId>\n <\/dependency>\n <!--hutool-->\n <dependency>\n <groupId>cn.hutool<\/groupId>\n <artifactId>hutool-all<\/artifactId>\n <\/dependency>\n <!--lombok-->\n <dependency>\n <groupId>org.projectlombok<\/groupId>\n <artifactId>lombok<\/artifactId>\n <optional>true<\/optional>\n <\/dependency>\n <dependency>\n <groupId>org.springframework.boot<\/groupId>\n <artifactId>spring-boot-starter-test<\/artifactId>\n <scope>test<\/scope>\n <exclusions>\n <exclusion>\n <groupId>org.junit.vintage<\/groupId>\n <artifactId>junit-vintage-engine<\/artifactId>\n <\/exclusion>\n <\/exclusions>\n <\/dependency>\n <\/dependencies>\n\n <build>\n <resources>\n <resource>\n <directory>${basedir}\/src\/main\/java<\/directory>\n <includes>\n <include>**\/*.xml<\/include>\n <\/includes>\n <\/resource>\n <resource>\n <directory>${basedir}\/src\/main\/resources<\/directory>\n <\/resource>\n <\/resources>\n <plugins>\n <plugin>\n <groupId>org.springframework.boot<\/groupId>\n <artifactId>spring-boot-maven-plugin<\/artifactId>\n <configuration>\n <excludes>\n <exclude>\n <groupId>org.projectlombok<\/groupId>\n <artifactId>lombok<\/artifactId>\n <\/exclude>\n <\/excludes>\n <\/configuration>\n <\/plugin>\n <plugin>\n <groupId>org.mybatis.generator<\/groupId>\n <artifactId>mybatis-generator-maven-plugin<\/artifactId>\n <version>1.4.2<\/version>\n <configuration>\n <configurationFile>${basedir}\/src\/main\/resources\/generatorConfig.xml<\/configurationFile>\n <overwrite>true<\/overwrite>\n <verbose>true<\/verbose>\n <\/configuration>\n <dependencies>\n <dependency>\n <groupId>mysql<\/groupId>\n <artifactId>mysql-connector-java<\/artifactId>\n <version>8.0.33<\/version>\n <\/dependency>\n <dependency>\n <groupId>tk.mybatis<\/groupId>\n <artifactId>mapper<\/artifactId>\n <version>4.2.3<\/version>\n <\/dependency>\n <\/dependencies>\n <\/plugin>\n <\/plugins>\n <\/build>\n\n<\/project><\/code><\/pre>\n\n\n\n\u914d\u7f6e<\/h3>\n\n\n\n
src\/main\/resources\u8def\u5f84\u4e0b\u65b0\u5efa<\/p>\n\n\n\n
1\u3001config.properties<\/p>\n\n\n\n
Mysql5<\/p>\n\n\n\n
#User\u8868\u5305\u540d\n<\/em>package.name=com.atguigu.cloud\n# mysql5.7<\/em>\njdbc.driverClass = com.mysql.jdbc.Driver\njdbc.url= jdbc:mysql:\/\/localhost:3306\/db2024?useUnicode=true&characterEncoding=UTF-8&useSSL=false\njdbc.user = root\njdbc.password =123456<\/code><\/pre>\n\n\n\nMysql8<\/p>\n\n\n\n
#t_pay\u8868\u5305\u540d\npackage.name=top.qaqaq\n\n# mysql8.0\njdbc.driverClass = com.mysql.cj.jdbc.Driver\njdbc.url= jdbc:mysql:\/\/localhost:3306\/springcloud?characterEncoding=utf8&useSSL=false&serverTimezone=GMT%2B8&rewriteBatchedStatements=true&allowPublicKeyRetrieval=true\njdbc.user = root\njdbc.password =123456<\/code><\/pre>\n\n\n\n2\u3001generatorConfig.xml\uff0c\u5185\u5bb9<\/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\n<generatorConfiguration>\n <properties resource=\"config.properties\"\/>\n\n <context id=\"Mysql\" targetRuntime=\"MyBatis3Simple\" defaultModelType=\"flat\">\n <property name=\"beginningDelimiter\" value=\"`\"\/>\n <property name=\"endingDelimiter\" value=\"`\"\/>\n\n <plugin type=\"tk.mybatis.mapper.generator.MapperPlugin\">\n <property name=\"mappers\" value=\"tk.mybatis.mapper.common.Mapper\"\/>\n <property name=\"caseSensitive\" value=\"true\"\/>\n <\/plugin>\n\n <jdbcConnection driverClass=\"${jdbc.driverClass}\"\n connectionURL=\"${jdbc.url}\"\n userId=\"${jdbc.user}\"\n password=\"${jdbc.password}\">\n <\/jdbcConnection>\n\n <javaModelGenerator targetPackage=\"${package.name}.entities\" targetProject=\"src\/main\/java\"\/>\n\n <sqlMapGenerator targetPackage=\"${package.name}.mapper\" targetProject=\"src\/main\/java\"\/>\n\n <javaClientGenerator targetPackage=\"${package.name}.mapper\" targetProject=\"src\/main\/java\" type=\"XMLMAPPER\"\/>\n\n <table tableName=\"t_pay\" domainObjectName=\"Pay\">\n <generatedKey column=\"id\" sqlStatement=\"JDBC\"\/>\n <\/table>\n <\/context>\n<\/generatorConfiguration><\/code><\/pre>\n\n\n\n\u4e00\u952e\u751f\u6210\u6b65\u9aa4<\/h3>\n\n\n\n
\u53cc\u51fb\u63d2\u4ef6 mybatis-generator:generate\uff0c\u4e00\u952e\u751f\u6210\uff0c\u751f\u6210entity+mapper\u63a5\u53e3+xml\u5b9e\u73b0SQL<\/p>\n","protected":false},"excerpt":{"rendered":"
mybatis-generator MyBatis Generator Core \u2013 Introduction […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[192],"tags":[194],"class_list":["post-4962","post","type-post","status-publish","format-standard","hentry","category-springcloud-","tag-springcloud"],"_links":{"self":[{"href":"https:\/\/qaqaq.top\/index.php?rest_route=\/wp\/v2\/posts\/4962"}],"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=4962"}],"version-history":[{"count":6,"href":"https:\/\/qaqaq.top\/index.php?rest_route=\/wp\/v2\/posts\/4962\/revisions"}],"predecessor-version":[{"id":4971,"href":"https:\/\/qaqaq.top\/index.php?rest_route=\/wp\/v2\/posts\/4962\/revisions\/4971"}],"wp:attachment":[{"href":"https:\/\/qaqaq.top\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=4962"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/qaqaq.top\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=4962"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/qaqaq.top\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=4962"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}
![\"\"](\"https:\/\/qaqaq.top\/wp-content\/uploads\/2025\/01\/image-16.png\")
<\/div><\/figure>\n\n\n\n