This is a super simple ORM using Java Reflect and Dynamic Proxy.
Set a DataSource for DaoFactory .
// Create a DataSource (DBCP, HikariCP and so on).
DataSource dataSource = ...;
DaoFactory factory = new DaoFactory(dataSource);Use @Select , @Insert ,@Update and @Delete to write DML statements.
public interface ItemDao {
@Select(sql = "select * from item")
List<HashMap<String, Object>> getAll();
@Select(sql = "select * from item where id = ?")
HashMap<String, Object> getById(long id);
@Insert(sql = "insert into item(name) values(?)", useGeneratedKey = true)
long add(String name);
@Delete(sql = "delete from item where id = ?")
long removeById(long id);
}The
@Selectannotation only supportHashMapas return type currently.
setuseGeneratedKeytotruecould return auto-generated primary key.
Use proxy object to manipulate data.
ItemDao itemDao = (ItemDao) factory.create(ItemDao.class);
// Select all
List<HashMap<String, Object>> items = itemDao.getAll();
// Select by id
HashMap<String, Object> item = itemDao.getById(id);
// Insert
long id = itemDao.add("NewItem");