mapping配置文件:
<insert id="insertsql">
insert into tuser(name,sex)values('吴3','男')
</insert>
对应的执行代码: sqlSession.insert("insertsql");
<!-- 添加数据参数关联 -->
<insert id="insertsqlparameter" parameterType="SystemEntity">
insert into
tuser(name,sex)values(#{name},#{sex})
</insert>
对应的执行代码:Session.insert("com.hengda.mybatis_yhf.entity.SystemEntity.insertsqlparameter", se);
<!-- 添加map参数 -->
<insert id="insertsqlmap" parameterType="java.util.Map">
insert into tuser(name,sex)values(#{name},#{sex})
</insert>
对应的执行代码:Map<String, Object> map = new HashMap<String, Object>();
map.put("name", "孙小里"); map.put("sex", "女");
sqlSession.insert(
"c.hengda.mybatis_yhf.entity.SystemEntity.insertsqlmap", map);
<!-- 添加对象关联 -->
<insert id="insertsqlasso" parameterType="UserClass">
insert into
tuserclass(uid,cid,remark)values(#{user.uid},#{clas.cid},#{remark})
</insert>
对应的执行代码:UserClass uc = new UserClass();
sqlSession.insert(
"com.hengda.mybatis_yhf.entity.SystemEntity.insertsqlasso", uc);
<delete id="deletesqlById" parameterType="int">
delete from tuserclass
where id=#{id}
</delete>
对应的执行代码:int result = sqlSession.delete("deletesqlById", 1);
<update id="updatesql" parameterType="SystemEntity">
update tuser set
name=#{name},sex=#{sex} where id=#{id}
</update>
对应的执行代码:sqlSession.update(
"com.hengda.mybatis_yhf.entity.SystemEntity.updatesql", se);
<!-- 单表查询 -->
<select id="selectsqlById" resultType="SystemEntity" parameterType="int">
select id,name,sex from tuser where id=#{id}
</select>
对应的执行代码:se = (SystemEntity) sqlSession.selectOne("selectsqlById", 2);
<!-- 单表查询List -->
<select id="selectsqllist" resultType="SystemEntity" >
select id,name,sex from tuser
</select>
对应的执行代码:List<SystemEntity> list = sqlSession.selectList("selectsqllist");
<!-- 单表查询Like -->
<select id="selectsqllike" resultType="SystemEntity" parameterType="java.lang.String" >
select id,name,sex from tuser where name like #{likesomeone}
</select>
对应的执行代码:List<SystemEntity> list = sqlSession.selectList("selectsqllike", "%李%");
<!-- 单表查询Like1 -->
<select id="selectsqllike" resultType="SystemEntity" parameterType="java.lang.String" >
select id,name,sex from tuser where name like concat('%',#{like},'%')
</select>
对应的执行代码:List<SystemEntity> list = sqlSession.selectList("selectsqllike", "%李%");
<!-- resultMap作用:
实体类的结果集中的字段跟数据库中的字段不一致时:通过resultMap把(column="name")的值
映射成(property="new_name"该值与数据库内对应).
-->
<resultMap id="systemEntityMap" type="SystemEntity">
<!-- 主键 -->
<id property="id" column="id"/>
<!-- 非主键 -->
<result property="new_name" column="name"/>
<result property="new_sex" column="sex"/>
</resultMap>