Android版Ibatis开源的ORM框架Aibatis介绍

android中的类似ibatis的ORM框架，类似Ibatis的简单配置，实现android数据库的快速开发。

开源地址：http://code.awsle.com/index.php/p/aibatis/

配置文件：SqlMapConfig.xml

<?xml version="1.0" encoding="UTF-8" ?>
<sqlMapConfig>
    <!-- 配置数据源 -->
	<dataSource>
		<dbName>aibatis_test_db</dbName>
		<dbVersion>1</dbVersion>
	</dataSource>
	<includes>
	    <include>/assets/config/aibatis-test.xml</include>
	</includes>
</sqlMapConfig>

SQL配置文件：aibatis-test.xml

<?xml version="1.0" encoding="UTF-8" ?>
<sqlMap>
	<!-- 命名空间 -->
	<namespace>test</namespace>
	<!-- 查询操作 -->
	<selects>
		<select>
			<id>selectPersonByName</id>
			<parameterClass>String</parameterClass>
			<resultClass>java.util.HashMap</resultClass>
			<sql>select *  from tbl_person t where t.name = #name#</sql>
		</select>
		<select>
			<id>selectPersons</id>
			<parameterClass>String</parameterClass>
			<resultClass>com.awsle.aibatis.pojo.Person</resultClass>
			<sql>select *  from tbl_person t </sql>
		</select>
	</selects>
	<!-- 更新操作 -->
	<updates>
	    <update>
	        <id>updatePersonPhoneByName</id>
	        <parameterClass>String</parameterClass>
			<sql>UPDATE "tbl_person" SET "phone"=#phone# WHERE name = #name#</sql>
	    </update>
	</updates>
	<!-- 插入操作 -->
	<inserts>
	    <insert>
	        <id>insertPerson</id>
	        <parameterClass>com.awsle.aibatis.pojo.Person</parameterClass>
	        <sql>INSERT INTO "tbl_person" ("name", "phone", "address", "email") VALUES (#name#, #phone#, #address#, #email#)</sql>
	    </insert>
	</inserts>
	<!-- 删除操作 -->
	<deletes>
	    <delete>
	        <id>deletePeronByName</id>
	        <parameterClass>String</parameterClass>
	        <sql>DELETE FROM "tbl_person" WHERE name = #name#</sql>
	    </delete>
	</deletes>
</sqlMap>

初始化SqlMap

Config.sqlMap = SqlMapClientBuilder.buildSqlMapClient(this.getClass().getResourceAsStream("/assets/config/SqlMapConfig.xml")).init(this);

调用方式，查询List

Config.sqlMap.queryForList("selectPersons");

查询成xml中配置的对象

Config.sqlMap.queryForObject("selectPersonByName");

更新操作

Config.sqlMap.update("updatePersonPhoneByName", name);