A sample code integration mybatis generator, mybatis dynamic sql, spring-boot.
integration features
- Generate Entity from database by run Gradle Task
dao:mybatisGenerate - Auto migration database DDL or DML by flyway
- Integration Lombok and MapStruct to simplify the code
- Integration Mybatis-Dynamic-SQL and shows how write complicated DSL SQL
- First: modify
api/resources/application.yml
spring: datasource: driver-class-name: com.mysql.cj.jdbc.Driver url: jdbc:mysql://{your database url}/{your database name} username: { your database username } password: { your database password }
- Second: modify
dao/resources/generatorConfiguration.xml
<generatorConfiguration> <context id="dsql" targetRuntime="MyBatis3DynamicSql"> <!-- ...... --> <jdbcConnection driverClass="com.mysql.cj.jdbc.Driver" connectionURL="jdbc:mysql://{your database url}/{your database name}" userId="{your database username}" password="{your database password}"/> <!-- ...... --> </context> </generatorConfiguration>
- Run Main class
api/java/cc/cc1234/api/Application.java
| Method | EndPoint | Request Body | Description |
|---|---|---|---|
| POST | /v1/api/user | {"username":"hello", "gender":"MALE"} | create user |
| DELETE | /v1/api/users/{userId} | N/A | delete user |
| PATCH | /v1/api/users/{userId} | {"username":"hello", "gender":"MALE"} | update user basic information |
| GET | /v1/api/users?page=1&size=20 | N/A | list users |
| GET | /v1/api/users/{userId}/goods/purchased | N/A | query user purchased goods |