推荐一个在线文档生成器

网址：https://java.bejson.com/generator/

效果：

CREATE TABLE `wo_jp_branch_org`  (
  `id` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '主键',
  `branch_org_code` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '分支机构组织机构代码',
  PRIMARY KEY (`id`) USING BTREE,
  INDEX `法人基本信息外键`(`basic_info_id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Compact;wo_

生成的效果：

import java.io.Serializable;
import java.util.Date;
import java.util.List;

/**
*  wo_jp_branch_org
* @author miller 2020-08-16
*/
public class WoJpBranchOrg implements Serializable {

    private static final long serialVersionUID = 1L;

    /**
    * 主键
    */
    private String id;

    /**
    * 分支机构组织机构代码
    */
    private String branchOrgCode;


    public WoJpBranchOrg() {
    }

    public String getId() {
        return id;
    }

    public void setId(String id) {
        this.id = id;
    }

    public String getBranchOrgCode() {
        return branchOrgCode;
    }

    public void setBranchOrgCode(String branchOrgCode) {
        this.branchOrgCode = branchOrgCode;
    }

}

 

<?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.softdev.system.dao.WoJpBranchOrgDao">

    <resultMap id="BaseResultMap" type="com.softdev.system.entity.WoJpBranchOrgEntity" >
                <result column="id" property="id" />
                <result column="branch_org_code" property="branchOrgCode" />
    </resultMap>

    <sql id="Base_Column_List">
                id,
                branch_org_code
    </sql>

    <insert id="insert" useGeneratedKeys="true" keyColumn="id" keyProperty="id" parameterType="com.softdev.system.entity.WoJpBranchOrgEntity">
        INSERT INTO wo_jp_branch_org
        <trim prefix="(" suffix=")" suffixOverrides=",">
                        <if test ='null != branchOrgCode'>
                        branch_org_code
                        </if>
        </trim>
        <trim prefix="values (" suffix=")" suffixOverrides=",">
                        <if test ='null != branchOrgCode'>
                        #{branchOrgCode}
                        </if>
        </trim>
    </insert>

    <delete id="delete" >
        DELETE FROM wo_jp_branch_org
        WHERE id = #{id}
    </delete>

    <update id="update" parameterType="com.softdev.system.entity.WoJpBranchOrgEntity">
        UPDATE wo_jp_branch_org
        <set>
                    <if test ='null != branchOrgCode'>branch_org_code = #{branchOrgCode}</if>
        </set>
        WHERE id = #{id}
    </update>


    <select id="load" resultMap="BaseResultMap">
        SELECT <include refid="Base_Column_List" />
        FROM wo_jp_branch_org
        WHERE id = #{id}
    </select>

    <select id="pageList" resultMap="BaseResultMap">
        SELECT <include refid="Base_Column_List" />
        FROM wo_jp_branch_org
        LIMIT #{offset}, #{pageSize}
    </select>

    <select id="pageListCount" resultType="java.lang.Integer">
        SELECT count(1)
        FROM wo_jp_branch_org
    </select>

</mapper>