myfavs-orm-helper

Create a new SqlDialect implementation defining pagination and UPSERT SQL generation, then create an AbstractOrm subclass that injects that dialect via its constructor. Register the mapping in OrmFactory so createOrm() resolves your new DbType.

MyFavs ORM targets developers who prefer handwritten SQL, offering a lightweight Query class over raw JDBC plus an Orm class with annotation-driven entity mapping and automatic CRUD. It avoids MyBatis XML configuration and depends only optionally on slf4j-api and Druid.

Yes, through SpringConnFactory, which delegates connection acquisition and release to Spring's DataSourceUtils. This lets ORM operations join the connection managed by @Transactional, and the starter provides Repository and BaseService classes for CRUD and programmatic transactions.

@Table lacks the @Inherited meta-annotation, so subclasses must declare @Table independently to be recognized as entities. In contrast, @Column, @PrimaryKey, and @LogicDelete are inherited by subclasses automatically.

Fields marked @LogicDelete turn DELETE operations into UPDATE statements that set the logic-delete column to the primary key value, not a boolean flag. The logic-delete field type must therefore match the primary key field type.

PageLite queries pageSize + 1 rows to infer hasNext without a COUNT query, so it cannot report total records or total pages. When the final page is exactly full, hasNext may be incorrectly true.