数据库修改

fangyuan

2022-11-17 04656ebd6d0000dd4653eaf000bf73cb2bd4f521

数据库修改

 .idea/compiler.xml

@@ -1,21 +1,21 @@
<?xml version="1.0" encoding="UTF-8"?>
<project version="4">
  <component name="CompilerConfiguration">
    <annotationProcessing>
      <profile default="true" name="Default" enabled="true" />
      <profile name="Maven default annotation processors profile" enabled="true">
        <sourceOutputDir name="target/generated-sources/annotations" />
        <sourceTestOutputDir name="target/generated-test-sources/test-annotations" />
        <outputRelativeToContentRoot value="true" />
        <module name="ycl-common" />
        <module name="ycl-platform" />
      </profile>
    </annotationProcessing>
  </component>
  <component name="JavacSettings">
    <option name="ADDITIONAL_OPTIONS_OVERRIDE">
      <module name="ycl-common" options="-parameters" />
      <module name="ycl-platform" options="-parameters" />
    </option>
  </component>
<?xml version="1.0" encoding="UTF-8"?>

<project version="4">

  <component name="CompilerConfiguration">

    <annotationProcessing>

      <profile default="true" name="Default" enabled="true" />

      <profile name="Maven default annotation processors profile" enabled="true">

        <sourceOutputDir name="target/generated-sources/annotations" />

        <sourceTestOutputDir name="target/generated-test-sources/test-annotations" />

        <outputRelativeToContentRoot value="true" />

        <module name="ycl-platform" />

        <module name="ycl-common" />

      </profile>

    </annotationProcessing>

  </component>

  <component name="JavacSettings">

    <option name="ADDITIONAL_OPTIONS_OVERRIDE">

      <module name="ycl-common" options="-parameters" />

      <module name="ycl-platform" options="-parameters" />

    </option>

  </component>

</project>

 .idea/easyCodeTableSetting.xml

@@ -1,520 +1,501 @@
<?xml version="1.0" encoding="UTF-8"?>
<project version="4">
  <component name="EasyCodeTableSetting">
    <option name="tableInfoMap">
      <map>
        <entry key="news_website.news_admin">
          <value>
            <TableInfoDTO>
              <option name="comment" value="后台用户表" />
              <option name="fullColumn">
                <list>
                  <ColumnInfoDTO>
                    <option name="custom" value="false" />
                    <option name="ext" value="{}" />
                    <option name="name" value="id" />
                    <option name="type" value="java.lang.Long" />
                  </ColumnInfoDTO>
                  <ColumnInfoDTO>
                    <option name="comment" value="用户姓名" />
                    <option name="custom" value="false" />
                    <option name="ext" value="{}" />
                    <option name="name" value="username" />
                    <option name="type" value="java.lang.String" />
                  </ColumnInfoDTO>
                  <ColumnInfoDTO>
                    <option name="custom" value="false" />
                    <option name="ext" value="{}" />
                    <option name="name" value="password" />
                    <option name="type" value="java.lang.String" />
                  </ColumnInfoDTO>
                  <ColumnInfoDTO>
                    <option name="comment" value="头像" />
                    <option name="custom" value="false" />
                    <option name="ext" value="{}" />
                    <option name="name" value="icon" />
                    <option name="type" value="java.lang.String" />
                  </ColumnInfoDTO>
                  <ColumnInfoDTO>
                    <option name="comment" value="邮箱" />
                    <option name="custom" value="false" />
                    <option name="ext" value="{}" />
                    <option name="name" value="email" />
                    <option name="type" value="java.lang.String" />
                  </ColumnInfoDTO>
                  <ColumnInfoDTO>
                    <option name="comment" value="用户名(系统默认生成）" />
                    <option name="custom" value="false" />
                    <option name="ext" value="{}" />
                    <option name="name" value="nickName" />
                    <option name="type" value="java.lang.String" />
                  </ColumnInfoDTO>
                  <ColumnInfoDTO>
                    <option name="comment" value="备注信息" />
                    <option name="custom" value="false" />
                    <option name="ext" value="{}" />
                    <option name="name" value="note" />
                    <option name="type" value="java.lang.String" />
                  </ColumnInfoDTO>
                  <ColumnInfoDTO>
                    <option name="comment" value="创建时间" />
                    <option name="custom" value="false" />
                    <option name="ext" value="{}" />
                    <option name="name" value="createTime" />
                    <option name="type" value="java.util.Date" />
                  </ColumnInfoDTO>
                  <ColumnInfoDTO>
                    <option name="comment" value="最后登录时间" />
                    <option name="custom" value="false" />
                    <option name="ext" value="{}" />
                    <option name="name" value="loginTime" />
                    <option name="type" value="java.util.Date" />
                  </ColumnInfoDTO>
                  <ColumnInfoDTO>
                    <option name="comment" value="帐号启用状态：0-&gt;禁用；1-&gt;启用" />
                    <option name="custom" value="false" />
                    <option name="ext" value="{}" />
                    <option name="name" value="status" />
                    <option name="type" value="java.lang.Integer" />
                  </ColumnInfoDTO>
                  <ColumnInfoDTO>
                    <option name="comment" value="mac地址" />
                    <option name="custom" value="false" />
                    <option name="ext" value="{}" />
                    <option name="name" value="macAddress" />
                    <option name="type" value="java.lang.String" />
                  </ColumnInfoDTO>
                  <ColumnInfoDTO>
                    <option name="comment" value=" 0-&gt;女，1-&gt;男" />
                    <option name="custom" value="false" />
                    <option name="ext" value="{}" />
                    <option name="name" value="sex" />
                    <option name="type" value="java.lang.Integer" />
                  </ColumnInfoDTO>
                  <ColumnInfoDTO>
                    <option name="comment" value="是否党员 0-&gt;否，1-&gt;是" />
                    <option name="custom" value="false" />
                    <option name="ext" value="{}" />
                    <option name="name" value="isDy" />
                    <option name="type" value="java.lang.Integer" />
                  </ColumnInfoDTO>
                  <ColumnInfoDTO>
                    <option name="comment" value="职务" />
                    <option name="custom" value="false" />
                    <option name="ext" value="{}" />
                    <option name="name" value="jobTitle" />
                    <option name="type" value="java.lang.String" />
                  </ColumnInfoDTO>
                  <ColumnInfoDTO>
                    <option name="comment" value="ip地址" />
                    <option name="custom" value="false" />
                    <option name="ext" value="{}" />
                    <option name="name" value="ipAddress" />
                    <option name="type" value="java.lang.String" />
                  </ColumnInfoDTO>
                  <ColumnInfoDTO>
                    <option name="comment" value="用户类型" />
                    <option name="custom" value="false" />
                    <option name="ext" value="{}" />
                    <option name="name" value="userType" />
                    <option name="type" value="java.lang.Object" />
                  </ColumnInfoDTO>
                  <ColumnInfoDTO>
                    <option name="comment" value="座机/分机" />
                    <option name="custom" value="false" />
                    <option name="ext" value="{}" />
                    <option name="name" value="zj" />
                    <option name="type" value="java.lang.String" />
                  </ColumnInfoDTO>
                  <ColumnInfoDTO>
                    <option name="comment" value="手机" />
                    <option name="custom" value="false" />
                    <option name="ext" value="{}" />
                    <option name="name" value="mobile" />
                    <option name="type" value="java.lang.String" />
                  </ColumnInfoDTO>
                  <ColumnInfoDTO>
                    <option name="comment" value="是否为网格管理员：0-&gt;不是；1-&gt;是" />
                    <option name="custom" value="false" />
                    <option name="ext" value="{}" />
                    <option name="name" value="isGrid" />
                    <option name="type" value="java.lang.Integer" />
                  </ColumnInfoDTO>
                </list>
              </option>
              <option name="name" value="NewsAdmin" />
              <option name="preName" value="" />
              <option name="saveModelName" value="" />
              <option name="savePackageName" value="" />
              <option name="savePath" value="" />
              <option name="templateGroupName" value="" />
            </TableInfoDTO>
          </value>
        </entry>
        <entry key="news_website.news_channel">
          <value>
            <TableInfoDTO>
              <option name="comment" value="频道表" />
              <option name="fullColumn">
                <list>
                  <ColumnInfoDTO>
                    <option name="comment" value="id" />
                    <option name="custom" value="false" />
                    <option name="ext" value="{}" />
                    <option name="name" value="id" />
                    <option name="type" value="java.lang.Integer" />
                  </ColumnInfoDTO>
                  <ColumnInfoDTO>
                    <option name="comment" value="频道名称" />
                    <option name="custom" value="false" />
                    <option name="ext" value="{}" />
                    <option name="name" value="name" />
                    <option name="type" value="java.lang.String" />
                  </ColumnInfoDTO>
                  <ColumnInfoDTO>
                    <option name="comment" value="频道编码ps名称首字母" />
                    <option name="custom" value="false" />
                    <option name="ext" value="{}" />
                    <option name="name" value="code" />
                    <option name="type" value="java.lang.String" />
                  </ColumnInfoDTO>
                  <ColumnInfoDTO>
                    <option name="comment" value="创建时间" />
                    <option name="custom" value="false" />
                    <option name="ext" value="{}" />
                    <option name="name" value="createTime" />
                    <option name="type" value="java.util.Date" />
                  </ColumnInfoDTO>
                </list>
              </option>
              <option name="name" value="NewsChannel" />
              <option name="preName" value="" />
              <option name="saveModelName" value="ycl-platform" />
              <option name="savePackageName" value="com.ycl" />
              <option name="savePath" value="./ycl-platform/src/main/java/com/ycl" />
              <option name="templateGroupName" value="MybatisPlus-Mixed" />
            </TableInfoDTO>
          </value>
        </entry>
        <entry key="news_website.news_channel_column">
          <value>
            <TableInfoDTO>
              <option name="comment" value="频道栏目中间表" />
              <option name="fullColumn">
                <list>
                  <ColumnInfoDTO>
                    <option name="custom" value="false" />
                    <option name="ext" value="{}" />
                    <option name="name" value="id" />
                    <option name="type" value="java.lang.Integer" />
                  </ColumnInfoDTO>
                  <ColumnInfoDTO>
                    <option name="comment" value="频道id" />
                    <option name="custom" value="false" />
                    <option name="ext" value="{}" />
                    <option name="name" value="channelId" />
                    <option name="type" value="java.lang.Integer" />
                  </ColumnInfoDTO>
                  <ColumnInfoDTO>
                    <option name="comment" value="栏目id" />
                    <option name="custom" value="false" />
                    <option name="ext" value="{}" />
                    <option name="name" value="columnId" />
                    <option name="type" value="java.lang.Integer" />
                  </ColumnInfoDTO>
                </list>
              </option>
              <option name="name" value="NewsChannelColumn" />
              <option name="preName" value="" />
              <option name="saveModelName" value="ycl-platform" />
              <option name="savePackageName" value="com.ycl" />
              <option name="savePath" value="./ycl-platform/src/main/java/com/ycl" />
              <option name="templateGroupName" value="" />
            </TableInfoDTO>
          </value>
        </entry>
        <entry key="news_website.news_column">
          <value>
            <TableInfoDTO>
              <option name="comment" value="栏目表" />
              <option name="fullColumn">
                <list>
                  <ColumnInfoDTO>
                    <option name="comment" value="id" />
                    <option name="custom" value="false" />
                    <option name="ext" value="{}" />
                    <option name="name" value="id" />
                    <option name="type" value="java.lang.Object" />
                  </ColumnInfoDTO>
                  <ColumnInfoDTO>
                    <option name="comment" value="栏目名称" />
                    <option name="custom" value="false" />
                    <option name="ext" value="{}" />
                    <option name="name" value="name" />
                    <option name="type" value="java.lang.String" />
                  </ColumnInfoDTO>
                </list>
              </option>
              <option name="name" value="NewsColumn" />
              <option name="preName" value="" />
              <option name="saveModelName" value="ycl-platform" />
              <option name="savePackageName" value="com.ycl" />
              <option name="savePath" value="./ycl-platform/src/main/java/com/ycl" />
              <option name="templateGroupName" value="" />
            </TableInfoDTO>
          </value>
        </entry>
        <entry key="news_website.news_column_information">
          <value>
            <TableInfoDTO>
              <option name="comment" value="栏目频道中间表" />
              <option name="fullColumn">
                <list>
                  <ColumnInfoDTO>
                    <option name="custom" value="false" />
                    <option name="ext" value="{}" />
                    <option name="name" value="id" />
                    <option name="type" value="java.lang.Integer" />
                  </ColumnInfoDTO>
                  <ColumnInfoDTO>
                    <option name="comment" value="栏目id" />
                    <option name="custom" value="false" />
                    <option name="ext" value="{}" />
                    <option name="name" value="columnId" />
                    <option name="type" value="java.lang.Integer" />
                  </ColumnInfoDTO>
                  <ColumnInfoDTO>
                    <option name="comment" value="咨询id" />
                    <option name="custom" value="false" />
                    <option name="ext" value="{}" />
                    <option name="name" value="informationId" />
                    <option name="type" value="java.lang.Integer" />
                  </ColumnInfoDTO>
                </list>
              </option>
              <option name="name" value="NewsColumnInformation" />
              <option name="preName" value="" />
              <option name="saveModelName" value="ycl-platform" />
              <option name="savePackageName" value="com.ycl" />
              <option name="savePath" value="./ycl-platform/src/main/java/com/ycl" />
              <option name="templateGroupName" value="" />
            </TableInfoDTO>
          </value>
        </entry>
        <entry key="news_website.news_duty">
          <value>
            <TableInfoDTO>
              <option name="comment" value="值班表" />
              <option name="fullColumn">
                <list>
                  <ColumnInfoDTO>
                    <option name="custom" value="false" />
                    <option name="ext" value="{}" />
                    <option name="name" value="id" />
                    <option name="type" value="java.lang.Integer" />
                  </ColumnInfoDTO>
                  <ColumnInfoDTO>
                    <option name="comment" value="值班人" />
                    <option name="custom" value="false" />
                    <option name="ext" value="{}" />
                    <option name="name" value="name" />
                    <option name="type" value="java.lang.String" />
                  </ColumnInfoDTO>
                  <ColumnInfoDTO>
                    <option name="comment" value="值班职位" />
                    <option name="custom" value="false" />
                    <option name="ext" value="{}" />
                    <option name="name" value="jobTitle" />
                    <option name="type" value="java.lang.String" />
                  </ColumnInfoDTO>
                  <ColumnInfoDTO>
                    <option name="comment" value="创建时间" />
                    <option name="custom" value="false" />
                    <option name="ext" value="{}" />
                    <option name="name" value="createTime" />
                    <option name="type" value="java.util.Date" />
                  </ColumnInfoDTO>
                  <ColumnInfoDTO>
                    <option name="comment" value="值班时间" />
                    <option name="custom" value="false" />
                    <option name="ext" value="{}" />
                    <option name="name" value="dutyTime" />
                    <option name="type" value="java.util.Date" />
                  </ColumnInfoDTO>
                </list>
              </option>
              <option name="name" value="NewsDuty" />
              <option name="preName" value="" />
              <option name="saveModelName" value="ycl-platform" />
              <option name="savePackageName" value="com.ycl" />
              <option name="savePath" value="./ycl-platform/src/main/java/com/ycl" />
              <option name="templateGroupName" value="" />
            </TableInfoDTO>
          </value>
        </entry>
        <entry key="news_website.news_information">
          <value>
            <TableInfoDTO>
              <option name="comment" value="咨询表" />
              <option name="fullColumn">
                <list>
                  <ColumnInfoDTO>
                    <option name="comment" value="id" />
                    <option name="custom" value="false" />
                    <option name="ext" value="{}" />
                    <option name="name" value="id" />
                    <option name="type" value="java.lang.Object" />
                  </ColumnInfoDTO>
                  <ColumnInfoDTO>
                    <option name="comment" value="标题" />
                    <option name="custom" value="false" />
                    <option name="ext" value="{}" />
                    <option name="name" value="title" />
                    <option name="type" value="java.lang.String" />
                  </ColumnInfoDTO>
                  <ColumnInfoDTO>
                    <option name="comment" value="内容" />
                    <option name="custom" value="false" />
                    <option name="ext" value="{}" />
                    <option name="name" value="content" />
                    <option name="type" value="java.lang.String" />
                  </ColumnInfoDTO>
                  <ColumnInfoDTO>
                    <option name="comment" value="发布时间" />
                    <option name="custom" value="false" />
                    <option name="ext" value="{}" />
                    <option name="name" value="publishTime" />
                    <option name="type" value="java.util.Date" />
                  </ColumnInfoDTO>
                  <ColumnInfoDTO>
                    <option name="comment" value="是否签收1签收0未签收" />
                    <option name="custom" value="false" />
                    <option name="ext" value="{}" />
                    <option name="name" value="isSign" />
                    <option name="type" value="java.lang.Integer" />
                  </ColumnInfoDTO>
                  <ColumnInfoDTO>
                    <option name="comment" value="创建时间" />
                    <option name="custom" value="false" />
                    <option name="ext" value="{}" />
                    <option name="name" value="createTime" />
                    <option name="type" value="java.util.Date" />
                  </ColumnInfoDTO>
                  <ColumnInfoDTO>
                    <option name="comment" value="警员id" />
                    <option name="custom" value="false" />
                    <option name="ext" value="{}" />
                    <option name="name" value="sendTo" />
                    <option name="type" value="java.lang.Object" />
                  </ColumnInfoDTO>
                  <ColumnInfoDTO>
                    <option name="comment" value="图片地址" />
                    <option name="custom" value="false" />
                    <option name="ext" value="{}" />
                    <option name="name" value="imageUrl" />
                    <option name="type" value="java.lang.String" />
                  </ColumnInfoDTO>
                </list>
              </option>
              <option name="name" value="NewsInformation" />
              <option name="preName" value="" />
              <option name="saveModelName" value="ycl-platform" />
              <option name="savePackageName" value="com.ycl" />
              <option name="savePath" value="./ycl-platform/src/main/java/com/ycl" />
              <option name="templateGroupName" value="" />
            </TableInfoDTO>
          </value>
        </entry>
        <entry key="news_website.news_ip">
          <value>
            <TableInfoDTO>
              <option name="comment" value="ip白名单表" />
              <option name="fullColumn">
                <list>
                  <ColumnInfoDTO>
                    <option name="custom" value="false" />
                    <option name="ext" value="{}" />
                    <option name="name" value="id" />
                    <option name="type" value="java.lang.Integer" />
                  </ColumnInfoDTO>
                  <ColumnInfoDTO>
                    <option name="comment" value="ip地址" />
                    <option name="custom" value="false" />
                    <option name="ext" value="{}" />
                    <option name="name" value="ipAddess" />
                    <option name="type" value="java.lang.String" />
                  </ColumnInfoDTO>
                  <ColumnInfoDTO>
                    <option name="comment" value="创建时间" />
                    <option name="custom" value="false" />
                    <option name="ext" value="{}" />
                    <option name="name" value="createTime" />
                    <option name="type" value="java.util.Date" />
                  </ColumnInfoDTO>
                </list>
              </option>
              <option name="name" value="NewsIp" />
              <option name="preName" value="" />
              <option name="saveModelName" value="ycl-platform" />
              <option name="savePackageName" value="com.ycl" />
              <option name="savePath" value="./ycl-platform/src/main/java/com/ycl" />
              <option name="templateGroupName" value="" />
            </TableInfoDTO>
          </value>
        </entry>
        <entry key="news_website.news_police">
          <value>
            <TableInfoDTO>
              <option name="comment" value="警员表&#13;&#10;" />
              <option name="fullColumn">
                <list>
                  <ColumnInfoDTO>
                    <option name="comment" value="自增主键" />
                    <option name="custom" value="false" />
                    <option name="ext" value="{}" />
                    <option name="name" value="id" />
                    <option name="type" value="java.lang.Object" />
                  </ColumnInfoDTO>
                  <ColumnInfoDTO>
                    <option name="comment" value="警员名称" />
                    <option name="custom" value="false" />
                    <option name="ext" value="{}" />
                    <option name="name" value="rname" />
                    <option name="type" value="java.lang.String" />
                  </ColumnInfoDTO>
                  <ColumnInfoDTO>
                    <option name="comment" value="创建时间" />
                    <option name="custom" value="false" />
                    <option name="ext" value="{}" />
                    <option name="name" value="createTime" />
                    <option name="type" value="java.util.Date" />
                  </ColumnInfoDTO>
                  <ColumnInfoDTO>
                    <option name="comment" value="修改时间" />
                    <option name="custom" value="false" />
                    <option name="ext" value="{}" />
                    <option name="name" value="updateTime" />
                    <option name="type" value="java.util.Date" />
                  </ColumnInfoDTO>
                  <ColumnInfoDTO>
                    <option name="comment" value="机构名称" />
                    <option name="custom" value="false" />
                    <option name="ext" value="{}" />
                    <option name="name" value="organizationName" />
                    <option name="type" value="java.lang.String" />
                  </ColumnInfoDTO>
                </list>
              </option>
              <option name="name" value="NewsPolice" />
              <option name="preName" value="" />
              <option name="saveModelName" value="ycl-platform" />
              <option name="savePackageName" value="com.ycl" />
              <option name="savePath" value="./ycl-platform/src/main/java/com/ycl" />
              <option name="templateGroupName" value="" />
            </TableInfoDTO>
          </value>
        </entry>
      </map>
    </option>
  </component>
