Nano Framework之使用Mybatis进行持久层开发

1、添加依赖
1.1、修改pom.xml

<dependency>
    <groupId>org.nanoframework</groupId>
    <artifactId>nano-orm-mybatis</artifactId>
    <version>1.2.0-RC1</version>
</dependency>

1.2、在src/main/resources下添加MyBatis数据源 examples-mybatis.properties

mybatis.environment.id=mybatis-examples
mapper.package.name=org.nanoframework.examples.first.webapp.mapper

JDBC.pool.type=DRUID
JDBC.driver=org.h2.Driver
JDBC.url=jdbc:h2:~/test2
JDBC.username=test
JDBC.password=test
JDBC.autoCommit=false

# 省略连接池的属性配置

1.3、修改context.properties

# mapper.package.root=examples,examples2修改为如下内容
mapper.package.root=examples,examples2,mybatis-examples
# 添加如下属性
mapper.package.jdbc.mybatis-examples=/examples-mybatis.properties

2、开发基于Mybatis的服务
2.1、在/src/main/java/org.nanoframework.examples.first.webapp.mapper下添加ExampleMapper接口

public interface ExampleMapper {
    List<Test> select();
}

2.2、在/src/main/resources/org.nanoframework.examples.first.webapp.mapper下添加ExampleMapper.xml

<?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.nanoframework.examples.first.webapp.mapper.ExampleMapper">
    <select id="select" resultType="org.nanoframework.examples.first.webapp.domain.Test">
        select id, name from t_nano_test
    </select>
</mapper>

2.3、添加MybatisExampleComponent组件接口及实现类

@Component
@ImplementedBy(MybatisExampleComponentImpl.class)
@RequestMapping("/mybatis")
public interface MybatisExampleComponent {
    @RequestMapping("/find/all")
    Object findAll();
}

public class MybatisExampleComponentImpl implements MybatisExampleComponent {

    @Inject
    private ExampleMapper exampleMapper;

    @Override
    public Object findAll() {
        List<Test> testList = exampleMapper.select();
        Map<String, Object> map = ResultMap.create(200, "Find all Test", "SUCCESS")._getBeanToMap();
        map.put("records", testList.size());
        map.put("rows", testList);
        return map;
    }

}

3、启动服务后进行以下操作

• http://ip:port/first-webapp/mybatis/find/all

4、至此，基于Mybatis的组件服务开发完成