Timo是基于Java的数据库持久工具,提供SQLMaps以及SQL工具
采用XML定义SQL语句
支持数据库与Java对象之间的映射
支持外部数据缓存，支持Ehcache，Memcached和内置同步缓存
提供SQL语句解析、格式化工具
安装方式
<depedecy> <groupId>org.piae</groupId> <artifactId>timo</artifactId> <versio>1.1</versio></depedecy>实例代码
1.XML配置
<?xml versio="1.0" ecodig="UTF-8" ?><global key="table" value="perso" /><mapper amespaces="org.piae.timo"> <sql ame="getPerso"> select * from :table where 1=1 <choose whe="id"> ad id = :id </choose> </sql></mapper>2.实例代码
public class SQLSessioFactoryDemo { public static void mai(Strig[] args) { SQLSessioFactory sessioFactory = ull; SQLBuilder builder = ull; try { builder = ew SQLBuilder() sessioFactory = ew SQLSessioFactory(); SQLSessio sessio = sessioFactory.getSessio(); Map<Strig, Object> parameters = ew HashMap<Strig, Object>(); parameters.put("id", 1); Perso perso = (Perso)sessio.oe( builder.getSQLByNameWithParameters("org.piae.timo.getPerso", parameters), Perso.class); sessio.close(); } catch (IOExceptio e) { } }}
评论