<?xml version="1.0" encoding="UTF-8"?>

<project version="4">

  <component name="EasyCodeTableSetting">

    <option name="tableInfoMap">

      <map>

        <entry key="news_website.news_admin">

          <value>

            <TableInfoDTO>

              <option name="comment" value="后台用户表" />

              <option name="fullColumn">

                <list>

                  <ColumnInfoDTO>

                    <option name="custom" value="false" />

                    <option name="ext" value="{}" />

                    <option name="name" value="id" />

                    <option name="type" value="java.lang.Long" />

                  </ColumnInfoDTO>

                  <ColumnInfoDTO>

                    <option name="comment" value="用户姓名" />

                    <option name="custom" value="false" />

                    <option name="ext" value="{}" />

                    <option name="name" value="username" />

                    <option name="type" value="java.lang.String" />

                  </ColumnInfoDTO>

                  <ColumnInfoDTO>

                    <option name="comment" value="密码" />

                    <option name="custom" value="false" />

                    <option name="ext" value="{}" />

                    <option name="name" value="password" />

                    <option name="type" value="java.lang.String" />

                  </ColumnInfoDTO>

                  <ColumnInfoDTO>

                    <option name="comment" value="头像" />

                    <option name="custom" value="false" />

                    <option name="ext" value="{}" />

                    <option name="name" value="icon" />

                    <option name="type" value="java.lang.String" />

                  </ColumnInfoDTO>

                  <ColumnInfoDTO>

                    <option name="comment" value="邮箱" />

                    <option name="custom" value="false" />

                    <option name="ext" value="{}" />

                    <option name="name" value="email" />

                    <option name="type" value="java.lang.String" />

                  </ColumnInfoDTO>

                  <ColumnInfoDTO>

                    <option name="comment" value="备注信息" />

                    <option name="custom" value="false" />

                    <option name="ext" value="{}" />

                    <option name="name" value="note" />

                    <option name="type" value="java.lang.String" />

                  </ColumnInfoDTO>

                  <ColumnInfoDTO>

                    <option name="comment" value="创建时间" />

                    <option name="custom" value="false" />

                    <option name="ext" value="{}" />

                    <option name="name" value="createTime" />

                    <option name="type" value="java.util.Date" />

                  </ColumnInfoDTO>

                  <ColumnInfoDTO>

                    <option name="comment" value="帐号启用状态：0-&gt;禁用；1-&gt;启用" />

                    <option name="custom" value="false" />

                    <option name="ext" value="{}" />

                    <option name="name" value="status" />

                    <option name="type" value="java.lang.Integer" />

                  </ColumnInfoDTO>

                  <ColumnInfoDTO>

                    <option name="comment" value=" 0-&gt;女，1-&gt;男" />

                    <option name="custom" value="false" />

                    <option name="ext" value="{}" />

                    <option name="name" value="sex" />

                    <option name="type" value="java.lang.Integer" />

                  </ColumnInfoDTO>

                  <ColumnInfoDTO>

                    <option name="comment" value="手机" />

                    <option name="custom" value="false" />

                    <option name="ext" value="{}" />

                    <option name="name" value="mobile" />

                    <option name="type" value="java.lang.String" />

                  </ColumnInfoDTO>

                  <ColumnInfoDTO>

                    <option name="comment" value="是否为网格管理员：0-&gt;不是；1-&gt;是" />

                    <option name="custom" value="false" />

                    <option name="ext" value="{}" />

                    <option name="name" value="isGrid" />

                    <option name="type" value="java.lang.Integer" />

                  </ColumnInfoDTO>

                  <ColumnInfoDTO>

                    <option name="comment" value="部门id" />

                    <option name="custom" value="false" />

                    <option name="ext" value="{}" />

                    <option name="name" value="newsDepartmentId" />

                    <option name="type" value="java.lang.Integer" />

                  </ColumnInfoDTO>

                </list>

              </option>

              <option name="name" value="NewsAdmin" />

              <option name="preName" value="" />

              <option name="saveModelName" value="ycl-platform" />

              <option name="savePackageName" value="com.ycl" />

              <option name="savePath" value="./ycl-platform/src/main/java/com/ycl" />

              <option name="templateGroupName" value="MybatisPlus-Mixed" />

            </TableInfoDTO>

          </value>

        </entry>

        <entry key="news_website.news_channel">

          <value>

            <TableInfoDTO>

              <option name="comment" value="频道表" />

              <option name="fullColumn">

                <list>

                  <ColumnInfoDTO>

                    <option name="comment" value="id" />

                    <option name="custom" value="false" />

                    <option name="ext" value="{}" />

                    <option name="name" value="id" />

                    <option name="type" value="java.lang.Integer" />

                  </ColumnInfoDTO>

                  <ColumnInfoDTO>

                    <option name="comment" value="频道名称" />

                    <option name="custom" value="false" />

                    <option name="ext" value="{}" />

                    <option name="name" value="name" />

                    <option name="type" value="java.lang.String" />

                  </ColumnInfoDTO>

                  <ColumnInfoDTO>

                    <option name="comment" value="频道编码ps名称首字母" />

                    <option name="custom" value="false" />

                    <option name="ext" value="{}" />

                    <option name="name" value="code" />

                    <option name="type" value="java.lang.String" />

                  </ColumnInfoDTO>

                  <ColumnInfoDTO>

                    <option name="comment" value="创建时间" />

                    <option name="custom" value="false" />

                    <option name="ext" value="{}" />

                    <option name="name" value="createTime" />

                    <option name="type" value="java.util.Date" />

                  </ColumnInfoDTO>

                </list>

              </option>

              <option name="name" value="NewsChannel" />

              <option name="preName" value="" />

              <option name="saveModelName" value="ycl-platform" />

              <option name="savePackageName" value="com.ycl" />

              <option name="savePath" value="./ycl-platform/src/main/java/com/ycl" />

              <option name="templateGroupName" value="MybatisPlus-Mixed" />

            </TableInfoDTO>

          </value>

        </entry>

        <entry key="news_website.news_channel_column">

          <value>

            <TableInfoDTO>

              <option name="comment" value="频道栏目中间表" />

              <option name="fullColumn">

                <list>

                  <ColumnInfoDTO>

                    <option name="custom" value="false" />

                    <option name="ext" value="{}" />

                    <option name="name" value="id" />

                    <option name="type" value="java.lang.Integer" />

                  </ColumnInfoDTO>

                  <ColumnInfoDTO>

                    <option name="comment" value="频道id" />

                    <option name="custom" value="false" />

                    <option name="ext" value="{}" />

                    <option name="name" value="channelId" />

                    <option name="type" value="java.lang.Integer" />

                  </ColumnInfoDTO>

                  <ColumnInfoDTO>

                    <option name="comment" value="栏目id" />

                    <option name="custom" value="false" />

                    <option name="ext" value="{}" />

                    <option name="name" value="columnId" />

                    <option name="type" value="java.lang.Integer" />

                  </ColumnInfoDTO>

                </list>

              </option>

              <option name="name" value="NewsChannelColumn" />

              <option name="preName" value="" />

              <option name="saveModelName" value="ycl-platform" />

              <option name="savePackageName" value="com.ycl" />

              <option name="savePath" value="./ycl-platform/src/main/java/com/ycl" />

              <option name="templateGroupName" value="" />

            </TableInfoDTO>

          </value>

        </entry>

        <entry key="news_website.news_column">

          <value>

            <TableInfoDTO>

              <option name="comment" value="栏目表" />

              <option name="fullColumn">

                <list>

                  <ColumnInfoDTO>

                    <option name="comment" value="id" />

                    <option name="custom" value="false" />

                    <option name="ext" value="{}" />

                    <option name="name" value="id" />

                    <option name="type" value="java.lang.Object" />

                  </ColumnInfoDTO>

                  <ColumnInfoDTO>

                    <option name="comment" value="栏目名称" />

                    <option name="custom" value="false" />

                    <option name="ext" value="{}" />

                    <option name="name" value="name" />

                    <option name="type" value="java.lang.String" />

                  </ColumnInfoDTO>

                </list>

              </option>

              <option name="name" value="NewsColumn" />

              <option name="preName" value="" />

              <option name="saveModelName" value="ycl-platform" />

              <option name="savePackageName" value="com.ycl" />

              <option name="savePath" value="./ycl-platform/src/main/java/com/ycl" />

              <option name="templateGroupName" value="" />

            </TableInfoDTO>

          </value>

        </entry>

        <entry key="news_website.news_column_information">

          <value>

            <TableInfoDTO>

              <option name="comment" value="栏目频道中间表" />

              <option name="fullColumn">

                <list>

                  <ColumnInfoDTO>

                    <option name="custom" value="false" />

                    <option name="ext" value="{}" />

                    <option name="name" value="id" />

                    <option name="type" value="java.lang.Integer" />

                  </ColumnInfoDTO>

                  <ColumnInfoDTO>

                    <option name="comment" value="栏目id" />

                    <option name="custom" value="false" />

                    <option name="ext" value="{}" />

                    <option name="name" value="columnId" />

                    <option name="type" value="java.lang.Integer" />

                  </ColumnInfoDTO>

                  <ColumnInfoDTO>

                    <option name="comment" value="咨询id" />

                    <option name="custom" value="false" />

                    <option name="ext" value="{}" />

                    <option name="name" value="informationId" />

                    <option name="type" value="java.lang.Integer" />

                  </ColumnInfoDTO>

                </list>

              </option>

              <option name="name" value="NewsColumnInformation" />

              <option name="preName" value="" />

              <option name="saveModelName" value="ycl-platform" />

              <option name="savePackageName" value="com.ycl" />

              <option name="savePath" value="./ycl-platform/src/main/java/com/ycl" />

              <option name="templateGroupName" value="" />

            </TableInfoDTO>

          </value>

        </entry>

        <entry key="news_website.news_department">

          <value>

            <TableInfoDTO>

              <option name="fullColumn">

                <list>

                  <ColumnInfoDTO>

                    <option name="custom" value="false" />

                    <option name="ext" value="{}" />

                    <option name="name" value="id" />

                    <option name="type" value="java.lang.Integer" />

                  </ColumnInfoDTO>

                  <ColumnInfoDTO>

                    <option name="comment" value="部门名称" />

                    <option name="custom" value="false" />

                    <option name="ext" value="{}" />

                    <option name="name" value="deptname" />

                    <option name="type" value="java.lang.String" />

                  </ColumnInfoDTO>

                </list>

              </option>

              <option name="name" value="NewsDepartment" />

              <option name="preName" value="" />

              <option name="saveModelName" value="ycl-platform" />

              <option name="savePackageName" value="com.ycl" />

              <option name="savePath" value="./ycl-platform/src/main/java/com/ycl" />

              <option name="templateGroupName" value="MybatisPlus-Mixed" />

            </TableInfoDTO>

          </value>

        </entry>

        <entry key="news_website.news_duty">

          <value>

            <TableInfoDTO>

              <option name="comment" value="值班表" />

              <option name="fullColumn">

                <list>

                  <ColumnInfoDTO>

                    <option name="custom" value="false" />

                    <option name="ext" value="{}" />

                    <option name="name" value="id" />

                    <option name="type" value="java.lang.Integer" />

                  </ColumnInfoDTO>

                  <ColumnInfoDTO>

                    <option name="comment" value="值班人" />

                    <option name="custom" value="false" />

                    <option name="ext" value="{}" />

                    <option name="name" value="name" />

                    <option name="type" value="java.lang.String" />

                  </ColumnInfoDTO>

                  <ColumnInfoDTO>

                    <option name="comment" value="值班职位" />

                    <option name="custom" value="false" />

                    <option name="ext" value="{}" />

                    <option name="name" value="jobTitle" />

                    <option name="type" value="java.lang.String" />

                  </ColumnInfoDTO>

                  <ColumnInfoDTO>

                    <option name="comment" value="创建时间" />

                    <option name="custom" value="false" />

                    <option name="ext" value="{}" />

                    <option name="name" value="createTime" />

                    <option name="type" value="java.util.Date" />

                  </ColumnInfoDTO>

                  <ColumnInfoDTO>

                    <option name="comment" value="值班时间" />

                    <option name="custom" value="false" />

                    <option name="ext" value="{}" />

                    <option name="name" value="dutyTime" />

                    <option name="type" value="java.util.Date" />

                  </ColumnInfoDTO>

                </list>

              </option>

              <option name="name" value="NewsDuty" />

              <option name="preName" value="" />

              <option name="saveModelName" value="ycl-platform" />

              <option name="savePackageName" value="com.ycl" />

              <option name="savePath" value="./ycl-platform/src/main/java/com/ycl" />

              <option name="templateGroupName" value="" />

            </TableInfoDTO>

          </value>

        </entry>

        <entry key="news_website.news_information">

          <value>

            <TableInfoDTO>

              <option name="comment" value="咨询表" />

              <option name="fullColumn">

                <list>

                  <ColumnInfoDTO>

                    <option name="comment" value="id" />

                    <option name="custom" value="false" />

                    <option name="ext" value="{}" />

                    <option name="name" value="id" />

                    <option name="type" value="java.lang.Object" />

                  </ColumnInfoDTO>

                  <ColumnInfoDTO>

                    <option name="comment" value="标题" />

                    <option name="custom" value="false" />

                    <option name="ext" value="{}" />

                    <option name="name" value="title" />

                    <option name="type" value="java.lang.String" />

                  </ColumnInfoDTO>

                  <ColumnInfoDTO>

                    <option name="comment" value="内容" />

                    <option name="custom" value="false" />

                    <option name="ext" value="{}" />

                    <option name="name" value="content" />

                    <option name="type" value="java.lang.String" />

                  </ColumnInfoDTO>

                  <ColumnInfoDTO>

                    <option name="comment" value="发布时间" />

                    <option name="custom" value="false" />

                    <option name="ext" value="{}" />

                    <option name="name" value="publishTime" />

                    <option name="type" value="java.util.Date" />

                  </ColumnInfoDTO>

                  <ColumnInfoDTO>

                    <option name="comment" value="是否签收1签收0未签收" />

                    <option name="custom" value="false" />

                    <option name="ext" value="{}" />

                    <option name="name" value="isSign" />

                    <option name="type" value="java.lang.Integer" />

                  </ColumnInfoDTO>

                  <ColumnInfoDTO>

                    <option name="comment" value="创建时间" />

                    <option name="custom" value="false" />

                    <option name="ext" value="{}" />

                    <option name="name" value="createTime" />

                    <option name="type" value="java.util.Date" />

                  </ColumnInfoDTO>

                  <ColumnInfoDTO>

                    <option name="comment" value="警员id" />

                    <option name="custom" value="false" />

                    <option name="ext" value="{}" />

                    <option name="name" value="sendTo" />

                    <option name="type" value="java.lang.Object" />

                  </ColumnInfoDTO>

                  <ColumnInfoDTO>

                    <option name="comment" value="图片地址" />

                    <option name="custom" value="false" />

                    <option name="ext" value="{}" />

                    <option name="name" value="imageUrl" />

                    <option name="type" value="java.lang.String" />

                  </ColumnInfoDTO>

                </list>

              </option>

              <option name="name" value="NewsInformation" />

              <option name="preName" value="" />

              <option name="saveModelName" value="ycl-platform" />

              <option name="savePackageName" value="com.ycl" />

              <option name="savePath" value="./ycl-platform/src/main/java/com/ycl" />

              <option name="templateGroupName" value="" />

            </TableInfoDTO>

          </value>

        </entry>

        <entry key="news_website.news_ip">

          <value>

            <TableInfoDTO>

              <option name="comment" value="ip白名单表" />

              <option name="fullColumn">

                <list>

                  <ColumnInfoDTO>

                    <option name="custom" value="false" />

                    <option name="ext" value="{}" />

                    <option name="name" value="id" />

                    <option name="type" value="java.lang.Integer" />

                  </ColumnInfoDTO>

                  <ColumnInfoDTO>

                    <option name="comment" value="ip地址" />

                    <option name="custom" value="false" />

                    <option name="ext" value="{}" />

                    <option name="name" value="ipAddess" />

                    <option name="type" value="java.lang.String" />

                  </ColumnInfoDTO>

                  <ColumnInfoDTO>

                    <option name="comment" value="创建时间" />

                    <option name="custom" value="false" />

                    <option name="ext" value="{}" />

                    <option name="name" value="createTime" />

                    <option name="type" value="java.util.Date" />

                  </ColumnInfoDTO>

                </list>

              </option>

              <option name="name" value="NewsIp" />

              <option name="preName" value="" />

              <option name="saveModelName" value="ycl-platform" />

              <option name="savePackageName" value="com.ycl" />

              <option name="savePath" value="./ycl-platform/src/main/java/com/ycl" />

              <option name="templateGroupName" value="" />

            </TableInfoDTO>

          </value>

        </entry>

        <entry key="news_website.news_police">

          <value>

            <TableInfoDTO>

              <option name="comment" value="警员表&#13;&#10;" />

              <option name="fullColumn">

                <list>

                  <ColumnInfoDTO>

                    <option name="comment" value="自增主键" />

                    <option name="custom" value="false" />

                    <option name="ext" value="{}" />

                    <option name="name" value="id" />

                    <option name="type" value="java.lang.Object" />

                  </ColumnInfoDTO>

                  <ColumnInfoDTO>

                    <option name="comment" value="警员名称" />

                    <option name="custom" value="false" />

                    <option name="ext" value="{}" />

                    <option name="name" value="rname" />

                    <option name="type" value="java.lang.String" />

                  </ColumnInfoDTO>

                  <ColumnInfoDTO>

                    <option name="comment" value="创建时间" />

                    <option name="custom" value="false" />

                    <option name="ext" value="{}" />

                    <option name="name" value="createTime" />

                    <option name="type" value="java.util.Date" />

                  </ColumnInfoDTO>

                  <ColumnInfoDTO>

                    <option name="comment" value="修改时间" />

                    <option name="custom" value="false" />

                    <option name="ext" value="{}" />

                    <option name="name" value="updateTime" />

                    <option name="type" value="java.util.Date" />

                  </ColumnInfoDTO>

                  <ColumnInfoDTO>

                    <option name="comment" value="机构名称" />

                    <option name="custom" value="false" />

                    <option name="ext" value="{}" />

                    <option name="name" value="organizationName" />

                    <option name="type" value="java.lang.String" />

                  </ColumnInfoDTO>

                </list>

              </option>

              <option name="name" value="NewsPolice" />

              <option name="preName" value="" />

              <option name="saveModelName" value="ycl-platform" />

              <option name="savePackageName" value="com.ycl" />

              <option name="savePath" value="./ycl-platform/src/main/java/com/ycl" />

              <option name="templateGroupName" value="" />

            </TableInfoDTO>

          </value>

        </entry>

      </map>

    </option>

  </component>

</project>

 .idea/vcs.xml

New file
@@ -0,0 +1,6 @@
<?xml version="1.0" encoding="UTF-8"?>

<project version="4">

  <component name="VcsDirectoryMappings">

    <mapping directory="" vcs="Git" />

  </component>

</project>

 logs/ycl/platform/error/2022-11-17/0.log

 logs/ycl/platform/normal/2022-11-17/0.log

New file
@@ -0,0 +1,40 @@
10:02:33.243 [background-preinit] INFO  o.h.v.i.u.Version - HV000001: Hibernate Validator 6.2.3.Final

10:02:33.257 [main] INFO  c.y.PlatformApplication - Starting PlatformApplication using Java 1.8.0_141 on ONB9MJU0KA3P0SP with PID 16036 (D:\ideaproject\ycl-airport-server\ycl-platform\target\classes started by Administrator in D:\ideaproject\ycl-airport-server)

10:02:33.257 [main] INFO  c.y.PlatformApplication - Starting PlatformApplication using Java 1.8.0_141 on ONB9MJU0KA3P0SP with PID 16036 (D:\ideaproject\ycl-airport-server\ycl-platform\target\classes started by Administrator in D:\ideaproject\ycl-airport-server)

10:02:33.258 [main] DEBUG c.y.PlatformApplication - Running with Spring Boot v2.7.0, Spring v5.3.20

10:02:33.258 [main] DEBUG c.y.PlatformApplication - Running with Spring Boot v2.7.0, Spring v5.3.20

