sql语句和下拉框实现

注解

插入更新： put post
搜索 ：get

删除：delete 

request 都可以代替 

例子： 

sql语句

查

select * from 表格 where id=#{id}

insert 

 <trim prefix="(" suffix=")" suffixOverrides="," >

对这个标签的解释：https://www.cnblogs.com/isme-zjh/p/17009529.html

 插入语句语法：

<insert id="insertSelective" parameterType="com.xxxx.crm.vo.Role" >
    insert into t_role
    <trim prefix="(" suffix=")" suffixOverrides="," >
      <if test="id != null" >
        id,
      </if>
      <if test="roleName != null" >
        role_name,
      </if>
      <if test="roleRemark != null" >
        role_remark,
      </if>
      <if test="createDate != null" >
        create_date,
      </if>
      <if test="updateDate != null" >
        update_date,
      </if>
      <if test="isValid != null" >
        is_valid,
      </if>
    </trim>
    <trim prefix="values (" suffix=")" suffixOverrides="," >
      <if test="id != null" >
        #{id,jdbcType=INTEGER},
      </if>
      <if test="roleName != null" >
        #{roleName,jdbcType=VARCHAR},
      </if>
      <if test="roleRemark != null" >
        #{roleRemark,jdbcType=VARCHAR},
      </if>
      <if test="createDate != null" >
        #{createDate,jdbcType=TIMESTAMP},
      </if>
      <if test="updateDate != null" >
        #{updateDate,jdbcType=TIMESTAMP},
      </if>
      <if test="isValid != null" >
        #{isValid,jdbcType=INTEGER},
      </if>
    </trim>
  </insert>

update 表名 set id=#{id} name=#{name}

delete from 表 where id=#{id}

==========================================

从数据库获取值 形成下拉框的流程：

 Ajax从后台获取到的结果返回到id值为这个，append再追加 达成下拉框的效果