项目地址： https://github.com/braisdom/ObjectiveSql
1 简单查询
@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 |
<?xml version="1.0" encoding="UTF-8" ?>
<!DOCTYPE mapper
PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN"
"http://mybatis.org/dtd/mybatis-3-mapper.dtd">
<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<Blog> 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)
|
1
Select Language