10:02:33.258 [main] INFO  c.y.PlatformApplication - The following 1 profile is active: "dev"

10:02:33.258 [main] INFO  c.y.PlatformApplication - The following 1 profile is active: "dev"

10:02:34.153 [main] INFO  o.s.d.r.c.RepositoryConfigurationDelegate - Multiple Spring Data modules found, entering strict repository configuration mode!

10:02:34.155 [main] INFO  o.s.d.r.c.RepositoryConfigurationDelegate - Bootstrapping Spring Data Redis repositories in DEFAULT mode.

10:02:34.196 [main] INFO  o.s.d.r.c.RepositoryConfigurationDelegate - Finished Spring Data repository scanning in 18 ms. Found 0 Redis repository interfaces.

10:02:34.648 [main] INFO  o.s.c.s.PostProcessorRegistrationDelegate$BeanPostProcessorChecker - Bean 'beanPostProcessorConfig' of type [com.ycl.config.BeanPostProcessorConfig$$EnhancerBySpringCGLIB$$b9084885] is not eligible for getting processed by all BeanPostProcessors (for example: not eligible for auto-proxying)

10:02:34.901 [main] INFO  o.s.b.w.e.t.TomcatWebServer - Tomcat initialized with port(s): 8082 (http)

10:02:34.910 [main] INFO  o.a.c.h.Http11NioProtocol - Initializing ProtocolHandler ["http-nio-8082"]

10:02:34.911 [main] INFO  o.a.c.c.StandardService - Starting service [Tomcat]

10:02:34.911 [main] INFO  o.a.c.c.StandardEngine - Starting Servlet engine: [Apache Tomcat/9.0.63]

