另一个轻量级的 ORM，基于 JDBC 的易用性封装。
- 无 XML
- 简化单表操作
- 灵活构建查询条件
可参考测试用例 src/test/java/io/github/minimo/orm/DatabaseTemplateImplTest.java
可通过 maven 中央仓库引入
https://central.sonatype.com/artifact/io.github.mini-mo/mini-orm/0.0.2
<dependency>
<groupId>io.github.mini-mo</groupId>
<artifactId>mini-orm</artifactId>
<version>0.0.2</version>
</dependency>- 单表操作
// save
User u = new User();
// set ...
db.save(u);
assertNotNull(u.getId()); // 自动获取自增ID
// findById
User u = db.findById(1, User.class);
// update
u.setName("name-2")
db.save(u);
// query list
List<User> users = db.from(User.class)
.where(and(
column("name").like("test"),
column("createdAt").range(begin, end)
)
.order(by("id").desc()))
.execute()
.list(0, 10) // list() | list(10)- Native Query
// native query
Map<String, Object> one = db.nativeQuery("select * from users where name = ?")
.bind(1, "test")
.asMap()
.one();
assertNotNull(one);
assertTrue(one.size() > 2);
List<Map<String, Object>> list = db.nativeQuery("select * from users where name = ? limit 10")
.bind(1, "test")
.asMap()
.list(0, 1);
assertFalse(list.isEmpty());
User one_2 = db.nativeQuery("select * from users where name = ?")
.bind(1, "test")
.map((rs, rowNum) -> new User(rs.getInt("id"), rs.getString("name")))
.one();
assertNotNull(one_2);
List<User> list_2 = db.nativeQuery("select * from users where name = ?")
.bind(1, "test")
.map((rs, rowNum) -> new User(rs.getInt("id"), rs.getString("name")))
.list();
assertFalse(list_2.isEmpty());- 默认查询
// auto binding
var one = db.createQuery("select * from users where name = ?", new UserName("test"))
.asMap()
.one();
assertNotNull(one);
assertTrue(one.size() > 2);
// auto binding
var one_2 = db.createQuery("select * from users where name = ?", "test")
.map(User.class)
.one();
assertNotNull(one_2);
var list_2 = db.createQuery("select * from users where name = ?", "test")
.map(User.class)
.list();
assertFalse(list_2.isEmpty());- 高级查询
// users 用户表
// books 书
// relations 用户/书关系 (uid int, bid int)
// 查询与用户有关的书名
var sql = "select u.id as id, b.name as name from relations r inner join users u on r.uid = u.id inner join books b on b.id = r.bid";
// map
var lm = db.createCompositeQuery(sql)
.where(column("b.name").is("test"))
.asMap()
.list(10);
assertFalse(lm.isEmpty());
// class
var ld = db.createCompositeQuery(sql)
.where(column("b.name").is("test"))
.map(UserBookDTO.class)
.list(10);
assertFalse(ld.isEmpty());
// row mapper
var ld_2 = db.createCompositeQuery(sql)
.where(column("b.name").is("test"))
.map((rs, i) -> new UserBookDTO(rs.getInt("id"), rs.getString("name")))
.list(10);
assertFalse(ld_2.isEmpty());