docker安装mysql：

进入dockerhub，搜索mysql，选择一个版本

docker run --name exhibit-redis -p 6379:6379/tcp -d redis

$ docker pull mysql$ docker run --name some-mysql -e MYSQL_ROOT_PASSWORD=my-secret-pw -p 3306:3306/tcp -d mysql:tag

docker安装都可走这个流程

java使用mysql

pom.xml

 <dependency>    <groupId>mysql</groupId>    <artifactId>mysql-connector-java</artifactId>    <scope>runtime</scope> </dependency>

application.yml

spring:  jpa:    hibernate:      ddl-auto: update    database-platform: "${SPRING_JPA_DATABASE_PLATFORM:org.hibernate.dialect.MySQL5InnoDBDialect}"    show-sql: "${CAPELLA_OTA_PROJECT_JPA_SHOW_SQL:false}"  datasource:    driver-class-name: "com.mysql.cj.jdbc.Driver"    url: "${SPRING_DATASOURCE_URL:jdbc:mysql://${APOLLO_SCHEDULE_DATASOURCE:${APOLLO_SCHEDULE_MYSQL_SERVER_HOST:192.168.5.17}:${APOLLO_SCHEDULE_MYSQL_SERVER_PORT:3306}/${APOLLO_SCHEDULE_MYSQL_DATABASE:apollo_schedule}}?autoReconnect=true&useUnicode=true&characterEncoding=UTF-8&allowMultiQueries=true&useSSL=false}"    username: "${APOLLO_SCHEDULE_MYSQL_USERNAME:${SPRING_DATASOURCE_USERNAME:root}}"    password: "${APOLLO_SCHEDULE_MYSQL_PASSWORD:${SPRING_DATASOURCE_PASSWORD:123456}}"

直接上代码

首先创建实体类

public class EntityConstants {    public static final String TABLE_WORKSHEET = "worksheet";    public static final String WORKSHEET_COLUMN_ID = "id";    public static final String WORKSHEET_COLUMN_TENANT_ID = "tenant_id";    public static final String WORKSHEET_COLUMN_REPORTER_NAME = "reporter_name";    public static final String WORKSHEET_COLUMN_CREATED_AT = "created_at";}

将实体类与表结构关联

@[email protected]@Accessors(chain = true)@Table(name = EntityConstants.TABLE_WORKSHEET)@DynamicUpdatepublic class WorksheetEntity {    @Id    @Column(name = EntityConstants.WORKSHEET_COLUMN_ID, length = 36, nullable = false)    private String id;    @Column(name = EntityConstants.WORKSHEET_COLUMN_TENANT_ID, length = 36, nullable = false)    private String tenantId;    @Transient    private String operatorName;    @Column(name = EntityConstants.WORKSHEET_COLUMN_CREATED_AT, nullable = false, updatable = false)    private Date createdAt;}

集成JpaRepository类，可以实现sql语句

public interface WorksheetRepositoryDao extends JpaRepository<WorksheetEntity, String>, JpaSpecificationExecutor<WorksheetEntity> {    Page<WorksheetEntity> findAll(Specification<WorksheetEntity> spec, Pageable pageable);    WorksheetEntity findByIdAndTenantId(String worksheetId, String tenantId);    WorksheetEntity findByIdAndOperatorId(String worksheetId, String operatorId);    int countByTenantId(String tenantId);    int countByTenantIdAndStatus(String tenantId, String status);    int countByOperatorId(String operatorId);    int countByOperatorIdAndStatus(String operatorId, String status);}