From cf510b3a38f20d5dba5b7a0b71f097753b3ca409 Mon Sep 17 00:00:00 2001
From: Fancy <Fancy.fx@outlook.com>
Date: 星期三, 25 十二月 2024 17:27:48 +0800
Subject: [PATCH] add mp table
---
pms-parent/pms-global/src/main/resources/mapper/MpOpenIdMapper.xml | 115 ++++++++++++++++++++++++++++
pms-parent/pms-global/src/main/java/com/dy/pmsGlobal/pojoMp/MpOpenId.java | 71 +++++++++++++++++
pms-parent/pms-global/src/main/java/com/dy/pmsGlobal/daoMp/MpOpenIdMapper.java | 25 ++++++
3 files changed, 211 insertions(+), 0 deletions(-)
diff --git a/pms-parent/pms-global/src/main/java/com/dy/pmsGlobal/daoMp/MpOpenIdMapper.java b/pms-parent/pms-global/src/main/java/com/dy/pmsGlobal/daoMp/MpOpenIdMapper.java
new file mode 100644
index 0000000..7da5a0a
--- /dev/null
+++ b/pms-parent/pms-global/src/main/java/com/dy/pmsGlobal/daoMp/MpOpenIdMapper.java
@@ -0,0 +1,25 @@
+package com.dy.pmsGlobal.daoMp;
+
+import com.dy.pmsGlobal.pojoMp.MpOpenId;
+
+/**
+* @author User
+* @description 閽堝琛ㄣ�恗p_open_id銆戠殑鏁版嵁搴撴搷浣淢apper
+* @createDate 2024-12-25 17:22:43
+* @Entity com.dy.pmsGlobal.pojoMp.MpOpenId
+*/
+public interface MpOpenIdMapper {
+
+ int deleteByPrimaryKey(Long id);
+
+ int insert(MpOpenId record);
+
+ int insertSelective(MpOpenId record);
+
+ MpOpenId selectByPrimaryKey(Long id);
+
+ int updateByPrimaryKeySelective(MpOpenId record);
+
+ int updateByPrimaryKey(MpOpenId record);
+
+}
diff --git a/pms-parent/pms-global/src/main/java/com/dy/pmsGlobal/pojoMp/MpOpenId.java b/pms-parent/pms-global/src/main/java/com/dy/pmsGlobal/pojoMp/MpOpenId.java
new file mode 100644
index 0000000..1590402
--- /dev/null
+++ b/pms-parent/pms-global/src/main/java/com/dy/pmsGlobal/pojoMp/MpOpenId.java
@@ -0,0 +1,71 @@
+package com.dy.pmsGlobal.pojoMp;
+
+import com.alibaba.fastjson2.annotation.JSONField;
+import com.alibaba.fastjson2.writer.ObjectWriterImplToString;
+import com.baomidou.mybatisplus.annotation.IdType;
+import com.baomidou.mybatisplus.annotation.TableField;
+import com.baomidou.mybatisplus.annotation.TableId;
+import com.baomidou.mybatisplus.annotation.TableName;
+import java.io.Serializable;
+import java.util.Date;
+
+import com.dy.common.po.BaseEntity;
+import lombok.*;
+
+/**
+ *
+ * @TableName mp_open_id
+ */
+@TableName(value ="mp_open_id", autoResultMap = true)
+@Builder
+@ToString
+@NoArgsConstructor
+@AllArgsConstructor
+public class MpOpenId implements BaseEntity {
+ /**
+ * 涓婚敭
+ */
+ @JSONField(serializeUsing= ObjectWriterImplToString.class)
+ @TableId(value = "id", type = IdType.INPUT)
+ public Long id;
+
+ /**
+ * 鐢ㄦ埛鍞竴鏍囪瘑
+ */
+ public String openId;
+
+ /**
+ * 浼氳瘽瀵嗛挜
+ */
+ public String sessionKey;
+
+ /**
+ * 寰俊鏄电О
+ */
+ public String nickName;
+
+ /**
+ * 寰俊澶村儚
+ */
+ public String headImgUrl;
+
+ /**
+ * 鎵嬫満鍙�
+ */
+ public String phone;
+
+ /**
+ * 鎬у埆
+ */
+ public String gender;
+
+ /**
+ * 鐪佷唤
+ */
+ public String province;
+
+ /**
+ * 鍒涘缓鏃堕棿
+ */
+ public Date createTime;
+}
\ No newline at end of file
diff --git a/pms-parent/pms-global/src/main/resources/mapper/MpOpenIdMapper.xml b/pms-parent/pms-global/src/main/resources/mapper/MpOpenIdMapper.xml
new file mode 100644
index 0000000..6cea7d0
--- /dev/null
+++ b/pms-parent/pms-global/src/main/resources/mapper/MpOpenIdMapper.xml
@@ -0,0 +1,115 @@
+<?xml version="1.0" encoding="UTF-8"?>
+<!DOCTYPE mapper
+ PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN"
+ "http://mybatis.org/dtd/mybatis-3-mapper.dtd">
+<mapper namespace="com.dy.pmsGlobal.daoMp.MpOpenIdMapper">
+
+ <resultMap id="BaseResultMap" type="com.dy.pmsGlobal.pojoMp.MpOpenId">
+ <id property="id" column="id" jdbcType="BIGINT"/>
+ <result property="openId" column="open_id" jdbcType="VARCHAR"/>
+ <result property="sessionKey" column="session_key" jdbcType="VARCHAR"/>
+ <result property="nickName" column="nick_name" jdbcType="VARCHAR"/>
+ <result property="headImgUrl" column="head_img_url" jdbcType="VARCHAR"/>
+ <result property="phone" column="phone" jdbcType="VARCHAR"/>
+ <result property="gender" column="gender" jdbcType="VARCHAR"/>
+ <result property="province" column="province" jdbcType="VARCHAR"/>
+ <result property="createTime" column="create_time" jdbcType="TIMESTAMP"/>
+ </resultMap>
+
+ <sql id="Base_Column_List">
+ id,open_id,session_key,
+ nick_name,head_img_url,phone,
+ gender,province,create_time
+ </sql>
+
+ <select id="selectByPrimaryKey" parameterType="java.lang.Long" resultMap="BaseResultMap">
+ select
+ <include refid="Base_Column_List" />
+ from mp_open_id
+ where id = #{id,jdbcType=BIGINT}
+ </select>
+
+ <delete id="deleteByPrimaryKey" parameterType="java.lang.Long">
+ delete from mp_open_id
+ where id = #{id,jdbcType=BIGINT}
+ </delete>
+ <insert id="insert" keyColumn="id" keyProperty="id" parameterType="com.dy.pmsGlobal.pojoMp.MpOpenId" useGeneratedKeys="true">
+ insert into mp_open_id
+ ( id,open_id,session_key
+ ,nick_name,head_img_url,phone
+ ,gender,province,create_time
+ )
+ values (#{id,jdbcType=BIGINT},#{openId,jdbcType=VARCHAR},#{sessionKey,jdbcType=VARCHAR}
+ ,#{nickName,jdbcType=VARCHAR},#{headImgUrl,jdbcType=VARCHAR},#{phone,jdbcType=VARCHAR}
+ ,#{gender,jdbcType=VARCHAR},#{province,jdbcType=VARCHAR},#{createTime,jdbcType=TIMESTAMP}
+ )
+ </insert>
+ <insert id="insertSelective" keyColumn="id" keyProperty="id" parameterType="com.dy.pmsGlobal.pojoMp.MpOpenId" useGeneratedKeys="true">
+ insert into mp_open_id
+ <trim prefix="(" suffix=")" suffixOverrides=",">
+ <if test="id != null">id,</if>
+ <if test="openId != null">open_id,</if>
+ <if test="sessionKey != null">session_key,</if>
+ <if test="nickName != null">nick_name,</if>
+ <if test="headImgUrl != null">head_img_url,</if>
+ <if test="phone != null">phone,</if>
+ <if test="gender != null">gender,</if>
+ <if test="province != null">province,</if>
+ <if test="createTime != null">create_time,</if>
+ </trim>
+ <trim prefix="values (" suffix=")" suffixOverrides=",">
+ <if test="id != null">#{id,jdbcType=BIGINT},</if>
+ <if test="openId != null">#{openId,jdbcType=VARCHAR},</if>
+ <if test="sessionKey != null">#{sessionKey,jdbcType=VARCHAR},</if>
+ <if test="nickName != null">#{nickName,jdbcType=VARCHAR},</if>
+ <if test="headImgUrl != null">#{headImgUrl,jdbcType=VARCHAR},</if>
+ <if test="phone != null">#{phone,jdbcType=VARCHAR},</if>
+ <if test="gender != null">#{gender,jdbcType=VARCHAR},</if>
+ <if test="province != null">#{province,jdbcType=VARCHAR},</if>
+ <if test="createTime != null">#{createTime,jdbcType=TIMESTAMP},</if>
+ </trim>
+ </insert>
+ <update id="updateByPrimaryKeySelective" parameterType="com.dy.pmsGlobal.pojoMp.MpOpenId">
+ update mp_open_id
+ <set>
+ <if test="openId != null">
+ open_id = #{openId,jdbcType=VARCHAR},
+ </if>
+ <if test="sessionKey != null">
+ session_key = #{sessionKey,jdbcType=VARCHAR},
+ </if>
+ <if test="nickName != null">
+ nick_name = #{nickName,jdbcType=VARCHAR},
+ </if>
+ <if test="headImgUrl != null">
+ head_img_url = #{headImgUrl,jdbcType=VARCHAR},
+ </if>
+ <if test="phone != null">
+ phone = #{phone,jdbcType=VARCHAR},
+ </if>
+ <if test="gender != null">
+ gender = #{gender,jdbcType=VARCHAR},
+ </if>
+ <if test="province != null">
+ province = #{province,jdbcType=VARCHAR},
+ </if>
+ <if test="createTime != null">
+ create_time = #{createTime,jdbcType=TIMESTAMP},
+ </if>
+ </set>
+ where id = #{id,jdbcType=BIGINT}
+ </update>
+ <update id="updateByPrimaryKey" parameterType="com.dy.pmsGlobal.pojoMp.MpOpenId">
+ update mp_open_id
+ set
+ open_id = #{openId,jdbcType=VARCHAR},
+ session_key = #{sessionKey,jdbcType=VARCHAR},
+ nick_name = #{nickName,jdbcType=VARCHAR},
+ head_img_url = #{headImgUrl,jdbcType=VARCHAR},
+ phone = #{phone,jdbcType=VARCHAR},
+ gender = #{gender,jdbcType=VARCHAR},
+ province = #{province,jdbcType=VARCHAR},
+ create_time = #{createTime,jdbcType=TIMESTAMP}
+ where id = #{id,jdbcType=BIGINT}
+ </update>
+</mapper>
--
Gitblit v1.8.0