<?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.example.mybatisdemo.daomapper.StudentMapper">
<resultMap >
insert into mysql_student ( name, age, sex)
values (#{name,jdbcType=VARCHAR}, #{age,jdbcType=INTEGER},
#{sex,jdbcType=CHAR})
</insert>
//插入一条新得数据，每个字段都更新切判断
//useGeneratedKeys="true" keyProperty="id":当主键id是自增的情况下，添加一条记录的同时，我们要获取到主键id。
// <trim prefix="(" suffix=")" suffixOverrides=","> ,prefix:在trim标签内sql语句加上前缀"(",suffix:在trim标签内sql语句加上后缀")",
<insert >
#{sex,jdbcType=CHAR},
</if>
</trim>
</insert>
-------------------------------------------------------------------------
//修改，每个字段判空
<update >
station_name = #{stationName,jdbcType=VARCHAR},
</if>
update_time = now(),
update_user = #{updateUser,jdbcType=VARCHAR}
</trim>
</set>
where id = #{id,jdbcType=BIGINT}
AND is_delete = 0
</update>
//简单得update
<update >
update mysql_student
set name = #{name,jdbcType=VARCHAR},
age = #{age,jdbcType=INTEGER},
sex = #{sex,jdbcType=CHAR}
where id = #{id,jdbcType=INTEGER}
</update>
-----------------------------------------------------------
<!-- 删除实体 -->
<update >
update address_base
<set>
is_delete = 1,
update_time = now(),
update_user = #{updateUser,jdbcType=VARCHAR}
</set>
where id = #{id,jdbcType=BIGINT}
AND is_delete = 0
</update>
<delete >
delete from mysql_student
where id = #{id,jdbcType=INTEGER}
</delete>
------------------------------------------------------
//查询根据id
<select >
select * from mysql_student where name = #{name,jdbcType=VARCHAR} and age=#{age,jdbcType=INTEGER}
</select>
//根据条件查询一个实体
<select >
select
id,
province_id,
city_id,
county_id,
town_id,
cky2,
address,
road,
station_id,
station_name
from address_base
where cky2 = #{cky2,jdbcType=INTEGER}
AND address = #{address,jdbcType=VARCHAR}
AND is_delete = 0
ORDER BY id DESC LIMIT 1
</select>
