现public

resultTypeMonster!--这里能用简写是因为mybatis-config.xml文件里配置了别名-typeAliases--SELECT

FROM

/mapper3.测试MonsterAnnotationTest

Test

monsterMapper.findMonsterByAge(-1);for

(Monster

{sqlSession.close();}System.out.println(操作成功);

}where标签应用实例

/select3.测试MonsterAnnotationTest

Test

Monster();monster.setId(20);monster.setName(牛魔王);ListMonster

monsters

monsterMapper.findMonsterByIdAndName(monster);for

(Monster

{sqlSession.close();}System.out.println(操作成功);

●需求:

findMonsterByIdOrName_choose(MapString,

Object

findMonsterByIdOrName_choose(MapString,

Object

/select3.测试MonsterAnnotationTest

Test

monsterMapper.findMonsterByIdOrName_choose(map);for

(Monster

{sqlSession.close();}System.out.println(查询成功);

}foreach标签应用实例

findMonsterById_forEach(MapString,

Object

findMonsterById_forEach(MapString,

Object

/select3.测试MonsterAnnotationTest

Test

monsterMapper.findMonsterById_forEach(map);for

(Monster

{sqlSession.close();}System.out.println(查询成功);

}trim标签应用实例[使用较少]

findMonsterByName_Trim(MapString,

Object

findMonsterByName_Trim(MapString,

Object

/select3.测试MonsterAnnotationTest

Test

monsterMapper.findMonsterByName_Trim(map);for

(Monster

{sqlSession.close();}System.out.println(操作成功);

}set标签应用实例[重点]

/update3.测试MonsterAnnotationTest

Test

12:12:12);monsterMapper.updateMonster_set(map);//增删改需要提交事务if

(sqlSession

{sqlSession.commit();sqlSession.close();}System.out.println(修改成功);

}课后练习

资源拷贝过来(这里我们拷贝com.zzw.entity.Hero.java,

mybatis-config.xml)

}4.拷贝com.zzw.mapper.HeroMapper.java接口,

com.zzw.mapper.HeroMapperTest.java,

做一个比较

namespacecom.zzw.mapper.HeroMapper!--1.配置/实现public

void

heroMapper;//编写方法完成初始化Beforepublic

void

MyBatisUtils.getSqlSession();heroMapper

sqlSession.getMapper(HeroMapper.class);System.out.println(heroMapper

heroMapper.getClass());}Testpublic

void

Hero();hero.setNickname(花和尚);hero.setSkill(倒拔垂杨柳);hero.setRank(13);hero.setSalary(7500.0);hero.setDays(new

Date());heroMapper.addHero(hero);//增删改需要提交事务if

(sqlSession

{sqlSession.commit();sqlSession.close();}System.out.println(操作成功);}编写方法:

查询rank大于

namespacecom.zzw.mapper.HeroMapper!--1.配置/实现public

void

heroMapper;//编写方法完成初始化Beforepublic

void

MyBatisUtils.getSqlSession();heroMapper

sqlSession.getMapper(HeroMapper.class);System.out.println(heroMapper

heroMapper.getClass());}Testpublic

void

heroMapper.findHeroByRank(map);for

(Hero

{sqlSession.close();}System.out.println(查询成功);}编写方法:

查询rank

findHeroByRank_choose(MapString,

Object

namespacecom.zzw.mapper.HeroMapper!--1.配置/实现public

ListHero

findHeroByRank_choose(MapString,

Object

hero!--解读1.where标签2.对ranks是否为空做判断3.如果ranks不为空,

对应入参map

close)#{rank}/foreach/if/where/select

public

heroMapper;//编写方法完成初始化Beforepublic

void

MyBatisUtils.getSqlSession();heroMapper

sqlSession.getMapper(HeroMapper.class);System.out.println(heroMapper

heroMapper.getClass());}Testpublic

void

heroMapper.findHeroByRank_choose(map);for

(Hero

{sqlSession.close();}System.out.println(查询成功);}编写方法:

修改hero信息,

namespacecom.zzw.mapper.HeroMapper!--1.配置/实现public

void

heroMapper;//编写方法完成初始化Beforepublic

void

MyBatisUtils.getSqlSession();heroMapper

sqlSession.getMapper(HeroMapper.class);System.out.println(heroMapper

heroMapper.getClass());}Testpublic

void

Hero();hero.setNickname(豹子头);hero.setRank(5);hero.setSalary(120000.0);hero.setId(4);heroMapper.updateHeroById_set(hero);//增删改需要提交事务if

(sqlSession

{sqlSession.commit();sqlSession.close();}System.out.println(操作成功);}编写方法:

如果没有传入id,

namespacecom.zzw.mapper.HeroMapper!--1.配置/实现public

ListHero

heroMapper;//编写方法完成初始化Beforepublic

void

MyBatisUtils.getSqlSession();heroMapper

sqlSession.getMapper(HeroMapper.class);System.out.println(heroMapper

heroMapper.getClass());}Testpublic

void

{sqlSession.close();}System.out.println(查询成功);}接下来我们学习,

mybatis映射关系