From 26f5dd8ef80e5671cda8fc0e6c0d0298c4e678ff Mon Sep 17 00:00:00 2001
From: shikeying <shikeying@163.com>
Date: 星期二, 27 九月 2022 16:31:33 +0800
Subject: [PATCH] 视频相似度分析3

---
 recommend-model-pojo/src/main/java/com/iplatform/model/po/Rc_video_user_mapper.java |   34 +++++++++++++++++++++++++---------
 1 files changed, 25 insertions(+), 9 deletions(-)

diff --git a/recommend-model-pojo/src/main/java/com/iplatform/model/po/Rc_video_user_mapper.java b/recommend-model-pojo/src/main/java/com/iplatform/model/po/Rc_video_user_mapper.java
index eb950b3..aa0112d 100644
--- a/recommend-model-pojo/src/main/java/com/iplatform/model/po/Rc_video_user_mapper.java
+++ b/recommend-model-pojo/src/main/java/com/iplatform/model/po/Rc_video_user_mapper.java
@@ -26,8 +26,9 @@
     public static final RowMapper<Rc_video_user> ROW_MAPPER = new Rc_video_userRowMapper();
 
     // 涓婚敭
-    public static final String USER_ID = "user_id";
+    public static final String ID = "id";
     // 鏅�氬睘鎬�
+    public static final String USER_ID = "user_id";
     public static final String VIDEO_ID = "video_id";
     public static final String SCORE = "score";
     public static final String CREATE_TIME = "create_time";
@@ -40,10 +41,13 @@
             throw new IllegalArgumentException("po鍙傛暟涓嶅厑璁镐负绌猴紒");
         }
         //涓婚敭
+        if (rc_video_user.isset_id) {
+            this.setId(rc_video_user.getId());
+        }
+        //鏅�氬睘鎬�
         if (rc_video_user.isset_user_id) {
             this.setUser_id(rc_video_user.getUser_id());
         }
-        //鏅�氬睘鎬�
         if (rc_video_user.isset_video_id) {
             this.setVideo_id(rc_video_user.getVideo_id());
         }
@@ -78,7 +82,7 @@
      */
     @Override
     public String getPkName_() {
-        return USER_ID;
+        return ID;
     }
 
     /**
@@ -86,7 +90,7 @@
      */
     @Override
     public Object getPkValue_() {
-        return this.getUser_id();
+        return this.getId();
     }
 
     /**
@@ -95,7 +99,8 @@
     @Override
     public SqlAndParameters<Map<String, Object>> getInsertSql_() {
         InsertBuilder ib = new InsertBuilder(this.getTableName_());
-        ib.set(USER_ID, this.getUser_id());
+        ib.set(ID, this.getId());
+        ib.set(USER_ID, this.getUser_id(), this.isset_user_id);
         ib.set(VIDEO_ID, this.getVideo_id(), this.isset_video_id);
         ib.set(SCORE, this.getScore(), this.isset_score);
         ib.set(CREATE_TIME, this.getCreate_time(), this.isset_create_time);
@@ -108,6 +113,7 @@
     @Override
     public SqlAndParameters<Map<String, Object>> getUpdateSql_() {
         UpdateBuilder ub = new UpdateBuilder(this.getTableName_());
+        ub.set(USER_ID, this.getUser_id(), this.isset_user_id);
         ub.set(VIDEO_ID, this.getVideo_id(), this.isset_video_id);
         ub.set(SCORE, this.getScore(), this.isset_score);
         ub.set(CREATE_TIME, this.getCreate_time(), this.isset_create_time);
@@ -121,6 +127,7 @@
     @Override
     public SqlAndParameters<Map<String, Object>> getUpdateSql_(String where, Map<String, Object> parameters) {
         UpdateBuilder ub = new UpdateBuilder(this.getTableName_());
+        ub.set(USER_ID, this.getUser_id(), this.isset_user_id);
         ub.set(VIDEO_ID, this.getVideo_id(), this.isset_video_id);
         ub.set(SCORE, this.getScore(), this.isset_score);
         ub.set(CREATE_TIME, this.getCreate_time(), this.isset_create_time);
@@ -134,6 +141,7 @@
     @Override
     public SqlAndParameters<Object[]> getUpdateSql_(String where, Object[] parameters) {
         UpdateBuilder ub = new UpdateBuilder(this.getTableName_());
+        ub.set(USER_ID, this.getUser_id(), this.isset_user_id);
         ub.set(VIDEO_ID, this.getVideo_id(), this.isset_video_id);
         ub.set(SCORE, this.getScore(), this.isset_score);
         ub.set(CREATE_TIME, this.getCreate_time(), this.isset_create_time);
@@ -185,7 +193,7 @@
      */
     @Override
     public SqlAndParameters<Map<String, Object>> getSelectSql_(String where, Map<String, Object> parameters) {
-        return new SqlAndParameters<>("select user_id, video_id, score, create_time from " + this.getTableName_() + " " + where, parameters);
+        return new SqlAndParameters<>("select id, user_id, video_id, score, create_time from " + this.getTableName_() + " " + where, parameters);
     }
 
     /**
@@ -193,7 +201,7 @@
      */
     @Override
     public SqlAndParameters<Object[]> getSelectSql_(String where, Object[] parameters) {
-        return new SqlAndParameters<>("select user_id, video_id, score, create_time from " + this.getTableName_() + " " + where, parameters);
+        return new SqlAndParameters<>("select id, user_id, video_id, score, create_time from " + this.getTableName_() + " " + where, parameters);
     }
 
     /**
@@ -225,11 +233,19 @@
         Rc_video_user rc_video_user = new Rc_video_user();
         Integer columnIndex;
         //涓婚敭
-        columnIndex = resultSetUtils.findColumn(rs, Rc_video_user_mapper.USER_ID);
+        columnIndex = resultSetUtils.findColumn(rs, Rc_video_user_mapper.ID);
         if (columnIndex > 0) {
-            rc_video_user.setUser_id(rs.getLong(columnIndex));
+            rc_video_user.setId(rs.getLong(columnIndex));
         }
         //鏅�氬睘鎬�
+        columnIndex = resultSetUtils.findColumn(rs, Rc_video_user_mapper.USER_ID);
+        if (columnIndex > 0) {
+            if (rs.getBigDecimal(columnIndex) == null) {
+                rc_video_user.setUser_id(null);
+            } else {
+                rc_video_user.setUser_id(rs.getLong(columnIndex));
+            }
+        }
         columnIndex = resultSetUtils.findColumn(rs, Rc_video_user_mapper.VIDEO_ID);
         if (columnIndex > 0) {
             rc_video_user.setVideo_id(rs.getString(columnIndex));

--
Gitblit v1.9.1