注解
插入更新: 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再追加 达成下拉框的效果