From a9522d959a40b0e5db87d3331c2f48f5539ffa53 Mon Sep 17 00:00:00 2001
From: lidongdong <1459917685@qq.com>
Date: 星期四, 29 九月 2022 11:10:10 +0800
Subject: [PATCH] 新增字段 视频url 图片url
---
flower_city/src/main/resources/application.properties | 4 ++--
flower_city/src/main/java/com/dg/core/db/gen/entity/GuideEvolveEntity.java | 13 +++++++++++++
flower_city/src/main/resources/mapper/GuideEvolveMapper.xml | 10 ++++++++++
3 files changed, 25 insertions(+), 2 deletions(-)
diff --git a/flower_city/src/main/java/com/dg/core/db/gen/entity/GuideEvolveEntity.java b/flower_city/src/main/java/com/dg/core/db/gen/entity/GuideEvolveEntity.java
index 793f30f..319d323 100644
--- a/flower_city/src/main/java/com/dg/core/db/gen/entity/GuideEvolveEntity.java
+++ b/flower_city/src/main/java/com/dg/core/db/gen/entity/GuideEvolveEntity.java
@@ -107,4 +107,17 @@
@JsonFormat(pattern = "yyyy-MM-dd HH:mm:ss")
private LocalDateTime updateTime;
+
+ /**
+ * 视频url
+ */
+ @ApiModelProperty(name = "videoUrl", value = "视频url")
+ private String videoUrl;
+
+ /**
+ * 图片url
+ */
+ @ApiModelProperty(name = "pictureUrl", value = "图片url")
+ private String pictureUrl;
+
}
diff --git a/flower_city/src/main/resources/application.properties b/flower_city/src/main/resources/application.properties
index 9ad5441..fce6af5 100644
--- a/flower_city/src/main/resources/application.properties
+++ b/flower_city/src/main/resources/application.properties
@@ -3,8 +3,8 @@
spring.datasource.password=nahanMysqlPwd&&RemoteRemote2019nahan
#spring.datasource.url=jdbc:mysql://10.8.0.74:3306/flower_city_automessage?useUnicode=true&characterEncoding=utf8&zeroDateTimeBehavior=convertToNull&useSSL=true&allowMultiQueries=true&serverTimezone=GMT%2B8
#spring.datasource.url=jdbc:mysql://localhost:3306/flower_city_automessage?useUnicode=true&characterEncoding=utf8&zeroDateTimeBehavior=convertToNull&useSSL=true&allowMultiQueries=true&serverTimezone=GMT%2B8
-#spring.datasource.url=jdbc:mysql://10.8.0.74:3306/huacheng_smart_life?useUnicode=true&characterEncoding=utf8&zeroDateTimeBehavior=convertToNull&useSSL=true&allowMultiQueries=true&serverTimezone=GMT%2B8
-spring.datasource.url=jdbc:mysql://182.151.2.19:3306/huacheng_smart_life?allowMultiQueries=true&useUnicode=true&characterEncoding=utf8&zeroDateTimeBehavior=convertToNull&useSSL=false&serverTimezone=GMT%2B8
+spring.datasource.url=jdbc:mysql://10.8.0.74:3306/huacheng_smart_life?useUnicode=true&characterEncoding=utf8&zeroDateTimeBehavior=convertToNull&useSSL=true&allowMultiQueries=true&serverTimezone=GMT%2B8
+#spring.datasource.url=jdbc:mysql://182.151.2.19:3306/huacheng_smart_life?allowMultiQueries=true&useUnicode=true&characterEncoding=utf8&zeroDateTimeBehavior=convertToNull&useSSL=false&serverTimezone=GMT%2B8
#datasource:
diff --git a/flower_city/src/main/resources/mapper/GuideEvolveMapper.xml b/flower_city/src/main/resources/mapper/GuideEvolveMapper.xml
index 2ce892f..e2739c8 100644
--- a/flower_city/src/main/resources/mapper/GuideEvolveMapper.xml
+++ b/flower_city/src/main/resources/mapper/GuideEvolveMapper.xml
@@ -17,6 +17,8 @@
<id property="createTime" column="create_time" />
<id property="updateTime" column="update_time" />
<id property="fromDepartmentalId" column="from_departmental_id" />
+ <id property="videoUrl" column="video_url" />
+ <id property="pictureUrl" column="picture_url" />
</resultMap>
@@ -34,6 +36,8 @@
accessory_name,
accessory_url,
from_departmental_id,
+ video_url,
+ picture_url,
create_time,
update_time
FROM
@@ -65,6 +69,8 @@
<if test="accessoryName != null and accessoryName != '' ">accessory_name,</if>
<if test="accessoryUrl != null and accessoryUrl != '' ">accessory_url,</if>
<if test="fromDepartmentalId != null and fromDepartmentalId != '' ">from_departmental_id,</if>
+ <if test="videoUrl != null and videoUrl != '' ">video_url,</if>
+ <if test="pictureUrl != null and pictureUrl != '' ">picture_url,</if>
update_time,
create_time
)values(
@@ -79,6 +85,8 @@
<if test="accessoryName != null and accessoryName != '' ">#{accessoryName},</if>
<if test="accessoryUrl != null and accessoryUrl != '' ">#{accessoryUrl},</if>
<if test="fromDepartmentalId != null and fromDepartmentalId != '' ">#{fromDepartmentalId},</if>
+ <if test="videoUrl != null and videoUrl != '' ">#{videoUrl},</if>
+ <if test="pictureUrl != null and pictureUrl != '' ">#{pictureUrl},</if>
sysdate(),
sysdate()
)
@@ -98,6 +106,8 @@
<if test="accessoryName != null and accessoryName != '' ">accessory_name=#{accessoryName},</if>
<if test="accessoryUrl != null and accessoryUrl != '' ">accessory_url=#{accessoryUrl},</if>
<if test="fromDepartmentalId != null and fromDepartmentalId != '' ">from_departmental_id=#{fromDepartmentalId},</if>
+ <if test="videoUrl != null and videoUrl != '' ">video_url=#{videoUrl},</if>
+ <if test="pictureUrl != null and pictureUrl != '' ">picture_url=#{pictureUrl},</if>
update_time=sysdate()
</set>
where id= #{Id}
--
Gitblit v1.7.1