ObjectiveSQL vs MyBatis

[catchex]

1 简单查询

以ObjectiveSQL 的方式定义一个简单的模型

@DomainModel
public class Blog {
    private Long id;
    private String title;
    private Integer state;
    @Relation(relationType = RelationType.BELONGS_TO)
    private Author author;
}

根据单字段查询

MyBatis	ObjectiveSQL
public interface BlogMapper { @Select("SELECT * FROM blog WHERE id = #{id}") Blog selectBlog(int id); } ... BlogMapper mapper = session.getMapper(BlogMapper.class); Blog blog = mapper.selectBlog(i);	Blog blog = Blog.queryByPrimaryKey(1);

稍微复杂一点的查询

MyBatis	ObjectiveSQL
<mapper namespace="org.mybatis.example.BlogMapper"> <select id="findByTitle" resultType="Blog"> select * from Blog where title like '%#{title}%' </select> </mapper> ... BlogMapper mapper = session.getMapper(BlogMapper.class); Blog blog = mapper.findByTitle("标题");	public static Blog queryByTitle(String title) { Query query = createQuery(); query.where("title like ?", "%" + title + "%"); return query.queryFirst(); } ... Blog blog = Blog.queryByTitle(1);

2 复杂查询

动态查询

MyBatis

ObjectiveSQL

<select id="findActiveBlogLike" resultType="Blog"> SELECT * FROM BLOG WHERE <if test="state != null"> state > #{state} </if> <if test="title != null"> AND title like #{title} </if> <if test="author != null and author.name != null"> AND author_name like #{author.name} </if> </select> ... BlogMapper mapper = session.getMapper(BlogMapper.class); Blog blog = mapper.findActiveBlogLike(...);

Blog.Table blog = Blog.asTable(); Select select = new Select(); LogicalExpression eternalExpression = new EternalExpression(); if(state != null) eternalExpression = eternalExpression .and(blog.state > state); if(title != null) eternalExpression = eternalExpression .and(blog.title.like(title)); if(author != null && author.name != null) eternalExpression = eternalExpression .and(blog.author.like(author.name)); return select.from(blog).where(eternalExpression) .execute();

关联查询

MyBatis	ObjectiveSQL
<mapper> <resultMap type="Blog" id="blog"> <id column="id" property="id" /> ... <association property="author" javaType="Author"> ... </association> </resultMap> <select id="findBlog" parameterType="int" resultMap="blog"> ... </select> </mapper> ... BlogMapper mapper = session.getMapper(BlogMapper.class); Blog blog = mapper. findBlog(...);	Blog blog = Blog.queryByPrimaryKey(1, Blog.BELONGS_TO_AUTHOR)