MyBatis(三)
发布日期:2021-04-30 21:02:24 浏览次数:109 分类:精选文章

本文共 1761 字,大约阅读时间需要 5 分钟。

MyBatis ??? SQL ????

??MyBatis ??????

MyBatis ???????? mybatis-config.xml?????????????? SQL ???????????????

1. ??????

properties ?????????????? mydata.properties???????? src/main/resources ??????????????? ${} ???????????

2. ???????

environments ????????????default ???????????? development???????????

  • transactionManager?????????????? JDBC?
  • dataSource???????????? UNPOOLED?POOLED ? JNDI ?????
3. SQL ??????

mappers ???? SQL ??????????????????????

  • ?????? resource="PersonMapper.xml"?
  • ?????? <package name="com.example.mapper"/>?
  • ??????? <mapper class="com.example.mapper.PersonMapper"/>?
  • ???????? url="file:///??/PersonMapper.xml"?

??SQL ????

SQL ?????? PersonMapper.xml?????????????? SQL ??????????

insert into t_person values (null, #{pername}, #{perage}, #{peraddress});
update t_person set per_name=#{pername}, per_age=#{perage}, per_address=#{peraddress} where per_id=#{perid};
delete from t_person where per_id=#{perid};
1. namespaces

namespace ???????????????????

2. SQL ??
  • insert???????parameterType ???????
  • update??????parameterType ???????
  • delete??????parameterType ???????
  • select??????parameterType ???????resultMap ???????
3. resultMap

resultMap ????????????????????id ?????????result ?????????

????????

  • ?????transactionManager ????????????????????JDBC ???????
  • ????dataSource ?? POOLED ???????????????
  • SQL ????????? SQL ???????????????????????
  • resultMap ???resultMap ? id ? type ????????????
  • ?????????????????????????????

    上一篇:get和post的联系与区别
    下一篇:elasticSearch spark支持

    发表评论

    最新留言

    路过按个爪印,很不错,赞一个!
    [***.219.124.196]2026年06月16日 19时40分45秒