CRM项目后端修改mapper的映射和多表联查实现将完整的线索信息提交到前端------CRM项目

已于 2024-03-01 21:29:21 修改
阅读量912 收藏 15
点赞数 21
分类专栏： CRM项目 # Spring-Boot框架 # Mybatis框架 文章标签： java mybatis spring 后端 mysql spring boot spring cloud
于 2024-02-29 23:32:23 首次发布
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://blog.csdn.net/2201_75960169/article/details/136368380
版权 
package com.alatus.service.impl;

import com.alatus.config.listener.UploadDataListener;
import com.alatus.constant.Constants;
import com.alatus.mapper.TClueMapper;
import com.alatus.model.TClue;
import com.alatus.query.BaseQuery;
import com.alatus.query.ClueQuery;
import com.alatus.service.ClueService;
import com.alatus.util.JWTUtils;
import com.alibaba.excel.EasyExcel;
import com.github.pagehelper.PageHelper;
import com.github.pagehelper.PageInfo;
import jakarta.annotation.Resource;
import org.springframework.beans.BeanUtils;
import org.springframework.stereotype.Service;

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

@Service
public class ClueServiceImpl implements ClueService {
    @Resource
    private TClueMapper tClueMapper;
    @Override
    public PageInfo<TClue> getClueByPage(Integer current) {
        // 1.设置PageHelper
        PageHelper.startPage(current, Constants.PAGE_SIZE);
        // 2.查询
        List<TClue> list = tClueMapper.selectClueByPage(BaseQuery.builder().build());
        // 3.封装分页数据到PageInfo
        PageInfo<TClue> info = new PageInfo<>(list);
        return info;
    }

    @Override
    public void importExcel(InputStream inputStream,String token) {
//        第一个参数是文件,第二个参数是excel模板类,第三个是监听器
        EasyExcel.read(inputStream,TClue.class,new UploadDataListener(tClueMapper,token)).sheet().doRead();
    }

    @Override
    public Integer deleteClue(Integer id) {
        return tClueMapper.deleteByPrimaryKey(id);
    }

    @Override
    public int delClueByIds(List<String> idsList) {
        return tClueMapper.deleteByIds(idsList);
    }

    @Override
    public Boolean checkPhone(String phone) {
        return !(tClueMapper.selectByCount(phone) > 0);
    }

    @Override
    public int saveClue(ClueQuery clueQuery) {
        TClue tClue = new TClue();
//        这个工具类的复制要求是两个对象的属性名要相同,属性要相同
        BeanUtils.copyProperties(clueQuery,tClue);
        tClue.setCreateTime(new Date());
//        通过token解析出的用户获取ID作为创建者的ID
        Integer loginId = JWTUtils.parseUserFromJWT(clueQuery.getToken()).getId();
        tClue.setCreateBy(loginId);
        return tClueMapper.insertSelective(tClue);
    }

    @Override
    public TClue getClueById(Integer id) {
        return tClueMapper.selectDetailByPrimaryKey(id);
    }

    @Override
    public int editClue(ClueQuery clueQuery) {
        TClue tClue = new TClue();
//        这个工具类的复制要求是两个对象的属性名要相同,属性要相同
        BeanUtils.copyProperties(clueQuery,tClue);
        tClue.setEditTime(new Date());
//        通过token解析出的用户获取ID作为创建者的ID
        Integer loginId = JWTUtils.parseUserFromJWT(clueQuery.getToken()).getId();
        tClue.setEditBy(loginId);
        return tClueMapper.updateByPrimaryKey(tClue);
    }
}

package com.alatus.service.impl;

import com.alatus.config.listener.UploadDataListener;
import com.alatus.constant.Constants;
import com.alatus.mapper.TClueMapper;
import com.alatus.model.TClue;
import com.alatus.query.BaseQuery;
import com.alatus.query.ClueQuery;
import com.alatus.service.ClueService;
import com.alatus.util.JWTUtils;
import com.alibaba.excel.EasyExcel;
import com.github.pagehelper.PageHelper;
import com.github.pagehelper.PageInfo;
import jakarta.annotation.Resource;
import org.springframework.beans.BeanUtils;
import org.springframework.stereotype.Service;

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

@Service
public class ClueServiceImpl implements ClueService {
    @Resource
    private TClueMapper tClueMapper;
    @Override
    public PageInfo<TClue> getClueByPage(Integer current) {
        // 1.设置PageHelper
        PageHelper.startPage(current, Constants.PAGE_SIZE);
        // 2.查询
        List<TClue> list = tClueMapper.selectClueByPage(BaseQuery.builder().build());
        // 3.封装分页数据到PageInfo
        PageInfo<TClue> info = new PageInfo<>(list);
        return info;
    }

    @Override
    public void importExcel(InputStream inputStream,String token) {
//        第一个参数是文件,第二个参数是excel模板类,第三个是监听器
        EasyExcel.read(inputStream,TClue.class,new UploadDataListener(tClueMapper,token)).sheet().doRead();
    }

    @Override
    public Integer deleteClue(Integer id) {
        return tClueMapper.deleteByPrimaryKey(id);
    }

    @Override
    public int delClueByIds(List<String> idsList) {
        return tClueMapper.deleteByIds(idsList);
    }

    @Override
    public Boolean checkPhone(String phone) {
        return !(tClueMapper.selectByCount(phone) > 0);
    }

    @Override
    public int saveClue(ClueQuery clueQuery) {
        TClue tClue = new TClue();
//        这个工具类的复制要求是两个对象的属性名要相同,属性要相同
        BeanUtils.copyProperties(clueQuery,tClue);
        tClue.setCreateTime(new Date());
//        通过token解析出的用户获取ID作为创建者的ID
        Integer loginId = JWTUtils.parseUserFromJWT(clueQuery.getToken()).getId();
        tClue.setCreateBy(loginId);
        return tClueMapper.insertSelective(tClue);
    }

    @Override
    public TClue getClueById(Integer id) {
        return tClueMapper.selectDetailByPrimaryKey(id);
    }

    @Override
    public int editClue(ClueQuery clueQuery) {
        TClue tClue = new TClue();
//        这个工具类的复制要求是两个对象的属性名要相同,属性要相同
        BeanUtils.copyProperties(clueQuery,tClue);
        tClue.setEditTime(new Date());
//        通过token解析出的用户获取ID作为创建者的ID
        Integer loginId = JWTUtils.parseUserFromJWT(clueQuery.getToken()).getId();
        tClue.setEditBy(loginId);
        return tClueMapper.updateByPrimaryKey(tClue);
    }
}

package com.alatus.mapper;

import com.alatus.model.TClue;
import com.alatus.query.BaseQuery;

import java.util.List;

public interface TClueMapper {
    int deleteByPrimaryKey(Integer id);

    int insert(TClue record);

    int insertSelective(TClue record);

    TClue selectByPrimaryKey(Integer id);

    int updateByPrimaryKeySelective(TClue record);

    int updateByPrimaryKey(TClue record);

    List<TClue> selectClueByPage(BaseQuery build);

    void saveClue(List<TClue> tClueList);

    int deleteByIds(List<String> idsList);

    int selectByCount(String phone);

    TClue selectDetailByPrimaryKey(Integer id);
}
package com.alatus.mapper;

