![](https://img-blog.csdnimg.cn/20201014180756930.png?x-oss-process=image/resize,m_fixed,h_64,w_64)
mybatis
微风吹过的夏天2016
Java程序员
展开
-
xxxMapper.xml简单crud
<!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" "http://mybatis.org/dtd/mybatis-3-mapper.dtd"> select * from Blog where id = #{id} insert into blog(name,age) v原创 2016-06-12 21:49:30 · 432 阅读 · 0 评论 -
mybaits-config.xml
详细可参考mybatis.zip包中的开发向导文档。 mybatis-config.xml详解: 简单的mybatis-config.mxl配置:数据源,SQL映射文件配置 <!DOCTYPE configuration PUBLIC "-//mybatis.org//DTD Config 3.0//EN" "http://mybatis.org/dtd/mybatis-3-con原创 2016-06-12 21:13:29 · 376 阅读 · 0 评论 -
表字段名和实体类属性名不一致的处理
解决方法,SQL映射文件中把实体类属性名作为SQL语句中字段的别名 select blog_id blogId,blog_nam blogName from blog where id=#{id}原创 2016-06-12 22:46:57 · 1008 阅读 · 0 评论 -
一对一关联查询
public class Teacher { private String id; private String name; } public class Classes { private String id; private String name; private Teacher teacher; } <!DOCTYPE mapper PUBLIC "-//mybat原创 2016-06-12 23:26:56 · 296 阅读 · 0 评论 -
一对多关联查询
public class Student { private String id; private String name; } public class Classes { private String id; private String name; private Teacher teacher; private List list; } <!DOCTYPE mapper原创 2016-06-12 23:42:16 · 367 阅读 · 0 评论 -
动态SQL与模糊查询
<!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" "http://mybatis.org/dtd/mybatis-3-mapper.dtd"> select * from user where name like #{name} and age between #{minAge} and原创 2016-06-13 00:07:15 · 598 阅读 · 0 评论