10:02:35.032 [main] INFO  o.a.c.c.C.[.[.[/air] - Initializing Spring embedded WebApplicationContext

10:02:35.032 [main] INFO  o.s.b.w.s.c.ServletWebServerApplicationContext - Root WebApplicationContext: initialization completed in 1735 ms

10:02:35.107 [main] INFO  c.a.d.s.b.a.DruidDataSourceAutoConfigure - Init DruidDataSource

10:02:35.200 [main] INFO  c.a.d.p.DruidDataSource - {dataSource-1} inited

10:02:37.711 [main] INFO  o.a.c.h.Http11NioProtocol - Starting ProtocolHandler ["http-nio-8082"]

10:02:37.735 [main] INFO  o.s.b.w.e.t.TomcatWebServer - Tomcat started on port(s): 8082 (http) with context path '/air'

10:02:38.191 [main] WARN  s.d.s.r.o.OperationImplicitParameterReader - Unable to interpret the implicit parameter configuration with dataType: Array, dataTypeClass: class java.lang.Void

10:02:38.231 [main] WARN  s.d.s.r.o.OperationImplicitParameterReader - Unable to interpret the implicit parameter configuration with dataType: Array, dataTypeClass: class java.lang.Void

10:02:38.231 [main] WARN  s.d.s.r.o.OperationImplicitParameterReader - Unable to interpret the implicit parameter configuration with dataType: Integer, dataTypeClass: class java.lang.Void

10:02:38.346 [main] WARN  s.d.s.r.o.OperationImplicitParameterReader - Unable to interpret the implicit parameter configuration with dataType: Array, dataTypeClass: class java.lang.Void

10:02:38.346 [main] WARN  s.d.s.r.o.OperationImplicitParameterReader - Unable to interpret the implicit parameter configuration with dataType: Integer, dataTypeClass: class java.lang.Void

10:02:38.372 [main] INFO  c.y.PlatformApplication - Started PlatformApplication in 5.657 seconds (JVM running for 6.632)

10:02:38.372 [main] INFO  c.y.PlatformApplication - Started PlatformApplication in 5.657 seconds (JVM running for 6.632)

10:02:38.374 [main] INFO  c.y.PlatformApplication - 
----------------------------------------------------------
    应用 'sccg-platform' 运行成功! 访问连接:
    Swagger文档:         http://192.168.3.185:8082/air/doc.html
    数据库监控:         http://127.0.0.1:8082/druid
----------------------------------------------------------

10:02:38.374 [main] INFO  c.y.PlatformApplication - 
----------------------------------------------------------
    应用 'sccg-platform' 运行成功! 访问连接:
    Swagger文档:         http://192.168.3.185:8082/air/doc.html
    数据库监控:         http://127.0.0.1:8082/druid
----------------------------------------------------------


 ycl-platform/src/main/java/com/ycl/controller/NewsAdminController.java

New file
@@ -0,0 +1,88 @@
package com.ycl.controller;







import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper;

import com.baomidou.mybatisplus.extension.api.ApiController;

import com.baomidou.mybatisplus.extension.api.R;

import com.baomidou.mybatisplus.extension.plugins.pagination.Page;

import com.ycl.entity.NewsAdmin;

import com.ycl.service.NewsAdminService;

import org.springframework.web.bind.annotation.*;



import javax.annotation.Resource;

import java.io.Serializable;

import java.util.List;



/**

 * 后台用户表(NewsAdmin)表控制层

 *

 * @author makejava

 * @since 2022-11-17 11:12:41

 */

@RestController

@RequestMapping("newsAdmin")

public class NewsAdminController extends ApiController {

    /**

     * 服务对象

     */

    @Resource

    private NewsAdminService newsAdminService;



    /**

     * 分页查询所有数据

     *

     * @param page 分页对象

     * @param newsAdmin 查询实体

     * @return 所有数据

     */

    @GetMapping

    public R selectAll(Page<NewsAdmin> page, NewsAdmin newsAdmin) {

        return success(this.newsAdminService.page(page, new QueryWrapper<>(newsAdmin)));

    }



    /**

     * 通过主键查询单条数据

     *

     * @param id 主键

     * @return 单条数据

     */

    @GetMapping("{id}")

    public R selectOne(@PathVariable Serializable id) {

        return success(this.newsAdminService.getById(id));

    }



    /**

     * 新增数据

     *

     * @param newsAdmin 实体对象

     * @return 新增结果

     */

    @PostMapping

    public R insert(@RequestBody NewsAdmin newsAdmin) {

        return success(this.newsAdminService.save(newsAdmin));

    }



    /**

     * 修改数据

     *

     * @param newsAdmin 实体对象

     * @return 修改结果

     */

    @PutMapping

    public R update(@RequestBody NewsAdmin newsAdmin) {

        return success(this.newsAdminService.updateById(newsAdmin));

    }



    /**

     * 删除数据

     *

     * @param idList 主键结合

     * @return 删除结果

     */

    @DeleteMapping

    public R delete(@RequestParam("idList") List<Long> idList) {

        return success(this.newsAdminService.removeByIds(idList));

    }

}




 ycl-platform/src/main/java/com/ycl/controller/NewsChannelColumnController.java

@@ -1,96 +1,88 @@
package com.ycl.controller;



import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper;
import com.baomidou.mybatisplus.extension.api.ApiController;
import com.baomidou.mybatisplus.extension.api.R;
import com.baomidou.mybatisplus.extension.plugins.pagination.Page;
import com.ycl.entity.NewsChannelColumn;
import com.ycl.service.NewsChannelColumnService;
import io.swagger.annotations.Api;
import io.swagger.annotations.ApiOperation;
import org.springframework.web.bind.annotation.*;

import javax.annotation.Resource;
import java.io.Serializable;
import java.util.List;

/**
 * 频道栏目中间表(NewsChannelColumn)表控制层
 *
 * @author makejava
 * @since 2022-11-16 16:52:30
 */
@RestController
@RequestMapping("newsChannelColumn")
@Api(tags = "频道栏目")
public class NewsChannelColumnController extends ApiController {
    /**
     * 服务对象
     */
    @Resource
    private NewsChannelColumnService newsChannelColumnService;

    /**
     * 分页查询所有数据
     *
     * @param page 分页对象
     * @param newsChannelColumn 查询实体
     * @return 所有数据
     */
    @GetMapping
    @ApiOperation(value = "查找全部")
    public R selectAll(Page<NewsChannelColumn> page, NewsChannelColumn newsChannelColumn) {
        return success(this.newsChannelColumnService.page(page, new QueryWrapper<>(newsChannelColumn)));
    }

    /**
     * 通过主键查询单条数据
     *
     * @param id 主键
     * @return 单条数据
     */
    @ApiOperation(value = "按id查找")
    @GetMapping("{id}")
    public R selectOne(@PathVariable Serializable id) {
        return success(this.newsChannelColumnService.getById(id));
    }

    /**
     * 新增数据
     *
     * @param newsChannelColumn 实体对象
     * @return 新增结果
     */
    @ApiOperation(value = "新增")
    @PostMapping
    public R insert(@RequestBody NewsChannelColumn newsChannelColumn) {
        return success(this.newsChannelColumnService.save(newsChannelColumn));
    }

    /**
     * 修改数据
     *
     * @param newsChannelColumn 实体对象
     * @return 修改结果
     */
    @ApiOperation(value = "修改")
    @PutMapping
    public R update(@RequestBody NewsChannelColumn newsChannelColumn) {
        return success(this.newsChannelColumnService.updateById(newsChannelColumn));
    }

    /**
     * 删除数据
     *
     * @param idList 主键结合
     * @return 删除结果
     */
    @ApiOperation(value = "删除")
    @DeleteMapping
    public R delete(@RequestParam("idList") List<Long> idList) {
        return success(this.newsChannelColumnService.removeByIds(idList));
    }
}

package com.ycl.controller;







import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper;

import com.baomidou.mybatisplus.extension.api.ApiController;

import com.baomidou.mybatisplus.extension.api.R;

import com.baomidou.mybatisplus.extension.plugins.pagination.Page;

import com.ycl.entity.NewsChannelColumn;

import com.ycl.service.NewsChannelColumnService;

import org.springframework.web.bind.annotation.*;



import javax.annotation.Resource;

import java.io.Serializable;

import java.util.List;



/**

 * 频道栏目中间表(NewsChannelColumn)表控制层

 *

 * @author makejava

 * @since 2022-11-17 11:12:41

 */

@RestController

@RequestMapping("newsChannelColumn")

public class NewsChannelColumnController extends ApiController {

    /**

     * 服务对象

     */

    @Resource

    private NewsChannelColumnService newsChannelColumnService;



    /**

     * 分页查询所有数据

     *

     * @param page 分页对象

     * @param newsChannelColumn 查询实体

     * @return 所有数据

     */

    @GetMapping

    public R selectAll(Page<NewsChannelColumn> page, NewsChannelColumn newsChannelColumn) {

        return success(this.newsChannelColumnService.page(page, new QueryWrapper<>(newsChannelColumn)));

    }



    /**

     * 通过主键查询单条数据

     *

     * @param id 主键

     * @return 单条数据

     */

    @GetMapping("{id}")

    public R selectOne(@PathVariable Serializable id) {

        return success(this.newsChannelColumnService.getById(id));

    }



    /**

     * 新增数据

     *

     * @param newsChannelColumn 实体对象

     * @return 新增结果

     */

    @PostMapping

    public R insert(@RequestBody NewsChannelColumn newsChannelColumn) {

        return success(this.newsChannelColumnService.save(newsChannelColumn));

    }



    /**

     * 修改数据

     *

     * @param newsChannelColumn 实体对象

     * @return 修改结果

     */

    @PutMapping

    public R update(@RequestBody NewsChannelColumn newsChannelColumn) {

        return success(this.newsChannelColumnService.updateById(newsChannelColumn));

    }



    /**

     * 删除数据

     *

     * @param idList 主键结合

     * @return 删除结果

     */

    @DeleteMapping

    public R delete(@RequestParam("idList") List<Long> idList) {

        return success(this.newsChannelColumnService.removeByIds(idList));

    }

}




 ycl-platform/src/main/java/com/ycl/controller/NewsChannelController.java

@@ -1,88 +1,88 @@
package com.ycl.controller;



import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper;
import com.baomidou.mybatisplus.extension.api.ApiController;
import com.baomidou.mybatisplus.extension.api.R;
import com.baomidou.mybatisplus.extension.plugins.pagination.Page;
import com.ycl.entity.NewsChannel;
import com.ycl.service.NewsChannelService;
import org.springframework.web.bind.annotation.*;

import javax.annotation.Resource;
import java.io.Serializable;
import java.util.List;

/**
 * 频道表(NewsChannel)表控制层
 *
 * @author makejava
 * @since 2022-11-16 16:52:30
 */
@RestController
@RequestMapping("newsChannel")
public class NewsChannelController extends ApiController {
    /**
     * 服务对象
     */
    @Resource
    private NewsChannelService newsChannelService;

    /**
     * 分页查询所有数据
     *
     * @param page 分页对象
     * @param newsChannel 查询实体
     * @return 所有数据
     */
    @GetMapping
    public R selectAll(Page<NewsChannel> page, NewsChannel newsChannel) {
        return success(this.newsChannelService.page(page, new QueryWrapper<>(newsChannel)));
    }

    /**
     * 通过主键查询单条数据
     *
     * @param id 主键
     * @return 单条数据
     */
    @GetMapping("{id}")
    public R selectOne(@PathVariable Serializable id) {
        return success(this.newsChannelService.getById(id));
    }

    /**
     * 新增数据
     *
     * @param newsChannel 实体对象
     * @return 新增结果
     */
    @PostMapping
    public R insert(@RequestBody NewsChannel newsChannel) {
        return success(this.newsChannelService.save(newsChannel));
    }

    /**
     * 修改数据
     *
     * @param newsChannel 实体对象
     * @return 修改结果
     */
    @PutMapping
    public R update(@RequestBody NewsChannel newsChannel) {
        return success(this.newsChannelService.updateById(newsChannel));
    }

    /**
     * 删除数据
     *
     * @param idList 主键结合
     * @return 删除结果
     */
    @DeleteMapping
    public R delete(@RequestParam("idList") List<Long> idList) {
        return success(this.newsChannelService.removeByIds(idList));
    }
}

package com.ycl.controller;







import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper;

import com.baomidou.mybatisplus.extension.api.ApiController;

import com.baomidou.mybatisplus.extension.api.R;

import com.baomidou.mybatisplus.extension.plugins.pagination.Page;

import com.ycl.entity.NewsChannel;

import com.ycl.service.NewsChannelService;

import org.springframework.web.bind.annotation.*;



import javax.annotation.Resource;

import java.io.Serializable;

import java.util.List;



/**

 * 频道表(NewsChannel)表控制层

 *

 * @author makejava

 * @since 2022-11-17 11:12:41

 */

@RestController

@RequestMapping("newsChannel")

public class NewsChannelController extends ApiController {

    /**

     * 服务对象

     */

    @Resource

    private NewsChannelService newsChannelService;



    /**

     * 分页查询所有数据

     *

     * @param page 分页对象

     * @param newsChannel 查询实体

     * @return 所有数据

     */

    @GetMapping

    public R selectAll(Page<NewsChannel> page, NewsChannel newsChannel) {

        return success(this.newsChannelService.page(page, new QueryWrapper<>(newsChannel)));

    }



    /**

     * 通过主键查询单条数据

     *

     * @param id 主键

     * @return 单条数据

     */

    @GetMapping("{id}")

    public R selectOne(@PathVariable Serializable id) {

        return success(this.newsChannelService.getById(id));

    }



    /**

     * 新增数据

     *

     * @param newsChannel 实体对象

     * @return 新增结果

     */

    @PostMapping

    public R insert(@RequestBody NewsChannel newsChannel) {

        return success(this.newsChannelService.save(newsChannel));

    }



    /**

     * 修改数据

     *

     * @param newsChannel 实体对象

     * @return 修改结果

     */

    @PutMapping

    public R update(@RequestBody NewsChannel newsChannel) {

        return success(this.newsChannelService.updateById(newsChannel));

    }



    /**

     * 删除数据

     *

     * @param idList 主键结合

     * @return 删除结果

     */

    @DeleteMapping

    public R delete(@RequestParam("idList") List<Long> idList) {

        return success(this.newsChannelService.removeByIds(idList));

    }

}




 ycl-platform/src/main/java/com/ycl/controller/NewsColumnController.java

@@ -1,88 +1,88 @@
package com.ycl.controller;



import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper;
import com.baomidou.mybatisplus.extension.api.ApiController;
import com.baomidou.mybatisplus.extension.api.R;
import com.baomidou.mybatisplus.extension.plugins.pagination.Page;
import com.ycl.entity.NewsColumn;
import com.ycl.service.NewsColumnService;
import org.springframework.web.bind.annotation.*;

import javax.annotation.Resource;
import java.io.Serializable;
import java.util.List;

/**
 * 栏目表(NewsColumn)表控制层
 *
 * @author makejava
 * @since 2022-11-16 16:52:30
 */
@RestController
@RequestMapping("newsColumn")
public class NewsColumnController extends ApiController {
    /**
     * 服务对象
     */
    @Resource
    private NewsColumnService newsColumnService;

    /**
     * 分页查询所有数据
     *
     * @param page 分页对象
     * @param newsColumn 查询实体
     * @return 所有数据
     */
    @GetMapping
    public R selectAll(Page<NewsColumn> page, NewsColumn newsColumn) {
        return success(this.newsColumnService.page(page, new QueryWrapper<>(newsColumn)));
    }

    /**
     * 通过主键查询单条数据
     *
     * @param id 主键
     * @return 单条数据
     */
    @GetMapping("{id}")
    public R selectOne(@PathVariable Serializable id) {
        return success(this.newsColumnService.getById(id));
    }

    /**
     * 新增数据
     *
     * @param newsColumn 实体对象
     * @return 新增结果
     */
    @PostMapping
    public R insert(@RequestBody NewsColumn newsColumn) {
        return success(this.newsColumnService.save(newsColumn));
    }

    /**
     * 修改数据
     *
     * @param newsColumn 实体对象
     * @return 修改结果
     */
    @PutMapping
    public R update(@RequestBody NewsColumn newsColumn) {
        return success(this.newsColumnService.updateById(newsColumn));
    }

    /**
     * 删除数据
     *
     * @param idList 主键结合
     * @return 删除结果
     */
    @DeleteMapping
    public R delete(@RequestParam("idList") List<Long> idList) {
        return success(this.newsColumnService.removeByIds(idList));
    }
}

package com.ycl.controller;







import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper;

import com.baomidou.mybatisplus.extension.api.ApiController;

import com.baomidou.mybatisplus.extension.api.R;

import com.baomidou.mybatisplus.extension.plugins.pagination.Page;

import com.ycl.entity.NewsColumn;

import com.ycl.service.NewsColumnService;

import org.springframework.web.bind.annotation.*;



import javax.annotation.Resource;

import java.io.Serializable;

import java.util.List;



/**

 * 栏目表(NewsColumn)表控制层

 *

 * @author makejava

 * @since 2022-11-17 11:12:41

 */

@RestController

@RequestMapping("newsColumn")

public class NewsColumnController extends ApiController {

    /**

     * 服务对象

     */

    @Resource

    private NewsColumnService newsColumnService;



    /**

     * 分页查询所有数据

     *

     * @param page 分页对象

     * @param newsColumn 查询实体

     * @return 所有数据

     */

    @GetMapping

    public R selectAll(Page<NewsColumn> page, NewsColumn newsColumn) {

        return success(this.newsColumnService.page(page, new QueryWrapper<>(newsColumn)));

    }



    /**

     * 通过主键查询单条数据

     *

     * @param id 主键

     * @return 单条数据

     */

    @GetMapping("{id}")

    public R selectOne(@PathVariable Serializable id) {

        return success(this.newsColumnService.getById(id));

    }



    /**

     * 新增数据

     *

     * @param newsColumn 实体对象

     * @return 新增结果

     */

    @PostMapping

    public R insert(@RequestBody NewsColumn newsColumn) {

        return success(this.newsColumnService.save(newsColumn));

    }



    /**

     * 修改数据

     *

     * @param newsColumn 实体对象

     * @return 修改结果

     */

    @PutMapping

    public R update(@RequestBody NewsColumn newsColumn) {

        return success(this.newsColumnService.updateById(newsColumn));

    }



    /**

     * 删除数据

     *

     * @param idList 主键结合

     * @return 删除结果

     */

    @DeleteMapping

    public R delete(@RequestParam("idList") List<Long> idList) {

        return success(this.newsColumnService.removeByIds(idList));

    }

}




 ycl-platform/src/main/java/com/ycl/controller/NewsColumnInformationController.java

@@ -1,88 +1,88 @@
package com.ycl.controller;



import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper;
import com.baomidou.mybatisplus.extension.api.ApiController;
import com.baomidou.mybatisplus.extension.api.R;
import com.baomidou.mybatisplus.extension.plugins.pagination.Page;
import com.ycl.entity.NewsColumnInformation;
import com.ycl.service.NewsColumnInformationService;
import org.springframework.web.bind.annotation.*;

import javax.annotation.Resource;
import java.io.Serializable;
import java.util.List;

/**
 * 栏目频道中间表(NewsColumnInformation)表控制层
 *
 * @author makejava
 * @since 2022-11-16 16:52:30
 */
@RestController
@RequestMapping("newsColumnInformation")
public class NewsColumnInformationController extends ApiController {
    /**
     * 服务对象
     */
    @Resource
    private NewsColumnInformationService newsColumnInformationService;

    /**
     * 分页查询所有数据
     *
     * @param page 分页对象
     * @param newsColumnInformation 查询实体
     * @return 所有数据
     */
    @GetMapping
    public R selectAll(Page<NewsColumnInformation> page, NewsColumnInformation newsColumnInformation) {
        return success(this.newsColumnInformationService.page(page, new QueryWrapper<>(newsColumnInformation)));
    }

    /**
     * 通过主键查询单条数据
     *
     * @param id 主键
     * @return 单条数据
     */
    @GetMapping("{id}")
    public R selectOne(@PathVariable Serializable id) {
        return success(this.newsColumnInformationService.getById(id));
    }

    /**
     * 新增数据
     *
     * @param newsColumnInformation 实体对象
     * @return 新增结果
     */
    @PostMapping
    public R insert(@RequestBody NewsColumnInformation newsColumnInformation) {
        return success(this.newsColumnInformationService.save(newsColumnInformation));
    }

    /**
     * 修改数据
     *
     * @param newsColumnInformation 实体对象
     * @return 修改结果
     */
    @PutMapping
    public R update(@RequestBody NewsColumnInformation newsColumnInformation) {
        return success(this.newsColumnInformationService.updateById(newsColumnInformation));
    }

    /**
     * 删除数据
     *
     * @param idList 主键结合
     * @return 删除结果
     */
    @DeleteMapping
    public R delete(@RequestParam("idList") List<Long> idList) {
        return success(this.newsColumnInformationService.removeByIds(idList));
    }
}

package com.ycl.controller;







import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper;

import com.baomidou.mybatisplus.extension.api.ApiController;

import com.baomidou.mybatisplus.extension.api.R;

import com.baomidou.mybatisplus.extension.plugins.pagination.Page;

import com.ycl.entity.NewsColumnInformation;

import com.ycl.service.NewsColumnInformationService;

import org.springframework.web.bind.annotation.*;



import javax.annotation.Resource;

import java.io.Serializable;

import java.util.List;



/**

 * 栏目咨询中间表(NewsColumnInformation)表控制层

 *

 * @author makejava

 * @since 2022-11-17 11:12:41

 */

@RestController

@RequestMapping("newsColumnInformation")

public class NewsColumnInformationController extends ApiController {

    /**

     * 服务对象

     */

    @Resource

    private NewsColumnInformationService newsColumnInformationService;



    /**

     * 分页查询所有数据

     *

     * @param page 分页对象

     * @param newsColumnInformation 查询实体

     * @return 所有数据

     */

    @GetMapping

    public R selectAll(Page<NewsColumnInformation> page, NewsColumnInformation newsColumnInformation) {

        return success(this.newsColumnInformationService.page(page, new QueryWrapper<>(newsColumnInformation)));

    }



    /**

     * 通过主键查询单条数据

     *

     * @param id 主键

     * @return 单条数据

     */

    @GetMapping("{id}")

    public R selectOne(@PathVariable Serializable id) {

        return success(this.newsColumnInformationService.getById(id));

    }



    /**

     * 新增数据

     *

     * @param newsColumnInformation 实体对象

     * @return 新增结果

     */

    @PostMapping

    public R insert(@RequestBody NewsColumnInformation newsColumnInformation) {

        return success(this.newsColumnInformationService.save(newsColumnInformation));

    }



    /**

     * 修改数据

     *

     * @param newsColumnInformation 实体对象

     * @return 修改结果

     */

    @PutMapping

    public R update(@RequestBody NewsColumnInformation newsColumnInformation) {

        return success(this.newsColumnInformationService.updateById(newsColumnInformation));

    }



    /**

     * 删除数据

     *

     * @param idList 主键结合

     * @return 删除结果

     */

    @DeleteMapping

    public R delete(@RequestParam("idList") List<Long> idList) {

        return success(this.newsColumnInformationService.removeByIds(idList));

    }

}




 ycl-platform/src/main/java/com/ycl/controller/NewsDepartmentController.java

New file
@@ -0,0 +1,88 @@
package com.ycl.controller;







import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper;

import com.baomidou.mybatisplus.extension.api.ApiController;

import com.baomidou.mybatisplus.extension.api.R;

import com.baomidou.mybatisplus.extension.plugins.pagination.Page;

import com.ycl.entity.NewsDepartment;

import com.ycl.service.NewsDepartmentService;

import org.springframework.web.bind.annotation.*;



import javax.annotation.Resource;

import java.io.Serializable;

import java.util.List;



/**

 * 部门（机构）表(NewsDepartment)表控制层

 *

 * @author makejava

 * @since 2022-11-17 11:12:41

 */

@RestController

@RequestMapping("newsDepartment")

public class NewsDepartmentController extends ApiController {

    /**

     * 服务对象

     */

    @Resource

    private NewsDepartmentService newsDepartmentService;



    /**

     * 分页查询所有数据

     *

     * @param page 分页对象

     * @param newsDepartment 查询实体

     * @return 所有数据

     */

    @GetMapping

    public R selectAll(Page<NewsDepartment> page, NewsDepartment newsDepartment) {

        return success(this.newsDepartmentService.page(page, new QueryWrapper<>(newsDepartment)));

    }



    /**

     * 通过主键查询单条数据

     *

     * @param id 主键

     * @return 单条数据

     */

    @GetMapping("{id}")

    public R selectOne(@PathVariable Serializable id) {

        return success(this.newsDepartmentService.getById(id));

    }



    /**

     * 新增数据

     *

     * @param newsDepartment 实体对象

     * @return 新增结果

     */

    @PostMapping

    public R insert(@RequestBody NewsDepartment newsDepartment) {

        return success(this.newsDepartmentService.save(newsDepartment));

    }



    /**

     * 修改数据

     *

     * @param newsDepartment 实体对象

     * @return 修改结果

     */

    @PutMapping

    public R update(@RequestBody NewsDepartment newsDepartment) {

        return success(this.newsDepartmentService.updateById(newsDepartment));

    }



    /**

     * 删除数据

     *

     * @param idList 主键结合

     * @return 删除结果

     */

    @DeleteMapping

    public R delete(@RequestParam("idList") List<Long> idList) {

        return success(this.newsDepartmentService.removeByIds(idList));

    }

}




 ycl-platform/src/main/java/com/ycl/controller/NewsDutyController.java

@@ -1,88 +1,88 @@
package com.ycl.controller;



import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper;
import com.baomidou.mybatisplus.extension.api.ApiController;
import com.baomidou.mybatisplus.extension.api.R;
import com.baomidou.mybatisplus.extension.plugins.pagination.Page;
import com.ycl.entity.NewsDuty;
import com.ycl.service.NewsDutyService;
import org.springframework.web.bind.annotation.*;

import javax.annotation.Resource;
import java.io.Serializable;
import java.util.List;

/**
 * 值班表(NewsDuty)表控制层
 *
 * @author makejava
 * @since 2022-11-16 16:52:30
 */
@RestController
@RequestMapping("newsDuty")
public class NewsDutyController extends ApiController {
    /**
     * 服务对象
     */
    @Resource
    private NewsDutyService newsDutyService;

    /**
     * 分页查询所有数据
     *
     * @param page 分页对象
     * @param newsDuty 查询实体
     * @return 所有数据
     */
    @GetMapping
    public R selectAll(Page<NewsDuty> page, NewsDuty newsDuty) {
        return success(this.newsDutyService.page(page, new QueryWrapper<>(newsDuty)));
    }

    /**
     * 通过主键查询单条数据
     *
     * @param id 主键
     * @return 单条数据
     */
    @GetMapping("{id}")
    public R selectOne(@PathVariable Serializable id) {
        return success(this.newsDutyService.getById(id));
    }

    /**
     * 新增数据
     *
     * @param newsDuty 实体对象
     * @return 新增结果
     */
    @PostMapping
    public R insert(@RequestBody NewsDuty newsDuty) {
        return success(this.newsDutyService.save(newsDuty));
    }

    /**
     * 修改数据
     *
     * @param newsDuty 实体对象
     * @return 修改结果
     */
    @PutMapping
    public R update(@RequestBody NewsDuty newsDuty) {
        return success(this.newsDutyService.updateById(newsDuty));
    }

    /**
     * 删除数据
     *
     * @param idList 主键结合
     * @return 删除结果
     */
    @DeleteMapping
    public R delete(@RequestParam("idList") List<Long> idList) {
        return success(this.newsDutyService.removeByIds(idList));
    }
}

package com.ycl.controller;







import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper;

import com.baomidou.mybatisplus.extension.api.ApiController;

import com.baomidou.mybatisplus.extension.api.R;

import com.baomidou.mybatisplus.extension.plugins.pagination.Page;

import com.ycl.entity.NewsDuty;

import com.ycl.service.NewsDutyService;

import org.springframework.web.bind.annotation.*;



import javax.annotation.Resource;

import java.io.Serializable;

import java.util.List;



/**

 * 值班表(NewsDuty)表控制层

 *

 * @author makejava

 * @since 2022-11-17 11:12:41

 */

@RestController

@RequestMapping("newsDuty")

public class NewsDutyController extends ApiController {

    /**

     * 服务对象

     */

    @Resource

    private NewsDutyService newsDutyService;



    /**

     * 分页查询所有数据

     *

     * @param page 分页对象

     * @param newsDuty 查询实体

     * @return 所有数据

     */

    @GetMapping

    public R selectAll(Page<NewsDuty> page, NewsDuty newsDuty) {

        return success(this.newsDutyService.page(page, new QueryWrapper<>(newsDuty)));

    }



    /**

     * 通过主键查询单条数据

     *

     * @param id 主键

     * @return 单条数据

     */

    @GetMapping("{id}")

    public R selectOne(@PathVariable Serializable id) {

        return success(this.newsDutyService.getById(id));

    }



    /**

     * 新增数据

     *

     * @param newsDuty 实体对象

     * @return 新增结果

     */

    @PostMapping

    public R insert(@RequestBody NewsDuty newsDuty) {

        return success(this.newsDutyService.save(newsDuty));

    }



    /**

     * 修改数据

     *

     * @param newsDuty 实体对象

     * @return 修改结果

     */

    @PutMapping

    public R update(@RequestBody NewsDuty newsDuty) {

        return success(this.newsDutyService.updateById(newsDuty));

    }



    /**

     * 删除数据

     *

     * @param idList 主键结合

     * @return 删除结果

     */

    @DeleteMapping

    public R delete(@RequestParam("idList") List<Long> idList) {

        return success(this.newsDutyService.removeByIds(idList));

    }

}




 ycl-platform/src/main/java/com/ycl/controller/NewsInformationController.java

@@ -1,88 +1,88 @@
package com.ycl.controller;



import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper;
import com.baomidou.mybatisplus.extension.api.ApiController;
import com.baomidou.mybatisplus.extension.api.R;
import com.baomidou.mybatisplus.extension.plugins.pagination.Page;
import com.ycl.entity.NewsInformation;
import com.ycl.service.NewsInformationService;
import org.springframework.web.bind.annotation.*;

import javax.annotation.Resource;
import java.io.Serializable;
import java.util.List;

/**
 * 咨询表(NewsInformation)表控制层
 *
 * @author makejava
 * @since 2022-11-16 16:52:30
 */
@RestController
@RequestMapping("newsInformation")
public class NewsInformationController extends ApiController {
    /**
     * 服务对象
     */
    @Resource
    private NewsInformationService newsInformationService;

    /**
     * 分页查询所有数据
     *
     * @param page 分页对象
     * @param newsInformation 查询实体
     * @return 所有数据
     */
    @GetMapping
    public R selectAll(Page<NewsInformation> page, NewsInformation newsInformation) {
        return success(this.newsInformationService.page(page, new QueryWrapper<>(newsInformation)));
    }

    /**
     * 通过主键查询单条数据
     *
     * @param id 主键
     * @return 单条数据
     */
    @GetMapping("{id}")
    public R selectOne(@PathVariable Serializable id) {
        return success(this.newsInformationService.getById(id));
    }

    /**
     * 新增数据
     *
     * @param newsInformation 实体对象
     * @return 新增结果
     */
    @PostMapping
    public R insert(@RequestBody NewsInformation newsInformation) {
        return success(this.newsInformationService.save(newsInformation));
    }

    /**
     * 修改数据
     *
     * @param newsInformation 实体对象
     * @return 修改结果
     */
    @PutMapping
    public R update(@RequestBody NewsInformation newsInformation) {
        return success(this.newsInformationService.updateById(newsInformation));
    }

    /**
     * 删除数据
     *
     * @param idList 主键结合
     * @return 删除结果
     */
    @DeleteMapping
    public R delete(@RequestParam("idList") List<Long> idList) {
        return success(this.newsInformationService.removeByIds(idList));
    }
}

package com.ycl.controller;







import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper;

import com.baomidou.mybatisplus.extension.api.ApiController;

import com.baomidou.mybatisplus.extension.api.R;

import com.baomidou.mybatisplus.extension.plugins.pagination.Page;

import com.ycl.entity.NewsInformation;

import com.ycl.service.NewsInformationService;

import org.springframework.web.bind.annotation.*;



import javax.annotation.Resource;

import java.io.Serializable;

import java.util.List;



/**

 * 资讯表(NewsInformation)表控制层

 *

 * @author makejava

 * @since 2022-11-17 11:12:41

 */

@RestController

@RequestMapping("newsInformation")

public class NewsInformationController extends ApiController {

    /**

     * 服务对象

     */

    @Resource

    private NewsInformationService newsInformationService;



    /**

     * 分页查询所有数据

     *

     * @param page 分页对象

     * @param newsInformation 查询实体

     * @return 所有数据

     */

    @GetMapping

    public R selectAll(Page<NewsInformation> page, NewsInformation newsInformation) {

        return success(this.newsInformationService.page(page, new QueryWrapper<>(newsInformation)));

    }



    /**

     * 通过主键查询单条数据

     *

     * @param id 主键

     * @return 单条数据

     */

    @GetMapping("{id}")

    public R selectOne(@PathVariable Serializable id) {

        return success(this.newsInformationService.getById(id));

    }



    /**

     * 新增数据

     *

     * @param newsInformation 实体对象

     * @return 新增结果

     */

    @PostMapping

    public R insert(@RequestBody NewsInformation newsInformation) {

        return success(this.newsInformationService.save(newsInformation));

    }



    /**

     * 修改数据

     *

     * @param newsInformation 实体对象

     * @return 修改结果

     */

    @PutMapping

    public R update(@RequestBody NewsInformation newsInformation) {

        return success(this.newsInformationService.updateById(newsInformation));

    }



    /**

     * 删除数据

     *

     * @param idList 主键结合

     * @return 删除结果

     */

    @DeleteMapping

    public R delete(@RequestParam("idList") List<Long> idList) {

        return success(this.newsInformationService.removeByIds(idList));

    }

}




 ycl-platform/src/main/java/com/ycl/controller/NewsIpController.java

@@ -1,88 +1,88 @@
package com.ycl.controller;



import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper;
import com.baomidou.mybatisplus.extension.api.ApiController;
import com.baomidou.mybatisplus.extension.api.R;
import com.baomidou.mybatisplus.extension.plugins.pagination.Page;
import com.ycl.entity.NewsIp;
import com.ycl.service.NewsIpService;
import org.springframework.web.bind.annotation.*;

import javax.annotation.Resource;
import java.io.Serializable;
import java.util.List;

/**
 * ip白名单表(NewsIp)表控制层
 *
 * @author makejava
 * @since 2022-11-16 16:52:30
 */
@RestController
@RequestMapping("newsIp")
public class NewsIpController extends ApiController {
    /**
     * 服务对象
     */
    @Resource
    private NewsIpService newsIpService;

    /**
     * 分页查询所有数据
     *
     * @param page 分页对象
     * @param newsIp 查询实体
     * @return 所有数据
     */
    @GetMapping
    public R selectAll(Page<NewsIp> page, NewsIp newsIp) {
        return success(this.newsIpService.page(page, new QueryWrapper<>(newsIp)));
    }

    /**
     * 通过主键查询单条数据
     *
     * @param id 主键
     * @return 单条数据
     */
    @GetMapping("{id}")
    public R selectOne(@PathVariable Serializable id) {
        return success(this.newsIpService.getById(id));
    }

    /**
     * 新增数据
     *
     * @param newsIp 实体对象
     * @return 新增结果
     */
    @PostMapping
    public R insert(@RequestBody NewsIp newsIp) {
        return success(this.newsIpService.save(newsIp));
    }

    /**
     * 修改数据
     *
     * @param newsIp 实体对象
     * @return 修改结果
     */
    @PutMapping
    public R update(@RequestBody NewsIp newsIp) {
        return success(this.newsIpService.updateById(newsIp));
    }

    /**
     * 删除数据
     *
     * @param idList 主键结合
     * @return 删除结果
     */
    @DeleteMapping
    public R delete(@RequestParam("idList") List<Long> idList) {
        return success(this.newsIpService.removeByIds(idList));
    }
}

package com.ycl.controller;







import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper;

import com.baomidou.mybatisplus.extension.api.ApiController;

import com.baomidou.mybatisplus.extension.api.R;

import com.baomidou.mybatisplus.extension.plugins.pagination.Page;

import com.ycl.entity.NewsIp;

import com.ycl.service.NewsIpService;

import org.springframework.web.bind.annotation.*;



import javax.annotation.Resource;

import java.io.Serializable;

import java.util.List;



/**

 * ip白名单表(NewsIp)表控制层

 *

 * @author makejava

 * @since 2022-11-17 11:12:41

 */

@RestController

@RequestMapping("newsIp")

public class NewsIpController extends ApiController {

    /**

     * 服务对象

     */

    @Resource

    private NewsIpService newsIpService;



    /**

     * 分页查询所有数据

     *

     * @param page 分页对象

     * @param newsIp 查询实体

     * @return 所有数据

     */

    @GetMapping

    public R selectAll(Page<NewsIp> page, NewsIp newsIp) {

        return success(this.newsIpService.page(page, new QueryWrapper<>(newsIp)));

    }



    /**

     * 通过主键查询单条数据

     *

     * @param id 主键

     * @return 单条数据

     */

    @GetMapping("{id}")

    public R selectOne(@PathVariable Serializable id) {

        return success(this.newsIpService.getById(id));

    }



    /**

     * 新增数据

     *

     * @param newsIp 实体对象

     * @return 新增结果

     */

    @PostMapping

    public R insert(@RequestBody NewsIp newsIp) {

        return success(this.newsIpService.save(newsIp));

    }



    /**

     * 修改数据

     *

     * @param newsIp 实体对象

     * @return 修改结果

     */

    @PutMapping

    public R update(@RequestBody NewsIp newsIp) {

        return success(this.newsIpService.updateById(newsIp));

    }



    /**

     * 删除数据

     *

     * @param idList 主键结合

     * @return 删除结果

     */

    @DeleteMapping

    public R delete(@RequestParam("idList") List<Long> idList) {

        return success(this.newsIpService.removeByIds(idList));

    }

}




 ycl-platform/src/main/java/com/ycl/controller/NewsPoliceController.java

@@ -1,89 +1,89 @@
package com.ycl.controller;



import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper;
import com.baomidou.mybatisplus.extension.api.ApiController;
import com.baomidou.mybatisplus.extension.api.R;
import com.baomidou.mybatisplus.extension.plugins.pagination.Page;
import com.ycl.entity.NewsPolice;
import com.ycl.service.NewsPoliceService;
import org.springframework.web.bind.annotation.*;

import javax.annotation.Resource;
import java.io.Serializable;
import java.util.List;

/**
 * 警员表
(NewsPolice)表控制层
 *
 * @author makejava
 * @since 2022-11-16 16:52:30
 */
@RestController
@RequestMapping("newsPolice")
public class NewsPoliceController extends ApiController {
    /**
     * 服务对象
     */
    @Resource
    private NewsPoliceService newsPoliceService;

    /**
     * 分页查询所有数据
     *
     * @param page 分页对象
     * @param newsPolice 查询实体
     * @return 所有数据
     */
    @GetMapping
    public R selectAll(Page<NewsPolice> page, NewsPolice newsPolice) {
        return success(this.newsPoliceService.page(page, new QueryWrapper<>(newsPolice)));
    }

    /**
     * 通过主键查询单条数据
     *
     * @param id 主键
     * @return 单条数据
     */
    @GetMapping("{id}")
    public R selectOne(@PathVariable Serializable id) {
        return success(this.newsPoliceService.getById(id));
    }

    /**
     * 新增数据
     *
     * @param newsPolice 实体对象
     * @return 新增结果
     */
    @PostMapping
    public R insert(@RequestBody NewsPolice newsPolice) {
        return success(this.newsPoliceService.save(newsPolice));
    }

    /**
     * 修改数据
     *
     * @param newsPolice 实体对象
     * @return 修改结果
     */
    @PutMapping
    public R update(@RequestBody NewsPolice newsPolice) {
        return success(this.newsPoliceService.updateById(newsPolice));
    }

    /**
     * 删除数据
     *
     * @param idList 主键结合
     * @return 删除结果
     */
    @DeleteMapping
    public R delete(@RequestParam("idList") List<Long> idList) {
        return success(this.newsPoliceService.removeByIds(idList));
    }
}

package com.ycl.controller;







import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper;

import com.baomidou.mybatisplus.extension.api.ApiController;

import com.baomidou.mybatisplus.extension.api.R;

import com.baomidou.mybatisplus.extension.plugins.pagination.Page;

import com.ycl.entity.NewsPolice;

import com.ycl.service.NewsPoliceService;

import org.springframework.web.bind.annotation.*;



import javax.annotation.Resource;

import java.io.Serializable;

import java.util.List;



/**

 * 警员表

(NewsPolice)表控制层

 *

 * @author makejava

 * @since 2022-11-17 11:12:42

 */

@RestController

@RequestMapping("newsPolice")

public class NewsPoliceController extends ApiController {

    /**

     * 服务对象

     */

    @Resource

    private NewsPoliceService newsPoliceService;



    /**

     * 分页查询所有数据

     *

     * @param page 分页对象

     * @param newsPolice 查询实体

     * @return 所有数据

     */

    @GetMapping

    public R selectAll(Page<NewsPolice> page, NewsPolice newsPolice) {

        return success(this.newsPoliceService.page(page, new QueryWrapper<>(newsPolice)));

    }



    /**

     * 通过主键查询单条数据

     *

     * @param id 主键

     * @return 单条数据

     */

    @GetMapping("{id}")

    public R selectOne(@PathVariable Serializable id) {

        return success(this.newsPoliceService.getById(id));

    }



    /**

     * 新增数据

     *

     * @param newsPolice 实体对象

     * @return 新增结果

     */

    @PostMapping

    public R insert(@RequestBody NewsPolice newsPolice) {

        return success(this.newsPoliceService.save(newsPolice));

    }



    /**

     * 修改数据

     *

     * @param newsPolice 实体对象

     * @return 修改结果

     */

    @PutMapping

    public R update(@RequestBody NewsPolice newsPolice) {

        return success(this.newsPoliceService.updateById(newsPolice));

    }



    /**

     * 删除数据

     *

     * @param idList 主键结合

     * @return 删除结果

     */

    @DeleteMapping

    public R delete(@RequestParam("idList") List<Long> idList) {

        return success(this.newsPoliceService.removeByIds(idList));

    }

}




 ycl-platform/src/main/java/com/ycl/dao/NewsAdminDao.java

New file
@@ -0,0 +1,35 @@
package com.ycl.dao;



import java.util.List;



import com.baomidou.mybatisplus.core.mapper.BaseMapper;

import org.apache.ibatis.annotations.Param;

import com.ycl.entity.NewsAdmin;



/**

 * 后台用户表(NewsAdmin)表数据库访问层

 *

 * @author makejava

 * @since 2022-11-17 11:12:41

 */

public interface NewsAdminDao extends BaseMapper<NewsAdmin> {



/**

* 批量新增数据（MyBatis原生foreach方法）

*

* @param entities List<NewsAdmin> 实例对象列表

* @return 影响行数

*/

int insertBatch(@Param("entities") List<NewsAdmin> entities);



/**

* 批量新增或按主键更新数据（MyBatis原生foreach方法）

*

* @param entities List<NewsAdmin> 实例对象列表

* @return 影响行数

* @throws org.springframework.jdbc.BadSqlGrammarException 入参是空List的时候会抛SQL语句错误的异常，请自行校验入参

*/

int insertOrUpdateBatch(@Param("entities") List<NewsAdmin> entities);



}




 ycl-platform/src/main/java/com/ycl/dao/NewsChannelColumnDao.java

New file
@@ -0,0 +1,35 @@
package com.ycl.dao;



import java.util.List;



import com.baomidou.mybatisplus.core.mapper.BaseMapper;

import org.apache.ibatis.annotations.Param;

import com.ycl.entity.NewsChannelColumn;



/**

 * 频道栏目中间表(NewsChannelColumn)表数据库访问层

 *

 * @author makejava

 * @since 2022-11-17 11:12:41

 */

public interface NewsChannelColumnDao extends BaseMapper<NewsChannelColumn> {



/**

* 批量新增数据（MyBatis原生foreach方法）

*

* @param entities List<NewsChannelColumn> 实例对象列表

* @return 影响行数

*/

int insertBatch(@Param("entities") List<NewsChannelColumn> entities);



/**

* 批量新增或按主键更新数据（MyBatis原生foreach方法）

*

* @param entities List<NewsChannelColumn> 实例对象列表

* @return 影响行数

* @throws org.springframework.jdbc.BadSqlGrammarException 入参是空List的时候会抛SQL语句错误的异常，请自行校验入参

*/

int insertOrUpdateBatch(@Param("entities") List<NewsChannelColumn> entities);



}




 ycl-platform/src/main/java/com/ycl/dao/NewsChannelDao.java

New file
@@ -0,0 +1,35 @@
package com.ycl.dao;



import java.util.List;



import com.baomidou.mybatisplus.core.mapper.BaseMapper;

import org.apache.ibatis.annotations.Param;

import com.ycl.entity.NewsChannel;



/**

 * 频道表(NewsChannel)表数据库访问层

 *

 * @author makejava

 * @since 2022-11-17 11:12:41

 */

public interface NewsChannelDao extends BaseMapper<NewsChannel> {



/**

* 批量新增数据（MyBatis原生foreach方法）

*

* @param entities List<NewsChannel> 实例对象列表

* @return 影响行数

*/

int insertBatch(@Param("entities") List<NewsChannel> entities);



/**

* 批量新增或按主键更新数据（MyBatis原生foreach方法）

*

* @param entities List<NewsChannel> 实例对象列表

* @return 影响行数

* @throws org.springframework.jdbc.BadSqlGrammarException 入参是空List的时候会抛SQL语句错误的异常，请自行校验入参

*/

int insertOrUpdateBatch(@Param("entities") List<NewsChannel> entities);



}




 ycl-platform/src/main/java/com/ycl/dao/NewsColumnDao.java

New file
@@ -0,0 +1,35 @@
package com.ycl.dao;



import java.util.List;



import com.baomidou.mybatisplus.core.mapper.BaseMapper;

import org.apache.ibatis.annotations.Param;

import com.ycl.entity.NewsColumn;



/**

 * 栏目表(NewsColumn)表数据库访问层

 *

 * @author makejava

 * @since 2022-11-17 11:12:41

 */

public interface NewsColumnDao extends BaseMapper<NewsColumn> {



/**

* 批量新增数据（MyBatis原生foreach方法）

*

* @param entities List<NewsColumn> 实例对象列表

* @return 影响行数

*/

int insertBatch(@Param("entities") List<NewsColumn> entities);



/**

* 批量新增或按主键更新数据（MyBatis原生foreach方法）

*

* @param entities List<NewsColumn> 实例对象列表

* @return 影响行数

* @throws org.springframework.jdbc.BadSqlGrammarException 入参是空List的时候会抛SQL语句错误的异常，请自行校验入参

*/

int insertOrUpdateBatch(@Param("entities") List<NewsColumn> entities);



}




 ycl-platform/src/main/java/com/ycl/dao/NewsColumnInformationDao.java

New file
@@ -0,0 +1,35 @@
package com.ycl.dao;



import java.util.List;



import com.baomidou.mybatisplus.core.mapper.BaseMapper;

import org.apache.ibatis.annotations.Param;

import com.ycl.entity.NewsColumnInformation;



/**

 * 栏目咨询中间表(NewsColumnInformation)表数据库访问层

 *

 * @author makejava

 * @since 2022-11-17 11:12:41

 */

public interface NewsColumnInformationDao extends BaseMapper<NewsColumnInformation> {



/**

* 批量新增数据（MyBatis原生foreach方法）

*

* @param entities List<NewsColumnInformation> 实例对象列表

* @return 影响行数

*/

int insertBatch(@Param("entities") List<NewsColumnInformation> entities);



/**

* 批量新增或按主键更新数据（MyBatis原生foreach方法）

*

* @param entities List<NewsColumnInformation> 实例对象列表

* @return 影响行数

* @throws org.springframework.jdbc.BadSqlGrammarException 入参是空List的时候会抛SQL语句错误的异常，请自行校验入参

*/

int insertOrUpdateBatch(@Param("entities") List<NewsColumnInformation> entities);



}




 ycl-platform/src/main/java/com/ycl/dao/NewsDepartmentDao.java

New file
@@ -0,0 +1,35 @@
package com.ycl.dao;



import java.util.List;



import com.baomidou.mybatisplus.core.mapper.BaseMapper;

import org.apache.ibatis.annotations.Param;

import com.ycl.entity.NewsDepartment;



/**

 * 部门（机构）表(NewsDepartment)表数据库访问层

 *

 * @author makejava

 * @since 2022-11-17 11:12:41

 */

public interface NewsDepartmentDao extends BaseMapper<NewsDepartment> {



/**

* 批量新增数据（MyBatis原生foreach方法）

*

* @param entities List<NewsDepartment> 实例对象列表

* @return 影响行数

*/

int insertBatch(@Param("entities") List<NewsDepartment> entities);



/**

* 批量新增或按主键更新数据（MyBatis原生foreach方法）

*

* @param entities List<NewsDepartment> 实例对象列表

* @return 影响行数

* @throws org.springframework.jdbc.BadSqlGrammarException 入参是空List的时候会抛SQL语句错误的异常，请自行校验入参

*/

int insertOrUpdateBatch(@Param("entities") List<NewsDepartment> entities);



}




 ycl-platform/src/main/java/com/ycl/dao/NewsDutyDao.java

New file
@@ -0,0 +1,35 @@
package com.ycl.dao;



import java.util.List;



import com.baomidou.mybatisplus.core.mapper.BaseMapper;

import org.apache.ibatis.annotations.Param;

import com.ycl.entity.NewsDuty;



/**

 * 值班表(NewsDuty)表数据库访问层

 *

 * @author makejava

 * @since 2022-11-17 11:12:41

 */

public interface NewsDutyDao extends BaseMapper<NewsDuty> {



/**

* 批量新增数据（MyBatis原生foreach方法）

*

* @param entities List<NewsDuty> 实例对象列表

* @return 影响行数

*/

int insertBatch(@Param("entities") List<NewsDuty> entities);



/**

* 批量新增或按主键更新数据（MyBatis原生foreach方法）

*

* @param entities List<NewsDuty> 实例对象列表

* @return 影响行数

* @throws org.springframework.jdbc.BadSqlGrammarException 入参是空List的时候会抛SQL语句错误的异常，请自行校验入参

*/

int insertOrUpdateBatch(@Param("entities") List<NewsDuty> entities);



}




 ycl-platform/src/main/java/com/ycl/dao/NewsInformationDao.java

New file
@@ -0,0 +1,35 @@
package com.ycl.dao;



import java.util.List;



import com.baomidou.mybatisplus.core.mapper.BaseMapper;

import org.apache.ibatis.annotations.Param;

import com.ycl.entity.NewsInformation;



/**

 * 资讯表(NewsInformation)表数据库访问层

 *

 * @author makejava

 * @since 2022-11-17 11:12:41

 */

public interface NewsInformationDao extends BaseMapper<NewsInformation> {



/**

* 批量新增数据（MyBatis原生foreach方法）

*

* @param entities List<NewsInformation> 实例对象列表

* @return 影响行数

*/

int insertBatch(@Param("entities") List<NewsInformation> entities);



/**

* 批量新增或按主键更新数据（MyBatis原生foreach方法）

*

* @param entities List<NewsInformation> 实例对象列表

* @return 影响行数

* @throws org.springframework.jdbc.BadSqlGrammarException 入参是空List的时候会抛SQL语句错误的异常，请自行校验入参

*/

int insertOrUpdateBatch(@Param("entities") List<NewsInformation> entities);



}




 ycl-platform/src/main/java/com/ycl/dao/NewsIpDao.java

New file
@@ -0,0 +1,35 @@
package com.ycl.dao;



import java.util.List;



import com.baomidou.mybatisplus.core.mapper.BaseMapper;

import org.apache.ibatis.annotations.Param;

import com.ycl.entity.NewsIp;



/**

 * ip白名单表(NewsIp)表数据库访问层

 *

 * @author makejava

 * @since 2022-11-17 11:12:41

 */

public interface NewsIpDao extends BaseMapper<NewsIp> {



/**

* 批量新增数据（MyBatis原生foreach方法）

*

* @param entities List<NewsIp> 实例对象列表

* @return 影响行数

*/

int insertBatch(@Param("entities") List<NewsIp> entities);



/**

* 批量新增或按主键更新数据（MyBatis原生foreach方法）

*

* @param entities List<NewsIp> 实例对象列表

* @return 影响行数

* @throws org.springframework.jdbc.BadSqlGrammarException 入参是空List的时候会抛SQL语句错误的异常，请自行校验入参

*/

int insertOrUpdateBatch(@Param("entities") List<NewsIp> entities);



}




 ycl-platform/src/main/java/com/ycl/dao/NewsPoliceDao.java

New file
@@ -0,0 +1,36 @@
package com.ycl.dao;



import java.util.List;



import com.baomidou.mybatisplus.core.mapper.BaseMapper;

import org.apache.ibatis.annotations.Param;

import com.ycl.entity.NewsPolice;



/**

 * 警员表

(NewsPolice)表数据库访问层

 *

 * @author makejava

 * @since 2022-11-17 11:12:42

 */

public interface NewsPoliceDao extends BaseMapper<NewsPolice> {



/**

* 批量新增数据（MyBatis原生foreach方法）

*

* @param entities List<NewsPolice> 实例对象列表

* @return 影响行数

*/

int insertBatch(@Param("entities") List<NewsPolice> entities);



/**

* 批量新增或按主键更新数据（MyBatis原生foreach方法）

*

* @param entities List<NewsPolice> 实例对象列表

* @return 影响行数

* @throws org.springframework.jdbc.BadSqlGrammarException 入参是空List的时候会抛SQL语句错误的异常，请自行校验入参

*/

int insertOrUpdateBatch(@Param("entities") List<NewsPolice> entities);



}




 ycl-platform/src/main/java/com/ycl/entity/NewsAdmin.java

New file
@@ -0,0 +1,147 @@
package com.ycl.entity;





import com.baomidou.mybatisplus.extension.activerecord.Model;

import java.io.Serializable;



/**

 * 后台用户表(NewsAdmin)表实体类

 *

 * @author makejava

 * @since 2022-11-17 11:12:41

 */

@SuppressWarnings("serial")

public class NewsAdmin extends Model<NewsAdmin> {

    
    private Long id;

    //用户姓名

    private String username;

    //密码

    private String password;

    //头像

    private String icon;

    //邮箱

    private String email;

    //备注信息

    private String note;

    //创建时间

    private Date createTime;

    //帐号启用状态：0->禁用；1->启用

    private Integer status;

    // 0->女，1->男

    private Integer sex;

    //手机

    private String mobile;

    //是否为网格管理员：0->不是；1->是

    private Integer isGrid;

    //警员id

    private Integer newsPoliceId;





    public Long getId() {

        return id;

    }



    public void setId(Long id) {

        this.id = id;

    }



    public String getUsername() {

        return username;

    }



    public void setUsername(String username) {

        this.username = username;

    }



    public String getPassword() {

        return password;

    }



    public void setPassword(String password) {

        this.password = password;

    }



    public String getIcon() {

        return icon;

    }



    public void setIcon(String icon) {

        this.icon = icon;

    }



    public String getEmail() {

        return email;

    }



    public void setEmail(String email) {

        this.email = email;

    }



    public String getNote() {

        return note;

    }



    public void setNote(String note) {

        this.note = note;

    }



    public Date getCreateTime() {

        return createTime;

    }



    public void setCreateTime(Date createTime) {

        this.createTime = createTime;

    }



    public Integer getStatus() {

        return status;

    }



    public void setStatus(Integer status) {

        this.status = status;

    }



    public Integer getSex() {

        return sex;

    }



    public void setSex(Integer sex) {

        this.sex = sex;

    }



    public String getMobile() {

        return mobile;

    }



    public void setMobile(String mobile) {

        this.mobile = mobile;

    }



    public Integer getIsGrid() {

        return isGrid;

    }



    public void setIsGrid(Integer isGrid) {

        this.isGrid = isGrid;

    }



    public Integer getNewsPoliceId() {

        return newsPoliceId;

    }



    public void setNewsPoliceId(Integer newsPoliceId) {

        this.newsPoliceId = newsPoliceId;

    }



    /**

     * 获取主键值

     *

     * @return 主键值

     */

    @Override

    protected Serializable pkVal() {

        return this.id;

    }

    }




 ycl-platform/src/main/java/com/ycl/entity/NewsChannel.java

@@ -1,68 +1,67 @@
package com.ycl.entity;


import com.baomidou.mybatisplus.extension.activerecord.Model;
import java.io.Serializable;
import java.time.LocalDate;

/**
 * 频道表(NewsChannel)表实体类
 *
 * @author makejava
 * @since 2022-11-16 16:52:30
 */
@SuppressWarnings("serial")
public class NewsChannel extends Model<NewsChannel> {
    //id
    private Integer id;
    //频道名称
    private String name;
    //频道编码ps名称首字母
    private String code;
    //创建时间
    private LocalDate createTime;


    public Integer getId() {
        return id;
    }

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

    public String getName() {
        return name;
    }

    public void setName(String name) {
        this.name = name;
    }

    public String getCode() {
        return code;
    }

    public void setCode(String code) {
        this.code = code;
    }

    public LocalDate getCreateTime() {
        return createTime;
    }

    public void setCreateTime(LocalDate createTime) {
        this.createTime = createTime;
    }

    /**
     * 获取主键值
     *
     * @return 主键值
     */
    @Override
    protected Serializable pkVal() {
        return this.id;
    }
    }

package com.ycl.entity;





import com.baomidou.mybatisplus.extension.activerecord.Model;

import java.io.Serializable;



/**

 * 频道表(NewsChannel)表实体类

 *

 * @author makejava

 * @since 2022-11-17 11:12:41

 */

@SuppressWarnings("serial")

public class NewsChannel extends Model<NewsChannel> {

    //id

    private Integer id;

    //频道名称

    private String name;

    //频道编码ps名称首字母

    private String code;

    //创建时间

    private Date createTime;





    public Integer getId() {

        return id;

    }



    public void setId(Integer id) {

        this.id = id;

    }



    public String getName() {

        return name;

    }



    public void setName(String name) {

        this.name = name;

    }



    public String getCode() {

        return code;

    }



    public void setCode(String code) {

        this.code = code;

    }



    public Date getCreateTime() {

        return createTime;

    }



    public void setCreateTime(Date createTime) {

        this.createTime = createTime;

    }



    /**

     * 获取主键值

     *

     * @return 主键值

     */

    @Override

    protected Serializable pkVal() {

        return this.id;

    }

    }




 ycl-platform/src/main/java/com/ycl/entity/NewsChannelColumn.java

@@ -1,57 +1,57 @@
package com.ycl.entity;


import com.baomidou.mybatisplus.extension.activerecord.Model;
import java.io.Serializable;

/**
 * 频道栏目中间表(NewsChannelColumn)表实体类
 *
 * @author makejava
 * @since 2022-11-16 16:52:30
 */
@SuppressWarnings("serial")
public class NewsChannelColumn extends Model<NewsChannelColumn> {
    
    private Integer id;
    //频道id
    private Integer channelId;
    //栏目id
    private Integer columnId;


    public Integer getId() {
        return id;
    }

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

    public Integer getChannelId() {
        return channelId;
    }

    public void setChannelId(Integer channelId) {
        this.channelId = channelId;
    }

    public Integer getColumnId() {
        return columnId;
    }

    public void setColumnId(Integer columnId) {
        this.columnId = columnId;
    }

    /**
     * 获取主键值
     *
     * @return 主键值
     */
    @Override
    protected Serializable pkVal() {
        return this.id;
    }
    }

package com.ycl.entity;





import com.baomidou.mybatisplus.extension.activerecord.Model;

import java.io.Serializable;



/**

 * 频道栏目中间表(NewsChannelColumn)表实体类

 *

 * @author makejava

 * @since 2022-11-17 11:12:41

 */

@SuppressWarnings("serial")

public class NewsChannelColumn extends Model<NewsChannelColumn> {

    
    private Integer id;

    //频道id

    private Integer channelId;

    //栏目id

    private Integer columnId;





    public Integer getId() {

        return id;

    }



    public void setId(Integer id) {

        this.id = id;

    }



    public Integer getChannelId() {

        return channelId;

    }



    public void setChannelId(Integer channelId) {

        this.channelId = channelId;

    }



    public Integer getColumnId() {

        return columnId;

    }



    public void setColumnId(Integer columnId) {

        this.columnId = columnId;

    }



    /**

     * 获取主键值

     *

     * @return 主键值

     */

    @Override

    protected Serializable pkVal() {

        return this.id;

    }

    }




 ycl-platform/src/main/java/com/ycl/entity/NewsColumn.java

@@ -1,47 +1,47 @@
package com.ycl.entity;


import com.baomidou.mybatisplus.extension.activerecord.Model;
import java.io.Serializable;

/**
 * 栏目表(NewsColumn)表实体类
 *
 * @author makejava
 * @since 2022-11-16 16:52:30
 */
@SuppressWarnings("serial")
public class NewsColumn extends Model<NewsColumn> {
    //id
    private Integer id;
    //栏目名称
    private String name;


    public Object getId() {
        return id;
    }

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

    public String getName() {
        return name;
    }

    public void setName(String name) {
        this.name = name;
    }

    /**
     * 获取主键值
     *
     * @return 主键值
     */
    @Override
    protected Serializable pkVal() {
        return this.id;
    }
    }

package com.ycl.entity;





import com.baomidou.mybatisplus.extension.activerecord.Model;

import java.io.Serializable;



/**

 * 栏目表(NewsColumn)表实体类

 *

 * @author makejava

 * @since 2022-11-17 11:12:41

 */

@SuppressWarnings("serial")

public class NewsColumn extends Model<NewsColumn> {

    //id

    private Object id;

    //栏目名称

    private String name;





    public Object getId() {

        return id;

    }



    public void setId(Object id) {

        this.id = id;

    }



    public String getName() {

        return name;

    }



    public void setName(String name) {

        this.name = name;

    }



    /**

     * 获取主键值

     *

     * @return 主键值

     */

    @Override

    protected Serializable pkVal() {

        return this.id;

    }

    }




 ycl-platform/src/main/java/com/ycl/entity/NewsColumnInformation.java

@@ -1,57 +1,57 @@
package com.ycl.entity;


import com.baomidou.mybatisplus.extension.activerecord.Model;
import java.io.Serializable;

/**
 * 栏目频道中间表(NewsColumnInformation)表实体类
 *
 * @author makejava
 * @since 2022-11-16 16:52:30
 */
@SuppressWarnings("serial")
public class NewsColumnInformation extends Model<NewsColumnInformation> {
    
    private Integer id;
    //栏目id
    private Integer columnId;
    //咨询id
    private Integer informationId;


    public Integer getId() {
        return id;
    }

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

    public Integer getColumnId() {
        return columnId;
    }

    public void setColumnId(Integer columnId) {
        this.columnId = columnId;
    }

    public Integer getInformationId() {
        return informationId;
    }

    public void setInformationId(Integer informationId) {
        this.informationId = informationId;
    }

    /**
     * 获取主键值
     *
     * @return 主键值
     */
    @Override
    protected Serializable pkVal() {
        return this.id;
    }
    }

package com.ycl.entity;





import com.baomidou.mybatisplus.extension.activerecord.Model;

import java.io.Serializable;



/**

 * 栏目咨询中间表(NewsColumnInformation)表实体类

 *

 * @author makejava

 * @since 2022-11-17 11:12:41

 */

@SuppressWarnings("serial")

public class NewsColumnInformation extends Model<NewsColumnInformation> {

    
    private Integer id;

    //栏目id

    private Integer columnId;

    //咨询id

    private Integer informationId;





    public Integer getId() {

        return id;

    }



    public void setId(Integer id) {

        this.id = id;

    }



    public Integer getColumnId() {

        return columnId;

    }



    public void setColumnId(Integer columnId) {

        this.columnId = columnId;

    }



    public Integer getInformationId() {

        return informationId;

    }



    public void setInformationId(Integer informationId) {

        this.informationId = informationId;

    }



    /**

     * 获取主键值

     *

     * @return 主键值

     */

    @Override

    protected Serializable pkVal() {

        return this.id;

    }

    }




 ycl-platform/src/main/java/com/ycl/entity/NewsDepartment.java

New file
@@ -0,0 +1,47 @@
package com.ycl.entity;





import com.baomidou.mybatisplus.extension.activerecord.Model;

import java.io.Serializable;



/**

 * 部门（机构）表(NewsDepartment)表实体类

 *

 * @author makejava

 * @since 2022-11-17 11:12:41

 */

@SuppressWarnings("serial")

public class NewsDepartment extends Model<NewsDepartment> {

    
    private Integer id;

    //部门名称

    private String deptname;





    public Integer getId() {

        return id;

    }



    public void setId(Integer id) {

        this.id = id;

    }



    public String getDeptname() {

        return deptname;

    }



    public void setDeptname(String deptname) {

        this.deptname = deptname;

    }



    /**

     * 获取主键值

     *

     * @return 主键值

     */

    @Override

    protected Serializable pkVal() {

        return this.id;

    }

    }




 ycl-platform/src/main/java/com/ycl/entity/NewsDuty.java

@@ -1,78 +1,77 @@
package com.ycl.entity;


import com.baomidou.mybatisplus.extension.activerecord.Model;
import java.io.Serializable;
import java.time.LocalDate;

/**
 * 值班表(NewsDuty)表实体类
 *
 * @author makejava
 * @since 2022-11-16 16:52:30
 */
@SuppressWarnings("serial")
public class NewsDuty extends Model<NewsDuty> {
    
    private Integer id;
    //值班人
    private String name;
    //值班职位
    private String jobTitle;
    //创建时间
    private LocalDate createTime;
    //值班时间
    private LocalDate dutyTime;


    public Integer getId() {
        return id;
    }

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

    public String getName() {
        return name;
    }

    public void setName(String name) {
        this.name = name;
    }

    public String getJobTitle() {
        return jobTitle;
    }

    public void setJobTitle(String jobTitle) {
        this.jobTitle = jobTitle;
    }

    public LocalDate getCreateTime() {
        return createTime;
    }

    public void setCreateTime(LocalDate createTime) {
        this.createTime = createTime;
    }

    public LocalDate getDutyTime() {
        return dutyTime;
    }

    public void setDutyTime(LocalDate dutyTime) {
        this.dutyTime = dutyTime;
    }

    /**
     * 获取主键值
     *
     * @return 主键值
     */
    @Override
    protected Serializable pkVal() {
        return this.id;
    }
    }

package com.ycl.entity;





import com.baomidou.mybatisplus.extension.activerecord.Model;

import java.io.Serializable;



/**

 * 值班表(NewsDuty)表实体类

 *

 * @author makejava

 * @since 2022-11-17 11:12:41

 */

@SuppressWarnings("serial")

public class NewsDuty extends Model<NewsDuty> {

    
    private Integer id;

    //值班人

    private String name;

    //值班职位

    private String jobTitle;

    //创建时间

    private Date createTime;

    //值班时间

    private Date dutyTime;





    public Integer getId() {

        return id;

    }



    public void setId(Integer id) {

        this.id = id;

    }



    public String getName() {

        return name;

    }



    public void setName(String name) {

        this.name = name;

    }



    public String getJobTitle() {

        return jobTitle;

    }



    public void setJobTitle(String jobTitle) {

        this.jobTitle = jobTitle;

    }



    public Date getCreateTime() {

        return createTime;

    }



    public void setCreateTime(Date createTime) {

        this.createTime = createTime;

    }



    public Date getDutyTime() {

        return dutyTime;

    }



    public void setDutyTime(Date dutyTime) {

        this.dutyTime = dutyTime;

    }



    /**

     * 获取主键值

     *

     * @return 主键值

     */

    @Override

    protected Serializable pkVal() {

        return this.id;

    }

    }




 ycl-platform/src/main/java/com/ycl/entity/NewsInformation.java

@@ -1,108 +1,117 @@
package com.ycl.entity;


import com.baomidou.mybatisplus.extension.activerecord.Model;
import java.io.Serializable;
import java.time.LocalDate;

/**
 * 咨询表(NewsInformation)表实体类
 *
 * @author makejava
 * @since 2022-11-16 16:52:30
 */
@SuppressWarnings("serial")
public class NewsInformation extends Model<NewsInformation> {
    //id
    private Integer id;
    //标题
    private String title;
    //内容
    private String content;
    //发布时间
    private LocalDate publishTime;
    //是否签收1签收0未签收
    private Integer isSign;
    //创建时间
    private LocalDate createTime;
    //警员id
    private Object sendTo;
    //图片地址
    private String imageUrl;


    public Integer getId() {
        return id;
    }

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

    public String getTitle() {
        return title;
    }

    public void setTitle(String title) {
        this.title = title;
    }

    public String getContent() {
        return content;
    }

    public void setContent(String content) {
        this.content = content;
    }

    public LocalDate getPublishTime() {
        return publishTime;
    }

    public void setPublishTime(LocalDate publishTime) {
        this.publishTime = publishTime;
    }

    public Integer getIsSign() {
        return isSign;
    }

    public void setIsSign(Integer isSign) {
        this.isSign = isSign;
    }

    public LocalDate getCreateTime() {
        return createTime;
    }

    public void setCreateTime(LocalDate createTime) {
        this.createTime = createTime;
    }

    public Object getSendTo() {
        return sendTo;
    }

    public void setSendTo(Object sendTo) {
        this.sendTo = sendTo;
    }

    public String getImageUrl() {
        return imageUrl;
    }

    public void setImageUrl(String imageUrl) {
        this.imageUrl = imageUrl;
    }

    /**
     * 获取主键值
     *
     * @return 主键值
     */
    @Override
    protected Serializable pkVal() {
        return this.id;
    }
    }

package com.ycl.entity;





import com.baomidou.mybatisplus.extension.activerecord.Model;

import java.io.Serializable;



/**

 * 资讯表(NewsInformation)表实体类

 *

 * @author makejava

 * @since 2022-11-17 11:12:41

 */

@SuppressWarnings("serial")

public class NewsInformation extends Model<NewsInformation> {

    //id

    private Object id;

    //标题

    private String title;

    //内容

    private String content;

    //发布时间

    private Date publishTime;

    //是否签收0未签收1签收2不需要签收

    private Integer isSign;

    //创建时间

    private Date createTime;

    //警员id

    private Object sendTo;

    //图片地址

    private String imageUrl;

    //部门（机构）id

    private String newsDepartmentId;





    public Object getId() {

        return id;

    }



    public void setId(Object id) {

        this.id = id;

    }



    public String getTitle() {

        return title;

    }



    public void setTitle(String title) {

        this.title = title;

    }



    public String getContent() {

        return content;

    }



    public void setContent(String content) {

        this.content = content;

    }



    public Date getPublishTime() {

        return publishTime;

    }



    public void setPublishTime(Date publishTime) {

        this.publishTime = publishTime;

    }



    public Integer getIsSign() {

        return isSign;

    }



    public void setIsSign(Integer isSign) {

        this.isSign = isSign;

    }



    public Date getCreateTime() {

        return createTime;

    }



    public void setCreateTime(Date createTime) {

        this.createTime = createTime;

    }



    public Object getSendTo() {

        return sendTo;

    }



    public void setSendTo(Object sendTo) {

        this.sendTo = sendTo;

    }



    public String getImageUrl() {

        return imageUrl;

    }



    public void setImageUrl(String imageUrl) {

        this.imageUrl = imageUrl;

    }



    public String getNewsDepartmentId() {

        return newsDepartmentId;

    }



    public void setNewsDepartmentId(String newsDepartmentId) {

        this.newsDepartmentId = newsDepartmentId;

    }



    /**

     * 获取主键值

     *

     * @return 主键值

     */

    @Override

    protected Serializable pkVal() {

        return this.id;

    }

    }




 ycl-platform/src/main/java/com/ycl/entity/NewsIp.java

@@ -1,57 +1,57 @@
package com.ycl.entity;


import com.baomidou.mybatisplus.extension.activerecord.Model;
import java.io.Serializable;
import java.time.LocalDate;

/**
 * ip白名单表(NewsIp)表实体类
 *
 * @author makejava
 * @since 2022-11-16 16:52:30
 */
@SuppressWarnings("serial")
public class NewsIp extends Model<NewsIp> {
    
    private Integer id;
    //ip地址
    private String ipAddess;
    //创建时间
    private LocalDate createTime;

    public Integer getId() {
        return id;
    }

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

    public String getIpAddess() {
        return ipAddess;
    }

    public void setIpAddess(String ipAddess) {
        this.ipAddess = ipAddess;
    }

    public LocalDate getCreateTime() {
        return createTime;
    }

    public void setCreateTime(LocalDate createTime) {
        this.createTime = createTime;
    }

    /**
     * 获取主键值
     *
     * @return 主键值
     */
    @Override
    protected Serializable pkVal() {
        return this.id;
    }
    }

package com.ycl.entity;





import com.baomidou.mybatisplus.extension.activerecord.Model;

import java.io.Serializable;



/**

 * ip白名单表(NewsIp)表实体类

 *

 * @author makejava

 * @since 2022-11-17 11:12:41

 */

@SuppressWarnings("serial")

public class NewsIp extends Model<NewsIp> {

    
    private Integer id;

    //ip地址

    private String ipAddess;

    //创建时间

    private Date createTime;





    public Integer getId() {

        return id;

    }



    public void setId(Integer id) {

        this.id = id;

    }



    public String getIpAddess() {

        return ipAddess;

    }



    public void setIpAddess(String ipAddess) {

        this.ipAddess = ipAddess;

    }



    public Date getCreateTime() {

        return createTime;

    }



    public void setCreateTime(Date createTime) {

        this.createTime = createTime;

    }



    /**

     * 获取主键值

     *

     * @return 主键值

     */

    @Override

    protected Serializable pkVal() {

        return this.id;

    }

    }




 ycl-platform/src/main/java/com/ycl/entity/NewsPolice.java

@@ -1,79 +1,78 @@
package com.ycl.entity;


import com.baomidou.mybatisplus.extension.activerecord.Model;
import java.io.Serializable;
import java.time.LocalDate;

/**
 * 警员表
(NewsPolice)表实体类
 *
 * @author makejava
 * @since 2022-11-16 16:52:30
 */
@SuppressWarnings("serial")
public class NewsPolice extends Model<NewsPolice> {
    //自增主键
    private Integer id;
    //警员名称
    private String rname;
    //创建时间
    private LocalDate createTime;
    //修改时间
    private LocalDate updateTime;
    //机构名称
    private String organizationName;


    public Integer getId() {
        return id;
    }

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

    public String getRname() {
        return rname;
    }

    public void setRname(String rname) {
        this.rname = rname;
    }

    public LocalDate getCreateTime() {
        return createTime;
    }

    public void setCreateTime(LocalDate createTime) {
        this.createTime = createTime;
    }

    public LocalDate getUpdateTime() {
        return updateTime;
    }

    public void setUpdateTime(LocalDate updateTime) {
        this.updateTime = updateTime;
    }

    public String getOrganizationName() {
        return organizationName;
    }

    public void setOrganizationName(String organizationName) {
        this.organizationName = organizationName;
    }

    /**
     * 获取主键值
     *
     * @return 主键值
     */
    @Override
    protected Serializable pkVal() {
        return this.id;
    }
    }

package com.ycl.entity;





import com.baomidou.mybatisplus.extension.activerecord.Model;

import java.io.Serializable;



/**

 * 警员表

(NewsPolice)表实体类

 *

 * @author makejava

 * @since 2022-11-17 11:12:42

 */

@SuppressWarnings("serial")

public class NewsPolice extends Model<NewsPolice> {

    //自增主键

    private Object id;

    //警员名称

    private String rname;

    //创建时间

    private Date createTime;

    //修改时间

    private Date updateTime;

    //机构名称

    private String organizationName;





    public Object getId() {

        return id;

    }



    public void setId(Object id) {

        this.id = id;

    }



    public String getRname() {

        return rname;

    }



    public void setRname(String rname) {

        this.rname = rname;

    }



    public Date getCreateTime() {

        return createTime;

    }



    public void setCreateTime(Date createTime) {

        this.createTime = createTime;

    }



    public Date getUpdateTime() {

        return updateTime;

    }



    public void setUpdateTime(Date updateTime) {

        this.updateTime = updateTime;

    }



    public String getOrganizationName() {

        return organizationName;

    }



    public void setOrganizationName(String organizationName) {

        this.organizationName = organizationName;

    }



    /**

     * 获取主键值

     *

     * @return 主键值

     */

    @Override

    protected Serializable pkVal() {

        return this.id;

    }

    }




 ycl-platform/src/main/java/com/ycl/service/NewsAdminService.java

New file
@@ -0,0 +1,15 @@
package com.ycl.service;



import com.baomidou.mybatisplus.extension.service.IService;

import com.ycl.entity.NewsAdmin;



/**

 * 后台用户表(NewsAdmin)表服务接口

 *

 * @author makejava

 * @since 2022-11-17 11:12:41

 */

public interface NewsAdminService extends IService<NewsAdmin> {



}




 ycl-platform/src/main/java/com/ycl/service/NewsChannelColumnService.java

@@ -1,15 +1,15 @@
package com.ycl.service;

import com.baomidou.mybatisplus.extension.service.IService;
import com.ycl.entity.NewsChannelColumn;

/**
 * 频道栏目中间表(NewsChannelColumn)表服务接口
 *
 * @author makejava
 * @since 2022-11-16 16:52:30
 */
public interface NewsChannelColumnService extends IService<NewsChannelColumn> {

}

package com.ycl.service;



import com.baomidou.mybatisplus.extension.service.IService;

import com.ycl.entity.NewsChannelColumn;



/**

 * 频道栏目中间表(NewsChannelColumn)表服务接口

 *

 * @author makejava

 * @since 2022-11-17 11:12:41

 */

public interface NewsChannelColumnService extends IService<NewsChannelColumn> {



}




 ycl-platform/src/main/java/com/ycl/service/NewsChannelService.java

@@ -1,15 +1,15 @@
package com.ycl.service;

import com.baomidou.mybatisplus.extension.service.IService;
import com.ycl.entity.NewsChannel;

/**
 * 频道表(NewsChannel)表服务接口
 *
 * @author makejava
 * @since 2022-11-16 16:52:30
 */
public interface NewsChannelService extends IService<NewsChannel> {

}

package com.ycl.service;



import com.baomidou.mybatisplus.extension.service.IService;

import com.ycl.entity.NewsChannel;



/**

 * 频道表(NewsChannel)表服务接口

 *

 * @author makejava

 * @since 2022-11-17 11:12:41

 */

public interface NewsChannelService extends IService<NewsChannel> {



}




 ycl-platform/src/main/java/com/ycl/service/NewsColumnInformationService.java

@@ -1,15 +1,15 @@
package com.ycl.service;

import com.baomidou.mybatisplus.extension.service.IService;
import com.ycl.entity.NewsColumnInformation;

/**
 * 栏目频道中间表(NewsColumnInformation)表服务接口
 *
 * @author makejava
 * @since 2022-11-16 16:52:30
 */
public interface NewsColumnInformationService extends IService<NewsColumnInformation> {

}

package com.ycl.service;



import com.baomidou.mybatisplus.extension.service.IService;

import com.ycl.entity.NewsColumnInformation;



/**

 * 栏目咨询中间表(NewsColumnInformation)表服务接口

 *

 * @author makejava

 * @since 2022-11-17 11:12:41

 */

public interface NewsColumnInformationService extends IService<NewsColumnInformation> {



}




 ycl-platform/src/main/java/com/ycl/service/NewsColumnService.java

@@ -1,15 +1,15 @@
package com.ycl.service;

import com.baomidou.mybatisplus.extension.service.IService;
import com.ycl.entity.NewsColumn;

/**
 * 栏目表(NewsColumn)表服务接口
 *
 * @author makejava
 * @since 2022-11-16 16:52:30
 */
public interface NewsColumnService extends IService<NewsColumn> {

}

package com.ycl.service;



import com.baomidou.mybatisplus.extension.service.IService;

import com.ycl.entity.NewsColumn;



/**

 * 栏目表(NewsColumn)表服务接口

 *

 * @author makejava

 * @since 2022-11-17 11:12:41

 */

public interface NewsColumnService extends IService<NewsColumn> {



}




 ycl-platform/src/main/java/com/ycl/service/NewsDepartmentService.java

New file
@@ -0,0 +1,15 @@
package com.ycl.service;



import com.baomidou.mybatisplus.extension.service.IService;

import com.ycl.entity.NewsDepartment;



/**

 * 部门（机构）表(NewsDepartment)表服务接口

 *

 * @author makejava

 * @since 2022-11-17 11:12:41

 */

public interface NewsDepartmentService extends IService<NewsDepartment> {



}




 ycl-platform/src/main/java/com/ycl/service/NewsDutyService.java

@@ -1,15 +1,15 @@
package com.ycl.service;

import com.baomidou.mybatisplus.extension.service.IService;
import com.ycl.entity.NewsDuty;

/**
 * 值班表(NewsDuty)表服务接口
 *
 * @author makejava
 * @since 2022-11-16 16:52:30
 */
public interface NewsDutyService extends IService<NewsDuty> {

}

package com.ycl.service;



import com.baomidou.mybatisplus.extension.service.IService;

import com.ycl.entity.NewsDuty;



/**

 * 值班表(NewsDuty)表服务接口

 *

 * @author makejava

 * @since 2022-11-17 11:12:41

 */

public interface NewsDutyService extends IService<NewsDuty> {



}




 ycl-platform/src/main/java/com/ycl/service/NewsInformationService.java

@@ -1,15 +1,15 @@
package com.ycl.service;

import com.baomidou.mybatisplus.extension.service.IService;
import com.ycl.entity.NewsInformation;

/**
 * 咨询表(NewsInformation)表服务接口
 *
 * @author makejava
 * @since 2022-11-16 16:52:30
 */
public interface NewsInformationService extends IService<NewsInformation> {

}

package com.ycl.service;



import com.baomidou.mybatisplus.extension.service.IService;

import com.ycl.entity.NewsInformation;



/**

 * 资讯表(NewsInformation)表服务接口

 *

 * @author makejava

 * @since 2022-11-17 11:12:41

 */

public interface NewsInformationService extends IService<NewsInformation> {



}




 ycl-platform/src/main/java/com/ycl/service/NewsIpService.java

@@ -1,15 +1,15 @@
package com.ycl.service;

import com.baomidou.mybatisplus.extension.service.IService;
import com.ycl.entity.NewsIp;

/**
 * ip白名单表(NewsIp)表服务接口
 *
 * @author makejava
 * @since 2022-11-16 16:52:30
 */
public interface NewsIpService extends IService<NewsIp> {

}

package com.ycl.service;



import com.baomidou.mybatisplus.extension.service.IService;

import com.ycl.entity.NewsIp;



/**

 * ip白名单表(NewsIp)表服务接口

 *

 * @author makejava

 * @since 2022-11-17 11:12:42

 */

public interface NewsIpService extends IService<NewsIp> {



}




 ycl-platform/src/main/java/com/ycl/service/NewsPoliceService.java

@@ -1,16 +1,16 @@
package com.ycl.service;

import com.baomidou.mybatisplus.extension.service.IService;
import com.ycl.entity.NewsPolice;

/**
 * 警员表
(NewsPolice)表服务接口
 *
 * @author makejava
 * @since 2022-11-16 16:52:30
 */
public interface NewsPoliceService extends IService<NewsPolice> {

}

package com.ycl.service;



import com.baomidou.mybatisplus.extension.service.IService;

import com.ycl.entity.NewsPolice;



/**

 * 警员表

(NewsPolice)表服务接口

 *

 * @author makejava

 * @since 2022-11-17 11:12:42

 */

public interface NewsPoliceService extends IService<NewsPolice> {



}




 ycl-platform/src/main/java/com/ycl/service/impl/NewsAdminServiceImpl.java

New file
@@ -0,0 +1,19 @@
package com.ycl.service.impl;



import com.baomidou.mybatisplus.extension.service.impl.ServiceImpl;

import com.ycl.dao.NewsAdminDao;

import com.ycl.entity.NewsAdmin;

import com.ycl.service.NewsAdminService;

import org.springframework.stereotype.Service;



/**

 * 后台用户表(NewsAdmin)表服务实现类

 *

 * @author makejava

 * @since 2022-11-17 11:12:41

 */

@Service("newsAdminService")

public class NewsAdminServiceImpl extends ServiceImpl<NewsAdminDao, NewsAdmin> implements NewsAdminService {



}




 ycl-platform/src/main/java/com/ycl/service/impl/NewsChannelColumnServiceImpl.java

@@ -1,19 +1,19 @@
package com.ycl.service.impl;

import com.baomidou.mybatisplus.extension.service.impl.ServiceImpl;
import com.ycl.mapper.NewsChannelColumnDao;
import com.ycl.entity.NewsChannelColumn;
import com.ycl.service.NewsChannelColumnService;
import org.springframework.stereotype.Service;

/**
 * 频道栏目中间表(NewsChannelColumn)表服务实现类
 *
 * @author makejava
 * @since 2022-11-16 16:52:30
 */
@Service("newsChannelColumnService")
public class NewsChannelColumnServiceImpl extends ServiceImpl<NewsChannelColumnDao, NewsChannelColumn> implements NewsChannelColumnService {

}

package com.ycl.service.impl;



import com.baomidou.mybatisplus.extension.service.impl.ServiceImpl;

import com.ycl.dao.NewsChannelColumnDao;

import com.ycl.entity.NewsChannelColumn;

import com.ycl.service.NewsChannelColumnService;

import org.springframework.stereotype.Service;



/**

 * 频道栏目中间表(NewsChannelColumn)表服务实现类

 *

 * @author makejava

 * @since 2022-11-17 11:12:41

 */

@Service("newsChannelColumnService")

public class NewsChannelColumnServiceImpl extends ServiceImpl<NewsChannelColumnDao, NewsChannelColumn> implements NewsChannelColumnService {



}




 ycl-platform/src/main/java/com/ycl/service/impl/NewsChannelServiceImpl.java

@@ -1,19 +1,19 @@
package com.ycl.service.impl;

import com.baomidou.mybatisplus.extension.service.impl.ServiceImpl;
import com.ycl.mapper.NewsChannelDao;
import com.ycl.entity.NewsChannel;
import com.ycl.service.NewsChannelService;
import org.springframework.stereotype.Service;

/**
 * 频道表(NewsChannel)表服务实现类
 *
 * @author makejava
 * @since 2022-11-16 16:52:30
 */
@Service("newsChannelService")
public class NewsChannelServiceImpl extends ServiceImpl<NewsChannelDao, NewsChannel> implements NewsChannelService {

}

package com.ycl.service.impl;



import com.baomidou.mybatisplus.extension.service.impl.ServiceImpl;

import com.ycl.dao.NewsChannelDao;

import com.ycl.entity.NewsChannel;

import com.ycl.service.NewsChannelService;

import org.springframework.stereotype.Service;



/**

 * 频道表(NewsChannel)表服务实现类

 *

 * @author makejava

 * @since 2022-11-17 11:12:41

 */

@Service("newsChannelService")

public class NewsChannelServiceImpl extends ServiceImpl<NewsChannelDao, NewsChannel> implements NewsChannelService {



}




 ycl-platform/src/main/java/com/ycl/service/impl/NewsColumnInformationServiceImpl.java

@@ -1,19 +1,19 @@
package com.ycl.service.impl;

import com.baomidou.mybatisplus.extension.service.impl.ServiceImpl;
import com.ycl.mapper.NewsColumnInformationDao;
import com.ycl.entity.NewsColumnInformation;
import com.ycl.service.NewsColumnInformationService;
import org.springframework.stereotype.Service;

/**
 * 栏目频道中间表(NewsColumnInformation)表服务实现类
 *
 * @author makejava
 * @since 2022-11-16 16:52:30
 */
@Service("newsColumnInformationService")
public class NewsColumnInformationServiceImpl extends ServiceImpl<NewsColumnInformationDao, NewsColumnInformation> implements NewsColumnInformationService {

}

package com.ycl.service.impl;



import com.baomidou.mybatisplus.extension.service.impl.ServiceImpl;

import com.ycl.dao.NewsColumnInformationDao;

import com.ycl.entity.NewsColumnInformation;

import com.ycl.service.NewsColumnInformationService;

import org.springframework.stereotype.Service;



/**

 * 栏目咨询中间表(NewsColumnInformation)表服务实现类

 *

 * @author makejava

 * @since 2022-11-17 11:12:41

 */

@Service("newsColumnInformationService")

public class NewsColumnInformationServiceImpl extends ServiceImpl<NewsColumnInformationDao, NewsColumnInformation> implements NewsColumnInformationService {



}




 ycl-platform/src/main/java/com/ycl/service/impl/NewsColumnServiceImpl.java

@@ -1,19 +1,19 @@
package com.ycl.service.impl;

import com.baomidou.mybatisplus.extension.service.impl.ServiceImpl;
import com.ycl.mapper.NewsColumnDao;
import com.ycl.entity.NewsColumn;
import com.ycl.service.NewsColumnService;
import org.springframework.stereotype.Service;

/**
 * 栏目表(NewsColumn)表服务实现类
 *
 * @author makejava
 * @since 2022-11-16 16:52:30
 */
@Service("newsColumnService")
public class NewsColumnServiceImpl extends ServiceImpl<NewsColumnDao, NewsColumn> implements NewsColumnService {

}

package com.ycl.service.impl;



import com.baomidou.mybatisplus.extension.service.impl.ServiceImpl;

import com.ycl.dao.NewsColumnDao;

import com.ycl.entity.NewsColumn;

import com.ycl.service.NewsColumnService;

import org.springframework.stereotype.Service;



/**

 * 栏目表(NewsColumn)表服务实现类

 *

 * @author makejava

 * @since 2022-11-17 11:12:41

 */

@Service("newsColumnService")

public class NewsColumnServiceImpl extends ServiceImpl<NewsColumnDao, NewsColumn> implements NewsColumnService {



}




 ycl-platform/src/main/java/com/ycl/service/impl/NewsDepartmentServiceImpl.java

New file
@@ -0,0 +1,19 @@
package com.ycl.service.impl;



import com.baomidou.mybatisplus.extension.service.impl.ServiceImpl;

import com.ycl.dao.NewsDepartmentDao;

import com.ycl.entity.NewsDepartment;

import com.ycl.service.NewsDepartmentService;

import org.springframework.stereotype.Service;



/**

 * 部门（机构）表(NewsDepartment)表服务实现类

 *

 * @author makejava

 * @since 2022-11-17 11:12:41

 */

@Service("newsDepartmentService")

public class NewsDepartmentServiceImpl extends ServiceImpl<NewsDepartmentDao, NewsDepartment> implements NewsDepartmentService {



}




 ycl-platform/src/main/java/com/ycl/service/impl/NewsDutyServiceImpl.java

@@ -1,19 +1,19 @@
package com.ycl.service.impl;

import com.baomidou.mybatisplus.extension.service.impl.ServiceImpl;
import com.ycl.mapper.NewsDutyDao;
import com.ycl.entity.NewsDuty;
import com.ycl.service.NewsDutyService;
import org.springframework.stereotype.Service;

/**
 * 值班表(NewsDuty)表服务实现类
 *
 * @author makejava
 * @since 2022-11-16 16:52:30
 */
@Service("newsDutyService")
public class NewsDutyServiceImpl extends ServiceImpl<NewsDutyDao, NewsDuty> implements NewsDutyService {

}

package com.ycl.service.impl;



import com.baomidou.mybatisplus.extension.service.impl.ServiceImpl;

import com.ycl.dao.NewsDutyDao;

import com.ycl.entity.NewsDuty;

import com.ycl.service.NewsDutyService;

import org.springframework.stereotype.Service;



/**

 * 值班表(NewsDuty)表服务实现类

 *

 * @author makejava

 * @since 2022-11-17 11:12:41

 */

@Service("newsDutyService")

public class NewsDutyServiceImpl extends ServiceImpl<NewsDutyDao, NewsDuty> implements NewsDutyService {



}




 ycl-platform/src/main/java/com/ycl/service/impl/NewsInformationServiceImpl.java

@@ -1,19 +1,19 @@
package com.ycl.service.impl;

import com.baomidou.mybatisplus.extension.service.impl.ServiceImpl;
import com.ycl.mapper.NewsInformationDao;
import com.ycl.entity.NewsInformation;
import com.ycl.service.NewsInformationService;
import org.springframework.stereotype.Service;

/**
 * 咨询表(NewsInformation)表服务实现类
 *
 * @author makejava
 * @since 2022-11-16 16:52:30
 */
@Service("newsInformationService")
public class NewsInformationServiceImpl extends ServiceImpl<NewsInformationDao, NewsInformation> implements NewsInformationService {

}

package com.ycl.service.impl;



import com.baomidou.mybatisplus.extension.service.impl.ServiceImpl;

import com.ycl.dao.NewsInformationDao;

import com.ycl.entity.NewsInformation;

import com.ycl.service.NewsInformationService;

import org.springframework.stereotype.Service;



/**

 * 资讯表(NewsInformation)表服务实现类

 *

 * @author makejava

 * @since 2022-11-17 11:12:41

 */

@Service("newsInformationService")

public class NewsInformationServiceImpl extends ServiceImpl<NewsInformationDao, NewsInformation> implements NewsInformationService {



}




 ycl-platform/src/main/java/com/ycl/service/impl/NewsIpServiceImpl.java

@@ -1,19 +1,19 @@
package com.ycl.service.impl;

import com.baomidou.mybatisplus.extension.service.impl.ServiceImpl;
import com.ycl.mapper.NewsIpDao;
import com.ycl.entity.NewsIp;
import com.ycl.service.NewsIpService;
import org.springframework.stereotype.Service;

/**
 * ip白名单表(NewsIp)表服务实现类
 *
 * @author makejava
 * @since 2022-11-16 16:52:30
 */
@Service("newsIpService")
public class NewsIpServiceImpl extends ServiceImpl<NewsIpDao, NewsIp> implements NewsIpService {

}

package com.ycl.service.impl;



import com.baomidou.mybatisplus.extension.service.impl.ServiceImpl;

import com.ycl.dao.NewsIpDao;

import com.ycl.entity.NewsIp;

import com.ycl.service.NewsIpService;

import org.springframework.stereotype.Service;



/**

 * ip白名单表(NewsIp)表服务实现类

 *

 * @author makejava

 * @since 2022-11-17 11:12:42

 */

@Service("newsIpService")

public class NewsIpServiceImpl extends ServiceImpl<NewsIpDao, NewsIp> implements NewsIpService {



}




 ycl-platform/src/main/java/com/ycl/service/impl/NewsPoliceServiceImpl.java

@@ -1,20 +1,20 @@
package com.ycl.service.impl;

import com.baomidou.mybatisplus.extension.service.impl.ServiceImpl;
import com.ycl.mapper.NewsPoliceDao;
import com.ycl.entity.NewsPolice;
import com.ycl.service.NewsPoliceService;
import org.springframework.stereotype.Service;

/**
 * 警员表
(NewsPolice)表服务实现类
 *
 * @author makejava
 * @since 2022-11-16 16:52:30
 */
@Service("newsPoliceService")
public class NewsPoliceServiceImpl extends ServiceImpl<NewsPoliceDao, NewsPolice> implements NewsPoliceService {

}

package com.ycl.service.impl;



import com.baomidou.mybatisplus.extension.service.impl.ServiceImpl;

import com.ycl.dao.NewsPoliceDao;

import com.ycl.entity.NewsPolice;

import com.ycl.service.NewsPoliceService;

import org.springframework.stereotype.Service;



/**

 * 警员表

(NewsPolice)表服务实现类

 *

 * @author makejava

 * @since 2022-11-17 11:12:42

 */

@Service("newsPoliceService")

public class NewsPoliceServiceImpl extends ServiceImpl<NewsPoliceDao, NewsPolice> implements NewsPoliceService {



}




 ycl-platform/src/main/resources/mapper/NewsAdminDao.xml

New file
@@ -0,0 +1,39 @@
<?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.ycl.dao.NewsAdminDao">



    <resultMap type="com.ycl.entity.NewsAdmin" id="NewsAdminMap">

        <result property="id" column="id" jdbcType="INTEGER"/>

        <result property="username" column="username" jdbcType="VARCHAR"/>

        <result property="password" column="password" jdbcType="VARCHAR"/>

        <result property="icon" column="icon" jdbcType="VARCHAR"/>

        <result property="email" column="email" jdbcType="VARCHAR"/>

        <result property="note" column="note" jdbcType="VARCHAR"/>

        <result property="createTime" column="create_time" jdbcType="TIMESTAMP"/>

        <result property="status" column="status" jdbcType="INTEGER"/>

        <result property="sex" column="sex" jdbcType="INTEGER"/>

        <result property="mobile" column="mobile" jdbcType="VARCHAR"/>

        <result property="isGrid" column="is_grid" jdbcType="INTEGER"/>

        <result property="newsPoliceId" column="news_police_id" jdbcType="INTEGER"/>

    </resultMap>



    <!-- 批量插入 -->

    <insert id="insertBatch" keyProperty="id" useGeneratedKeys="true">

        insert into news_website.news_admin(username, password, icon, email, note, create_time, status, sex, mobile, is_grid, news_police_id)

        values

        <foreach collection="entities" item="entity" separator=",">

        (#{entity.username}, #{entity.password}, #{entity.icon}, #{entity.email}, #{entity.note}, #{entity.createTime}, #{entity.status}, #{entity.sex}, #{entity.mobile}, #{entity.isGrid}, #{entity.newsPoliceId})

        </foreach>

    </insert>

    <!-- 批量插入或按主键更新 -->

    <insert id="insertOrUpdateBatch" keyProperty="id" useGeneratedKeys="true">

        insert into news_website.news_admin(username, password, icon, email, note, create_time, status, sex, mobile, is_grid, news_police_id)

        values

        <foreach collection="entities" item="entity" separator=",">

            (#{entity.username}, #{entity.password}, #{entity.icon}, #{entity.email}, #{entity.note}, #{entity.createTime}, #{entity.status}, #{entity.sex}, #{entity.mobile}, #{entity.isGrid}, #{entity.newsPoliceId})

        </foreach>

        on duplicate key update

         username = values(username) , password = values(password) , icon = values(icon) , email = values(email) , note = values(note) , create_time = values(create_time) , status = values(status) , sex = values(sex) , mobile = values(mobile) , is_grid = values(is_grid) , news_police_id = values(news_police_id)     </insert>



</mapper>




 ycl-platform/src/main/resources/mapper/NewsChannelColumnDao.xml

@@ -1,30 +1,30 @@
<?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.ycl.mapper.NewsChannelColumnDao">

    <resultMap type="com.ycl.entity.NewsChannelColumn" id="NewsChannelColumnMap">
        <result property="id" column="id" jdbcType="INTEGER"/>
        <result property="channelId" column="channel_id" jdbcType="INTEGER"/>
        <result property="columnId" column="column_id" jdbcType="INTEGER"/>
    </resultMap>

    <!-- 批量插入 -->
    <insert id="insertBatch" keyProperty="id" useGeneratedKeys="true">
        insert into news_website.news_channel_column(channel_id, column_id)
        values
        <foreach collection="entities" item="entity" separator=",">
        (#{entity.channelId}, #{entity.columnId})
        </foreach>
    </insert>
    <!-- 批量插入或按主键更新 -->
    <insert id="insertOrUpdateBatch" keyProperty="id" useGeneratedKeys="true">
        insert into news_website.news_channel_column(channel_id, column_id)
        values
        <foreach collection="entities" item="entity" separator=",">
            (#{entity.channelId}, #{entity.columnId})
        </foreach>
        on duplicate key update
         channel_id = values(channel_id) , column_id = values(column_id)     </insert>

</mapper>

<?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.ycl.dao.NewsChannelColumnDao">



    <resultMap type="com.ycl.entity.NewsChannelColumn" id="NewsChannelColumnMap">

        <result property="id" column="id" jdbcType="INTEGER"/>

        <result property="channelId" column="channel_id" jdbcType="INTEGER"/>

        <result property="columnId" column="column_id" jdbcType="INTEGER"/>

    </resultMap>



    <!-- 批量插入 -->

    <insert id="insertBatch" keyProperty="id" useGeneratedKeys="true">

        insert into news_website.news_channel_column(channel_id, column_id)

        values

        <foreach collection="entities" item="entity" separator=",">

        (#{entity.channelId}, #{entity.columnId})

        </foreach>

    </insert>

    <!-- 批量插入或按主键更新 -->

    <insert id="insertOrUpdateBatch" keyProperty="id" useGeneratedKeys="true">

        insert into news_website.news_channel_column(channel_id, column_id)

        values

        <foreach collection="entities" item="entity" separator=",">

            (#{entity.channelId}, #{entity.columnId})

        </foreach>

        on duplicate key update

         channel_id = values(channel_id) , column_id = values(column_id)     </insert>



</mapper>




 ycl-platform/src/main/resources/mapper/NewsChannelDao.xml

@@ -1,31 +1,31 @@
<?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.ycl.mapper.NewsChannelDao">

    <resultMap type="com.ycl.entity.NewsChannel" id="NewsChannelMap">
        <result property="id" column="id" jdbcType="INTEGER"/>
        <result property="name" column="name" jdbcType="VARCHAR"/>
        <result property="code" column="code" jdbcType="VARCHAR"/>
        <result property="createTime" column="create_time" jdbcType="TIMESTAMP"/>
    </resultMap>

    <!-- 批量插入 -->
    <insert id="insertBatch" keyProperty="id" useGeneratedKeys="true">
        insert into news_website.news_channel(name, code, create_time)
        values
        <foreach collection="entities" item="entity" separator=",">
        (#{entity.name}, #{entity.code}, #{entity.createTime})
        </foreach>
    </insert>
    <!-- 批量插入或按主键更新 -->
    <insert id="insertOrUpdateBatch" keyProperty="id" useGeneratedKeys="true">
        insert into news_website.news_channel(name, code, create_time)
        values
        <foreach collection="entities" item="entity" separator=",">
            (#{entity.name}, #{entity.code}, #{entity.createTime})
        </foreach>
        on duplicate key update
         name = values(name) , code = values(code) , create_time = values(create_time)     </insert>

</mapper>

<?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.ycl.dao.NewsChannelDao">



    <resultMap type="com.ycl.entity.NewsChannel" id="NewsChannelMap">

        <result property="id" column="id" jdbcType="INTEGER"/>

        <result property="name" column="name" jdbcType="VARCHAR"/>

        <result property="code" column="code" jdbcType="VARCHAR"/>

        <result property="createTime" column="create_time" jdbcType="TIMESTAMP"/>

    </resultMap>



    <!-- 批量插入 -->

    <insert id="insertBatch" keyProperty="id" useGeneratedKeys="true">

        insert into news_website.news_channel(name, code, create_time)

        values

        <foreach collection="entities" item="entity" separator=",">

        (#{entity.name}, #{entity.code}, #{entity.createTime})

        </foreach>

    </insert>

    <!-- 批量插入或按主键更新 -->

    <insert id="insertOrUpdateBatch" keyProperty="id" useGeneratedKeys="true">

        insert into news_website.news_channel(name, code, create_time)

        values

        <foreach collection="entities" item="entity" separator=",">

            (#{entity.name}, #{entity.code}, #{entity.createTime})

        </foreach>

        on duplicate key update

         name = values(name) , code = values(code) , create_time = values(create_time)     </insert>



</mapper>




 ycl-platform/src/main/resources/mapper/NewsColumnDao.xml

@@ -1,29 +1,29 @@
<?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.ycl.mapper.NewsColumnDao">

    <resultMap type="com.ycl.entity.NewsColumn" id="NewsColumnMap">
        <result property="id" column="id" jdbcType="VARCHAR"/>
        <result property="name" column="name" jdbcType="VARCHAR"/>
    </resultMap>

    <!-- 批量插入 -->
    <insert id="insertBatch" keyProperty="id" useGeneratedKeys="true">
        insert into news_website.news_column(name)
        values
        <foreach collection="entities" item="entity" separator=",">
        (#{entity.name})
        </foreach>
    </insert>
    <!-- 批量插入或按主键更新 -->
    <insert id="insertOrUpdateBatch" keyProperty="id" useGeneratedKeys="true">
        insert into news_website.news_column(name)
        values
        <foreach collection="entities" item="entity" separator=",">
            (#{entity.name})
        </foreach>
        on duplicate key update
         name = values(name)     </insert>

</mapper>

<?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.ycl.dao.NewsColumnDao">



    <resultMap type="com.ycl.entity.NewsColumn" id="NewsColumnMap">

        <result property="id" column="id" jdbcType="VARCHAR"/>

        <result property="name" column="name" jdbcType="VARCHAR"/>

    </resultMap>



    <!-- 批量插入 -->

    <insert id="insertBatch" keyProperty="id" useGeneratedKeys="true">

        insert into news_website.news_column(name)

        values

        <foreach collection="entities" item="entity" separator=",">

        (#{entity.name})

        </foreach>

    </insert>

    <!-- 批量插入或按主键更新 -->

    <insert id="insertOrUpdateBatch" keyProperty="id" useGeneratedKeys="true">

        insert into news_website.news_column(name)

        values

        <foreach collection="entities" item="entity" separator=",">

            (#{entity.name})

        </foreach>

        on duplicate key update

         name = values(name)     </insert>



</mapper>




 ycl-platform/src/main/resources/mapper/NewsColumnInformationDao.xml

@@ -1,30 +1,30 @@
<?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.ycl.mapper.NewsColumnInformationDao">

    <resultMap type="com.ycl.entity.NewsColumnInformation" id="NewsColumnInformationMap">
        <result property="id" column="id" jdbcType="INTEGER"/>
        <result property="columnId" column="column_id" jdbcType="INTEGER"/>
        <result property="informationId" column="information_id" jdbcType="INTEGER"/>
    </resultMap>

    <!-- 批量插入 -->
    <insert id="insertBatch" keyProperty="id" useGeneratedKeys="true">
        insert into news_website.news_column_information(column_id, information_id)
        values
        <foreach collection="entities" item="entity" separator=",">
        (#{entity.columnId}, #{entity.informationId})
        </foreach>
    </insert>
    <!-- 批量插入或按主键更新 -->
    <insert id="insertOrUpdateBatch" keyProperty="id" useGeneratedKeys="true">
        insert into news_website.news_column_information(column_id, information_id)
        values
        <foreach collection="entities" item="entity" separator=",">
            (#{entity.columnId}, #{entity.informationId})
        </foreach>
        on duplicate key update
         column_id = values(column_id) , information_id = values(information_id)     </insert>

</mapper>

<?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.ycl.dao.NewsColumnInformationDao">



    <resultMap type="com.ycl.entity.NewsColumnInformation" id="NewsColumnInformationMap">

        <result property="id" column="id" jdbcType="INTEGER"/>

        <result property="columnId" column="column_id" jdbcType="INTEGER"/>

        <result property="informationId" column="information_id" jdbcType="INTEGER"/>

    </resultMap>



    <!-- 批量插入 -->

    <insert id="insertBatch" keyProperty="id" useGeneratedKeys="true">

        insert into news_website.news_column_information(column_id, information_id)

        values

        <foreach collection="entities" item="entity" separator=",">

        (#{entity.columnId}, #{entity.informationId})

        </foreach>

    </insert>

    <!-- 批量插入或按主键更新 -->

    <insert id="insertOrUpdateBatch" keyProperty="id" useGeneratedKeys="true">

        insert into news_website.news_column_information(column_id, information_id)

        values

        <foreach collection="entities" item="entity" separator=",">

            (#{entity.columnId}, #{entity.informationId})

        </foreach>

        on duplicate key update

         column_id = values(column_id) , information_id = values(information_id)     </insert>



</mapper>




 ycl-platform/src/main/resources/mapper/NewsDepartmentDao.xml

New file
@@ -0,0 +1,29 @@
<?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.ycl.dao.NewsDepartmentDao">



    <resultMap type="com.ycl.entity.NewsDepartment" id="NewsDepartmentMap">

        <result property="id" column="id" jdbcType="INTEGER"/>

        <result property="deptname" column="deptname" jdbcType="VARCHAR"/>

    </resultMap>



    <!-- 批量插入 -->

    <insert id="insertBatch" keyProperty="id" useGeneratedKeys="true">

        insert into news_website.news_department(deptname)

        values

        <foreach collection="entities" item="entity" separator=",">

        (#{entity.deptname})

        </foreach>

    </insert>

    <!-- 批量插入或按主键更新 -->

    <insert id="insertOrUpdateBatch" keyProperty="id" useGeneratedKeys="true">

        insert into news_website.news_department(deptname)

        values

        <foreach collection="entities" item="entity" separator=",">

            (#{entity.deptname})

        </foreach>

        on duplicate key update

         deptname = values(deptname)     </insert>



</mapper>




 ycl-platform/src/main/resources/mapper/NewsDutyDao.xml

@@ -1,32 +1,32 @@
<?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.ycl.mapper.NewsDutyDao">

    <resultMap type="com.ycl.entity.NewsDuty" id="NewsDutyMap">
        <result property="id" column="id" jdbcType="INTEGER"/>
        <result property="name" column="name" jdbcType="VARCHAR"/>
        <result property="jobTitle" column="job_title" jdbcType="VARCHAR"/>
        <result property="createTime" column="create_time" jdbcType="TIMESTAMP"/>
        <result property="dutyTime" column="duty_time" jdbcType="TIMESTAMP"/>
    </resultMap>

    <!-- 批量插入 -->
    <insert id="insertBatch" keyProperty="id" useGeneratedKeys="true">
        insert into news_website.news_duty(name, job_title, create_time, duty_time)
        values
        <foreach collection="entities" item="entity" separator=",">
        (#{entity.name}, #{entity.jobTitle}, #{entity.createTime}, #{entity.dutyTime})
        </foreach>
    </insert>
    <!-- 批量插入或按主键更新 -->
    <insert id="insertOrUpdateBatch" keyProperty="id" useGeneratedKeys="true">
        insert into news_website.news_duty(name, job_title, create_time, duty_time)
        values
        <foreach collection="entities" item="entity" separator=",">
            (#{entity.name}, #{entity.jobTitle}, #{entity.createTime}, #{entity.dutyTime})
        </foreach>
        on duplicate key update
         name = values(name) , job_title = values(job_title) , create_time = values(create_time) , duty_time = values(duty_time)     </insert>

</mapper>

<?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.ycl.dao.NewsDutyDao">



    <resultMap type="com.ycl.entity.NewsDuty" id="NewsDutyMap">

        <result property="id" column="id" jdbcType="INTEGER"/>

        <result property="name" column="name" jdbcType="VARCHAR"/>

        <result property="jobTitle" column="job_title" jdbcType="VARCHAR"/>

        <result property="createTime" column="create_time" jdbcType="TIMESTAMP"/>

        <result property="dutyTime" column="duty_time" jdbcType="TIMESTAMP"/>

    </resultMap>



    <!-- 批量插入 -->

    <insert id="insertBatch" keyProperty="id" useGeneratedKeys="true">

        insert into news_website.news_duty(name, job_title, create_time, duty_time)

        values

        <foreach collection="entities" item="entity" separator=",">

        (#{entity.name}, #{entity.jobTitle}, #{entity.createTime}, #{entity.dutyTime})

        </foreach>

    </insert>

    <!-- 批量插入或按主键更新 -->

    <insert id="insertOrUpdateBatch" keyProperty="id" useGeneratedKeys="true">

        insert into news_website.news_duty(name, job_title, create_time, duty_time)

        values

        <foreach collection="entities" item="entity" separator=",">

            (#{entity.name}, #{entity.jobTitle}, #{entity.createTime}, #{entity.dutyTime})

        </foreach>

        on duplicate key update

         name = values(name) , job_title = values(job_title) , create_time = values(create_time) , duty_time = values(duty_time)     </insert>



</mapper>




 ycl-platform/src/main/resources/mapper/NewsInformationDao.xml

@@ -1,35 +1,36 @@
<?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.ycl.mapper.NewsInformationDao">

    <resultMap type="com.ycl.entity.NewsInformation" id="NewsInformationMap">
        <result property="id" column="id" jdbcType="VARCHAR"/>
        <result property="title" column="title" jdbcType="VARCHAR"/>
        <result property="content" column="content" jdbcType="VARCHAR"/>
        <result property="publishTime" column="publish_time" jdbcType="TIMESTAMP"/>
        <result property="isSign" column="is_sign" jdbcType="INTEGER"/>
        <result property="createTime" column="create_time" jdbcType="TIMESTAMP"/>
        <result property="sendTo" column="send_to" jdbcType="VARCHAR"/>
        <result property="imageUrl" column="image_url" jdbcType="VARCHAR"/>
    </resultMap>

    <!-- 批量插入 -->
    <insert id="insertBatch" keyProperty="id" useGeneratedKeys="true">
        insert into news_website.news_information(title, content, publish_time, is_sign, create_time, send_to, image_url)
        values
        <foreach collection="entities" item="entity" separator=",">
        (#{entity.title}, #{entity.content}, #{entity.publishTime}, #{entity.isSign}, #{entity.createTime}, #{entity.sendTo}, #{entity.imageUrl})
        </foreach>
    </insert>
    <!-- 批量插入或按主键更新 -->
    <insert id="insertOrUpdateBatch" keyProperty="id" useGeneratedKeys="true">
        insert into news_website.news_information(title, content, publish_time, is_sign, create_time, send_to, image_url)
        values
        <foreach collection="entities" item="entity" separator=",">
            (#{entity.title}, #{entity.content}, #{entity.publishTime}, #{entity.isSign}, #{entity.createTime}, #{entity.sendTo}, #{entity.imageUrl})
        </foreach>
        on duplicate key update
         title = values(title) , content = values(content) , publish_time = values(publish_time) , is_sign = values(is_sign) , create_time = values(create_time) , send_to = values(send_to) , image_url = values(image_url)     </insert>

</mapper>

<?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.ycl.dao.NewsInformationDao">



    <resultMap type="com.ycl.entity.NewsInformation" id="NewsInformationMap">

        <result property="id" column="id" jdbcType="VARCHAR"/>

        <result property="title" column="title" jdbcType="VARCHAR"/>

        <result property="content" column="content" jdbcType="VARCHAR"/>

        <result property="publishTime" column="publish_time" jdbcType="TIMESTAMP"/>

        <result property="isSign" column="is_sign" jdbcType="INTEGER"/>

        <result property="createTime" column="create_time" jdbcType="TIMESTAMP"/>

        <result property="sendTo" column="send_to" jdbcType="VARCHAR"/>

        <result property="imageUrl" column="image_url" jdbcType="VARCHAR"/>

        <result property="newsDepartmentId" column="news_department_id" jdbcType="VARCHAR"/>

    </resultMap>



    <!-- 批量插入 -->

    <insert id="insertBatch" keyProperty="id" useGeneratedKeys="true">

        insert into news_website.news_information(title, content, publish_time, is_sign, create_time, send_to, image_url, news_department_id)

        values

        <foreach collection="entities" item="entity" separator=",">

        (#{entity.title}, #{entity.content}, #{entity.publishTime}, #{entity.isSign}, #{entity.createTime}, #{entity.sendTo}, #{entity.imageUrl}, #{entity.newsDepartmentId})

        </foreach>

    </insert>

    <!-- 批量插入或按主键更新 -->

    <insert id="insertOrUpdateBatch" keyProperty="id" useGeneratedKeys="true">

        insert into news_website.news_information(title, content, publish_time, is_sign, create_time, send_to, image_url, news_department_id)

        values

        <foreach collection="entities" item="entity" separator=",">

            (#{entity.title}, #{entity.content}, #{entity.publishTime}, #{entity.isSign}, #{entity.createTime}, #{entity.sendTo}, #{entity.imageUrl}, #{entity.newsDepartmentId})

        </foreach>

        on duplicate key update

         title = values(title) , content = values(content) , publish_time = values(publish_time) , is_sign = values(is_sign) , create_time = values(create_time) , send_to = values(send_to) , image_url = values(image_url) , news_department_id = values(news_department_id)     </insert>



</mapper>




 ycl-platform/src/main/resources/mapper/NewsIpDao.xml

@@ -1,30 +1,30 @@
<?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.ycl.mapper.NewsIpDao">

    <resultMap type="com.ycl.entity.NewsIp" id="NewsIpMap">
        <result property="id" column="id" jdbcType="INTEGER"/>
        <result property="ipAddess" column="ip_addess" jdbcType="VARCHAR"/>
        <result property="createTime" column="create_time" jdbcType="TIMESTAMP"/>
    </resultMap>

    <!-- 批量插入 -->
    <insert id="insertBatch" keyProperty="id" useGeneratedKeys="true">
        insert into news_website.news_ip(ip_addess, create_time)
        values
        <foreach collection="entities" item="entity" separator=",">
        (#{entity.ipAddess}, #{entity.createTime})
        </foreach>
    </insert>
    <!-- 批量插入或按主键更新 -->
    <insert id="insertOrUpdateBatch" keyProperty="id" useGeneratedKeys="true">
        insert into news_website.news_ip(ip_addess, create_time)
        values
        <foreach collection="entities" item="entity" separator=",">
            (#{entity.ipAddess}, #{entity.createTime})
        </foreach>
        on duplicate key update
         ip_addess = values(ip_addess) , create_time = values(create_time)     </insert>

</mapper>

<?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.ycl.dao.NewsIpDao">



    <resultMap type="com.ycl.entity.NewsIp" id="NewsIpMap">

        <result property="id" column="id" jdbcType="INTEGER"/>

        <result property="ipAddess" column="ip_addess" jdbcType="VARCHAR"/>

        <result property="createTime" column="create_time" jdbcType="TIMESTAMP"/>

    </resultMap>



    <!-- 批量插入 -->

    <insert id="insertBatch" keyProperty="id" useGeneratedKeys="true">

        insert into news_website.news_ip(ip_addess, create_time)

        values

        <foreach collection="entities" item="entity" separator=",">

        (#{entity.ipAddess}, #{entity.createTime})

        </foreach>

    </insert>

    <!-- 批量插入或按主键更新 -->

    <insert id="insertOrUpdateBatch" keyProperty="id" useGeneratedKeys="true">

        insert into news_website.news_ip(ip_addess, create_time)

        values

        <foreach collection="entities" item="entity" separator=",">

            (#{entity.ipAddess}, #{entity.createTime})

        </foreach>

        on duplicate key update

         ip_addess = values(ip_addess) , create_time = values(create_time)     </insert>



</mapper>




 ycl-platform/src/main/resources/mapper/NewsPoliceDao.xml

@@ -1,32 +1,32 @@
<?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.ycl.mapper.NewsPoliceDao">

    <resultMap type="com.ycl.entity.NewsPolice" id="NewsPoliceMap">
        <result property="id" column="id" jdbcType="VARCHAR"/>
        <result property="rname" column="rname" jdbcType="VARCHAR"/>
        <result property="createTime" column="create_time" jdbcType="TIMESTAMP"/>
        <result property="updateTime" column="update_time" jdbcType="TIMESTAMP"/>
        <result property="organizationName" column="organization_name" jdbcType="VARCHAR"/>
    </resultMap>

    <!-- 批量插入 -->
    <insert id="insertBatch" keyProperty="id" useGeneratedKeys="true">
        insert into news_website.news_police(rname, create_time, update_time, organization_name)
        values
        <foreach collection="entities" item="entity" separator=",">
        (#{entity.rname}, #{entity.createTime}, #{entity.updateTime}, #{entity.organizationName})
        </foreach>
    </insert>
    <!-- 批量插入或按主键更新 -->
    <insert id="insertOrUpdateBatch" keyProperty="id" useGeneratedKeys="true">
        insert into news_website.news_police(rname, create_time, update_time, organization_name)
        values
        <foreach collection="entities" item="entity" separator=",">
            (#{entity.rname}, #{entity.createTime}, #{entity.updateTime}, #{entity.organizationName})
        </foreach>
        on duplicate key update
         rname = values(rname) , create_time = values(create_time) , update_time = values(update_time) , organization_name = values(organization_name)     </insert>

</mapper>

<?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.ycl.dao.NewsPoliceDao">



    <resultMap type="com.ycl.entity.NewsPolice" id="NewsPoliceMap">

        <result property="id" column="id" jdbcType="VARCHAR"/>

        <result property="rname" column="rname" jdbcType="VARCHAR"/>

        <result property="createTime" column="create_time" jdbcType="TIMESTAMP"/>

        <result property="updateTime" column="update_time" jdbcType="TIMESTAMP"/>

        <result property="organizationName" column="organization_name" jdbcType="VARCHAR"/>

    </resultMap>



    <!-- 批量插入 -->

    <insert id="insertBatch" keyProperty="id" useGeneratedKeys="true">

        insert into news_website.news_police(rname, create_time, update_time, organization_name)

        values

        <foreach collection="entities" item="entity" separator=",">

        (#{entity.rname}, #{entity.createTime}, #{entity.updateTime}, #{entity.organizationName})

        </foreach>

    </insert>

    <!-- 批量插入或按主键更新 -->

    <insert id="insertOrUpdateBatch" keyProperty="id" useGeneratedKeys="true">

        insert into news_website.news_police(rname, create_time, update_time, organization_name)

        values

        <foreach collection="entities" item="entity" separator=",">

            (#{entity.rname}, #{entity.createTime}, #{entity.updateTime}, #{entity.organizationName})

        </foreach>

        on duplicate key update

         rname = values(rname) , create_time = values(create_time) , update_time = values(update_time) , organization_name = values(organization_name)     </insert>



</mapper>