Java轻量级ORM持久层框架:ORMLite

jopen 12年前

ORMLite是一个轻量级的Java对象关系映射持久层框架。支持包括 MySQL、Postgres、Microsoft SQL Server、H2、Derby、HSQLDB和Sqlite等在内的数据库。提供灵活的QueryBuilder来构建复杂的数据查询。强大的抽象 DAO类,只需5行代码便能够自动生成SQL来创建和删除数据库表格。
RMLite易于使用并提供了以下特性:

  • Setup your classes by simply adding Java annotations.
  • Powerful abstract Database Access Object (DAO) classes.
  • Flexible QueryBuilder to easily construct simple and complex queries.
  • Supports MySQL, Postgres, Microsoft SQL Server, H2, Derby, HSQLDB, and Sqlite and can be extended to additional databases relatively easily.
  • Provisional support for DB2, Oracle, ODBC, and Netezza. Contact the author if your database type is not supported.
  • Handles "compiled" SQL statements for repetitive query tasks.
  • Supports "foreign" objects with the class field being the object but an id stored in the database table.
  • Basic support for database transactions.
  • Auto generates SQL to create and drop database tables.
  • Spring configuration support for DOAs and class configurations.
  • Support for configuring of tables and fields without annotations.
  • Supports native calls to Android SQLite database APIs

示例代码:

public class AccountApp {        public static void main(String[] args) throws Exception {            // this uses h2 by default but change to match your database            String databaseUrl = "jdbc:h2:mem:account";            // create a connection source to our database            ConnectionSource connectionSource = new JdbcConnectionSource(databaseUrl);            // instantiate the dao            AccountDaoImpl accountDao = new AccountDaoImpl(connectionSource);            // if you need to create the 'accounts' table make this call            TableUtils.createTable(connectionSource, Account.class);

项目主页:http://www.open-open.com/lib/view/home/1357891151200