import com.alatus.model.TClue;
import com.alatus.query.BaseQuery;

import java.util.List;

public interface TClueMapper {
    int deleteByPrimaryKey(Integer id);

    int insert(TClue record);

    int insertSelective(TClue record);

    TClue selectByPrimaryKey(Integer id);

    int updateByPrimaryKeySelective(TClue record);

    int updateByPrimaryKey(TClue record);

    List<TClue> selectClueByPage(BaseQuery build);

    void saveClue(List<TClue> tClueList);

    int deleteByIds(List<String> idsList);

    int selectByCount(String phone);

    TClue selectDetailByPrimaryKey(Integer id);
}
<?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.alatus.mapper.TClueMapper">
  <resultMap id="BaseResultMap" type="com.alatus.model.TClue">
    <id column="id" jdbcType="INTEGER" property="id" />
    <result column="owner_id" jdbcType="INTEGER" property="ownerId" />
    <result column="activity_id" jdbcType="INTEGER" property="activityId" />
    <result column="full_name" jdbcType="VARCHAR" property="fullName" />
    <result column="appellation" jdbcType="INTEGER" property="appellation" />
    <result column="phone" jdbcType="VARCHAR" property="phone" />
    <result column="weixin" jdbcType="VARCHAR" property="weixin" />
    <result column="qq" jdbcType="VARCHAR" property="qq" />
    <result column="email" jdbcType="VARCHAR" property="email" />
    <result column="age" jdbcType="INTEGER" property="age" />
    <result column="job" jdbcType="VARCHAR" property="job" />
    <result column="year_income" jdbcType="DECIMAL" property="yearIncome" />
    <result column="address" jdbcType="VARCHAR" property="address" />
    <result column="need_loan" jdbcType="INTEGER" property="needLoan" />
    <result column="intention_state" jdbcType="INTEGER" property="intentionState" />
    <result column="intention_product" jdbcType="INTEGER" property="intentionProduct" />
    <result column="state" jdbcType="INTEGER" property="state" />
    <result column="source" jdbcType="INTEGER" property="source" />
    <result column="description" jdbcType="VARCHAR" property="description" />
    <result column="next_contact_time" jdbcType="TIMESTAMP" property="nextContactTime" />
    <result column="create_time" jdbcType="TIMESTAMP" property="createTime" />
    <result column="create_by" jdbcType="INTEGER" property="createBy" />
    <result column="edit_time" jdbcType="TIMESTAMP" property="editTime" />
    <result column="edit_by" jdbcType="INTEGER" property="editBy" />
  </resultMap>

  <resultMap id="ClueResultMap" type="com.alatus.model.TClue">
    <id column="id" jdbcType="INTEGER" property="id" />
    <result column="owner_id" jdbcType="INTEGER" property="ownerId" />
    <result column="activity_id" jdbcType="INTEGER" property="activityId" />
    <result column="full_name" jdbcType="VARCHAR" property="fullName" />
    <result column="appellation" jdbcType="INTEGER" property="appellation" />
    <result column="phone" jdbcType="VARCHAR" property="phone" />
    <result column="weixin" jdbcType="VARCHAR" property="weixin" />
    <result column="qq" jdbcType="VARCHAR" property="qq" />
    <result column="email" jdbcType="VARCHAR" property="email" />
    <result column="age" jdbcType="INTEGER" property="age" />
    <result column="job" jdbcType="VARCHAR" property="job" />
    <result column="year_income" jdbcType="DECIMAL" property="yearIncome" />
    <result column="address" jdbcType="VARCHAR" property="address" />
    <result column="need_loan" jdbcType="INTEGER" property="needLoan" />
    <result column="intention_state" jdbcType="INTEGER" property="intentionState" />
    <result column="intention_product" jdbcType="INTEGER" property="intentionProduct" />
    <result column="state" jdbcType="INTEGER" property="state" />
    <result column="source" jdbcType="INTEGER" property="source" />
    <result column="description" jdbcType="VARCHAR" property="description" />
    <result column="next_contact_time" jdbcType="TIMESTAMP" property="nextContactTime" />
    <result column="create_time" jdbcType="TIMESTAMP" property="createTime" />
    <result column="create_by" jdbcType="INTEGER" property="createBy" />
    <result column="edit_time" jdbcType="TIMESTAMP" property="editTime" />
    <result column="edit_by" jdbcType="INTEGER" property="editBy" />
    <!--一对一关联查询的映射-->
    <association property="ownerDO" javaType="com.alatus.model.TUser">
      <id column="ownerId" jdbcType="INTEGER" property="id" />
      <result column="ownerName" jdbcType="VARCHAR" property="name" />
    </association>
    <!--一对一关联查询的映射-->
    <association property="activityDO" javaType="com.alatus.model.TActivity">
      <id column="activityId" jdbcType="INTEGER" property="id" />
      <result column="activityName" jdbcType="VARCHAR" property="name" />
    </association>
    <!--一对一关联查询的映射-->
    <association property="appellationDO" javaType="com.alatus.model.TDicValue">
      <id column="appellationId" jdbcType="INTEGER" property="id" />
      <result column="appellationName" jdbcType="VARCHAR" property="typeValue" />
    </association>
    <!--一对一关联查询的映射-->
    <association property="needLoanDO" javaType="com.alatus.model.TDicValue">
      <id column="needLoanId" jdbcType="INTEGER" property="id" />
      <result column="needLoanName" jdbcType="VARCHAR" property="typeValue" />
    </association>
    <!--一对一关联查询的映射-->
    <association property="intentionStateDO" javaType="com.alatus.model.TDicValue">
      <id column="intentionStateId" jdbcType="INTEGER" property="id" />
      <result column="intentionStateName" jdbcType="VARCHAR" property="typeValue" />
    </association>
    <!--一对一关联查询的映射-->
    <association property="intentionProductDO" javaType="com.alatus.model.TProduct">
      <id column="intentionProductId" jdbcType="INTEGER" property="id" />
      <result column="intentionProductName" jdbcType="VARCHAR" property="name" />
    </association>
    <!--一对一关联查询的映射-->
    <association property="stateDO" javaType="com.alatus.model.TDicValue">
      <id column="stateId" jdbcType="INTEGER" property="id" />
      <result column="stateName" jdbcType="VARCHAR" property="typeValue" />
    </association>
    <!--一对一关联查询的映射-->
    <association property="sourceDO" javaType="com.alatus.model.TDicValue">
      <id column="sourceId" jdbcType="INTEGER" property="id" />
      <result column="sourceName" jdbcType="VARCHAR" property="typeValue" />
    </association>
  </resultMap>


  <sql id="Base_Column_List">
    id, owner_id, activity_id, full_name, appellation, phone, weixin, qq, email, age, 
    job, year_income, address, need_loan, intention_state, intention_product, `state`, 
    `source`, description, next_contact_time, create_time, create_by, edit_time, edit_by
  </sql>
  <select id="selectByPrimaryKey" parameterType="java.lang.Integer" resultMap="BaseResultMap">
    select 
    <include refid="Base_Column_List" />
    from t_clue
    where id = #{id,jdbcType=INTEGER}
  </select>

  <select id="selectClueByPage" parameterType="java.lang.Integer" resultMap="ClueResultMap">
    select
      tc.*,
      tu1.id ownerId, tu1.name ownerName,
      ta.id activityId, ta.name activityName,
      tdv.id appellationId, tdv.type_value appellationName,
      tdv2.id needLoanId, tdv2.type_value needLoanName,
      tdv3.id intentionStateId, tdv3.type_value intentionStateName,
      tp.id intentionProductId,  tp.name intentionProductName,
      tdv4.id stateId, tdv4.type_value stateName,
      tdv5.id sourceId, tdv5.type_value sourceName
    from t_clue tc left join t_user tu1 on tc.owner_id = tu1.id
                   left join t_activity ta on tc.activity_id = ta.id
                   left join t_dic_value tdv on tc.appellation = tdv.id

                   left join t_dic_value tdv2 on tc.need_loan = tdv2.id
                   left join t_dic_value tdv3 on tc.intention_state = tdv3.id

                   left join t_product tp on tc.intention_product = tp.id

                   left join t_dic_value tdv4 on tc.state = tdv4.id
                   left join t_dic_value tdv5 on tc.source = tdv5.id
  </select>



    <select id="selectByCount" parameterType="java.lang.String" resultType="java.lang.Integer">
      select
        count(0)
      from t_clue
      where phone = #{phone,jdbcType=VARCHAR}
    </select>


  <select id="selectDetailByPrimaryKey" parameterType="java.lang.Integer" resultMap="ClueResultMap">
    select
      tc.*,
      tu1.id ownerId, tu1.name ownerName,
      ta.id activityId, ta.name activityName,
      tdv.id appellationId, tdv.type_value appellationName,
      tdv2.id needLoanId, tdv2.type_value needLoanName,
      tdv3.id intentionStateId, tdv3.type_value intentionStateName,
      tp.id intentionProductId,  tp.name intentionProductName,
      tdv4.id stateId, tdv4.type_value stateName,
      tdv5.id sourceId, tdv5.type_value sourceName
    from t_clue tc left join t_user tu1 on tc.owner_id = tu1.id
                   left join t_activity ta on tc.activity_id = ta.id
                   left join t_dic_value tdv on tc.appellation = tdv.id

                   left join t_dic_value tdv2 on tc.need_loan = tdv2.id
                   left join t_dic_value tdv3 on tc.intention_state = tdv3.id

                   left join t_product tp on tc.intention_product = tp.id

                   left join t_dic_value tdv4 on tc.state = tdv4.id
                   left join t_dic_value tdv5 on tc.source = tdv5.id
    where tc.id = #{id,jdbcType=INTEGER}
  </select>



  <delete id="deleteByPrimaryKey" parameterType="java.lang.Integer">
    delete from t_clue
    where id = #{id,jdbcType=INTEGER}
  </delete>


  <delete id="deleteByIds" parameterType="java.util.List">
    delete from t_clue
    where id in
    <foreach collection="idsList" item="id" open="(" close=")" separator=",">
      #{id,jdbcType=INTEGER}
    </foreach>
  </delete>


    <insert id="insert" keyColumn="id" keyProperty="id" parameterType="com.alatus.model.TClue" useGeneratedKeys="true">
    insert into t_clue (owner_id, activity_id, full_name, 
      appellation, phone, weixin, 
      qq, email, age, job, 
      year_income, address, need_loan, 
      intention_state, intention_product, `state`, 
      `source`, description, next_contact_time, 
      create_time, create_by, edit_time, 
      edit_by)
    values (#{ownerId,jdbcType=INTEGER}, #{activityId,jdbcType=INTEGER}, #{fullName,jdbcType=VARCHAR}, 
      #{appellation,jdbcType=INTEGER}, #{phone,jdbcType=VARCHAR}, #{weixin,jdbcType=VARCHAR}, 
      #{qq,jdbcType=VARCHAR}, #{email,jdbcType=VARCHAR}, #{age,jdbcType=INTEGER}, #{job,jdbcType=VARCHAR}, 
      #{yearIncome,jdbcType=DECIMAL}, #{address,jdbcType=VARCHAR}, #{needLoan,jdbcType=INTEGER}, 
      #{intentionState,jdbcType=INTEGER}, #{intentionProduct,jdbcType=INTEGER}, #{state,jdbcType=INTEGER}, 
      #{source,jdbcType=INTEGER}, #{description,jdbcType=VARCHAR}, #{nextContactTime,jdbcType=TIMESTAMP}, 
      #{createTime,jdbcType=TIMESTAMP}, #{createBy,jdbcType=INTEGER}, #{editTime,jdbcType=TIMESTAMP}, 
      #{editBy,jdbcType=INTEGER})
  </insert>
  <insert id="insertSelective" keyColumn="id" keyProperty="id" parameterType="com.alatus.model.TClue" useGeneratedKeys="true">
    insert into t_clue
    <trim prefix="(" suffix=")" suffixOverrides=",">
      <if test="ownerId != null">
        owner_id,
      </if>
      <if test="activityId != null">
        activity_id,
      </if>
      <if test="fullName != null">
        full_name,
      </if>
      <if test="appellation != null">
        appellation,
      </if>
      <if test="phone != null">
        phone,
      </if>
      <if test="weixin != null">
        weixin,
      </if>
      <if test="qq != null">
        qq,
      </if>
      <if test="email != null">
        email,
      </if>
      <if test="age != null">
        age,
      </if>
      <if test="job != null">
        job,
      </if>
      <if test="yearIncome != null">
        year_income,
      </if>
      <if test="address != null">
        address,
      </if>
      <if test="needLoan != null">
        need_loan,
      </if>
      <if test="intentionState != null">
        intention_state,
      </if>
      <if test="intentionProduct != null">
        intention_product,
      </if>
      <if test="state != null">
        `state`,
      </if>
      <if test="source != null">
        `source`,
      </if>
      <if test="description != null">
        description,
      </if>
      <if test="nextContactTime != null">
        next_contact_time,
      </if>
      <if test="createTime != null">
        create_time,
      </if>
      <if test="createBy != null">
        create_by,
      </if>
      <if test="editTime != null">
        edit_time,
      </if>
      <if test="editBy != null">
        edit_by,
      </if>
    </trim>
    <trim prefix="values (" suffix=")" suffixOverrides=",">
      <if test="ownerId != null">
        #{ownerId,jdbcType=INTEGER},
      </if>
      <if test="activityId != null">
        #{activityId,jdbcType=INTEGER},
      </if>
      <if test="fullName != null">
        #{fullName,jdbcType=VARCHAR},
      </if>
      <if test="appellation != null">
        #{appellation,jdbcType=INTEGER},
      </if>
      <if test="phone != null">
        #{phone,jdbcType=VARCHAR},
      </if>
      <if test="weixin != null">
        #{weixin,jdbcType=VARCHAR},
      </if>
      <if test="qq != null">
        #{qq,jdbcType=VARCHAR},
      </if>
      <if test="email != null">
        #{email,jdbcType=VARCHAR},
      </if>
      <if test="age != null">
        #{age,jdbcType=INTEGER},
      </if>
      <if test="job != null">
        #{job,jdbcType=VARCHAR},
      </if>
      <if test="yearIncome != null">
        #{yearIncome,jdbcType=DECIMAL},
      </if>
      <if test="address != null">
        #{address,jdbcType=VARCHAR},
      </if>
      <if test="needLoan != null">
        #{needLoan,jdbcType=INTEGER},
      </if>
      <if test="intentionState != null">
        #{intentionState,jdbcType=INTEGER},
      </if>
      <if test="intentionProduct != null">
        #{intentionProduct,jdbcType=INTEGER},
      </if>
      <if test="state != null">
        #{state,jdbcType=INTEGER},
      </if>
      <if test="source != null">
        #{source,jdbcType=INTEGER},
      </if>
      <if test="description != null">
        #{description,jdbcType=VARCHAR},
      </if>
      <if test="nextContactTime != null">
        #{nextContactTime,jdbcType=TIMESTAMP},
      </if>
      <if test="createTime != null">
        #{createTime,jdbcType=TIMESTAMP},
      </if>
      <if test="createBy != null">
        #{createBy,jdbcType=INTEGER},
      </if>
      <if test="editTime != null">
        #{editTime,jdbcType=TIMESTAMP},
      </if>
      <if test="editBy != null">
        #{editBy,jdbcType=INTEGER},
      </if>
    </trim>
  </insert>


  <!--批量保存-->
  <insert id="saveClue" keyColumn="id" keyProperty="id" parameterType="com.alatus.model.TClue" useGeneratedKeys="true">
    insert into t_clue(`owner_id`, `activity_id`, `full_name`,
    `appellation`, `phone`, `weixin`,
    `qq`, `email`, `age`, `job`,
    `year_income`, `address`, `need_loan`,
    `intention_state`, `intention_product`, `state`,
    `source`, `description`, `next_contact_time`,
    `create_time`, `create_by`, `edit_time`,
    edit_by)
    values
      <foreach collection="tClueList" item="tClue"  separator="," >
        (#{tClue.ownerId,jdbcType=INTEGER}, #{tClue.activityId,jdbcType=INTEGER}, #{tClue.fullName,jdbcType=VARCHAR},
        #{tClue.appellation,jdbcType=INTEGER}, #{tClue.phone,jdbcType=VARCHAR}, #{tClue.weixin,jdbcType=VARCHAR},
        #{tClue.qq,jdbcType=VARCHAR}, #{tClue.email,jdbcType=VARCHAR}, #{tClue.age,jdbcType=INTEGER}, #{tClue.job,jdbcType=VARCHAR},
        #{tClue.yearIncome,jdbcType=DECIMAL}, #{tClue.address,jdbcType=VARCHAR}, #{tClue.needLoan,jdbcType=INTEGER},
        #{tClue.intentionState,jdbcType=INTEGER}, #{tClue.intentionProduct,jdbcType=INTEGER}, #{tClue.state,jdbcType=INTEGER},
        #{tClue.source,jdbcType=INTEGER}, #{tClue.description,jdbcType=VARCHAR}, #{tClue.nextContactTime,jdbcType=TIMESTAMP},
        #{tClue.createTime,jdbcType=TIMESTAMP}, #{tClue.createBy,jdbcType=INTEGER}, #{tClue.editTime,jdbcType=TIMESTAMP},
        #{tClue.editBy,jdbcType=INTEGER})
      </foreach>
  </insert>
  
  
  
    <update id="updateByPrimaryKeySelective" parameterType="com.alatus.model.TClue">
    update t_clue
    <set>
      <if test="ownerId != null">
        owner_id = #{ownerId,jdbcType=INTEGER},
      </if>
      <if test="activityId != null">
        activity_id = #{activityId,jdbcType=INTEGER},
      </if>
      <if test="fullName != null">
        full_name = #{fullName,jdbcType=VARCHAR},
      </if>
      <if test="appellation != null">
        appellation = #{appellation,jdbcType=INTEGER},
      </if>
      <if test="phone != null">
        phone = #{phone,jdbcType=VARCHAR},
      </if>
      <if test="weixin != null">
        weixin = #{weixin,jdbcType=VARCHAR},
      </if>
      <if test="qq != null">
        qq = #{qq,jdbcType=VARCHAR},
      </if>
      <if test="email != null">
        email = #{email,jdbcType=VARCHAR},
      </if>
      <if test="age != null">
        age = #{age,jdbcType=INTEGER},
      </if>
      <if test="job != null">
        job = #{job,jdbcType=VARCHAR},
      </if>
      <if test="yearIncome != null">
        year_income = #{yearIncome,jdbcType=DECIMAL},
      </if>
      <if test="address != null">
        address = #{address,jdbcType=VARCHAR},
      </if>
      <if test="needLoan != null">
        need_loan = #{needLoan,jdbcType=INTEGER},
      </if>
      <if test="intentionState != null">
        intention_state = #{intentionState,jdbcType=INTEGER},
      </if>
      <if test="intentionProduct != null">
        intention_product = #{intentionProduct,jdbcType=INTEGER},
      </if>
      <if test="state != null">
        `state` = #{state,jdbcType=INTEGER},
      </if>
      <if test="source != null">
        `source` = #{source,jdbcType=INTEGER},
      </if>
      <if test="description != null">
        description = #{description,jdbcType=VARCHAR},
      </if>
      <if test="nextContactTime != null">
        next_contact_time = #{nextContactTime,jdbcType=TIMESTAMP},
      </if>
      <if test="createTime != null">
        create_time = #{createTime,jdbcType=TIMESTAMP},
      </if>
      <if test="createBy != null">
        create_by = #{createBy,jdbcType=INTEGER},
      </if>
      <if test="editTime != null">
        edit_time = #{editTime,jdbcType=TIMESTAMP},
      </if>
      <if test="editBy != null">
        edit_by = #{editBy,jdbcType=INTEGER},
      </if>
    </set>
    where id = #{id,jdbcType=INTEGER}
  </update>
  <update id="updateByPrimaryKey" parameterType="com.alatus.model.TClue">
    update t_clue
    set owner_id = #{ownerId,jdbcType=INTEGER},
      activity_id = #{activityId,jdbcType=INTEGER},
      full_name = #{fullName,jdbcType=VARCHAR},
      appellation = #{appellation,jdbcType=INTEGER},
      phone = #{phone,jdbcType=VARCHAR},
      weixin = #{weixin,jdbcType=VARCHAR},
      qq = #{qq,jdbcType=VARCHAR},
      email = #{email,jdbcType=VARCHAR},
      age = #{age,jdbcType=INTEGER},
      job = #{job,jdbcType=VARCHAR},
      year_income = #{yearIncome,jdbcType=DECIMAL},
      address = #{address,jdbcType=VARCHAR},
      need_loan = #{needLoan,jdbcType=INTEGER},
      intention_state = #{intentionState,jdbcType=INTEGER},
      intention_product = #{intentionProduct,jdbcType=INTEGER},
      `state` = #{state,jdbcType=INTEGER},
      `source` = #{source,jdbcType=INTEGER},
      description = #{description,jdbcType=VARCHAR},
      next_contact_time = #{nextContactTime,jdbcType=TIMESTAMP},
      create_time = #{createTime,jdbcType=TIMESTAMP},
      create_by = #{createBy,jdbcType=INTEGER},
      edit_time = #{editTime,jdbcType=TIMESTAMP},
      edit_by = #{editBy,jdbcType=INTEGER}
    where id = #{id,jdbcType=INTEGER}
  </update>
</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.alatus.mapper.TClueMapper">
  <resultMap id="BaseResultMap" type="com.alatus.model.TClue">
    <id column="id" jdbcType="INTEGER" property="id" />
    <result column="owner_id" jdbcType="INTEGER" property="ownerId" />
    <result column="activity_id" jdbcType="INTEGER" property="activityId" />
    <result column="full_name" jdbcType="VARCHAR" property="fullName" />
    <result column="appellation" jdbcType="INTEGER" property="appellation" />
    <result column="phone" jdbcType="VARCHAR" property="phone" />
    <result column="weixin" jdbcType="VARCHAR" property="weixin" />
    <result column="qq" jdbcType="VARCHAR" property="qq" />
    <result column="email" jdbcType="VARCHAR" property="email" />
    <result column="age" jdbcType="INTEGER" property="age" />
    <result column="job" jdbcType="VARCHAR" property="job" />
    <result column="year_income" jdbcType="DECIMAL" property="yearIncome" />
    <result column="address" jdbcType="VARCHAR" property="address" />
    <result column="need_loan" jdbcType="INTEGER" property="needLoan" />
    <result column="intention_state" jdbcType="INTEGER" property="intentionState" />
    <result column="intention_product" jdbcType="INTEGER" property="intentionProduct" />
    <result column="state" jdbcType="INTEGER" property="state" />
    <result column="source" jdbcType="INTEGER" property="source" />
    <result column="description" jdbcType="VARCHAR" property="description" />
    <result column="next_contact_time" jdbcType="TIMESTAMP" property="nextContactTime" />
    <result column="create_time" jdbcType="TIMESTAMP" property="createTime" />
    <result column="create_by" jdbcType="INTEGER" property="createBy" />
    <result column="edit_time" jdbcType="TIMESTAMP" property="editTime" />
    <result column="edit_by" jdbcType="INTEGER" property="editBy" />
  </resultMap>

  <resultMap id="ClueResultMap" type="com.alatus.model.TClue">
    <id column="id" jdbcType="INTEGER" property="id" />
    <result column="owner_id" jdbcType="INTEGER" property="ownerId" />
    <result column="activity_id" jdbcType="INTEGER" property="activityId" />
    <result column="full_name" jdbcType="VARCHAR" property="fullName" />
    <result column="appellation" jdbcType="INTEGER" property="appellation" />
    <result column="phone" jdbcType="VARCHAR" property="phone" />
    <result column="weixin" jdbcType="VARCHAR" property="weixin" />
    <result column="qq" jdbcType="VARCHAR" property="qq" />
    <result column="email" jdbcType="VARCHAR" property="email" />
    <result column="age" jdbcType="INTEGER" property="age" />
    <result column="job" jdbcType="VARCHAR" property="job" />
    <result column="year_income" jdbcType="DECIMAL" property="yearIncome" />
    <result column="address" jdbcType="VARCHAR" property="address" />
    <result column="need_loan" jdbcType="INTEGER" property="needLoan" />
    <result column="intention_state" jdbcType="INTEGER" property="intentionState" />
    <result column="intention_product" jdbcType="INTEGER" property="intentionProduct" />
    <result column="state" jdbcType="INTEGER" property="state" />
    <result column="source" jdbcType="INTEGER" property="source" />
    <result column="description" jdbcType="VARCHAR" property="description" />
    <result column="next_contact_time" jdbcType="TIMESTAMP" property="nextContactTime" />
    <result column="create_time" jdbcType="TIMESTAMP" property="createTime" />
    <result column="create_by" jdbcType="INTEGER" property="createBy" />
    <result column="edit_time" jdbcType="TIMESTAMP" property="editTime" />
    <result column="edit_by" jdbcType="INTEGER" property="editBy" />
    <!--一对一关联查询的映射-->
    <association property="ownerDO" javaType="com.alatus.model.TUser">
      <id column="ownerId" jdbcType="INTEGER" property="id" />
      <result column="ownerName" jdbcType="VARCHAR" property="name" />
    </association>
    <!--一对一关联查询的映射-->
    <association property="activityDO" javaType="com.alatus.model.TActivity">
      <id column="activityId" jdbcType="INTEGER" property="id" />
      <result column="activityName" jdbcType="VARCHAR" property="name" />
    </association>
    <!--一对一关联查询的映射-->
    <association property="appellationDO" javaType="com.alatus.model.TDicValue">
      <id column="appellationId" jdbcType="INTEGER" property="id" />
      <result column="appellationName" jdbcType="VARCHAR" property="typeValue" />
    </association>
    <!--一对一关联查询的映射-->
    <association property="needLoanDO" javaType="com.alatus.model.TDicValue">
      <id column="needLoanId" jdbcType="INTEGER" property="id" />
      <result column="needLoanName" jdbcType="VARCHAR" property="typeValue" />
    </association>
    <!--一对一关联查询的映射-->
    <association property="intentionStateDO" javaType="com.alatus.model.TDicValue">
      <id column="intentionStateId" jdbcType="INTEGER" property="id" />
      <result column="intentionStateName" jdbcType="VARCHAR" property="typeValue" />
    </association>
    <!--一对一关联查询的映射-->
    <association property="intentionProductDO" javaType="com.alatus.model.TProduct">
      <id column="intentionProductId" jdbcType="INTEGER" property="id" />
      <result column="intentionProductName" jdbcType="VARCHAR" property="name" />
    </association>
    <!--一对一关联查询的映射-->
    <association property="stateDO" javaType="com.alatus.model.TDicValue">
      <id column="stateId" jdbcType="INTEGER" property="id" />
      <result column="stateName" jdbcType="VARCHAR" property="typeValue" />
    </association>
    <!--一对一关联查询的映射-->
    <association property="sourceDO" javaType="com.alatus.model.TDicValue">
      <id column="sourceId" jdbcType="INTEGER" property="id" />
      <result column="sourceName" jdbcType="VARCHAR" property="typeValue" />
    </association>
  </resultMap>


  <sql id="Base_Column_List">
    id, owner_id, activity_id, full_name, appellation, phone, weixin, qq, email, age, 
    job, year_income, address, need_loan, intention_state, intention_product, `state`, 
    `source`, description, next_contact_time, create_time, create_by, edit_time, edit_by
  </sql>
  <select id="selectByPrimaryKey" parameterType="java.lang.Integer" resultMap="BaseResultMap">
    select 
    <include refid="Base_Column_List" />
    from t_clue
    where id = #{id,jdbcType=INTEGER}
  </select>

  <select id="selectClueByPage" parameterType="java.lang.Integer" resultMap="ClueResultMap">
    select
      tc.*,
      tu1.id ownerId, tu1.name ownerName,
      ta.id activityId, ta.name activityName,
      tdv.id appellationId, tdv.type_value appellationName,
      tdv2.id needLoanId, tdv2.type_value needLoanName,
      tdv3.id intentionStateId, tdv3.type_value intentionStateName,
      tp.id intentionProductId,  tp.name intentionProductName,
      tdv4.id stateId, tdv4.type_value stateName,
      tdv5.id sourceId, tdv5.type_value sourceName
    from t_clue tc left join t_user tu1 on tc.owner_id = tu1.id
                   left join t_activity ta on tc.activity_id = ta.id
                   left join t_dic_value tdv on tc.appellation = tdv.id

                   left join t_dic_value tdv2 on tc.need_loan = tdv2.id
                   left join t_dic_value tdv3 on tc.intention_state = tdv3.id

                   left join t_product tp on tc.intention_product = tp.id

                   left join t_dic_value tdv4 on tc.state = tdv4.id
                   left join t_dic_value tdv5 on tc.source = tdv5.id
  </select>



    <select id="selectByCount" parameterType="java.lang.String" resultType="java.lang.Integer">
      select
        count(0)
      from t_clue
      where phone = #{phone,jdbcType=VARCHAR}
    </select>


  <select id="selectDetailByPrimaryKey" parameterType="java.lang.Integer" resultMap="ClueResultMap">
    select
      tc.*,
      tu1.id ownerId, tu1.name ownerName,
      ta.id activityId, ta.name activityName,
      tdv.id appellationId, tdv.type_value appellationName,
      tdv2.id needLoanId, tdv2.type_value needLoanName,
      tdv3.id intentionStateId, tdv3.type_value intentionStateName,
      tp.id intentionProductId,  tp.name intentionProductName,
      tdv4.id stateId, tdv4.type_value stateName,
      tdv5.id sourceId, tdv5.type_value sourceName
    from t_clue tc left join t_user tu1 on tc.owner_id = tu1.id
                   left join t_activity ta on tc.activity_id = ta.id
                   left join t_dic_value tdv on tc.appellation = tdv.id

                   left join t_dic_value tdv2 on tc.need_loan = tdv2.id
                   left join t_dic_value tdv3 on tc.intention_state = tdv3.id

                   left join t_product tp on tc.intention_product = tp.id

                   left join t_dic_value tdv4 on tc.state = tdv4.id
                   left join t_dic_value tdv5 on tc.source = tdv5.id
    where tc.id = #{id,jdbcType=INTEGER}
  </select>



  <delete id="deleteByPrimaryKey" parameterType="java.lang.Integer">
    delete from t_clue
    where id = #{id,jdbcType=INTEGER}
  </delete>


  <delete id="deleteByIds" parameterType="java.util.List">
    delete from t_clue
    where id in
    <foreach collection="idsList" item="id" open="(" close=")" separator=",">
      #{id,jdbcType=INTEGER}
    </foreach>
  </delete>


    <insert id="insert" keyColumn="id" keyProperty="id" parameterType="com.alatus.model.TClue" useGeneratedKeys="true">
    insert into t_clue (owner_id, activity_id, full_name, 
      appellation, phone, weixin, 
      qq, email, age, job, 
      year_income, address, need_loan, 
      intention_state, intention_product, `state`, 
      `source`, description, next_contact_time, 
      create_time, create_by, edit_time, 
      edit_by)
    values (#{ownerId,jdbcType=INTEGER}, #{activityId,jdbcType=INTEGER}, #{fullName,jdbcType=VARCHAR}, 
      #{appellation,jdbcType=INTEGER}, #{phone,jdbcType=VARCHAR}, #{weixin,jdbcType=VARCHAR}, 
      #{qq,jdbcType=VARCHAR}, #{email,jdbcType=VARCHAR}, #{age,jdbcType=INTEGER}, #{job,jdbcType=VARCHAR}, 
      #{yearIncome,jdbcType=DECIMAL}, #{address,jdbcType=VARCHAR}, #{needLoan,jdbcType=INTEGER}, 
      #{intentionState,jdbcType=INTEGER}, #{intentionProduct,jdbcType=INTEGER}, #{state,jdbcType=INTEGER}, 
      #{source,jdbcType=INTEGER}, #{description,jdbcType=VARCHAR}, #{nextContactTime,jdbcType=TIMESTAMP}, 
      #{createTime,jdbcType=TIMESTAMP}, #{createBy,jdbcType=INTEGER}, #{editTime,jdbcType=TIMESTAMP}, 
      #{editBy,jdbcType=INTEGER})
  </insert>
  <insert id="insertSelective" keyColumn="id" keyProperty="id" parameterType="com.alatus.model.TClue" useGeneratedKeys="true">
    insert into t_clue
    <trim prefix="(" suffix=")" suffixOverrides=",">
      <if test="ownerId != null">
        owner_id,
      </if>
      <if test="activityId != null">
        activity_id,
      </if>
      <if test="fullName != null">
        full_name,
      </if>
      <if test="appellation != null">
        appellation,
      </if>
      <if test="phone != null">
        phone,
      </if>
      <if test="weixin != null">
        weixin,
      </if>
      <if test="qq != null">
        qq,
      </if>
      <if test="email != null">
        email,
      </if>
      <if test="age != null">
        age,
      </if>
      <if test="job != null">
        job,
      </if>
      <if test="yearIncome != null">
        year_income,
      </if>
      <if test="address != null">
        address,
      </if>
      <if test="needLoan != null">
        need_loan,
      </if>
      <if test="intentionState != null">
        intention_state,
      </if>
      <if test="intentionProduct != null">
        intention_product,
      </if>
      <if test="state != null">
        `state`,
      </if>
      <if test="source != null">
        `source`,
      </if>
      <if test="description != null">
        description,
      </if>
      <if test="nextContactTime != null">
        next_contact_time,
      </if>
      <if test="createTime != null">
        create_time,
      </if>
      <if test="createBy != null">
        create_by,
      </if>
      <if test="editTime != null">
        edit_time,
      </if>
      <if test="editBy != null">
        edit_by,
      </if>
    </trim>
    <trim prefix="values (" suffix=")" suffixOverrides=",">
      <if test="ownerId != null">
        #{ownerId,jdbcType=INTEGER},
      </if>
      <if test="activityId != null">
        #{activityId,jdbcType=INTEGER},
      </if>
      <if test="fullName != null">
        #{fullName,jdbcType=VARCHAR},
      </if>
      <if test="appellation != null">
        #{appellation,jdbcType=INTEGER},
      </if>
      <if test="phone != null">
        #{phone,jdbcType=VARCHAR},
      </if>
      <if test="weixin != null">
        #{weixin,jdbcType=VARCHAR},
      </if>
      <if test="qq != null">
        #{qq,jdbcType=VARCHAR},
      </if>
      <if test="email != null">
        #{email,jdbcType=VARCHAR},
      </if>
      <if test="age != null">
        #{age,jdbcType=INTEGER},
      </if>
      <if test="job != null">
        #{job,jdbcType=VARCHAR},
      </if>
      <if test="yearIncome != null">
        #{yearIncome,jdbcType=DECIMAL},
      </if>
      <if test="address != null">
        #{address,jdbcType=VARCHAR},
      </if>
      <if test="needLoan != null">
        #{needLoan,jdbcType=INTEGER},
      </if>
      <if test="intentionState != null">
        #{intentionState,jdbcType=INTEGER},
      </if>
      <if test="intentionProduct != null">
        #{intentionProduct,jdbcType=INTEGER},
      </if>
      <if test="state != null">
        #{state,jdbcType=INTEGER},
      </if>
      <if test="source != null">
        #{source,jdbcType=INTEGER},
      </if>
      <if test="description != null">
        #{description,jdbcType=VARCHAR},
      </if>
      <if test="nextContactTime != null">
        #{nextContactTime,jdbcType=TIMESTAMP},
      </if>
      <if test="createTime != null">
        #{createTime,jdbcType=TIMESTAMP},
      </if>
      <if test="createBy != null">
        #{createBy,jdbcType=INTEGER},
      </if>
      <if test="editTime != null">
        #{editTime,jdbcType=TIMESTAMP},
      </if>
      <if test="editBy != null">
        #{editBy,jdbcType=INTEGER},
      </if>
    </trim>
  </insert>


  <!--批量保存-->
  <insert id="saveClue" keyColumn="id" keyProperty="id" parameterType="com.alatus.model.TClue" useGeneratedKeys="true">
    insert into t_clue(`owner_id`, `activity_id`, `full_name`,
    `appellation`, `phone`, `weixin`,
    `qq`, `email`, `age`, `job`,
    `year_income`, `address`, `need_loan`,
    `intention_state`, `intention_product`, `state`,
    `source`, `description`, `next_contact_time`,
    `create_time`, `create_by`, `edit_time`,
    edit_by)
    values
      <foreach collection="tClueList" item="tClue"  separator="," >
        (#{tClue.ownerId,jdbcType=INTEGER}, #{tClue.activityId,jdbcType=INTEGER}, #{tClue.fullName,jdbcType=VARCHAR},
        #{tClue.appellation,jdbcType=INTEGER}, #{tClue.phone,jdbcType=VARCHAR}, #{tClue.weixin,jdbcType=VARCHAR},
        #{tClue.qq,jdbcType=VARCHAR}, #{tClue.email,jdbcType=VARCHAR}, #{tClue.age,jdbcType=INTEGER}, #{tClue.job,jdbcType=VARCHAR},
        #{tClue.yearIncome,jdbcType=DECIMAL}, #{tClue.address,jdbcType=VARCHAR}, #{tClue.needLoan,jdbcType=INTEGER},
        #{tClue.intentionState,jdbcType=INTEGER}, #{tClue.intentionProduct,jdbcType=INTEGER}, #{tClue.state,jdbcType=INTEGER},
        #{tClue.source,jdbcType=INTEGER}, #{tClue.description,jdbcType=VARCHAR}, #{tClue.nextContactTime,jdbcType=TIMESTAMP},
        #{tClue.createTime,jdbcType=TIMESTAMP}, #{tClue.createBy,jdbcType=INTEGER}, #{tClue.editTime,jdbcType=TIMESTAMP},
        #{tClue.editBy,jdbcType=INTEGER})
      </foreach>
  </insert>
  
  
  
    <update id="updateByPrimaryKeySelective" parameterType="com.alatus.model.TClue">
    update t_clue
    <set>
      <if test="ownerId != null">
        owner_id = #{ownerId,jdbcType=INTEGER},
      </if>
      <if test="activityId != null">
        activity_id = #{activityId,jdbcType=INTEGER},
      </if>
      <if test="fullName != null">
        full_name = #{fullName,jdbcType=VARCHAR},
      </if>
      <if test="appellation != null">
        appellation = #{appellation,jdbcType=INTEGER},
      </if>
      <if test="phone != null">
        phone = #{phone,jdbcType=VARCHAR},
      </if>
      <if test="weixin != null">
        weixin = #{weixin,jdbcType=VARCHAR},
      </if>
      <if test="qq != null">
        qq = #{qq,jdbcType=VARCHAR},
      </if>
      <if test="email != null">
        email = #{email,jdbcType=VARCHAR},
      </if>
      <if test="age != null">
        age = #{age,jdbcType=INTEGER},
      </if>
      <if test="job != null">
        job = #{job,jdbcType=VARCHAR},
      </if>
      <if test="yearIncome != null">
        year_income = #{yearIncome,jdbcType=DECIMAL},
      </if>
      <if test="address != null">
        address = #{address,jdbcType=VARCHAR},
      </if>
      <if test="needLoan != null">
        need_loan = #{needLoan,jdbcType=INTEGER},
      </if>
      <if test="intentionState != null">
        intention_state = #{intentionState,jdbcType=INTEGER},
      </if>
      <if test="intentionProduct != null">
        intention_product = #{intentionProduct,jdbcType=INTEGER},
      </if>
      <if test="state != null">
        `state` = #{state,jdbcType=INTEGER},
      </if>
      <if test="source != null">
        `source` = #{source,jdbcType=INTEGER},
      </if>
      <if test="description != null">
        description = #{description,jdbcType=VARCHAR},
      </if>
      <if test="nextContactTime != null">
        next_contact_time = #{nextContactTime,jdbcType=TIMESTAMP},
      </if>
      <if test="createTime != null">
        create_time = #{createTime,jdbcType=TIMESTAMP},
      </if>
      <if test="createBy != null">
        create_by = #{createBy,jdbcType=INTEGER},
      </if>
      <if test="editTime != null">
        edit_time = #{editTime,jdbcType=TIMESTAMP},
      </if>
      <if test="editBy != null">
        edit_by = #{editBy,jdbcType=INTEGER},
      </if>
    </set>
    where id = #{id,jdbcType=INTEGER}
  </update>
  <update id="updateByPrimaryKey" parameterType="com.alatus.model.TClue">
    update t_clue
    set owner_id = #{ownerId,jdbcType=INTEGER},
      activity_id = #{activityId,jdbcType=INTEGER},
      full_name = #{fullName,jdbcType=VARCHAR},
      appellation = #{appellation,jdbcType=INTEGER},
      phone = #{phone,jdbcType=VARCHAR},
      weixin = #{weixin,jdbcType=VARCHAR},
      qq = #{qq,jdbcType=VARCHAR},
      email = #{email,jdbcType=VARCHAR},
      age = #{age,jdbcType=INTEGER},
      job = #{job,jdbcType=VARCHAR},
      year_income = #{yearIncome,jdbcType=DECIMAL},
      address = #{address,jdbcType=VARCHAR},
      need_loan = #{needLoan,jdbcType=INTEGER},
      intention_state = #{intentionState,jdbcType=INTEGER},
      intention_product = #{intentionProduct,jdbcType=INTEGER},
      `state` = #{state,jdbcType=INTEGER},
      `source` = #{source,jdbcType=INTEGER},
      description = #{description,jdbcType=VARCHAR},
      next_contact_time = #{nextContactTime,jdbcType=TIMESTAMP},
      create_time = #{createTime,jdbcType=TIMESTAMP},
      create_by = #{createBy,jdbcType=INTEGER},
      edit_time = #{editTime,jdbcType=TIMESTAMP},
      edit_by = #{editBy,jdbcType=INTEGER}
    where id = #{id,jdbcType=INTEGER}
  </update>
</mapper>
旧约Alatus
关注
专栏目录
ssm-crm-new
04-17
【SSM-CRM-NEW：基于Spring、SpringMVC、MyBatis的客户关系管理系统】 ...如果你要深入学习或参与这个项目，你需要熟悉SSM框架的使用，理解CRM的基本概念和流程，同时具备一定的数据库设计和前端开发能力。
管理系统系列--SSM 框架搭建的CRM客户管理系统.zip
02-25
3. **MyBatis**：是一个持久层框架，它允许开发者用SQL语句来操作数据库，通过XML或注解方式配置和映射原生信息，将接口和Java的POJOs(Plain Old Java Objects，普通的Java对象)映射成数据库中的记录。 4. **CRM...
CRM项目后端分页查询封装用户到活动对象实现一对一映射对象为前端页面提供数据------CRM项目
春风若有怜花意，可否许我再少年
02-14 986
CRM项目后端分页查询封装用户到活动对象实现一对一映射对象为前端页面提供数据------CRM项目
CRM项目后端Query对象映射提取前端的form表单实现数据提交到数据库------CRM项目
春风若有怜花意，可否许我再少年
02-16 1016
CRM项目后端Query对象映射提取前端的form表单实现数据提交到数据库------CRM项目
CRM项目后端使用EasyExcel和定时任务完成将数据库的字段信息扫到缓存并映射到excel提交数据库------CRM项目
春风若有怜花意，可否许我再少年
02-24 947
CRM项目后端使用EasyExcel和定时任务完成将数据库的字段信息扫到缓存并映射到excel提交数据库------CRM项目
CRM项目使用Query映射类封装前端提交的数据用BeanUtils工具类转为Model对象保存到数据库中------CRM项目
春风若有怜花意，可否许我再少年
02-09 980
CRM项目使用Query映射类封装前端提交的数据用BeanUtils工具类转为Model对象保存到数据库中------CRM项目
CRM项目后端部分通过Query映射对象和解析json将数据保存到后台数据库中------CRM项目
春风若有怜花意，可否许我再少年
02-16 799
CRM项目后端部分通过Query映射对象和解析json将数据保存到后台数据库中------CRM项目
CRM项目-模块二
weixin_55314201的博客
02-27 547
1.营销管理表结构分析 针对企业中客户的质询需求所建立的信息录入功能，方便销售人员进行后续的客户需求跟踪与联系，提高企业客户购买产品的几率。 对于系统录入每条营销机会记录，系统会分配对应的销售人员与对应的客户进行详细了解，从而提高客户开发计划的成功几率。对应到营销机会管理模块功能上。即：营销机会数据的录入，分配，修改，删除与查询等基本操作。 t_cus_dev_plan--->t_sale_chance 2.营销机会管理功能实现 (1)准备工作 *1.生成代码 通过 mybatis-
CRM项目后端映射线索备注信息返回前台接收------CRM项目
春风若有怜花意，可否许我再少年
02-29 894
CRM项目后端映射线索备注信息返回前台接收------CRM项目
动力节点-crm-项目笔记(待完善)
zhang_xaio_yu的博客
05-17 4069
文章目录1,搭建开发环境：1.1创建项目：crm-project1.1.1设置JDK.1.1.2创建工程：crm1.1.3补全目录结构：1.1.4设置编码格式：UTF-81.1.5数据库编码设置1.1.6字符集编码的设置2.spring application配置文件知识点2.1.applicationContext-datasource.xml2.1.1.sqlsessionFactory他是一个数据库2.1.2为什么使用127.0.0.1不用localhost2.2 applicationContex
CRM项目后端映射带有DO对象的Activity对象并封装回传到前端------CRM项目
春风若有怜花意，可否许我再少年
02-17 938
CRM项目后端映射带有DO对象的Activity对象并封装回传到前端------CRM项目
boot-crm.rar_-baijiahao_boot图书管理_pairz6w_ssm 系统_图书管理系统
09-21
通过这个压缩包中的"boot-crm"项目，开发者不仅可以学习到如何使用SSM框架开发实际的图书管理系统，还可以了解到如何结合Spring Boot来简化开发流程，以及在实际项目中如何进行系统设计、实现和优化。
CRM-OrVersion.rar
08-02
在CRM系统中，Oracle数据库作为后端存储，负责保存客户信息、交易记录、交互历史等关键数据，确保数据的安全性和一致性。 SSM（Spring、SpringMVC、Mybatis）是Java开发中常用的三大框架组合。Spring作为核心容器，...
JAVA-01-变量
LJH_laura_li的博客
11-08 441
在方法、构造函数或块内部定义的变量。
Java基于小程序公考学习平台的设计与实现（附源码，文档）
最新发布
chusheng1840的博客
11-09 1060
Java基于小程序公考学习平台的设计与实现，小程序公考学习平台使用Java语言进行编码，使用Mysql创建数据表保存本系统产生的数据。系统可以提供信息显示和相应服务，其管理小程序公考学习平台信息，查看小程序公考学习平台信息，管理小程序公考学习平台。总之，小程序公考学习平台集中管理信息，有着保密性强，效率高，存储空间大，成本低等诸多优点。它可以降低信息管理成本，实现信息管理计算机化。关键词：小程序公考学习平台；Java语言；Mysql。
基于 SpringBoot 实现QQ邮箱验证码注册功能
2301_79201049的博客
11-06 664
找到并开通以下的邮件协议服务，而且服务开启也较为简单，需要我们发送一个短信到指定的号码，开启后平台会提供一个授权码，一定要记住这个授权码，发邮件的时候需要这个。host 是根据服务主机区分，网易邮箱是 smtp.163.com, qq邮箱是 smtp.qq.com。其中的 username 是你第一步中操作的邮箱账号，nickname 是接收者收到邮件中显示的发件人。发送邮件的核心依赖是 mail ，由于该项目还涉及其他依赖就全都导进来了。（1）首先打开QQ邮箱，点击设置并来到账号页面。
java_方法重写/覆盖(override)
HHppGo的博客
11-07 338
方法覆盖（重写）就是子类有一个方法，和父类的某个方法的名称、返回类型、参数一样，那么我们就说子类的这个方法覆盖了父类的方法。
在 C# 中，如何实现观察者模式？
Leo的博客
11-06 507
观察者模式是一种设计模式，它定义了一种一对多的依赖关系，让多个观察者对象同时监听某一个主题对象。当该主题对象的状态发生变化时，会通知所有观察者对象，使它们能够自动更新自己。这个模式常用于事件处理系统、通知系统等场景。
并发编程的基础：深入理解内存屏障（Memory Barriers）
2401_86353562的博客
11-06 1008
内存屏障是一种基础语言，在不同的计算机架构下有不同的实现细节。本文主要在x86_64处理器下，通过Linux及其内核代码来分析和使用内存屏障对大多数应用层开发者来说，“内存屏障”（memory Barrier）是一种陌生，甚至有些诡异的技术。实际上，他机制常被用在操作系统内核中，用于实现同步、驱动程序利用它，能够实现高效的无锁数据结构，提高多线程程序的性能表现。本文首先探讨了内存屏障的必要性，之后介绍如何利用内存屏障实现一个无锁唤醒振荡器（队列），用于在多个线程间进行高效的数据交换。
Spring MVC与Mybatis构建企业级CRM项目的架构与搭建指南
CRM项目是一种企业级的信息管理系统，专注于客户关系管理，帮助企业更好地理解和管理与客户的交互，提升客户满意度和商业效益。本文将深入探讨CRM项目的开发过程，包括技术架构设计和环境搭建。 ### 技术架构详解 ...
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值