From fd03e31f173ad9c52b15a30a9127e2b6a468538d Mon Sep 17 00:00:00 2001 From: shikeying <shikeying@163.com> Date: 星期一, 26 九月 2022 18:50:33 +0800 Subject: [PATCH] 视频相似度分析2 --- recommend-model-pojo/src/main/java/com/iplatform/model/po/Rc_video_t2_mapper.java | 20 ++++++++++++++------ 1 files changed, 14 insertions(+), 6 deletions(-) diff --git a/recommend-model-pojo/src/main/java/com/iplatform/model/po/Rc_video_t2_mapper.java b/recommend-model-pojo/src/main/java/com/iplatform/model/po/Rc_video_t2_mapper.java index 1411a5c..2489d77 100644 --- a/recommend-model-pojo/src/main/java/com/iplatform/model/po/Rc_video_t2_mapper.java +++ b/recommend-model-pojo/src/main/java/com/iplatform/model/po/Rc_video_t2_mapper.java @@ -7,8 +7,6 @@ import com.walker.jdbc.sqlgen.InsertBuilder; import com.walker.jdbc.sqlgen.SelectBuilder; import com.walker.jdbc.sqlgen.UpdateBuilder; -import com.walker.jdbc.util.StringUtils; - import org.springframework.jdbc.core.RowMapper; import java.sql.ResultSet; @@ -31,6 +29,7 @@ public static final String SRC_VIDEO_ID = "src_video_id"; public static final String SIM_VIDEO_ID = "sim_video_id"; public static final String SCORE = "score"; + public static final String BATCH_ID = "batch_id"; /** * 榛樿鏋勯�犲嚱鏁� @@ -52,6 +51,9 @@ } if (rc_video_t2.isset_score) { this.setScore(rc_video_t2.getScore()); + } + if(rc_video_t2.isset_batch_id){ + this.setBatch_id(rc_video_t2.getBatch_id()); } // 鍘绘帀锛�2022-09-07 // this.setDatabaseName_(rc_video_t2.getDatabaseName_()); @@ -99,6 +101,7 @@ ib.set(SRC_VIDEO_ID, this.getSrc_video_id(), this.isset_src_video_id); ib.set(SIM_VIDEO_ID, this.getSim_video_id(), this.isset_sim_video_id); ib.set(SCORE, this.getScore(), this.isset_score); + ib.set(BATCH_ID, this.getBatch_id(), this.isset_batch_id); return ib.genMapSql(); } @@ -111,6 +114,7 @@ ub.set(SRC_VIDEO_ID, this.getSrc_video_id(), this.isset_src_video_id); ub.set(SIM_VIDEO_ID, this.getSim_video_id(), this.isset_sim_video_id); ub.set(SCORE, this.getScore(), this.isset_score); + ub.set(BATCH_ID, this.getBatch_id(), this.isset_batch_id); ub.where(this.getPkName_(), this.getPkValue_()); return ub.genMapSql(); } @@ -124,7 +128,7 @@ ub.set(SRC_VIDEO_ID, this.getSrc_video_id(), this.isset_src_video_id); ub.set(SIM_VIDEO_ID, this.getSim_video_id(), this.isset_sim_video_id); ub.set(SCORE, this.getScore(), this.isset_score); - + ub.set(BATCH_ID, this.getBatch_id(), this.isset_batch_id); return ub.genMapSql(where, parameters); } @@ -137,7 +141,7 @@ ub.set(SRC_VIDEO_ID, this.getSrc_video_id(), this.isset_src_video_id); ub.set(SIM_VIDEO_ID, this.getSim_video_id(), this.isset_sim_video_id); ub.set(SCORE, this.getScore(), this.isset_score); - + ub.set(BATCH_ID, this.getBatch_id(), this.isset_batch_id); return ub.genArraySql(where, parameters); } @@ -185,7 +189,7 @@ */ @Override public SqlAndParameters<Map<String, Object>> getSelectSql_(String where, Map<String, Object> parameters) { - return new SqlAndParameters<>("select id, src_video_id, sim_video_id, score from " + this.getTableName_() + " " + where, parameters); + return new SqlAndParameters<>("select id, src_video_id, sim_video_id, score, batch_id from " + this.getTableName_() + " " + where, parameters); } /** @@ -193,7 +197,7 @@ */ @Override public SqlAndParameters<Object[]> getSelectSql_(String where, Object[] parameters) { - return new SqlAndParameters<>("select id, src_video_id, sim_video_id, score from " + this.getTableName_() + " " + where, parameters); + return new SqlAndParameters<>("select id, src_video_id, sim_video_id, score, batch_id from " + this.getTableName_() + " " + where, parameters); } /** @@ -238,6 +242,10 @@ if (columnIndex > 0) { rc_video_t2.setSim_video_id(rs.getString(columnIndex)); } + columnIndex = resultSetUtils.findColumn(rs, Rc_video_t2_mapper.BATCH_ID); + if (columnIndex > 0) { + rc_video_t2.setBatch_id(rs.getString(columnIndex)); + } columnIndex = resultSetUtils.findColumn(rs, Rc_video_t2_mapper.SCORE); if (columnIndex > 0) { if (rs.getBigDecimal(columnIndex) == null) { -- Gitblit v1.9.1